Debian Codegraph @

mysql-test/suite/ndbcluster/row_format.result

raw
1 # Create table without specifying ROW_FORMAT, should use default
2 # which is DYNAMIC
3 CREATE TABLE t1_dynamic(
4 a int primary key,
5 b int
6 ) engine = NDB;
7 # Create table with ROW_FORMAT=FIXED, should use FIXED
8 CREATE TABLE t2_fixed(
9 a int primary key,
10 b int
11 ) ROW_FORMAT=FIXED engine = NDB;
12 # Create table with ROW_FORMAT=DEFAULT, will also use DYNAMIC
13 CREATE TABLE t4_default_dynamic(
14 a int primary key,
15 b int
16 ) ROW_FORMAT=DEFAULT engine = NDB;
17 # Show that tables are using the expected row_format
18 SELECT table_name, row_format FROM information_schema.tables
19 WHERE TABLE_SCHEMA = 'test' order by TABLE_NAME;
20 TABLE_NAME ROW_FORMAT
21 t1_dynamic Dynamic
22 t2_fixed Fixed
23 t4_default_dynamic Dynamic
24 #
25 # Check that columns can _not_ be added inplace on a table
26 # which has ROW_FORMAT=FIXED
27 #
28 ALTER TABLE t2_fixed
29 algorithm=inplace,
30 ADD COLUMN c int null;
31 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Adding column(s) or add/reorganize partition not supported online. Try ALGORITHM=COPY.
32 #
33 # Check that columns can be added inplace on a table
34 # which has ROW_FORMAT=DYNAMIC
35 #
36 ALTER TABLE t1_dynamic
37 algorithm=inplace,
38 ADD COLUMN c int null COLUMN_FORMAT DYNAMIC;
39 #
40 # Check that ROW_FORMAT can _not_ be changed with inplace ALTER
41 #
42 ALTER TABLE t1_dynamic
43 algorithm=inplace,
44 ROW_FORMAT=FIXED;
45 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: ROW_FORMAT changed. Try ALGORITHM=COPY.
46 ALTER TABLE t2_fixed
47 algorithm=inplace,
48 ROW_FORMAT=DYNAMIC;
49 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: ROW_FORMAT changed. Try ALGORITHM=COPY.
50 #
51 # Check that ROW_FORMAT can be changed with copying ALTER
52 #
53 # DYNAMIC -> FIXED
54 ALTER TABLE t4_default_dynamic
55 algorithm=copy,
56 ROW_FORMAT=FIXED;
57 # FIXED -> DYNAMIC
58 ALTER TABLE t2_fixed
59 algorithm=copy,
60 ROW_FORMAT=DYNAMIC;
61 DROP TABLE t1_dynamic,t2_fixed,t4_default_dynamic;