db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jean T. Anderson (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2255) ij should indicate that it is waiting for more input in a multi-line interactive statement.
Date Sat, 20 Jan 2007 00:21:30 GMT

    [ 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

        

Mime
View raw message