This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.
[ BUILD # : 200807231346 ] [ JDK VERSION : other ] When trying to execute an SQL Command on a MySQL database connection, Netbeans throws the MySQLSyntaxErrorException: Table 'test.test' doesn't exist. This exception is thrown when a table that does not exist is selected. Ideally, the SQL Command editor should be able to detect what tables are present in the database, which we can also view in the Services tab under database connection. Steps to reproduce bug: 1.) Create a connection to MySQL Server 2.) Connect to the database 3.) Right click on the connection in Services Tab and select Execute Command 4.) Enter a select query on a table that doesn't exist (say. SELECT * FROM test), but since test is not a table in my example table test, netbeans throws an exception. NOTE: When reported using the exception reporter, it detects that it is a duplicate of Issue #128975, but that issue is about previleges. The entire error log can be found at: http://statistics.netbeans.org/ analytics/detail.do?id=82262
The SQL Editor is not a full SQL parser and does not check the SQL to see if things like the tables or columns exist. It for the most part just sends the SQL to the database and lets it report any syntax or semantic errors. We now have code completion, so you can use that to get a drop-down of available tables and it will insert the name correctly.
Reverting this - this *is* a problem - the issue is that it is showing up as an exception, rather than being printed to the output window like it used to. There is an issue I have open on this and I'll make this a duplicate. Apologies for misunderstanding the issue.
*** This issue has been marked as a duplicate of 140068 ***
Gave wrong bug id as duplicate
*** This issue has been marked as a duplicate of 141210 ***