112 lines
3.9 KiB
Plaintext
112 lines
3.9 KiB
Plaintext
create table ndb_ddl_test.shadow1 (
|
|
in_other_engine int primary key
|
|
) engine = InnoDB;
|
|
insert into ndb_ddl_test.shadow1 values(100);
|
|
show create table ndb_ddl_test.shadow1;
|
|
ERROR 42S02: Table 'ndb_ddl_test.shadow1' doesn't exist
|
|
create table ndb_ddl_test.shadow1 (
|
|
in_NDB_engine int primary key
|
|
) engine = NDB;
|
|
Warnings:
|
|
Warning 1296 Node <nodeid> 'Distribution of CREATE TABLE 'shadow1' failed'
|
|
select column_name from
|
|
information_schema.columns
|
|
where TABLE_SCHEMA = 'ndb_ddl_test' and TABLE_NAME = 'shadow1';
|
|
COLUMN_NAME
|
|
in_other_engine
|
|
truncate table ndb_ddl_test.shadow1;
|
|
Warnings:
|
|
Warning 1296 Node <nodeid> 'Distribution of TRUNCATE TABLE 'shadow1' failed'
|
|
select column_name from
|
|
information_schema.columns
|
|
where TABLE_SCHEMA = 'ndb_ddl_test' and TABLE_NAME = 'shadow1';
|
|
COLUMN_NAME
|
|
in_other_engine
|
|
select count(*) = 1 from ndb_ddl_test.shadow1;
|
|
count(*) = 1
|
|
1
|
|
alter table ndb_ddl_test.shadow1 algorithm=copy,
|
|
add column added_by_copying_alter int;
|
|
Warnings:
|
|
Warning 1296 Node <nodeid> 'Distribution of ALTER TABLE 'shadow1' failed'
|
|
select column_name from
|
|
information_schema.columns
|
|
where TABLE_SCHEMA = 'ndb_ddl_test' and TABLE_NAME = 'shadow1';
|
|
COLUMN_NAME
|
|
in_other_engine
|
|
alter table ndb_ddl_test.shadow1 algorithm=inplace,
|
|
add column added_by_inplace_alter int default NULL column_format DYNAMIC;
|
|
Warnings:
|
|
Warning 1296 Node <nodeid> 'Distribution of ALTER TABLE 'shadow1' failed'
|
|
select column_name from
|
|
information_schema.columns
|
|
where TABLE_SCHEMA = 'ndb_ddl_test' and TABLE_NAME = 'shadow1';
|
|
COLUMN_NAME
|
|
in_other_engine
|
|
drop table ndb_ddl_test.shadow1;
|
|
Warnings:
|
|
Warning 1296 Node <nodeid> 'Distribution of DROP TABLE 'shadow1' failed'
|
|
rename table ndb_ddl_test.t1 to ndb_ddl_test.shadow1;
|
|
select column_name from
|
|
information_schema.columns
|
|
where TABLE_SCHEMA = 'ndb_ddl_test' and TABLE_NAME = 'shadow1';
|
|
COLUMN_NAME
|
|
in_other_engine
|
|
select column_name from
|
|
information_schema.columns
|
|
where TABLE_SCHEMA = 'ndb_ddl_test' and TABLE_NAME = 't1';
|
|
COLUMN_NAME
|
|
create table ndb_ddl_test.shadow2 (
|
|
in_other_engine int primary key
|
|
) engine = InnoDB;
|
|
insert into ndb_ddl_test.shadow2 values(100);
|
|
rename table ndb_ddl_test.shadow1 to ndb_ddl_test.shadow2;
|
|
Warnings:
|
|
Warning 1296 Node <nodeid> 'Distribution of RENAME TABLE 'shadow1' failed'
|
|
rename table ndb_ddl_test.shadow2 to ndb_ddl_test.t1;
|
|
select column_name from
|
|
information_schema.columns
|
|
where TABLE_SCHEMA = 'ndb_ddl_test' and TABLE_NAME = 'shadow1';
|
|
COLUMN_NAME
|
|
in_other_engine
|
|
select count(*) = 1 from ndb_ddl_test.shadow1;
|
|
count(*) = 1
|
|
1
|
|
drop table ndb_ddl_test.shadow1;
|
|
drop table ndb_ddl_test.shadow2;
|
|
== verify_mysql_dd.inc ==
|
|
create table ndb_ddl_test2.shadow_in_db (
|
|
in_other_engine int primary key
|
|
) engine = InnoDB;
|
|
create table ndb_ddl_test2.table_in_ndb (
|
|
in_NDB_engine int primary key
|
|
) engine = NDB;
|
|
show create table ndb_ddl_test2.shadow_in_db;
|
|
ERROR 42S02: Table 'ndb_ddl_test2.shadow_in_db' doesn't exist
|
|
drop database ndb_ddl_test2;
|
|
Warnings:
|
|
Warning 1296 Node <nodeid> 'Distribution of DROP DATABASE 'ndb_ddl_test2' failed'
|
|
use ndb_ddl_test2;
|
|
ERROR 42000: Unknown database 'ndb_ddl_test2'
|
|
use ndb_ddl_test2;
|
|
show create table ndb_ddl_test2.table_in_ndb;
|
|
ERROR 42S02: Table 'ndb_ddl_test2.table_in_ndb' doesn't exist
|
|
drop table ndb_ddl_test2.shadow_in_db;
|
|
drop database ndb_ddl_test2;
|
|
create database ndb_ddl_test2;
|
|
USE ndb_ddl_test;
|
|
CREATE TABLE abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz12 (
|
|
id INT PRIMARY KEY
|
|
) ENGINE InnoDB;
|
|
USE ndb_ddl_test;
|
|
CREATE TABLE abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz12 (
|
|
id INT PRIMARY KEY
|
|
) ENGINE NDB;
|
|
Warnings:
|
|
Warning 1296 Node <nodeid> 'Distribution of CREATE TABLE 'abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz12' failed'
|
|
DROP TABLE abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz12;
|
|
Warnings:
|
|
Warning 1296 Node <nodeid> 'Distribution of DROP TABLE 'abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz12' failed'
|
|
DROP TABLE abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz12;
|
|
== verify_mysql_dd.inc ==
|