You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Knut Anders Hatlen (JIRA)" <ji...@apache.org> on 2007/12/02 00:37:43 UTC
[jira] Updated: (DERBY-3242) ij doesn't understand bracketed
comments
[ 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.