diff options
Diffstat (limited to 'mysql-test/suite/rpl/r/create_select.result')
-rw-r--r-- | mysql-test/suite/rpl/r/create_select.result | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/mysql-test/suite/rpl/r/create_select.result b/mysql-test/suite/rpl/r/create_select.result new file mode 100644 index 00000000000..ac222824e34 --- /dev/null +++ b/mysql-test/suite/rpl/r/create_select.result @@ -0,0 +1,30 @@ +include/rpl_init.inc [topology=1->2->3] +# On server_1 +CREATE DATABASE test_8428; +USE test_8428; +CREATE TABLE t1(i INT) ENGINE=INNODB; +INSERT INTO t1 VALUES(1), (2), (3), (4), (5); +CREATE TABLE t2 AS SELECT * FROM t1; +CREATE TABLE t3 ENGINE=MyISAM AS SELECT * FROM t1; +# On server_2 +SHOW TABLES IN test_8428; +Tables_in_test_8428 +t1 +t2 +t3 +# On server_3 +SHOW TABLES IN test_8428; +Tables_in_test_8428 +t1 +t2 +t3 +SELECT * from test_8428.t1; +i +1 +2 +3 +4 +5 +DROP DATABASE test_8428; +include/rpl_end.inc +# End of test |