Major Description
Repro steps:
1. CREATE PRIMARY INDEX `#primary` ON `default`
2. select COUNT(meta().id) from default where meta().id == NULL OR (meta().id > 'doc32' and meta().id < 'doc37')
Expected output: In my dataset, there are 4 documents matching second condition after OR. So expected result is :
[
]
Actual result returned by query:
[
]
Please note - the query does not use GSI in this case.
Explain plan:
{
|
"plan": {
|
"#operator": "Sequence",
|
"~children": [
|
{
|
"#operator": "ValueScan",
|
"values": "[]"
|
},
|
{
|
"#operator": "Fetch",
|
"keyspace": "default",
|
"namespace": "default"
|
},
|
{
|
"#operator": "Parallel",
|
"~child": {
|
"#operator": "Sequence",
|
"~children": [
|
{
|
"#operator": "InitialGroup",
|
"aggregates": [
|
"count((meta(`default`).`id`))"
|
],
|
"group_keys": []
|
}
|
]
|
}
|
},
|
{
|
"#operator": "IntermediateGroup",
|
"aggregates": [
|
"count((meta(`default`).`id`))"
|
],
|
"group_keys": []
|
},
|
{
|
"#operator": "FinalGroup",
|
"aggregates": [
|
"count((meta(`default`).`id`))"
|
],
|
"group_keys": []
|
},
|
{
|
"#operator": "Parallel",
|
"~child": {
|
"#operator": "Sequence",
|
"~children": [
|
{
|
"#operator": "InitialProject",
|
"result_terms": [
|
{
|
"expr": "count((meta(`default`).`id`))"
|
}
|
]
|
},
|
{
|
"#operator": "FinalProject"
|
}
|
]
|
}
|
}
|
]
|
},
|
"text": "select COUNT(meta().id) from default where meta().id == NULL OR (meta().id > 'doc32' and meta().id < 'doc37')"
|
}
|
Attachments
| For Gerrit Dashboard: MB-28605 | ||||||
|---|---|---|---|---|---|---|
| # | Subject | Branch | Project | Status | CR | V |
| 91482,4 | MB-28605 OR expression does not evaluate to NULL if one subterm evaluates to NULL | master | query | Status: MERGED | +2 | +1 |
| 92727,2 | MB-28605 Add check for MISSING/NULL after Evaluate() call | master | query | Status: MERGED | +2 | +1 |