1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
|
--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;
|
