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
67
68
69
70
71
72
73
74
75
76
77
78
|
##########################################################################
# Test script to test CHECK TABLE
##########################################################################
--source include/not_valgrind.inc
--source include/have_lowercase0.inc
--source include/have_nodebug.inc
--echo #########
--echo # SETUP #
--echo #########
# ------------------------------------------------------------
# datadir is created as following
#
# on 8.0.28
# Create table t1 (c1 varchar(10));
# Alter table t1 add column c2 varchar(10) default "def_c2", algorithm=instant;
# Alter table t1 add column c3 varchar(10) default "def_c3", algorithm=instant;
# Insert into t1 values ("r1c1", "r1c2", "r1c3");
# Insert into t1 values ("r2c1", "r2c2", "r2c3");
#
# <UPGRADE to 8.0.31>
#
# on 8.0.31
# Insert into t1 values ("r3c1", "r3c2", "def_c3");
# Start transaction;
# Update t1 set c1="r3331c1" where c1="r3c1";
# Rollback;
# ------------------------------------------------------------
--disable_query_log
call mtr.add_suppression("Record has both instant and version bit set");
call mtr.add_suppression("Apparent corruption in space .* page .* index `GEN_CLUST_INDEX`");
call mtr.add_suppression("In page .* of index `GEN_CLUST_INDEX` of table");
--enable_query_log
--echo # Stop the running the server
--source include/shutdown_mysqld.inc
--echo # Copy and unzip the datadir.
--copy_file $MYSQLTEST_VARDIR/std_data/instant_ddl/check_table.zip $MYSQL_TMP_DIR/check_table.zip
--file_exists $MYSQL_TMP_DIR/check_table.zip
--exec unzip -qo $MYSQL_TMP_DIR/check_table.zip -d $MYSQL_TMP_DIR
let $DATADIR = $MYSQL_TMP_DIR/data;
--echo # Restart the server against the unzipped datadir
--let LOG_FILE= $MYSQLTEST_VARDIR/log/my_restart.err
--replace_result $DATADIR DATADIR $LOG_FILE LOG_FILE
--let $restart_parameters = restart: --datadir=$DATADIR --innodb-page-size=16k --log-error=$LOG_FILE
--let $wait_counter=3000
--source include/start_mysqld.inc
SHOW CREATE TABLE t1;
CHECK TABLE t1;
--let SEARCH_FILE= $LOG_FILE
--echo # Expect found
--let SEARCH_PATTERN= Record has both instant and version bit set
--source include/search_pattern.inc
--echo ###########
--echo # CLEANUP #
--echo ###########
--echo # Shutdown server
--source include/shutdown_mysqld.inc
--echo # Remove copied files
--file_exists $MYSQL_TMP_DIR/check_table.zip
--force-rmdir $MYSQL_TMP_DIR/data
--remove_file $MYSQL_TMP_DIR/check_table.zip
--remove_file $LOG_FILE
--echo # Restarting server to restore server state
let $restart_parameters =;
--source include/start_mysqld.inc
|
