1 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;
2 drop database if exists mysqltest;
8 ERROR HY000: Can't create table 'test.t1' (errno: 138)
11 Error 1478 Table storage engine 'ndbcluster' does not support the create option 'Row format FIXED incompatible with variable sized attribute'
12 Error 1005 Can't create table 'test.t1' (errno: 138)
40 create table t1 (a int auto_increment primary key, b varchar(1000)) engine = ndb;
41 insert into t1(b) values ('0123456789');
42 insert into t1(b) select b from t1;
43 insert into t1(b) select b from t1;
44 insert into t1(b) select b from t1;
45 insert into t1(b) select b from t1;
46 insert into t1(b) select b from t1;
47 insert into t1(b) select b from t1;
48 insert into t1(b) select b from t1;
49 insert into t1(b) select b from t1;
50 insert into t1(b) select b from t1;
51 insert into t1(b) select b from t1;
52 select count(*) from t1;
56 update t1 set b = concat(b,b);
57 update t1 set b = concat(b,b);
58 update t1 set b = concat(b,b);
59 update t1 set b = concat(b,b);
60 update t1 set b = concat(b,b);
62 select count(*),b from t1 group by b;