Debian Codegraph @

mysql-test/suite/rpl/r/create_select.result

raw
1 include/rpl_init.inc [topology=1->2->3]
2 connection server_1;
3 CREATE DATABASE test_8428;
4 USE test_8428;
5 CREATE TABLE t1(i INT) ENGINE=INNODB;
6 INSERT INTO t1 VALUES(1), (2), (3), (4), (5);
7 CREATE TABLE t2 AS SELECT * FROM t1;
8 CREATE TABLE t3 ENGINE=MyISAM AS SELECT * FROM t1;
9 connection server_2;
10 SHOW TABLES IN test_8428;
11 Tables_in_test_8428
12 t1
13 t2
14 t3
15 connection server_3;
16 SHOW TABLES IN test_8428;
17 Tables_in_test_8428
18 t1
19 t2
20 t3
21 SELECT * from test_8428.t1;
22 i
23 1
24 2
25 3
26 4
27 5
28 connection server_1;
29 DROP DATABASE test_8428;
30 include/rpl_end.inc
31 # End of test