diff options
author | unknown <joreland@mysql.com> | 2004-12-01 12:43:30 +0100 |
---|---|---|
committer | unknown <joreland@mysql.com> | 2004-12-01 12:43:30 +0100 |
commit | 99880af843f5a89baa51389eaee325221df5879d (patch) | |
tree | 43c119cc06a6dd05632385858f9ed5fc4fc78405 /mysql-test/r/ndb_read_multi_range.result | |
parent | 34944e9567d7ba9d3eecbfb8154b2a6da99f911b (diff) | |
download | mariadb-git-99880af843f5a89baa51389eaee325221df5879d.tar.gz |
wl#2126 - ndb - Fix handling of null values wrt read multi range
mysql-test/r/ndb_read_multi_range.result:
Add tests of null handling to read_multi
mysql-test/t/ndb_read_multi_range.test:
Add tests of null handling to read_multi
ndb/include/ndbapi/NdbOperation.hpp:
Get recattr
ndb/include/ndbapi/NdbRecAttr.hpp:
Get recattr
sql/ha_ndbcluster.cc:
Fix handling of null values wrt read multi range
sql/ha_ndbcluster.h:
Fix handling of null values wrt read multi range
Diffstat (limited to 'mysql-test/r/ndb_read_multi_range.result')
-rw-r--r-- | mysql-test/r/ndb_read_multi_range.result | 51 |
1 files changed, 51 insertions, 0 deletions
diff --git a/mysql-test/r/ndb_read_multi_range.result b/mysql-test/r/ndb_read_multi_range.result index 13243eb4353..f42ac394b6c 100644 --- a/mysql-test/r/ndb_read_multi_range.result +++ b/mysql-test/r/ndb_read_multi_range.result @@ -212,3 +212,54 @@ delete from t1 where d in (12,6,7); select * from t1 where d in (12,6,7); a b c d e drop table t1; +create table t1 ( +a int not null primary key, +b int, +c int, +d int, +unique index (b), +index(c) +) engine = ndb; +insert into t1 values +(1,null,1,1), +(2,2,2,2), +(3,null,null,3), +(4,4,null,4), +(5,null,5,null), +(6,6,6,null), +(7,null,null,null), +(8,8,null,null), +(9,null,9,9), +(10,10,10,10), +(11,null,null,11), +(12,12,null,12), +(13,null,13,null), +(14,14,14,null), +(15,null,null,null), +(16,16,null,null); +create table t2 as select * from t1 where a in (5,6,7,8,9,10); +select * from t2 order by a; +a b c d +5 NULL 5 NULL +6 6 6 NULL +7 NULL NULL NULL +8 8 NULL NULL +9 NULL 9 9 +10 10 10 10 +drop table t2; +create table t2 as select * from t1 where b in (5,6,7,8,9,10); +select * from t2 order by a; +a b c d +6 6 6 NULL +8 8 NULL NULL +10 10 10 10 +drop table t2; +create table t2 as select * from t1 where c in (5,6,7,8,9,10); +select * from t2 order by a; +a b c d +5 NULL 5 NULL +6 6 6 NULL +9 NULL 9 9 +10 10 10 10 +drop table t2; +drop table t1; |