Bugzilla – Full Text Bug Listing
| Summary: | show and describe failed to execute in SQL Editor | ||||||
|---|---|---|---|---|---|---|---|
| Product: | [Tools] Data Tools | Reporter: | Bruce Wen <wengm> | ||||
| Component: | SQL Editor Framework | Assignee: | dtp.sqldevtools-inbox <dtp.sqldevtools-inbox> | ||||
| Status: | NEW --- | QA Contact: | |||||
| Severity: | normal | ||||||
| Priority: | P3 | CC: | bpayton | ||||
| Version: | unspecified | ||||||
| Target Milestone: | --- | ||||||
| Hardware: | PC | ||||||
| OS: | Windows XP | ||||||
| Whiteboard: | |||||||
| Attachments: |
|
||||||
Created attachment 186143 [details]
show command failed to execute from SQL Editor
"show" and "describe" are Derby ij commands, not SQL statements. DTP uses JDBC to connect to the Derby database, so it can only issue SQL statements to the database. |
Build Identifier: I20080617-2000 show and describe commands failed to execute from SQL Editor. The following message displayed: Encountered "show" at line 1, column 1 Reproducible: Always Steps to Reproduce: 1. connect to derby database in Data Source Explorer 2. create a sql file: Type - Derby_10.x; Name - connection name; database - derby database name 3. type SQL statement "show schemas;" or "describe ${TableName}" 4. high-light the statement and right click -> execute selected text Expected Result: The SQL statement executed successfully Actual Result: Failed and error message says: Encountered "show" at line 1, column 1