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.
1. Connect to DB and open Query Editor. 2. Write following code: " delimiter // create procedure test() begin select * from PERSON; end// delimiter ; " 3. Execute statement. Result: Following message appears in Output window: "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' at line 4 Line 2, column 1 Execution finished after 0 s, 1 error(s) occurred." If delimiter is changed from '//' to for example '\\' everything works fine. So not all strings can be delimiter. Why this issue is P2. Because string "delimiter //" I found in MySQL stored procedures tutorial.
Sorry, the workaround is simple - don't use this delimiter, there are many other choices. I don't believe this is a P2.
Not exactly trivial to fix: the code which checks for the delimiter doesn't get to process all characters. For example '/' is processed separately, because it also has other meanings (beginning of a block comment).
*** Issue 149609 has been marked as a duplicate of this issue. ***
Reassigned to new owner.
Fixed. core-main #1c56dd8a7a80
Integrated into 'main-golden', will be available in build *200909111401* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress) Changeset: http://hg.netbeans.org/main-golden/rev/1c56dd8a7a80 User: Jiri Skrivanek <jskrivanek@netbeans.org> Log: #136833 - Support double-slash delimiter.