diff options
Diffstat (limited to 'mysql-test/r/rpl000009.result')
| -rw-r--r-- | mysql-test/r/rpl000009.result | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/mysql-test/r/rpl000009.result b/mysql-test/r/rpl000009.result index d0faf0435e3..fc55de7246c 100644 --- a/mysql-test/r/rpl000009.result +++ b/mysql-test/r/rpl000009.result @@ -46,6 +46,19 @@ show databases; Database mysql test +create database foo; +create table foo.t1(n int, s char(20)); +insert into foo.t1 values (1, 'original foo.t1'); +create table foo.t3(n int, s char(20)); +insert into foo.t3 values (1, 'original foo.t3'); +create database foo2; +create table foo2.t1(n int, s char(20)); +insert into foo2.t1 values (1, 'original foo2.t1'); +create database bar; +create table bar.t1(n int, s char(20)); +insert into bar.t1 values (1, 'original bar.t1'); +create table bar.t3(n int, s char(20)); +insert into bar.t3 values (1, 'original bar.t3'); load data from master; Warnings: Note 1008 Can't drop database 'mysqltest'; database doesn't exist @@ -60,10 +73,23 @@ use mysqltest2; show tables; Tables_in_mysqltest2 use mysqltest; +t1 +t3 +select * from t1; +n s +1 original foo.t1 +use foo2; +show tables; +Tables_in_foo2 +t1 +select * from t1; +n s +1 original foo2.t1 show tables; Tables_in_mysqltest t1 t2 +t3 select * from mysqltest.t1; n s 1 one test |