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
|
##########################################################################
# Test script to test UPGRADE from older version table having
# INSTANT ADD columns.
#
# $row_format is to be set to the row_format on which test is to be run.
##########################################################################
--echo # ------------------------------------------------------------
--echo # Start server with old datadir with
--echo # table t1_$row_format having
--echo # id, c1, c2 normal columns
--echo # c3 INSTANT ADD column with default.
--echo # ------------------------------------------------------------
--disable_warnings
eval SHOW CREATE TABLE t1_$row_format;
--enable_warnings
--echo # ------------------------------------------------------------
--echo # Read rows from upgraded table t1_$row_format
--echo # ------------------------------------------------------------
--let $table_name=t1_$row_format
--source suite/innodb/include/print_instant_metadata.inc
eval SELECT id, LEFT(c1 , 10), LEFT(c2, 10), LEFT(c3, 10) FROM t1_$row_format ORDER BY id;
--echo # ------------------------------------------------------------
--echo # Run an UPDATE and ROLLBACK.
--echo # ------------------------------------------------------------
START TRANSACTION;
eval UPDATE t1_$row_format SET c1 = repeat('x', 200) WHERE id = 1;
eval SELECT id, LEFT(c1 , 10), LEFT(c2, 10), LEFT(c3, 10) FROM t1_$row_format ORDER BY id;
ROLLBACK;
eval SELECT id, LEFT(c1 , 10), LEFT(c2, 10), LEFT(c3, 10) FROM t1_$row_format ORDER BY id;
|
