Details
-
Bug
-
Resolution: Fixed
-
Major
-
4.5.0
-
Untriaged
-
Unknown
Description
Query which gives correct result:
explain SELECT COUNT FROM simple_table WHERE ((decimal_field1 < 4938) OR ((decimal_field1 > 4938) OR (decimal_field1 <= 4938))) ;
Output:
[
{
"plan": {
"#operator": "Sequence",
"~children": [
{
"#operator": "DistinctScan",
"scan": {
"#operator": "IndexScan",
"covers": [
"cover ((`simple_table`.`decimal_field1`))",
"cover ((meta(`simple_table`).`id`))"
],
"index": "simple_table_idx_decimal_field1",
"keyspace": "simple_table",
"namespace": "default",
"spans": [
{
"Range":
},
{
"Range":
},
{
"Range":
}
],
"using": "gsi"
}
},
{
"#operator": "Parallel",
"~child": {
"#operator": "Sequence",
"~children": [
,
{ "#operator": "InitialGroup", "aggregates": [ "count(*)" ], "group_keys": [] } ]
}
},
,
,
{
"#operator": "Parallel",
"~child": {
"#operator": "Sequence",
"~children": [
{
"#operator": "InitialProject",
"result_terms": [
]
},
]
}
}
]
},
"text": "SELECT COUNT FROM simple_table WHERE ((decimal_field1 < 4938) OR ((decimal_field1 > 4938) OR (decimal_field1 <= 4938))) ;"
}
]
Query which gives wrong result:
explain SELECT COUNT FROM simple_table WHERE NOT ((decimal_field1 < 4938) OR ((decimal_field1 > 4938) OR (decimal_field1 <= 4938))) ;
{
"plan": {
"#operator": "Sequence",
"~children": [
{
"#operator": "IndexCountScan",
"covers": [
"cover ((`simple_table`.`decimal_field1`))",
"cover ((meta(`simple_table`).`id`))"
],
"index": "simple_table_idx_decimal_field1",
"keyspace": "simple_table",
"namespace": "default",
"spans": [
{
"Range":
}
],
"using": "gsi"
},
{
"#operator": "IndexCountProject",
"result_terms": [
]
}
]
},
"text": "SELECT COUNT FROM simple_table WHERE not ((decimal_field1 < 4938) OR ((decimal_field1 > 4938) OR (decimal_field1 <= 4938))) ;"
}
]
Query which gives wrong result:
SELECT bool_field1 FROM simple_table WHERE (bool_field1 == true) AND (bool_field1 == false)
[
{
"plan": {
"#operator": "Sequence",
"~children": [
{
"#operator": "IndexScan",
"covers": [
"cover ((`simple_table`.`bool_field1`))",
"cover ((meta(`simple_table`).`id`))"
],
"index": "simple_table_idx_bool_field1",
"keyspace": "simple_table",
"namespace": "default",
"spans": [
{
"Range":
}
],
"using": "gsi"
},
{
"#operator": "Parallel",
"~child": {
"#operator": "Sequence",
"~children": [
,
{
"#operator": "InitialProject",
"result_terms": [
]
},
]
}
}
]
},
"text": "SELECT bool_field1 FROM simple_table WHERE (bool_field1 == true) AND (bool_field1 == false) ;"
}
]