[
https://issues.apache.org/jira/browse/DERBY-3408?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12616813#action_12616813
]
Knut Anders Hatlen commented on DERBY-3408:
-------------------------------------------
This looks like a good improvement to me. The SQL state 42X01 doesn't
necessarily mean that the user issued one of the IJ-specific commands, like for
instance:
ij> select * from t where x = 4 sort by z;
ERROR 42X01: Syntax error: Encountered "sort" at line 1, column 29.
Issue the 'help' command for general information on IJ command syntax.
Perhaps we should append "or consult the reference manual for the supported SQL
syntax" or something to cover what the help command is silent about?
> 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.
