用于EagleEye3.0 规则集漏报和误报测试的示例项目,项目收集于github和gitee
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.
 
 
 
 
 
 

66 lines
1.8 KiB

--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;