1 2--let $old_table_id = `SELECT table_id FROM information_schema.innodb_tables WHERE name like '%t1%';` 3 4--let $old_instant_cols = `SELECT instant_cols FROM information_schema.innodb_tables WHERE name like '%t1%';` 5 6--eval $instant_add_column 7 8--let $table_id = `SELECT table_id FROM information_schema.innodb_tables WHERE name like '%t1%';` 9 10--let $instant_cols = `SELECT instant_cols FROM information_schema.innodb_tables WHERE name like '%t1%';` 11 12if ($old_table_id != $table_id) 13{ 14 --echo Table ID differed 15} 16 17if ($old_table_id == $table_id) 18{ 19 --echo Table id did not change 20} 21 22if ($old_instant_cols == 0) 23{ 24 --disable_query_log 25 --eval SELECT count(*) = $new_cols FROM information_schema.innodb_columns WHERE table_id = $table_id AND has_default = 1; 26 --enable_query_log 27} 28 29if ($old_instant_cols != 0) 30{ 31--eval SELECT $old_instant_cols = instant_cols AS `Instant columns equal` FROM information_schema.innodb_tables WHERE name like '%t1%' 32} 33 34CHECK TABLE t1; 35