| 1 |
create database mysqltest; |
| 2 |
create table mysqltest.t1 (a int primary key, b int) engine=ndb; |
| 3 |
use mysqltest; |
| 4 |
show tables; |
| 5 |
Tables_in_mysqltest |
| 6 |
t1 |
| 7 |
drop database mysqltest; |
| 8 |
create database mysqltest; |
| 9 |
use mysqltest; |
| 10 |
show tables; |
| 11 |
Tables_in_mysqltest |
| 12 |
drop database mysqltest; |
| 13 |
create database `mysqltest.db`; |
| 14 |
create table `mysqltest.db`.t1 (a int primary key, b int) engine=ndb; |
| 15 |
alter table `mysqltest.db`.t1 algorithm=copy, add column c int; |
| 16 |
alter table `mysqltest.db`.t1 algorithm=inplace, add column d int column_format dynamic; |
| 17 |
drop table `mysqltest.db`.t1; |
| 18 |
drop database `mysqltest.db`; |
| 19 |
create database newdb; |
| 20 |
create table newdb.t1 (a int primary key) engine=innodb; |
| 21 |
create table newdb.t1 (a int primary key, |
| 22 |
b1 blob, |
| 23 |
b2 blob, |
| 24 |
b3 blob, |
| 25 |
b4 blob, |
| 26 |
b5 blob, |
| 27 |
b6 blob, |
| 28 |
b7 blob, |
| 29 |
b8 blob, |
| 30 |
b9 blob, |
| 31 |
b10 blob, |
| 32 |
b11 blob, |
| 33 |
b12 blob, |
| 34 |
b13 blob, |
| 35 |
b14 blob, |
| 36 |
b15 blob, |
| 37 |
b16 blob, |
| 38 |
b17 blob, |
| 39 |
b18 blob, |
| 40 |
b19 blob, |
| 41 |
b20 blob, |
| 42 |
b21 blob, |
| 43 |
b22 blob, |
| 44 |
b23 blob, |
| 45 |
b24 blob, |
| 46 |
b25 blob, |
| 47 |
b26 blob, |
| 48 |
b27 blob, |
| 49 |
b28 blob, |
| 50 |
b29 blob) engine = ndb; |
| 51 |
Warnings: |
| 52 |
Warning 1296 Node <nodeid> 'Distribution of CREATE TABLE 't1' failed' |
| 53 |
drop database newdb; |
| 54 |
create database newdb; |
| 55 |
use newdb; |
| 56 |
show tables; |
| 57 |
Tables_in_newdb |
| 58 |
create table newdb.t1(a int primary key) engine=ndb; |
| 59 |
show tables; |
| 60 |
Tables_in_newdb |
| 61 |
t1 |
| 62 |
drop table t1; |
| 63 |
drop database newdb; |