MySQL Bugs: #14702: misleading error message when syntax error in CREATE PROCEDURE

Bug #14702	misleading error message when syntax error in CREATE PROCEDURE
Submitted:	7 Nov 2005 12:27	Modified:	24 Jul 2006 11:15
Reporter:	Guilhem Bichot	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Stored Routines	Severity:	S3 (Non-critical)
Version:	5.0	OS:	Linux (linux)
Assigned to:	Tomash Brechko	CPU Architecture:	Any

Description:
Testing if MySQL supports the IF NOT EXISTS for CREATE PROCEDURE (in fact it does not):

mysql> create if not exists procedure empty() begin end;
ERROR 1446 (HY000): View definer is not fully qualified
while I rather expected "You have an error in your SQL syntax".
Note that I'm using --skip-grant-tables.

How to repeat:
Use --skip-grant-tables (don't know if it matters) and type:
create if not exists procedure empty() begin end;

Suggested fix:
maybe the error message should rather talk about a syntax error, if possible.

This bug is similar to Bug#9801 "Views: imperfect error message" and stems from the way VIEWs' DEFINER grammar is implemented.

mysql> create if not exists procedure empty() begin end
    -> ;
ERROR 1064 (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 'if not exists procedure empty() begin end' at line 1
mysql> select version();
+---------------------------+
| version()                 |
+---------------------------+
| 5.0.25-valgrind-max-debug | 
+---------------------------+
1 row in set (0.00 sec)

mysql>

Tomash, please add a test case and close the bug.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/9486

The patch above adds a test case.  The bug is closed.

Merged into 5.1.12
The test case is in 5.0.25
No changelog entry (we don't know when this got fixed anyway).