[
https://issues.apache.org/jira/browse/DERBY-2255?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12466188
]
Jean T. Anderson commented on DERBY-2255:
-----------------------------------------
This worked fine for me on max osx (10.4).
It doesn't catch a carriage return inside a quote (and I'd argue it really
shouldn't because a carriage return could be part of the data). For example,
here's a query with a properly closed quote:
ij> select
> *
> from
> bar
> where
> description =
> 'here is row 2';
ID |DESCRIPTION
--------------------------------
2 |here is row 2
1 row selected
And here's a query without a close quote before the semicolon:
ij> select *
> from bar
> where description='here is row 3;
=== hangs here with no continuation prompt ===
I think users might still be confused -- but hopefully less confused because
they can see the continuation prompt on the preceding lines.
> ij should indicate that it is waiting for more input in a multi-line
> interactive statement.
> -------------------------------------------------------------------------------------------
>
> Key: DERBY-2255
> URL: https://issues.apache.org/jira/browse/DERBY-2255
> Project: Derby
> Issue Type: Improvement
> Components: Tools
> Affects Versions: 10.2.2.0
> Reporter: Anders Morken
> Assigned To: Anders Morken
> Priority: Trivial
> Attachments: DERBY-2255-1.diff, DERBY-2255-2.diff
>
>
> Many users have been confused by the lack of response from ij when they
> forget to end a statement with a semicolon, and believe that Derby is taking
> its sweet time answering their query, while ij is simply waiting for more
> input.
> This issue tries to address this by adding a short "> " prompt to the next
> line after a newline has been entered by the user without ending the
> statement with a semicolon.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
