mysql-server show procedure bug - improve error message
Bug #209382 reported by
Taras Halturin
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
mysql-dfsg-5.1 (Ubuntu) |
Triaged
|
Wishlist
|
Unassigned |
Bug Description
Binary package hint: mysql-server
5.0 version have the same bug.
http://
i try to show store code like this:
mysql> show procedure code a1;
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 '' at line 1
# mysqld --help
mysqld Ver 5.0.51a-3ubuntu5 for debian-linux-gnu on i486 ((Ubuntu))
affects: | mysql-dfsg-5.0 (Ubuntu) → mysql-dfsg-5.1 (Ubuntu) |
To post a comment you must log in.
As pointed out on the mysql bug and in the help message, the command is only available when debugging support is enable at build time. mysql is not built with debugging in Ubuntu.
However the error message could be improved as suggested in mysql bug. Thus marking wishlist.
To reproduce:
mysql> DELIMITER //
mysql> CREATE PROCEDURE p1 ()
-> BEGIN
-> DECLARE fanta INT DEFAULT 55;
-> DROP TABLE t2;
-> LOOP
-> INSERT INTO t3 VALUES (fanta);
-> END LOOP;
-> END//
Query OK, 0 rows affected (0.00 sec)
mysql> SHOW PROCEDURE CODE p1//
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 '' at line 1