summaryrefslogtreecommitdiff
path: root/mysql-test/t/federated.test
diff options
context:
space:
mode:
authorunknown <jimw@mysql.com>2006-06-28 12:26:21 -0700
committerunknown <jimw@mysql.com>2006-06-28 12:26:21 -0700
commit01d3a61fefdce51ae946b10359b8c1c39b90d8e5 (patch)
treee0a56f22164103a72115793083e5997fac5daa1c /mysql-test/t/federated.test
parent23474afb8d061e70081f7c221d8b9a7152d1e7f8 (diff)
parent12e62a8e89c2c37268e7a0d845fa4029c7dd3e40 (diff)
downloadmariadb-git-01d3a61fefdce51ae946b10359b8c1c39b90d8e5.tar.gz
Merge bk-internal:/home/bk/mysql-5.0-engines
into mysql.com:/home/jimw/my/mysql-5.0-16494 sql/ha_federated.cc: Auto merged mysql-test/r/federated.result: Resolve conflict mysql-test/t/federated.test: Resolve conflict
Diffstat (limited to 'mysql-test/t/federated.test')
-rw-r--r--mysql-test/t/federated.test18
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/t/federated.test b/mysql-test/t/federated.test
index 780008cf13a..4af253dc326 100644
--- a/mysql-test/t/federated.test
+++ b/mysql-test/t/federated.test
@@ -1361,4 +1361,22 @@ drop table federated.t1, federated.t2;
connection slave;
drop table federated.t1, federated.t2;
+#
+# Bug #16494: Updates that set a column to NULL fail sometimes
+#
+connection slave;
+create table t1 (id int not null auto_increment primary key, val int);
+connection master;
+eval create table t1
+ (id int not null auto_increment primary key, val int) engine=federated
+ connection='mysql://root@127.0.0.1:$SLAVE_MYPORT/test/t1';
+insert into t1 values (1,0),(2,0);
+update t1 set val = NULL where id = 1;
+select * from t1;
+connection slave;
+select * from t1;
+drop table t1;
+connection master;
+drop table t1;
+
source include/federated_cleanup.inc;