1. Connect to DB and open Query Editor.
2. Write following code:
create procedure test()
select * from PERSON;
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.
Integrated into 'main-golden', will be available in build *200909111401* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)
User: Jiri Skrivanek <email@example.com>
Log: #136833 - Support double-slash delimiter.