summaryrefslogtreecommitdiff
path: root/mysql-test/r/ndb_read_multi_range.result
diff options
context:
space:
mode:
authorunknown <joreland@mysql.com>2004-12-01 12:43:30 +0100
committerunknown <joreland@mysql.com>2004-12-01 12:43:30 +0100
commit99880af843f5a89baa51389eaee325221df5879d (patch)
tree43c119cc06a6dd05632385858f9ed5fc4fc78405 /mysql-test/r/ndb_read_multi_range.result
parent34944e9567d7ba9d3eecbfb8154b2a6da99f911b (diff)
downloadmariadb-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.result51
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;