Debian Codegraph @

mysql-test/suite/ndb_ddl/shadow_table.result

raw
1 create table ndb_ddl_test.shadow1 (
2 in_other_engine int primary key
3 ) engine = InnoDB;
4 insert into ndb_ddl_test.shadow1 values(100);
5 show create table ndb_ddl_test.shadow1;
6 ERROR 42S02: Table 'ndb_ddl_test.shadow1' doesn't exist
7 create table ndb_ddl_test.shadow1 (
8 in_NDB_engine int primary key
9 ) engine = NDB;
10 Warnings:
11 Warning 1296 Node <nodeid> 'Distribution of CREATE TABLE 'shadow1' failed'
12 select column_name from
13 information_schema.columns
14 where TABLE_SCHEMA = 'ndb_ddl_test' and TABLE_NAME = 'shadow1';
15 COLUMN_NAME
16 in_other_engine
17 truncate table ndb_ddl_test.shadow1;
18 Warnings:
19 Warning 1296 Node <nodeid> 'Distribution of TRUNCATE TABLE 'shadow1' failed'
20 select column_name from
21 information_schema.columns
22 where TABLE_SCHEMA = 'ndb_ddl_test' and TABLE_NAME = 'shadow1';
23 COLUMN_NAME
24 in_other_engine
25 select count(*) = 1 from ndb_ddl_test.shadow1;
26 count(*) = 1
27 1
28 alter table ndb_ddl_test.shadow1 algorithm=copy,
29 add column added_by_copying_alter int;
30 Warnings:
31 Warning 1296 Node <nodeid> 'Distribution of ALTER TABLE 'shadow1' failed'
32 select column_name from
33 information_schema.columns
34 where TABLE_SCHEMA = 'ndb_ddl_test' and TABLE_NAME = 'shadow1';
35 COLUMN_NAME
36 in_other_engine
37 alter table ndb_ddl_test.shadow1 algorithm=inplace,
38 add column added_by_inplace_alter int default NULL column_format DYNAMIC;
39 Warnings:
40 Warning 1296 Node <nodeid> 'Distribution of ALTER TABLE 'shadow1' failed'
41 select column_name from
42 information_schema.columns
43 where TABLE_SCHEMA = 'ndb_ddl_test' and TABLE_NAME = 'shadow1';
44 COLUMN_NAME
45 in_other_engine
46 drop table ndb_ddl_test.shadow1;
47 Warnings:
48 Warning 1296 Node <nodeid> 'Distribution of DROP TABLE 'shadow1' failed'
49 rename table ndb_ddl_test.t1 to ndb_ddl_test.shadow1;
50 select column_name from
51 information_schema.columns
52 where TABLE_SCHEMA = 'ndb_ddl_test' and TABLE_NAME = 'shadow1';
53 COLUMN_NAME
54 in_other_engine
55 select column_name from
56 information_schema.columns
57 where TABLE_SCHEMA = 'ndb_ddl_test' and TABLE_NAME = 't1';
58 COLUMN_NAME
59 create table ndb_ddl_test.shadow2 (
60 in_other_engine int primary key
61 ) engine = InnoDB;
62 insert into ndb_ddl_test.shadow2 values(100);
63 rename table ndb_ddl_test.shadow1 to ndb_ddl_test.shadow2;
64 Warnings:
65 Warning 1296 Node <nodeid> 'Distribution of RENAME TABLE 'shadow1' failed'
66 rename table ndb_ddl_test.shadow2 to ndb_ddl_test.t1;
67 select column_name from
68 information_schema.columns
69 where TABLE_SCHEMA = 'ndb_ddl_test' and TABLE_NAME = 'shadow1';
70 COLUMN_NAME
71 in_other_engine
72 select count(*) = 1 from ndb_ddl_test.shadow1;
73 count(*) = 1
74 1
75 drop table ndb_ddl_test.shadow1;
76 drop table ndb_ddl_test.shadow2;
77 == verify_mysql_dd.inc ==
78 create table ndb_ddl_test2.shadow_in_db (
79 in_other_engine int primary key
80 ) engine = InnoDB;
81 create table ndb_ddl_test2.table_in_ndb (
82 in_NDB_engine int primary key
83 ) engine = NDB;
84 show create table ndb_ddl_test2.shadow_in_db;
85 ERROR 42S02: Table 'ndb_ddl_test2.shadow_in_db' doesn't exist
86 drop database ndb_ddl_test2;
87 Warnings:
88 Warning 1296 Node <nodeid> 'Distribution of DROP DATABASE 'ndb_ddl_test2' failed'
89 use ndb_ddl_test2;
90 ERROR 42000: Unknown database 'ndb_ddl_test2'
91 use ndb_ddl_test2;
92 show create table ndb_ddl_test2.table_in_ndb;
93 ERROR 42S02: Table 'ndb_ddl_test2.table_in_ndb' doesn't exist
94 drop table ndb_ddl_test2.shadow_in_db;
95 drop database ndb_ddl_test2;
96 create database ndb_ddl_test2;
97 USE ndb_ddl_test;
98 CREATE TABLE abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz12 (
99 id INT PRIMARY KEY
100 ) ENGINE InnoDB;
101 USE ndb_ddl_test;
102 CREATE TABLE abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz12 (
103 id INT PRIMARY KEY
104 ) ENGINE NDB;
105 Warnings:
106 Warning 1296 Node <nodeid> 'Distribution of CREATE TABLE 'abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz12' failed'
107 DROP TABLE abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz12;
108 Warnings:
109 Warning 1296 Node <nodeid> 'Distribution of DROP TABLE 'abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz12' failed'
110 DROP TABLE abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz12;
111 == verify_mysql_dd.inc ==