Debian Codegraph @

mysql-test/suite/ndb_ddl/util_tables_drop.result

raw
1 CREATE TABLE t1 (
2 a int primary key
3 ) ENGINE = NDB;
4 SHOW CREATE TABLE t1;
5 Table Create Table
6 t1 CREATE TABLE `t1` (
7 `a` int NOT NULL,
8 PRIMARY KEY (`a`)
9 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
10 RESET MASTER;
11 # Drop mysql.ndb_schema from NDB
12 Dropping table ndb_schema...OK
13 # mysqld1: Wait until ready again...
14 # mysqld2: Wait until ready again...
15 # mysqld3: Wait until ready again...
16 # mysqld4: Wait until ready again...
17 # mysqld5: Wait until ready again...
18 # mysqld6: Wait until ready again...
19 # Check if a LOST_EVENTS event was written to the binlog
20 include/show_binlog_events.inc
21 Log_name Pos Event_type Server_id End_log_pos Info
22 ALTER TABLE t1 ADD COLUMN b int not null;
23 SHOW CREATE TABLE t1;
24 Table Create Table
25 t1 CREATE TABLE `t1` (
26 `a` int NOT NULL,
27 `b` int NOT NULL,
28 PRIMARY KEY (`a`)
29 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
30 DROP TABLE t1;
31 CREATE TABLE t1 (
32 a int primary key
33 ) ENGINE = NDB;
34 SHOW CREATE TABLE t1;
35 Table Create Table
36 t1 CREATE TABLE `t1` (
37 `a` int NOT NULL,
38 PRIMARY KEY (`a`)
39 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
40 RESET MASTER;
41 # Drop mysql.ndb_apply_status from NDB
42 Dropping table ndb_apply_status...OK
43 # mysqld1: Wait until ready again...
44 # mysqld2: Wait until ready again...
45 # mysqld3: Wait until ready again...
46 # mysqld4: Wait until ready again...
47 # mysqld5: Wait until ready again...
48 # mysqld6: Wait until ready again...
49 # Check if a LOST_EVENTS event was written to the binlog
50 include/show_binlog_events.inc
51 Log_name Pos Event_type Server_id End_log_pos Info
52 binlog.000001 # Incident # # #1 (LOST_EVENTS)
53 binlog.000001 # Rotate # # binlog.000002;pos=POS
54 ALTER TABLE t1 ADD COLUMN b int not null;
55 SHOW CREATE TABLE t1;
56 Table Create Table
57 t1 CREATE TABLE `t1` (
58 `a` int NOT NULL,
59 `b` int NOT NULL,
60 PRIMARY KEY (`a`)
61 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
62 DROP TABLE t1;
63 CREATE TABLE t1 (
64 a int primary key
65 ) ENGINE = NDB;
66 SHOW CREATE TABLE t1;
67 Table Create Table
68 t1 CREATE TABLE `t1` (
69 `a` int NOT NULL,
70 PRIMARY KEY (`a`)
71 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
72 RESET MASTER;
73 # Drop mysql.ndb_schema_result from NDB
74 Dropping table ndb_schema_result...OK
75 # mysqld1: Wait until ready again...
76 # mysqld2: Wait until ready again...
77 # mysqld3: Wait until ready again...
78 # mysqld4: Wait until ready again...
79 # mysqld5: Wait until ready again...
80 # mysqld6: Wait until ready again...
81 # Check if a LOST_EVENTS event was written to the binlog
82 include/show_binlog_events.inc
83 Log_name Pos Event_type Server_id End_log_pos Info
84 ALTER TABLE t1 ADD COLUMN b int not null;
85 SHOW CREATE TABLE t1;
86 Table Create Table
87 t1 CREATE TABLE `t1` (
88 `a` int NOT NULL,
89 `b` int NOT NULL,
90 PRIMARY KEY (`a`)
91 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
92 DROP TABLE t1;