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: | |
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
[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 | +-----+-----------+--------+---------------+