summaryrefslogtreecommitdiff
path: root/mysql-test/t/rpl000002.test
diff options
context:
space:
mode:
authormonty@mysql.com <>2004-02-17 01:35:17 +0200
committermonty@mysql.com <>2004-02-17 01:35:17 +0200
commite9315f984d9224044e771b5c483050a81b03b947 (patch)
tree7e3324032ecc97c6af3771a6904e8ae32dbf7a48 /mysql-test/t/rpl000002.test
parent050af89dd8034046df593c1ac7e060ee37bfdf27 (diff)
downloadmariadb-git-e9315f984d9224044e771b5c483050a81b03b947.tar.gz
Changed wellformedlen to well_formed_len
Fixed that blobs >16M can be inserted/updated Fixed bug when doing CREATE TEMPORARY TABLE ... LIKE
Diffstat (limited to 'mysql-test/t/rpl000002.test')
-rw-r--r--mysql-test/t/rpl000002.test15
1 files changed, 14 insertions, 1 deletions
diff --git a/mysql-test/t/rpl000002.test b/mysql-test/t/rpl000002.test
index 803eb069b66..4fbb6a595a4 100644
--- a/mysql-test/t/rpl000002.test
+++ b/mysql-test/t/rpl000002.test
@@ -1,5 +1,7 @@
source include/master-slave.inc;
+# Test replication of auto_increment
+
create table t1 (n int auto_increment primary key);
set insert_id = 2000;
insert into t1 values (NULL),(NULL),(NULL);
@@ -12,15 +14,26 @@ drop table t1;
sync_slave_with_master;
stop slave;
connection master;
+
+# Test replication of timestamp
+
create table t2(id int auto_increment primary key, created datetime);
set timestamp=12345;
insert into t2 set created=now();
select * from t2;
+
+# Test replication of CREATE .. LIKE (Bug #2557)
+
+create table t3 like t2;
+create temporary table t4 like t2;
+create table t5 select * from t4;
save_master_pos;
connection slave;
start slave;
sync_with_master;
select * from t2;
+show create table t3;
+show create table t5;
connection master;
-drop table t2;
+drop table t2,t3,t5;
sync_slave_with_master;