-- source include/have_ndb.inc

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;
drop table t1;

--error ER_ILLEGAL_HA_CREATE_OPTION
create table t1 (a int primary key)
engine NDB
comment='NDB_TABLE=NOLOGGING=1,NOLOGGING';
show warnings;

--error ER_ILLEGAL_HA_CREATE_OPTION
create table t1 (a int primary key)
engine NDB
comment='NDB_TABLE=NOLOGGING=a,NOLOGGING';
show warnings;

--error ER_ILLEGAL_HA_CREATE_OPTION
create table t1 (a int primary key)
engine NDB
comment='NDB_TABLE=NOLOGGING,NOLOGGINGa';
show warnings;

create table t1 (a int primary key,
                 b blob comment 'NDB_COLUMN=MAX_BLOB_PART_SIZE',
                 c blob)
engine NDB;
source show_attributes.inc;
drop table t1;

--echo #
--echo # Bug#27778713 : 'CREATE TABLE IF EXISTS' RETURNS ERROR 157 DUE TO UNINITIALIZED THD_NDB
--echo #

--echo #setup - create the table
create table t1 (a int primary key) engine ndb;

--echo #execute same query in loops through mysql -e argument - should pass without any error
--let $loops = 20
while($loops) {
  --exec $MYSQL -e "create table if not exists test.t1 (a int primary key) engine ndb;"
  --dec $loops
}

--connection default
--echo #cleanup
drop table t1;