Debian Codegraph @

mysql-test/suite/innodb/t/upgrade_fts_shared_tablespace.test

raw
1 --source include/not_valgrind.inc
2 --source include/big_test.inc
3
4 --echo # Bug #31154128 INPLACE UPGRADE 5.7 -> 8.0. FAILS WITH "ERROR IN FIXING SE DATA" SPECIFIC CASE
5 --echo #
6 --echo # This test upgrades a 5.7 database with a table in a general tablespace
7 --echo # having a FULLTEXT index to 8.0
8 --echo #
9
10 --echo # Stop the running server
11 --source include/shutdown_mysqld.inc
12
13 --echo # Unzip the datadir
14 # This zip file contains a data directory generated on 5.7 with following commands:
15 # $ mysqld --initialize-insecure --innodb-redo-log-capacity=8388608
16 # $ mysqld --innodb-redo-log-capacity=8388608
17 # CREATE DATABASE test;
18 # USE test;
19 # CREATE TABLESPACE `ts1` ADD DATAFILE 'ts1.ibd' Engine=InnoDB;
20 # CREATE TABLE t1 (c2 text, FULLTEXT idx (c2)) TABLESPACE ts1;
21 # INSERT INTO t1 VALUES ("hello"),("world");
22 # SHUTDOWN;
23 --let $zip_filename = data57_fts_shared_tablespace
24 let $DATADIR1 = $MYSQL_TMP_DIR/$zip_filename;
25 --exec unzip -qo $MYSQLTEST_VARDIR/std_data/$zip_filename.zip -d $DATADIR1
26
27 --echo # Restart the server with the unzipped datadir
28 --replace_result $DATADIR1 DATADIR
29 --let $wait_counter=3000
30 --let $restart_parameters = restart: --datadir=$DATADIR1 --innodb_page_size=16k
31 --source include/start_mysqld.inc
32
33 SHOW TABLES;
34 SHOW CREATE TABLE t1;
35 SELECT * FROM t1;
36 SELECT * FROM t1 WHERE MATCH(c2) AGAINST("world");
37
38 --echo # Cleanup
39 --echo # Shutdown server
40 --source include/shutdown_mysqld.inc
41
42 --echo # Remove copied files
43 --force-rmdir $MYSQL_TMP_DIR/$zip_filename
44
45 --echo # Restart the server
46 let $restart_parameters =;
47 --source include/start_mysqld.inc