Debian Codegraph @

mysql-test/suite/ndb/r/ndb_row_format.result

raw
1 CREATE TABLE t1 (
2 a INT KEY,
3 b VARCHAR(10)
4 )
5 ROW_FORMAT=FIXED
6 ENGINE=NDB;
7 Warnings:
8 Warning 1478 Row format FIXED incompatible with dynamic attribute b
9 SHOW WARNINGS;
10 Level Code Message
11 Warning 1478 Row format FIXED incompatible with dynamic attribute b
12 ForceVarPart: 0
13 Warnings:
14 Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
15 INSERT INTO t1 values(0,''),(2,"**"),(4,"****"),(6,"******"),(8,"********"),(10,"**********"),(12,"************");
16 Warnings:
17 Warning 1265 Data truncated for column 'b' at row 7
18 SELECT * FROM t1 ORDER BY a;
19 a b
20 0
21 2 **
22 4 ****
23 6 ******
24 8 ********
25 10 **********
26 12 **********
27 DROP TABLE t1;
28 CREATE TABLE t1 (
29 a INT KEY,
30 b INT
31 )
32 ENGINE=NDB;
33 ForceVarPart: 1
34 DROP TABLE t1;
35 CREATE TABLE t1(
36 a INT KEY,
37 b INT
38 )
39 ROW_FORMAT=DEFAULT
40 ENGINE=NDB;
41 ForceVarPart: 1
42 DROP TABLE t1;
43 CREATE TABLE t1(
44 a INT KEY,
45 b INT
46 )
47 ROW_FORMAT=FIXED
48 ENGINE=NDB;
49 ForceVarPart: 0
50 DROP TABLE t1;
51 CREATE TABLE t1(
52 a INT KEY,
53 b INT
54 )
55 ROW_FORMAT=DYNAMIC
56 ENGINE=NDB;
57 ForceVarPart: 1
58 DROP TABLE t1;
59 create table t1 (
60 a int auto_increment primary key,
61 b varchar(1000) character set latin1
62 ) engine = ndb;
63 insert into t1(b) values ('0123456789');
64 insert into t1(b) select b from t1;
65 insert into t1(b) select b from t1;
66 insert into t1(b) select b from t1;
67 insert into t1(b) select b from t1;
68 insert into t1(b) select b from t1;
69 insert into t1(b) select b from t1;
70 insert into t1(b) select b from t1;
71 insert into t1(b) select b from t1;
72 insert into t1(b) select b from t1;
73 insert into t1(b) select b from t1;
74 select count(*) from t1;
75 count(*)
76 1024
77 begin;
78 update t1 set b = concat(b,b);
79 update t1 set b = concat(b,b);
80 update t1 set b = concat(b,b);
81 update t1 set b = concat(b,b);
82 update t1 set b = concat(b,b);
83 rollback;
84 select count(*),b from t1 group by b;
85 count(*) b
86 1024 0123456789
87 drop table t1;
88 CREATE TABLE t1(a int primary key,b int) ROW_FORMAT=DEFAULT engine = NDB;
89 CREATE TABLE t2(a int primary key,b int) ROW_FORMAT=DYNAMIC engine = NDB;
90 CREATE TABLE t3(a int primary key,b int) ROW_FORMAT=FIXED engine = NDB;
91 CREATE TABLE t4(a int primary key,b int) ROW_FORMAT=COMPRESSED engine = NDB;
92 ERROR HY000: Table storage engine 'ndbcluster' does not support the create option 'ROW_FORMAT=COMPRESSED'
93 CREATE TABLE t5(a int primary key,b int) ROW_FORMAT=REDUNDANT engine = NDB;
94 ERROR HY000: Table storage engine 'ndbcluster' does not support the create option 'ROW_FORMAT=REDUNDANT'
95 CREATE TABLE t6(a int primary key,b int) ROW_FORMAT=COMPACT engine = NDB;
96 ERROR HY000: Table storage engine 'ndbcluster' does not support the create option 'ROW_FORMAT=COMPACT'
97 SELECT table_name, row_format FROM information_schema.tables
98 WHERE TABLE_SCHEMA = 'test' order by TABLE_NAME;
99 TABLE_NAME ROW_FORMAT
100 t1 Dynamic
101 t2 Dynamic
102 t3 Fixed
103 ALTER TABLE t2 ALGORITHM=COPY,ROW_FORMAT=COMPRESSED;
104 ERROR HY000: Table storage engine 'ndbcluster' does not support the create option 'ROW_FORMAT=COMPRESSED'
105 DROP TABLE t1,t2,t3;