| Bug #49710 | Unable to create SP via SQL Editor Add Routine | ||
|---|---|---|---|
| Submitted: | 15 Dec 2009 10:04 | Modified: | 10 Feb 2010 11:22 |
| Reporter: | Alex W | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Workbench: SQL Editor | Severity: | S2 (Serious) |
| Version: | 5.2.10 Beta - Rev4680 | OS: | Windows |
| Assigned to: | Alexander Musienko | CPU Architecture: | Any |
| Tags: | stored procedure | ||
[27 Jan 2010 12:54]
Alfredo Kojima
bug #50116 marked as duplicate of this one
[1 Feb 2010 17:14]
Johannes Taxacher
fix confirmed. will be included in 5.2.16
[10 Feb 2010 11:22]
Tony Bedford
An entry has been added to the 5.2.16 changelog: In the SQL Editor, in the add routine dialog, if the template was used, and a simple SELECT 1; statement added to the template, then when changes were applied the following error was generated: ERROR 1064: 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 '' at line 3 SQL Statement: CREATE PROCEDURE `world`.`new_routine` () BEGIN SELECT 1
Description: Under SQL Development, Connection to Database. When trying to add an SP using Add Routine it fails using the default template in the editor window. -- -------------------------------------------------------------------------------- -- Routine DDL -- -------------------------------------------------------------------------------- DELIMITER // CREATE PROCEDURE `testdb`.`new_routine` () BEGIN SELECT 1; END// When apply is clicked, ERROR 1064: 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 'CREATE PROCEDURE `widget_cms`.`new_routine` () BEGIN SELECT 1' at line 2 How to repeat: 1: Have a connection to a DB and open the SQL Editor. 2: Click "Add Routine" and add some basic SQL. 3: Click Apply. 4: Click Apply on review window. 5: Observe error.