diff options
Diffstat (limited to 'mysql-test/r/rpl000002.result')
-rw-r--r-- | mysql-test/r/rpl000002.result | 18 |
1 files changed, 17 insertions, 1 deletions
diff --git a/mysql-test/r/rpl000002.result b/mysql-test/r/rpl000002.result index 56e34b4874f..e5e661795fe 100644 --- a/mysql-test/r/rpl000002.result +++ b/mysql-test/r/rpl000002.result @@ -23,8 +23,24 @@ insert into t2 set created=now(); select * from t2; id created 1 1970-01-01 06:25:45 +create table t3 like t2; +create temporary table t4 like t2; +create table t5 select * from t4; start slave; select * from t2; id created 1 1970-01-01 06:25:45 -drop table t2; +show create table t3; +Table Create Table +t3 CREATE TABLE `t3` ( + `id` int(11) NOT NULL auto_increment, + `created` datetime default NULL, + PRIMARY KEY (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +show create table t5; +Table Create Table +t5 CREATE TABLE `t5` ( + `id` int(11) NOT NULL default '0', + `created` datetime default NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +drop table t2,t3,t5; |