Debian Codegraph @

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

raw
1 create table t1 (a int primary key)
2 engine NDB
3 comment='NDB_TABLE=NOLOGGING=1';
4 drop table t1;
5 create table t1 (a int primary key)
6 engine NDB
7 comment='NDB_TABLE=NOLOGGING';
8 show warnings;
9 Level Code Message
10 drop table t1;
11 create table t1 (a int primary key)
12 engine NDB
13 comment='NDB_TABLE=NOLOGGING=1,NOLOGGING';
14 ERROR HY000: Table storage engine 'ndbcluster' does not support the create option 'Syntax error in COMMENT modifier'
15 show warnings;
16 Level Code Message
17 Warning 1478 NDB_TABLE= : modifier NOLOGGING specified twice
18 Error 1478 Table storage engine 'ndbcluster' does not support the create option 'Syntax error in COMMENT modifier'
19 create table t1 (a int primary key)
20 engine NDB
21 comment='NDB_TABLE=NOLOGGING=a,NOLOGGING';
22 ERROR HY000: Table storage engine 'ndbcluster' does not support the create option 'Syntax error in COMMENT modifier'
23 show warnings;
24 Level Code Message
25 Warning 1478 NDB_TABLE= : invalid value 'a' for NOLOGGING
26 Error 1478 Table storage engine 'ndbcluster' does not support the create option 'Syntax error in COMMENT modifier'
27 create table t1 (a int primary key)
28 engine NDB
29 comment='NDB_TABLE=NOLOGGING,NOLOGGINGa';
30 ERROR HY000: Table storage engine 'ndbcluster' does not support the create option 'Syntax error in COMMENT modifier'
31 show warnings;
32 Level Code Message
33 Warning 1478 NDB_TABLE= : unknown modifier: NOLOGGINGa
34 Error 1478 Table storage engine 'ndbcluster' does not support the create option 'Syntax error in COMMENT modifier'
35 create table t1 (a int primary key,
36 b blob comment 'NDB_COLUMN=MAX_BLOB_PART_SIZE',
37 c blob)
38 engine NDB;
39 Attributes:
40 a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
41 b Blob(256,13948,0) NULL AT=MEDIUM_VAR ST=MEMORY BV=2 BT=NDB$BLOB_#_#
42 c Blob(256,2000,0) NULL AT=MEDIUM_VAR ST=MEMORY BV=2 BT=NDB$BLOB_#_#
43 drop table t1;
44 #
45 # Bug#27778713 : 'CREATE TABLE IF EXISTS' RETURNS ERROR 157 DUE TO UNINITIALIZED THD_NDB
46 #
47 #setup - create the table
48 create table t1 (a int primary key) engine ndb;
49 #execute same query in loops through mysql -e argument - should pass without any error
50 #cleanup
51 drop table t1;