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 143250 - Delimiter not detected if it comes after a comment
Summary: Delimiter not detected if it comes after a comment
Status: VERIFIED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 6.x
Hardware: All All
: P2 blocker (vote)
Assignee: David Vancouvering
URL:
Keywords:
Depends on:
Blocks: 134307
  Show dependency tree
 
Reported: 2008-08-07 23:38 UTC by David Vancouvering
Modified: 2008-08-14 15:50 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description David Vancouvering 2008-08-07 23:38:18 UTC
This works:

DELIMITER ??
DROP TABLE foo??
CREATE TABLE foo(id integer primary key)??

This doesn't:

-- Testing after a comment
DELIMITER ??
DROP TABLE foo??
CREATE TABLE foo(id integer primary key)??

I get: 
Error code 1064, SQL state 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near 'DELIMITER ?? DROP TABLE foo?? CREATE TABLE foo(id integer primary
key)??' at line 1
Line 2, column 1
Comment 1 David Vancouvering 2008-08-07 23:38:48 UTC
I'll take this, I need to fix it for the Sakila script to work anyway
Comment 2 David Vancouvering 2008-08-07 23:39:59 UTC
Blocks Sakila support, although of course I could just get rid of the comments
Comment 3 David Vancouvering 2008-08-11 17:25:36 UTC
Fixed 6d2a816fbac8
Comment 4 Roman Mostyka 2008-08-13 12:27:21 UTC
Verified with build 080812.
Comment 5 Quality Engineering 2008-08-14 15:50:48 UTC
Integrated into 'main-golden', available in build *200808141419* on http://bits.netbeans.org/dev/nightly/
Changeset: http://hg.netbeans.org/main/rev/6d2a816fbac8
User: David Van Couvering <davidvc@netbeans.org>
Log: #143250 - Delimiter statement not being detected after a line comment