db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-3242) ij doesn't understand bracketed comments
Date Sat, 01 Dec 2007 23:37:43 GMT

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

Knut Anders Hatlen updated DERBY-3242:
--------------------------------------

    Attachment: comment.sql

Attached is the script I used for testing. This is what ij prints when I run it:

ij> run '/tmp/comment.sql';
ij> create table t (x int);
0 rows inserted/updated/deleted
ij> /*
insert into t values 1, 2, 3;
ERROR 42X01: Syntax error: Encountered "<EOF>" at line 2, column 28.
ij> insert into t values 4, 5, 6;
3 rows inserted/updated/deleted
ij> */
;
ERROR 42X01: Syntax error: Encountered "*" at line 1, column 1.

> ij doesn't understand bracketed comments
> ----------------------------------------
>
>                 Key: DERBY-3242
>                 URL: https://issues.apache.org/jira/browse/DERBY-3242
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL, Tools
>    Affects Versions: 10.4.0.0
>            Reporter: Knut Anders Hatlen
>         Attachments: comment.sql
>
>
> When I execute this sql script in ij
> ------
> create table t (x int);
> /*
> insert into t values 1, 2, 3;
> insert into t values 4, 5, 6;
> */
> ------
> the first INSERT statement in the comment is correctly ignored, but the second one is
executed. So after running the script, table T contains these rows:
> ij> select * from t;
> X          
> -----------
> 4          
> 5          
> 6          
> 3 rows selected

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message