diff options
| author | Marc Alff <marc.alff@sun.com> | 2009-10-29 10:51:04 -0600 |
|---|---|---|
| committer | Marc Alff <marc.alff@sun.com> | 2009-10-29 10:51:04 -0600 |
| commit | 63e732fe6140f1ca9dbfacb18bff5119c3c67647 (patch) | |
| tree | 2dcacd76b2ac37ed934e4aecb67f7a107ff04f48 /mysql-test/t/sp-no-code.test | |
| parent | afc87e52ac154db1ae97dc917c3e80e2872b868b (diff) | |
| download | mariadb-git-63e732fe6140f1ca9dbfacb18bff5119c3c67647.tar.gz | |
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.
Diffstat (limited to 'mysql-test/t/sp-no-code.test')
| -rw-r--r-- | mysql-test/t/sp-no-code.test | 12 |
1 files changed, 12 insertions, 0 deletions
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 <name>" +# + +-- source include/have_nodebug.inc + +--error ER_FEATURE_DISABLED +show procedure code foo; + +--error ER_FEATURE_DISABLED +show function code foo; + |