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