From 63e732fe6140f1ca9dbfacb18bff5119c3c67647 Mon Sep 17 00:00:00 2001 From: Marc Alff Date: Thu, 29 Oct 2009 10:51:04 -0600 Subject: Bug#33637 SHOW PROCEDURE CODE/SHOW FUNCTION CODE sp_name gives a syntax error. Backport for 5.5 In non debug builds, the statements: - SHOW PROCEDURE CODE - SHOW FUNCTION CODE used to fail with a "syntax error", which is misleading. These statements have been changed to return the following error for non debug builds: ERROR HY000: The 'SHOW PROCEDURE|FUNCTION CODE' feature is disabled; you need MySQL built with '--with-debug' to have it working For debug builds (./configure --with-debug), nothing is changed. --- mysql-test/t/sp-no-code.test | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 mysql-test/t/sp-no-code.test (limited to 'mysql-test/t/sp-no-code.test') diff --git a/mysql-test/t/sp-no-code.test b/mysql-test/t/sp-no-code.test new file mode 100644 index 00000000000..ce16c32a270 --- /dev/null +++ b/mysql-test/t/sp-no-code.test @@ -0,0 +1,12 @@ +# +# Test the debugging feature "show procedure/function code " +# + +-- source include/have_nodebug.inc + +--error ER_FEATURE_DISABLED +show procedure code foo; + +--error ER_FEATURE_DISABLED +show function code foo; + -- cgit v1.2.1