CREATE INDEX ix1 ON default(c1);
|
insert into default values("1",{"c1":5});
|
insert into default values("2",{"c1":null});
|
insert into default values("3",{"c1":null});
|
|
curl -v http://Administrator:password@localhost:8093/query/service -H "Content-Type: application/json" -d '{"statement":"prepare p1 from select count(c1) from default where c1 = $name"}'
|
curl -v http://Administrator:password@localhost:8093/query/service -H "Content-Type: application/json" -d '{"prepared":"p1","$name":null}'
|
The second statement should return one document of value 0
c1 = null never be true because nulls can't be compared