Debian Codegraph @

mysql-test/suite/innodb/r/instant_ddl_recovery_old.result

raw
1 #########
2 # SETUP #
3 #########
4 # Stop the running the server
5 # Copy and unzip the datadir.
6 # Restart the server against the unzipped datadir
7 # restart: --datadir=DATADIR --innodb-page-size=16k
8 ##############################################
9 # Test instant ADD COLUMN for REDUNDANT format
10 ##############################################
11 #########
12 # SETUP #
13 #########
14 # Metadata from INFORMATION_SCHEMA.TABLES
15 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
16 test/t1_redundant 7 3 0
17 # Metadata from INFORMATION_SCHEMA.COLUMNS
18 NAME POS MTYPE PRTYPE HAS_DEFAULT
19 id 0 6 1283 0
20 c1 1 13 16711934 0
21 c2 2 13 16711934 0
22 c3 3 13 16711934 1
23 SELECT * FROM t1_redundant;
24 id c1 c2 c3
25 1 r0c0 r1c2 r1c3
26 3 r3c1 r3c2 r3c3
27 ###########
28 # CLEANUP #
29 ###########
30 DROP TABLE t1_redundant;
31 ############################################
32 # Test instant ADD COLUMN for DYNAMIC format
33 ############################################
34 #########
35 # SETUP #
36 #########
37 # Metadata from INFORMATION_SCHEMA.TABLES
38 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
39 test/t1_dynamic 7 3 0
40 # Metadata from INFORMATION_SCHEMA.COLUMNS
41 NAME POS MTYPE PRTYPE HAS_DEFAULT
42 id 0 6 1283 0
43 c1 1 13 16711934 0
44 c2 2 13 16711934 0
45 c3 3 13 16711934 1
46 SELECT * FROM t1_dynamic;
47 id c1 c2 c3
48 1 r0c0 r1c2 r1c3
49 3 r3c1 r3c2 r3c3
50 ###########
51 # CLEANUP #
52 ###########
53 DROP TABLE t1_dynamic;
54 ############################################
55 # Test instant ADD COLUMN for COMPACT format
56 ############################################
57 #########
58 # SETUP #
59 #########
60 # Metadata from INFORMATION_SCHEMA.TABLES
61 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
62 test/t1_compact 7 3 0
63 # Metadata from INFORMATION_SCHEMA.COLUMNS
64 NAME POS MTYPE PRTYPE HAS_DEFAULT
65 id 0 6 1283 0
66 c1 1 13 16711934 0
67 c2 2 13 16711934 0
68 c3 3 13 16711934 1
69 SELECT * FROM t1_compact;
70 id c1 c2 c3
71 1 r0c0 r1c2 r1c3
72 3 r3c1 r3c2 r3c3
73 ###########
74 # CLEANUP #
75 ###########
76 DROP TABLE t1_compact;
77 ###########
78 # CLEANUP #
79 ###########
80 # Shutdown server
81 # Remove copied files
82 # Restarting server to restore server state
83 # restart