52 lines
2.0 KiB
Plaintext
52 lines
2.0 KiB
Plaintext
create table t1 (a int primary key)
|
|
engine NDB
|
|
comment='NDB_TABLE=NOLOGGING=1';
|
|
drop table t1;
|
|
create table t1 (a int primary key)
|
|
engine NDB
|
|
comment='NDB_TABLE=NOLOGGING';
|
|
show warnings;
|
|
Level Code Message
|
|
drop table t1;
|
|
create table t1 (a int primary key)
|
|
engine NDB
|
|
comment='NDB_TABLE=NOLOGGING=1,NOLOGGING';
|
|
ERROR HY000: Table storage engine 'ndbcluster' does not support the create option 'Syntax error in COMMENT modifier'
|
|
show warnings;
|
|
Level Code Message
|
|
Warning 1478 NDB_TABLE= : modifier NOLOGGING specified twice
|
|
Error 1478 Table storage engine 'ndbcluster' does not support the create option 'Syntax error in COMMENT modifier'
|
|
create table t1 (a int primary key)
|
|
engine NDB
|
|
comment='NDB_TABLE=NOLOGGING=a,NOLOGGING';
|
|
ERROR HY000: Table storage engine 'ndbcluster' does not support the create option 'Syntax error in COMMENT modifier'
|
|
show warnings;
|
|
Level Code Message
|
|
Warning 1478 NDB_TABLE= : invalid value 'a' for NOLOGGING
|
|
Error 1478 Table storage engine 'ndbcluster' does not support the create option 'Syntax error in COMMENT modifier'
|
|
create table t1 (a int primary key)
|
|
engine NDB
|
|
comment='NDB_TABLE=NOLOGGING,NOLOGGINGa';
|
|
ERROR HY000: Table storage engine 'ndbcluster' does not support the create option 'Syntax error in COMMENT modifier'
|
|
show warnings;
|
|
Level Code Message
|
|
Warning 1478 NDB_TABLE= : unknown modifier: NOLOGGINGa
|
|
Error 1478 Table storage engine 'ndbcluster' does not support the create option 'Syntax error in COMMENT modifier'
|
|
create table t1 (a int primary key,
|
|
b blob comment 'NDB_COLUMN=MAX_BLOB_PART_SIZE',
|
|
c blob)
|
|
engine NDB;
|
|
Attributes:
|
|
a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
|
|
b Blob(256,13948,0) NULL AT=MEDIUM_VAR ST=MEMORY BV=2 BT=NDB$BLOB_#_#
|
|
c Blob(256,2000,0) NULL AT=MEDIUM_VAR ST=MEMORY BV=2 BT=NDB$BLOB_#_#
|
|
drop table t1;
|
|
#
|
|
# Bug#27778713 : 'CREATE TABLE IF EXISTS' RETURNS ERROR 157 DUE TO UNINITIALIZED THD_NDB
|
|
#
|
|
#setup - create the table
|
|
create table t1 (a int primary key) engine ndb;
|
|
#execute same query in loops through mysql -e argument - should pass without any error
|
|
#cleanup
|
|
drop table t1;
|