diff options
Diffstat (limited to 'mysql-test/suite/innodb/t/innodb-wl5980-alter.test')
-rw-r--r-- | mysql-test/suite/innodb/t/innodb-wl5980-alter.test | 256 |
1 files changed, 186 insertions, 70 deletions
diff --git a/mysql-test/suite/innodb/t/innodb-wl5980-alter.test b/mysql-test/suite/innodb/t/innodb-wl5980-alter.test index 9b51612854f..22b1306e902 100644 --- a/mysql-test/suite/innodb/t/innodb-wl5980-alter.test +++ b/mysql-test/suite/innodb/t/innodb-wl5980-alter.test @@ -6,15 +6,12 @@ --source include/have_innodb.inc --source include/have_symlink.inc ---disable_query_log -# These values can change during the test -LET $innodb_file_per_table_orig=`select @@innodb_file_per_table`; -LET $regexp=/FTS_[0-9a-f_]+([A-Z0-9_]+)\.([islbd]{3})/FTS_AUX_\1.\2/; +SET @innodb_file_per_table_orig=@@GLOBAL.innodb_file_per_table; +LET $regexp=/FTS_[0-9a-f_]+([A-Z0-9_]+)\.([islbd]{3})/FTS_AUX_\1.\2/ /#sql-ib[1-9][0-9]*\.ibd\n//; # Set up some variables LET $MYSQL_DATA_DIR = `select @@datadir`; LET $data_directory_clause = DATA DIRECTORY='$MYSQL_TMP_DIR/alt_dir'; ---enable_query_log SET default_storage_engine=InnoDB; SET GLOBAL innodb_file_per_table=ON; @@ -58,11 +55,15 @@ ALTER TABLE t1 ALTER c2 DROP DEFAULT; SHOW CREATE TABLE t1; --echo ### files in MYSQL_DATA_DIR/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_DATA_DIR/test --replace_regex $regexp ---list_files $MYSQL_DATA_DIR/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --echo ### files in MYSQL_TMP_DIR/alt_dir/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_TMP_DIR/alt_dir/test --replace_regex $regexp ---list_files $MYSQL_TMP_DIR/alt_dir/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt -- source suite/innodb/include/innodb_dict.inc @@ -71,44 +72,60 @@ ALTER TABLE t1 CHANGE c2 c2 INT AFTER c1; ALTER TABLE t1 CHANGE c1 c1 INT FIRST; --echo ### files in MYSQL_DATA_DIR/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_DATA_DIR/test --replace_regex $regexp ---list_files $MYSQL_DATA_DIR/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --echo ### files in MYSQL_TMP_DIR/alt_dir/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_TMP_DIR/alt_dir/test --replace_regex $regexp ---list_files $MYSQL_TMP_DIR/alt_dir/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt -- source suite/innodb/include/innodb_dict.inc ALTER TABLE t1 CHANGE C2 c3 INT; --echo ### files in MYSQL_DATA_DIR/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_DATA_DIR/test --replace_regex $regexp ---list_files $MYSQL_DATA_DIR/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --echo ### files in MYSQL_TMP_DIR/alt_dir/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_TMP_DIR/alt_dir/test --replace_regex $regexp ---list_files $MYSQL_TMP_DIR/alt_dir/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt -- source suite/innodb/include/innodb_dict.inc ALTER TABLE t1 CHANGE c3 C INT; --echo ### files in MYSQL_DATA_DIR/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_DATA_DIR/test --replace_regex $regexp ---list_files $MYSQL_DATA_DIR/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --echo ### files in MYSQL_TMP_DIR/alt_dir/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_TMP_DIR/alt_dir/test --replace_regex $regexp ---list_files $MYSQL_TMP_DIR/alt_dir/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt -- source suite/innodb/include/innodb_dict.inc ALTER TABLE t1 CHANGE C Cöŀumň_TWO INT; --echo ### files in MYSQL_DATA_DIR/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_DATA_DIR/test --replace_regex $regexp ---list_files $MYSQL_DATA_DIR/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --echo ### files in MYSQL_TMP_DIR/alt_dir/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_TMP_DIR/alt_dir/test --replace_regex $regexp ---list_files $MYSQL_TMP_DIR/alt_dir/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt SELECT i.* FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN_COLS i INNER JOIN sys_foreign sf ON i.ID = sf.ID; @@ -121,11 +138,15 @@ ALTER TABLE t1 CHANGE cöĿǖmň_two c3 INT; ALTER TABLE t1 CHANGE cÖĿUMŇ_two c3 INT, RENAME TO t3; --echo ### files in MYSQL_DATA_DIR/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_DATA_DIR/test --replace_regex $regexp ---list_files $MYSQL_DATA_DIR/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --echo ### files in MYSQL_TMP_DIR/alt_dir/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_TMP_DIR/alt_dir/test --replace_regex $regexp ---list_files $MYSQL_TMP_DIR/alt_dir/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt SELECT st.NAME, i.NAME FROM sys_tables st INNER JOIN INFORMATION_SCHEMA.INNODB_SYS_TABLES i @@ -144,11 +165,15 @@ ALTER TABLE t3 CHANGE c3 `1234567890123456789012345678901234567890123456789012345678901234` INT; --echo ### files in MYSQL_DATA_DIR/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_DATA_DIR/test --replace_regex $regexp ---list_files $MYSQL_DATA_DIR/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --echo ### files in MYSQL_TMP_DIR/alt_dir/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_TMP_DIR/alt_dir/test --replace_regex $regexp ---list_files $MYSQL_TMP_DIR/alt_dir/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR SHOW CREATE TABLE t3; @@ -169,11 +194,15 @@ ALTER TABLE t3 CHANGE `倀倁倂倃倄倅倆倇倈倉倊個倌倍倎倏倐們倒倓倔倕倖倗倘候倚倛倜倝倞借倠倡倢倣値倥倦倧倨倩倪倫倬倭倮倯倰倱倲倳倴倵倶倷倸倹债倻值倽倾ä` INT; --echo ### files in MYSQL_DATA_DIR/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_DATA_DIR/test --replace_regex $regexp ---list_files $MYSQL_DATA_DIR/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --echo ### files in MYSQL_TMP_DIR/alt_dir/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_TMP_DIR/alt_dir/test --replace_regex $regexp ---list_files $MYSQL_TMP_DIR/alt_dir/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt # check that the rename is case-insensitive (note the upper-case ä at end) ALTER TABLE t3 CHANGE @@ -181,11 +210,15 @@ ALTER TABLE t3 CHANGE c3 INT; --echo ### files in MYSQL_DATA_DIR/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_DATA_DIR/test --replace_regex $regexp ---list_files $MYSQL_DATA_DIR/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --echo ### files in MYSQL_TMP_DIR/alt_dir/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_TMP_DIR/alt_dir/test --replace_regex $regexp ---list_files $MYSQL_TMP_DIR/alt_dir/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt # test with 4-byte UTF-8 (should be disallowed) --error ER_INVALID_CHARACTER_STRING @@ -197,11 +230,15 @@ ALTER TABLE t3 CHANGE c3 😲 INT; ALTER TABLE t3 RENAME TO t2; --echo ### files in MYSQL_DATA_DIR/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_DATA_DIR/test --replace_regex $regexp ---list_files $MYSQL_DATA_DIR/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --echo ### files in MYSQL_TMP_DIR/alt_dir/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_TMP_DIR/alt_dir/test --replace_regex $regexp ---list_files $MYSQL_TMP_DIR/alt_dir/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt SELECT st.NAME, i.NAME FROM sys_tables st INNER JOIN INFORMATION_SCHEMA.INNODB_SYS_TABLES i @@ -217,11 +254,15 @@ FROM sys_tables st INNER JOIN INFORMATION_SCHEMA.INNODB_SYS_TABLES i ON i.TABLE_ID=st.TABLE_ID; --echo ### files in MYSQL_DATA_DIR/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_DATA_DIR/test --replace_regex $regexp ---list_files $MYSQL_DATA_DIR/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --echo ### files in MYSQL_TMP_DIR/alt_dir/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_TMP_DIR/alt_dir/test --replace_regex $regexp ---list_files $MYSQL_TMP_DIR/alt_dir/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt -- source suite/innodb/include/innodb_dict.inc @@ -257,11 +298,15 @@ SET foreign_key_checks=1; SHOW CREATE TABLE t1c; --echo ### files in MYSQL_DATA_DIR/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_DATA_DIR/test --replace_regex $regexp ---list_files $MYSQL_DATA_DIR/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --echo ### files in MYSQL_TMP_DIR/alt_dir/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_TMP_DIR/alt_dir/test --replace_regex $regexp ---list_files $MYSQL_TMP_DIR/alt_dir/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt -- source suite/innodb/include/innodb_dict.inc @@ -278,11 +323,15 @@ SET foreign_key_checks=0; ALTER TABLE t1c DROP INDEX C3; --echo ### files in MYSQL_DATA_DIR/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_DATA_DIR/test --replace_regex $regexp ---list_files $MYSQL_DATA_DIR/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --echo ### files in MYSQL_TMP_DIR/alt_dir/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_TMP_DIR/alt_dir/test --replace_regex $regexp ---list_files $MYSQL_TMP_DIR/alt_dir/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt SET foreign_key_checks=1; @@ -294,11 +343,15 @@ SHOW CREATE TABLE t1c; ALTER TABLE t1c DROP FOREIGN KEY t1C3; --echo ### files in MYSQL_DATA_DIR/test ---list_files $MYSQL_DATA_DIR/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_DATA_DIR/test --replace_regex $regexp +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --echo ### files in MYSQL_TMP_DIR/alt_dir/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_TMP_DIR/alt_dir/test --replace_regex $regexp ---list_files $MYSQL_TMP_DIR/alt_dir/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR SHOW CREATE TABLE t1c; @@ -307,11 +360,15 @@ SHOW CREATE TABLE t1c; ALTER TABLE t1c DROP INDEX c2, DROP FOREIGN KEY t1C2; --echo ### files in MYSQL_DATA_DIR/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_DATA_DIR/test --replace_regex $regexp ---list_files $MYSQL_DATA_DIR/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --echo ### files in MYSQL_TMP_DIR/alt_dir/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_TMP_DIR/alt_dir/test --replace_regex $regexp ---list_files $MYSQL_TMP_DIR/alt_dir/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR SHOW CREATE TABLE t1c; @@ -321,11 +378,15 @@ SHOW CREATE TABLE t1c; ALTER TABLE t1 DROP INDEX c2, CHANGE c3 c2 INT; --echo ### files in MYSQL_DATA_DIR/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_DATA_DIR/test --replace_regex $regexp ---list_files $MYSQL_DATA_DIR/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --echo ### files in MYSQL_TMP_DIR/alt_dir/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_TMP_DIR/alt_dir/test --replace_regex $regexp ---list_files $MYSQL_TMP_DIR/alt_dir/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt -- source suite/innodb/include/innodb_dict.inc @@ -344,11 +405,15 @@ CHANGE c1 pk INT, ALTER c2 SET DEFAULT 42, RENAME TO tt, ALGORITHM=INPLACE, LOCK=SHARED; --echo ### files in MYSQL_DATA_DIR/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_DATA_DIR/test --replace_regex $regexp ---list_files $MYSQL_DATA_DIR/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --echo ### files in MYSQL_TMP_DIR/alt_dir/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_TMP_DIR/alt_dir/test --replace_regex $regexp ---list_files $MYSQL_TMP_DIR/alt_dir/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt # The output should be empty, because index->id was reassigned. -- source suite/innodb/include/innodb_dict.inc @@ -388,11 +453,15 @@ CREATE TABLE t1n LIKE t1o; ALTER TABLE t1n ADD FULLTEXT INDEX(ct); --echo ### files in MYSQL_DATA_DIR/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_DATA_DIR/test --replace_regex $regexp ---list_files $MYSQL_DATA_DIR/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --echo ### files in MYSQL_TMP_DIR/alt_dir/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_TMP_DIR/alt_dir/test --replace_regex $regexp ---list_files $MYSQL_TMP_DIR/alt_dir/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --error ER_WRONG_COLUMN_NAME ALTER TABLE t1n CHANGE c1 Fts_DOC_ID INT, ALGORITHM=INPLACE; @@ -403,30 +472,42 @@ ALTER TABLE t1n CHANGE FTS_DOC_ID c11 INT, ALGORITHM=INPLACE; ALTER TABLE t1n CHANGE c1 FTS_DOC_ïD INT, ALGORITHM=INPLACE; --echo ### files in MYSQL_DATA_DIR/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_DATA_DIR/test --replace_regex $regexp ---list_files $MYSQL_DATA_DIR/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --echo ### files in MYSQL_TMP_DIR/alt_dir/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_TMP_DIR/alt_dir/test --replace_regex $regexp ---list_files $MYSQL_TMP_DIR/alt_dir/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt ALTER TABLE t1n CHANGE FTS_DOC_ÏD c1 INT, ALGORITHM=INPLACE; --echo ### files in MYSQL_DATA_DIR/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_DATA_DIR/test --replace_regex $regexp ---list_files $MYSQL_DATA_DIR/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --echo ### files in MYSQL_TMP_DIR/alt_dir/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_TMP_DIR/alt_dir/test --replace_regex $regexp ---list_files $MYSQL_TMP_DIR/alt_dir/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt ALTER TABLE t1n CHANGE c1 c2 INT, CHANGE c2 ct INT, CHANGE ct c1 TEXT, ALGORITHM=INPLACE; --echo ### files in MYSQL_DATA_DIR/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_DATA_DIR/test --replace_regex $regexp ---list_files $MYSQL_DATA_DIR/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --echo ### files in MYSQL_TMP_DIR/alt_dir/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_TMP_DIR/alt_dir/test --replace_regex $regexp ---list_files $MYSQL_TMP_DIR/alt_dir/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR SHOW CREATE TABLE t1n; @@ -434,11 +515,15 @@ ALTER TABLE t1n CHANGE c2 c1 INT, CHANGE ct c2 INT, CHANGE c1 ct TEXT, ALGORITHM=COPY; --echo ### files in MYSQL_DATA_DIR/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_DATA_DIR/test --replace_regex $regexp ---list_files $MYSQL_DATA_DIR/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --echo ### files in MYSQL_TMP_DIR/alt_dir/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_TMP_DIR/alt_dir/test --replace_regex $regexp ---list_files $MYSQL_TMP_DIR/alt_dir/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR SHOW CREATE TABLE t1n; @@ -451,33 +536,45 @@ ALTER TABLE t1n ADD INDEX(c2), CHANGE c2 c4 INT, ALGORITHM=COPY; ALTER TABLE t1n ADD INDEX(c4), CHANGE c2 c4 INT, ALGORITHM=INPLACE; --echo ### files in MYSQL_DATA_DIR/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_DATA_DIR/test --replace_regex $regexp ---list_files $MYSQL_DATA_DIR/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --echo ### files in MYSQL_TMP_DIR/alt_dir/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_TMP_DIR/alt_dir/test --replace_regex $regexp ---list_files $MYSQL_TMP_DIR/alt_dir/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR SHOW CREATE TABLE t1n; ALTER TABLE t1n DROP INDEX c4; --echo ### files in MYSQL_DATA_DIR/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_DATA_DIR/test --replace_regex $regexp ---list_files $MYSQL_DATA_DIR/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --echo ### files in MYSQL_TMP_DIR/alt_dir/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_TMP_DIR/alt_dir/test --replace_regex $regexp ---list_files $MYSQL_TMP_DIR/alt_dir/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --error ER_DUP_FIELDNAME ALTER TABLE t1n CHANGE c4 c1 INT, ADD INDEX(c1), ALGORITHM=INPLACE; ALTER TABLE t1n CHANGE c4 c11 INT, ADD INDEX(c11), ALGORITHM=INPLACE; --echo ### files in MYSQL_DATA_DIR/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_DATA_DIR/test --replace_regex $regexp ---list_files $MYSQL_DATA_DIR/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --echo ### files in MYSQL_TMP_DIR/alt_dir/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_TMP_DIR/alt_dir/test --replace_regex $regexp ---list_files $MYSQL_TMP_DIR/alt_dir/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR SHOW CREATE TABLE t1n; @@ -486,22 +583,30 @@ DROP TABLE t1n; ALTER TABLE t1o MODIFY c1 BIGINT UNSIGNED NOT NULL; --echo ### files in MYSQL_DATA_DIR/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_DATA_DIR/test --replace_regex $regexp ---list_files $MYSQL_DATA_DIR/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --echo ### files in MYSQL_TMP_DIR/alt_dir/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_TMP_DIR/alt_dir/test --replace_regex $regexp ---list_files $MYSQL_TMP_DIR/alt_dir/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt ALTER TABLE t1o ADD FULLTEXT INDEX(ct), CHANGE c1 FTS_DOC_ID BIGINT UNSIGNED NOT NULL, ALGORITHM=INPLACE; --echo ### files in MYSQL_DATA_DIR/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_DATA_DIR/test --replace_regex $regexp ---list_files $MYSQL_DATA_DIR/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --echo ### files in MYSQL_TMP_DIR/alt_dir/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_TMP_DIR/alt_dir/test --replace_regex $regexp ---list_files $MYSQL_TMP_DIR/alt_dir/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt # This would create a hidden FTS_DOC_ID column, which cannot be done online. --error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON @@ -521,11 +626,15 @@ ALTER TABLE t1o CHANGE FTS_DOC_ID foo_id BIGINT UNSIGNED NOT NULL, DROP INDEX ct, LOCK=NONE; --echo ### files in MYSQL_DATA_DIR/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_DATA_DIR/test --replace_regex $regexp ---list_files $MYSQL_DATA_DIR/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --echo ### files in MYSQL_TMP_DIR/alt_dir/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_TMP_DIR/alt_dir/test --replace_regex $regexp ---list_files $MYSQL_TMP_DIR/alt_dir/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR SHOW CREATE TABLE t1o; @@ -548,21 +657,29 @@ FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN i WHERE FOR_NAME='test/t1o'; ALTER TABLE t1o ADD UNIQUE INDEX FTS_DOC_ID_INDEX(foo_id); --echo ### files in MYSQL_DATA_DIR/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_DATA_DIR/test --replace_regex $regexp ---list_files $MYSQL_DATA_DIR/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --echo ### files in MYSQL_TMP_DIR/alt_dir/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_TMP_DIR/alt_dir/test --replace_regex $regexp ---list_files $MYSQL_TMP_DIR/alt_dir/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt ALTER TABLE t1o CHANGE foo_id FTS_DOC_ID BIGINT UNSIGNED NOT NULL, ADD FULLTEXT INDEX(ct); --echo ### files in MYSQL_DATA_DIR/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_DATA_DIR/test --replace_regex $regexp ---list_files $MYSQL_DATA_DIR/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --echo ### files in MYSQL_TMP_DIR/alt_dir/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_TMP_DIR/alt_dir/test --replace_regex $regexp ---list_files $MYSQL_TMP_DIR/alt_dir/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --error ER_INNODB_FT_WRONG_DOCID_INDEX ALTER TABLE t1o CHANGE FTS_DOC_ID foo_id BIGINT UNSIGNED NOT NULL; @@ -580,15 +697,14 @@ INNER JOIN sys_tables st ON i.TABLE_ID=st.TABLE_ID; DROP TABLE tt, t1o, sys_tables, sys_indexes, sys_foreign; --echo ### files in MYSQL_DATA_DIR/test +--list_files_write_file $MYSQL_DATA_DIR.files.txt $MYSQL_DATA_DIR/test --replace_regex $regexp ---list_files $MYSQL_DATA_DIR/test +--cat_file $MYSQL_DATA_DIR.files.txt +--remove_file $MYSQL_DATA_DIR.files.txt --echo ### files in MYSQL_TMP_DIR/alt_dir/test --replace_regex $regexp --list_files $MYSQL_TMP_DIR/alt_dir/test --rmdir $MYSQL_TMP_DIR/alt_dir/test --rmdir $MYSQL_TMP_DIR/alt_dir --- disable_query_log -eval set global innodb_file_per_table=$innodb_file_per_table_orig; -call mtr.add_suppression("deleting orphaned .ibd file"); --- enable_query_log +SET GLOBAL innodb_file_per_table = @innodb_file_per_table_orig; |