Description
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