[jira] Updated: (DERBY-3408) Wrong message when using SHOW in ij.

["Bryan Pendleton (JIRA)" <ji...@apache.org>]

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

Bryan Pendleton updated DERBY-3408:
-----------------------------------

    Attachment: suggestHelp.diff

One simple approach would be for IJ to notice when message 42X01
(the general all-purpose 'syntax error' message) was issued, and to
follow it up with a simple suggestion that the user might try using the
'help' command for general information about command syntax.

Attached is a simple patch to do this. 

The output from IJ would then look like:

ij> show;
ERROR 42X01: Syntax error: Encountered "show" at line 1, column 1.
Issue the 'help' command for general information on IJ command syntax.
ij> show schema;
ERROR 42X01: Syntax error: Encountered "show" at line 1, column 1.
Issue the 'help' command for general information on IJ command syntax.

This may impact some number of regression tests; I haven't
investigated to see what the scope of the impact would be, just
wanted to see what people thought of this approach.



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