[Bug 209382] Re: mysql-server show procedure bug

Mathias Gug mathiaz at ubuntu.com
Mon Mar 31 19:00:31 BST 2008


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


** Changed in: mysql-dfsg-5.0 (Ubuntu)
   Importance: Undecided => Wishlist
       Status: New => Triaged

** Summary changed:

- mysql-server show procedure bug
+ mysql-server show procedure bug - improve error message

-- 
mysql-server show procedure bug - improve error message
https://bugs.launchpad.net/bugs/209382
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.



More information about the Ubuntu-server-bugs mailing list