diff options
| author | unknown <gshchepa/uchum@host.loc> | 2008-05-13 00:37:45 +0500 |
|---|---|---|
| committer | unknown <gshchepa/uchum@host.loc> | 2008-05-13 00:37:45 +0500 |
| commit | 07343d013ffc230a6c7cf9e284615a0afc503de1 (patch) | |
| tree | 7a72be60619a2a6c56eecb436d4e8a59d79c6a7e /mysql-test/t/repair.test | |
| parent | 9592070014671b54f7a763bd8bf1e2b91a69c056 (diff) | |
| parent | e7e49eb69ee6ca949d8f885505da572bb1d394c4 (diff) | |
| download | mariadb-git-07343d013ffc230a6c7cf9e284615a0afc503de1.tar.gz | |
Merge host.loc:/work/bugs/5.0-bugteam-36055
into host.loc:/work/bk/5.1-bugteam
sql/handler.cc:
Auto merged
mysql-test/r/repair.result:
Merge with 5.0-bugteam (bug#36055).
mysql-test/t/repair.test:
Merge with 5.0-bugteam (bug#36055).
sql/sql_table.cc:
Merge with 5.0-bugteam (bug#36055).
Diffstat (limited to 'mysql-test/t/repair.test')
| -rw-r--r-- | mysql-test/t/repair.test | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/mysql-test/t/repair.test b/mysql-test/t/repair.test index b433b8720b9..94a9fda6757 100644 --- a/mysql-test/t/repair.test +++ b/mysql-test/t/repair.test @@ -113,6 +113,36 @@ SET myisam_sort_buffer_size=@@global.myisam_sort_buffer_size; DROP TABLE t1; --echo End of 4.1 tests + +# +# BUG#36055 - mysql_upgrade doesn't really 'upgrade' tables +# + +--echo # Test with a saved table from 4.1 +--copy_file std_data/bug36055.frm $MYSQLTEST_VARDIR/master-data/test/t1.frm +--copy_file std_data/bug36055.MYD $MYSQLTEST_VARDIR/master-data/test/t1.MYD +--copy_file std_data/bug36055.MYI $MYSQLTEST_VARDIR/master-data/test/t1.MYI + +--replace_column 12 # 13 # +SHOW TABLE STATUS LIKE 't1'; +SELECT * FROM t1; + +--echo # Run CHECK TABLE, it should indicate table need a REPAIR TABLE +CHECK TABLE t1 FOR UPGRADE; + +--echo # REPAIR old table USE_FRM should fail +REPAIR TABLE t1 USE_FRM; + +--echo # Run REPAIR TABLE to upgrade .frm file +REPAIR TABLE t1; +--replace_column 12 # 13 # +SHOW TABLE STATUS LIKE 't1'; +SELECT * FROM t1; + +REPAIR TABLE t1 USE_FRM; +SELECT * FROM t1; + +DROP TABLE t1; # End of 5.0 tests # |