This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 71486 - sql commands with "--" are not executed properly
Summary: sql commands with "--" are not executed properly
Status: VERIFIED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 5.x
Hardware: PC All
: P3 blocker (vote)
Assignee: Andrei Badea
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-01-17 12:36 UTC by patrnyv
Modified: 2007-03-01 09:23 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description patrnyv 2006-01-17 12:36:16 UTC 
SQL script

INSERT INTO XKP VALUES(NULL,'B','CZK',NULL,-40,'561','Test 04 -- EBD1082_001',
'2','CZK',NULL,NULL,'0','0','2007-10-31','F',
NULL,99,'2006-01-05','S','',0,22,1,NULL,NULL,'0','0');

is not executed with message: An error has occured during execution: Unexpected
end of command in statement [INSERT INTO XKP VALUES(NULL,'B','CZK',NULL,-40,'561',']


I blame the '--' in next column.
Comment 1 Andrei Badea 2006-01-17 13:39:49 UTC 
You are right, the code which removes the comments doesn't deal correctly with
strings.
Comment 2 Andrei Badea 2006-04-20 23:01:41 UTC 
This was fixed when the support for executing SQL scripts was integrated.
Comment 3 Lukasz Grela 2007-03-01 09:23:45 UTC 
v.