Bug #22223 Syntax error near delimiter
Submitted: 10 Sep 2006 11:51 Modified: 11 Sep 2006 12:47
Reporter: Luke Quinane Email Updates:
Status: Not a Bug Impact on me:
None 
Category:Connector / NET Severity:S3 (Non-critical)
Version:1.0.7 OS:Windows (Windows XP SP2)
Assigned to: CPU Architecture:Any

[10 Sep 2006 11:51] Luke Quinane
Description:
A syntax error occurs trying to create a store procedure when running a script with the .net connector.

How to repeat:
Run the attached test program.
[10 Sep 2006 11:52] Luke Quinane
App to demonstrate the problem

Attachment: TestApp.zip (application/zip, text), 3.11 KiB.

[11 Sep 2006 12:47] Tonci Grgin
Hi Luke and thanks for great problem report.

Sorry, I don't see this as a bug. According to manual:
*Creating Stored Procedures from Connector/NET*
  It should be noted that, unlike the command-line and GUI clients, you are not required to specify a special delimiter when creating stored procedures in Connector/NET.

So your script should read:
DROP DATABASE IF EXISTS bug22223;
CREATE DATABASE bug22223;
USE bug22223;
DROP TABLE IF EXISTS Tbl1;
CREATE TABLE Tbl1 (
	Field1 INT NOT NULL
);
INSERT INTO Tbl1 (Field1) VALUES (1);
DROP PROCEDURE IF EXISTS GetField1;
CREATE PROCEDURE GetField1
(
)
BEGIN
	SELECT
		Field1
	FROM
		Tbl1;
END;
[12 Jan 2009 4:18] Jared S
Keyword compatability chart.

+-----+-----------+--------+---------------+
|     | DELIMITER | DEFINE | (DROP;CREATE;)|
+-----+-----------+--------+---------------+
| NET |     NA    |   Y    |     Y         |
+-----+-----------+--------+---------------+
| ODBC|     NA    |   NA   |     NA        |
+-----+-----------+--------+---------------+