diff options
author | monty@mysql.com <> | 2004-02-17 01:35:17 +0200 |
---|---|---|
committer | monty@mysql.com <> | 2004-02-17 01:35:17 +0200 |
commit | e9315f984d9224044e771b5c483050a81b03b947 (patch) | |
tree | 7e3324032ecc97c6af3771a6904e8ae32dbf7a48 /mysql-test/t/rpl000002.test | |
parent | 050af89dd8034046df593c1ac7e060ee37bfdf27 (diff) | |
download | mariadb-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.test | 15 |
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; |