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