Debian Codegraph @

mysql-test/suite/ndb/t/ndb_create_table.test

raw
1 -- source include/have_ndb.inc
2
3 create table t1 (a int primary key)
4 engine NDB
5 comment='NDB_TABLE=NOLOGGING=1';
6 drop table t1;
7
8 create table t1 (a int primary key)
9 engine NDB
10 comment='NDB_TABLE=NOLOGGING';
11 show warnings;
12 drop table t1;
13
14 --error ER_ILLEGAL_HA_CREATE_OPTION
15 create table t1 (a int primary key)
16 engine NDB
17 comment='NDB_TABLE=NOLOGGING=1,NOLOGGING';
18 show warnings;
19
20 --error ER_ILLEGAL_HA_CREATE_OPTION
21 create table t1 (a int primary key)
22 engine NDB
23 comment='NDB_TABLE=NOLOGGING=a,NOLOGGING';
24 show warnings;
25
26 --error ER_ILLEGAL_HA_CREATE_OPTION
27 create table t1 (a int primary key)
28 engine NDB
29 comment='NDB_TABLE=NOLOGGING,NOLOGGINGa';
30 show warnings;
31
32 create table t1 (a int primary key,
33 b blob comment 'NDB_COLUMN=MAX_BLOB_PART_SIZE',
34 c blob)
35 engine NDB;
36 source show_attributes.inc;
37 drop table t1;
38
39 --echo #
40 --echo # Bug#27778713 : 'CREATE TABLE IF EXISTS' RETURNS ERROR 157 DUE TO UNINITIALIZED THD_NDB
41 --echo #
42
43 --echo #setup - create the table
44 create table t1 (a int primary key) engine ndb;
45
46 --echo #execute same query in loops through mysql -e argument - should pass without any error
47 --let $loops = 20
48 while($loops) {
49 --exec $MYSQL -e "create table if not exists test.t1 (a int primary key) engine ndb;"
50 --dec $loops
51 }
52
53 --connection default
54 --echo #cleanup
55 drop table t1;
56