You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
67 lines
1.8 KiB
67 lines
1.8 KiB
3 months ago
|
--source include/force_myisam_default.inc
|
||
|
|
--source include/have_myisam.inc
|
||
|
|
|
||
|
|
|
||
|
|
#
|
||
|
|
# Bug#26325 TEMPORARY TABLE "corrupt" after first read, according to CHECK TABLE
|
||
|
|
#
|
||
|
|
|
||
|
|
# Repair table is supported only by MyISAM engine
|
||
|
|
|
||
|
|
let $global_tmp_storage_engine = `select @@global.default_tmp_storage_engine`;
|
||
|
|
let $session_tmp_storage_engine = `select @@session.default_tmp_storage_engine`;
|
||
|
|
|
||
|
|
SET @@GLOBAL.default_tmp_storage_engine = MyISAM;
|
||
|
|
SET @@session.default_tmp_storage_engine = MyISAM;
|
||
|
|
|
||
|
|
SELECT @@global.default_tmp_storage_engine;
|
||
|
|
SELECT @@session.default_tmp_storage_engine;
|
||
|
|
|
||
|
|
CREATE TEMPORARY TABLE t1(a INT);
|
||
|
|
CHECK TABLE t1;
|
||
|
|
REPAIR TABLE t1;
|
||
|
|
DROP TABLE t1;
|
||
|
|
|
||
|
|
# Reset the variables to MTR default
|
||
|
|
eval SET @@global.default_tmp_storage_engine = $global_tmp_storage_engine;
|
||
|
|
eval SET @@session.default_tmp_storage_engine = $session_tmp_storage_engine;
|
||
|
|
|
||
|
|
SELECT @@global.default_tmp_storage_engine;
|
||
|
|
SELECT @@session.default_tmp_storage_engine;
|
||
|
|
|
||
|
|
CREATE TEMPORARY TABLE t1(a INT);
|
||
|
|
CHECK TABLE t1;
|
||
|
|
REPAIR TABLE t1;
|
||
|
|
DROP TABLE t1;
|
||
|
|
|
||
|
|
--echo # Checking MyISAM storage engine
|
||
|
|
CREATE TABLE t2(i INT) ENGINE=MYISAM;
|
||
|
|
|
||
|
|
--echo # Table has been created with last_checked_for_upgrade = 0,
|
||
|
|
--echo # so the check will be performed
|
||
|
|
CHECK TABLE t2 FOR UPGRADE;
|
||
|
|
|
||
|
|
--echo # Checking again will detect that the table has already been checked
|
||
|
|
CHECK TABLE t2 FOR UPGRADE;
|
||
|
|
|
||
|
|
ALTER TABLE t2 CHANGE COLUMN i j INT, ALGORITHM=INPLACE;
|
||
|
|
|
||
|
|
--echo # Checking again after ALTER INPLACE to verify that the check status is
|
||
|
|
--echo # still present
|
||
|
|
CHECK TABLE t2 FOR UPGRADE;
|
||
|
|
|
||
|
|
ALTER TABLE t2 CHANGE COLUMN j k INT, ALGORITHM=COPY;
|
||
|
|
|
||
|
|
--echo # Checking again after ALTER COPY to verify that the check status is
|
||
|
|
--echo # still present
|
||
|
|
CHECK TABLE t2 FOR UPGRADE;
|
||
|
|
|
||
|
|
TRUNCATE TABLE t2;
|
||
|
|
|
||
|
|
--echo # Checking again after TRUNCATE to verify that the check status is
|
||
|
|
--echo # still present
|
||
|
|
CHECK TABLE t2 FOR UPGRADE;
|
||
|
|
|
||
|
|
--echo # Cleanup
|
||
|
|
DROP TABLE t2;
|