diff options
author | unknown <ingo@mysql.com> | 2006-06-29 10:18:29 +0200 |
---|---|---|
committer | unknown <ingo@mysql.com> | 2006-06-29 10:18:29 +0200 |
commit | 579d0519a25a5bc47ceba2b640931fd5fd2d70d4 (patch) | |
tree | c585ef40ededb05605b16ec8f9962b071f6fc73f /mysql-test/r/federated.result | |
parent | 9016a6be2072e93d72656fa7c7822ee93d2000a9 (diff) | |
parent | 01d3a61fefdce51ae946b10359b8c1c39b90d8e5 (diff) | |
download | mariadb-git-579d0519a25a5bc47ceba2b640931fd5fd2d70d4.tar.gz |
Merge mysql.com:/home/mydev/mysql-5.0-amerge
into mysql.com:/home/mydev/mysql-5.0-bug11824
configure.in:
Auto merged
mysql-test/r/federated.result:
Auto merged
mysql-test/t/federated.test:
Auto merged
sql/ha_federated.cc:
Auto merged
sql/mysqld.cc:
Auto merged
Diffstat (limited to 'mysql-test/r/federated.result')
-rw-r--r-- | mysql-test/r/federated.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/federated.result b/mysql-test/r/federated.result index 9194439efd7..fbad519f6b3 100644 --- a/mysql-test/r/federated.result +++ b/mysql-test/r/federated.result @@ -1689,6 +1689,22 @@ id c1 c2 9 abc ppc drop table federated.t1, federated.t2; drop table federated.t1, federated.t2; +create table t1 (id int not null auto_increment primary key, val int); +create table t1 +(id int not null auto_increment primary key, val int) engine=federated +connection='mysql://root@127.0.0.1:9308/test/t1'; +insert into t1 values (1,0),(2,0); +update t1 set val = NULL where id = 1; +select * from t1; +id val +1 NULL +2 0 +select * from t1; +id val +1 NULL +2 0 +drop table t1; +drop table t1; DROP TABLE IF EXISTS federated.t1; DROP DATABASE IF EXISTS federated; DROP TABLE IF EXISTS federated.t1; |