[ 
https://issues.apache.org/jira/browse/DERBY-3408?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12616858#action_12616858
 ] 

Knut Anders Hatlen commented on DERBY-3408:
-------------------------------------------

I think 42X01 can be raised for almost any SQL statement if you mistype 
something, so then we'd basically have to add all the supported SQL syntax to 
the help text. IJ is meant to work with other JDBC drivers too, so it's 
probably best not to assume too much about what syntax the underlying SQL 
engine supports.

> Wrong message when using SHOW in ij.
> ------------------------------------
>
>                 Key: DERBY-3408
>                 URL: https://issues.apache.org/jira/browse/DERBY-3408
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>            Reporter: Jazarine Jamal
>            Priority: Minor
>         Attachments: suggestHelp.diff
>
>
> When running the show command using ij, it gives out a wrong message.
> eg.:
> ij> show schema;
> ERROR 42X01: Syntax error: Encountered "show" at line 2, column 1.
> The message should be something like:
> Syntax error: Encountered "schema" at line 2,column 1:no such thing as 
> "schema"

-- 
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