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.

Bug 136963 - Unable to execute SQL against a MySQL connection in ShowData module
Summary: Unable to execute SQL against a MySQL connection in ShowData module
Status: VERIFIED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Show Data (show other bugs)
Version: 6.x
Hardware: Macintosh All
: P1 blocker (vote)
Assignee: _ ahimanikya
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-06-11 01:01 UTC by David Vancouvering
Modified: 2008-06-26 12:25 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description David Vancouvering 2008-06-11 01:01:09 UTC
- Connect to a MySQL database
- Create a table, e.g. 'CREATE TABLE test (id int primary key)'
- In the Show Data editor, run 'SELECT * from test'
- You get the error 'table TEST not found...'

If I try 'select * from test' in the standard SQL editor it works fine.

Two things: 
- the dialog is not that helpful, it would be nice if it showed the SQL that failed
- it is interesting to note that 'TEST' is capitalized in the error message
Comment 2 Roman Mostyka 2008-06-26 12:25:04 UTC
Verified with build 080625.