diff options
| author | unknown <ramil/ram@mysql.com/ramil.myoffice.izhnet.ru> | 2007-11-21 11:11:22 +0400 |
|---|---|---|
| committer | unknown <ramil/ram@mysql.com/ramil.myoffice.izhnet.ru> | 2007-11-21 11:11:22 +0400 |
| commit | 18851d9ea771499f5e84267d2ed5c16768942f86 (patch) | |
| tree | feb7a77f624de6cb6d1064c296c8db925dfbc6f7 /mysql-test/t/analyze.test | |
| parent | 3f43b07b4ae78728c9bc6e608eb66ba2c35ce9a8 (diff) | |
| download | mariadb-git-18851d9ea771499f5e84267d2ed5c16768942f86.tar.gz | |
Fix for bug #30495: optimize table t1,t2,t3 extended errors
Problem: we have CHECK TABLE options allowed (by accident?) for
ANALYZE/OPTIMIZE TABLE.
Fix: disable them.
Note: it might require additional fixes in 5.1/6.0
mysql-test/r/analyze.result:
Fix for bug #30495: optimize table t1,t2,t3 extended errors
- test result.
mysql-test/t/analyze.test:
Fix for bug #30495: optimize table t1,t2,t3 extended errors
- test case.
sql/sql_yacc.yy:
Fix for bug #30495: optimize table t1,t2,t3 extended errors
- opt_mi_check_type (CHECK TABLE options) removed from analyze: and optimize:
Diffstat (limited to 'mysql-test/t/analyze.test')
| -rw-r--r-- | mysql-test/t/analyze.test | 14 |
1 files changed, 13 insertions, 1 deletions
diff --git a/mysql-test/t/analyze.test b/mysql-test/t/analyze.test index 7c9830bb468..0903db1eca4 100644 --- a/mysql-test/t/analyze.test +++ b/mysql-test/t/analyze.test @@ -72,4 +72,16 @@ analyze table t1; show index from t1; drop table t1; -# End of 4.1 tests +--echo End of 4.1 tests + +# +# Bug #30495: optimize table t1,t2,t3 extended errors +# +create table t1(a int); +--error 1064 +analyze table t1 extended; +--error 1064 +optimize table t1 extended; +drop table t1; + +--echo End of 5.0 tests |