summaryrefslogtreecommitdiff
path: root/mysql-test/r/rpl000002.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/rpl000002.result')
-rw-r--r--mysql-test/r/rpl000002.result18
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;