diff options
| author | unknown <svoj@april.(none)> | 2008-02-14 16:47:46 +0400 |
|---|---|---|
| committer | unknown <svoj@april.(none)> | 2008-02-14 16:47:46 +0400 |
| commit | 8ecceaf2db1689e3f0a89a7b22c4409a109ada49 (patch) | |
| tree | 321ae44e7e9cb55d70a5d80e0d591487eeac6542 /mysql-test/r/federated.result | |
| parent | b8f4976df08bcc029b01f3d35c8a10c9190fc023 (diff) | |
| parent | 55f6727b708d99562b48ba5391a43ec235375125 (diff) | |
| download | mariadb-git-8ecceaf2db1689e3f0a89a7b22c4409a109ada49.tar.gz | |
Merge mysql.com:/home/svoj/devel/mysql/BUG33946/mysql-5.0-engines
into mysql.com:/home/svoj/devel/mysql/BUG33946/mysql-5.1-engines
mysql-test/r/federated.result:
Manual merge.
mysql-test/t/federated.test:
Manual merge.
storage/federated/ha_federated.cc:
Manual merge.
Diffstat (limited to 'mysql-test/r/federated.result')
| -rw-r--r-- | mysql-test/r/federated.result | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/r/federated.result b/mysql-test/r/federated.result index 00287338459..98e6569fa36 100644 --- a/mysql-test/r/federated.result +++ b/mysql-test/r/federated.result @@ -2066,6 +2066,30 @@ select 1 from t1 order by a; drop table t1; drop table t1; drop view v1; +CREATE TABLE t1 (a INT, b INT, KEY(a,b)); +INSERT INTO t1 VALUES(NULL,1),(1,NULL),(NULL,NULL),(1,1),(2,2); +CREATE TABLE t1 (a INT, b INT, KEY(a,b)) ENGINE=federated +CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/test/t1'; +SELECT * FROM t1 WHERE a IS NULL; +a b +NULL NULL +NULL 1 +SELECT * FROM t1 WHERE a IS NOT NULL; +a b +1 NULL +1 1 +2 2 +SELECT * FROM t1 WHERE a=1 AND b=1; +a b +1 1 +SELECT * FROM t1 WHERE a IS NULL AND b=1; +a b +NULL 1 +SELECT * FROM t1 WHERE a IS NOT NULL AND b=1; +a b +1 1 +DROP TABLE t1; +DROP TABLE t1; End of 5.1 tests DROP TABLE IF EXISTS federated.t1; DROP DATABASE IF EXISTS federated; |