[DERBY-3242] ij doesn't understand bracketed comments

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.4.1.3
• Fix Version/s: 10.4.1.3
• Component/s: SQL, Tools
• Assignee: James F. Adams
• Reporter: Knut Anders Hatlen
• Created: 01/Dec/07 23:33
• Updated: 02/May/13 02:29
• Resolved: 17/Dec/07 13:57

Description

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

Issue Links

• is blocked by: DERBY-3626 Issue with bracketed SQL comments on a remote database connection from ij
• is depended upon by: DERBY-3289 Bracketed comments should be documented in the Derby Tools and Utilities Guide
• relates to: DERBY-1749 Implement Bracketed SQL comments (/*...*/ comments)