summaryrefslogtreecommitdiff
path: root/mysql-test/r/sp-dynamic.result
diff options
context:
space:
mode:
authorunknown <konstantin@mysql.com>2006-04-25 04:27:23 +0400
committerunknown <konstantin@mysql.com>2006-04-25 04:27:23 +0400
commitf28b9a34235b08f72bf3c2b8de85227958cac17d (patch)
treed727aecc399c52bb4ae1fb8dd09469ffe7ffbbb8 /mysql-test/r/sp-dynamic.result
parentef82f93dcc0d4636cdf102f6583224b49989581f (diff)
downloadmariadb-git-f28b9a34235b08f72bf3c2b8de85227958cac17d.tar.gz
A fix and a test case for Bug#19308 "REPAIR/OPTIMIZE/ANALYZE
supported in SP but not in PS": just enable them in prepared statements, the supporting functionality was implemented when they were enabled in stored procedures. mysql-test/r/ps.result: Bug#19308: test results fixed. mysql-test/r/ps_1general.result: Adjust existing test cases (ANALYZE/OPTIMIZE/REPAIR are now allowed in prepared statements. mysql-test/r/sp-dynamic.result: Adjust existing test cases (ANALYZE/OPTIMIZE/REPAIR are now allowed in prepared statements. mysql-test/t/ps.test: Add a test case for Bug#19308 "REPAIR/OPTIMIZE/ANALYZE supported in SP but not in PS" mysql-test/t/ps_1general.test: Adjust existing test cases (ANALYZE/OPTIMIZE/REPAIR are now allowed in prepared statements. sql/sql_prepare.cc: Enable ANALYZE, OPTIMIZE, REPAIR in prepared statements.
Diffstat (limited to 'mysql-test/r/sp-dynamic.result')
-rw-r--r--mysql-test/r/sp-dynamic.result6
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/r/sp-dynamic.result b/mysql-test/r/sp-dynamic.result
index c00b09f90e1..d9d5706cded 100644
--- a/mysql-test/r/sp-dynamic.result
+++ b/mysql-test/r/sp-dynamic.result
@@ -286,12 +286,12 @@ id stmt_text status
1 select 1 supported
2 flush tables not supported
3 handler t1 open as ha not supported
-4 analyze table t1 not supported
+4 analyze table t1 supported
5 check table t1 not supported
6 checksum table t1 not supported
7 check table t1 not supported
-8 optimize table t1 not supported
-9 repair table t1 not supported
+8 optimize table t1 supported
+9 repair table t1 supported
10 describe extended select * from t1 supported
11 help help not supported
12 show databases supported