[ 
https://issues.apache.org/jira/browse/DERBY-4957?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Bruce Wen updated DERBY-4957:
-----------------------------

    Description: 
Reproduce Steps:
1. Install Derby plugin to Eclipse
2. Connect to Derby database 
3. Create a SQL file
4. Execute "show schemas;" statement --- Execution failed and syntax error 
message "Encountered "show" at line 1, column 1." showed in status panel.
5. Execute "describe task;" statement --- Execution failed and syntax error 
message "Encountered "describe" at line 1, column 1." showed in status panel. 
Note: task is the table name.

Note:
1. It seems that show and describe commands can not be recognize by the SQL 
Engine of Eclipse Derby plugin.
2. commands create, drop, select, update, delete, insert work well

  was:
1. Install Derby plugin to Eclipse
2. Connect to Derby database 
3. Create a SQL file
4. Execute "show schemas;" statement --- Execution failed and syntax error 
message "Encountered "show" at line 1, column 1." showed in status panel.
5. Execute "describe task;" statement --- Execution failed and syntax error 
message "Encountered "describe" at line 1, column 1." showed in status panel. 
Note: task is the table name.

It seems that show and describe commands can not be recognize by the SQL Engine 
of Eclipse Derby plugin.


> describe and show command failed in Eclipse Plugin
> --------------------------------------------------
>
>                 Key: DERBY-4957
>                 URL: https://issues.apache.org/jira/browse/DERBY-4957
>             Project: Derby
>          Issue Type: Bug
>          Components: Eclipse Plug-in
>         Environment: Eclipse Ganymede (3.4) - Eclipse IDE for Java EE 
> Developers
> Build id: I20080617-2000
> Windows XP Professional
> Dell OPTIPLEX 755
>            Reporter: Bruce Wen
>
> Reproduce Steps:
> 1. Install Derby plugin to Eclipse
> 2. Connect to Derby database 
> 3. Create a SQL file
> 4. Execute "show schemas;" statement --- Execution failed and syntax error 
> message "Encountered "show" at line 1, column 1." showed in status panel.
> 5. Execute "describe task;" statement --- Execution failed and syntax error 
> message "Encountered "describe" at line 1, column 1." showed in status panel. 
> Note: task is the table name.
> Note:
> 1. It seems that show and describe commands can not be recognize by the SQL 
> Engine of Eclipse Derby plugin.
> 2. commands create, drop, select, update, delete, insert work well

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to