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 149609 - not able to run a query with DELIMITER //
Summary: not able to run a query with DELIMITER //
Status: RESOLVED DUPLICATE of bug 136833
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 6.x
Hardware: All All
: P2 blocker (vote)
Assignee: Andrei Badea
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-10-09 11:23 UTC by Jan Horvath
Modified: 2008-10-09 12:27 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 Jan Horvath 2008-10-09 11:23:46 UTC 
I'm not able to run a query like this on MySQL 5:

DROP FUNCTION IF EXISTS test;
DELIMITER //
CREATE FUNCTION test(a INT) RETURNS INT DETERMINISTIC
    BEGIN
        RETURN a;
    END; //
DELIMITER;

SELECT test(2);

If the delimiter '//' is replaced by '|' it works for me. Marking as P2 since it is not easy to find this workaround.
Comment 1 Roman Mostyka 2008-10-09 12:27:17 UTC 
Look comments in original issue why this issue isn't P2.

*** This issue has been marked as a duplicate of 136833 ***