Details
-
Bug
-
Resolution: Fixed
-
Major
-
5.0.0
-
5.0.0-2824
-
Untriaged
-
Yes
Description
Test which fails:
./testrunner -i query2.ini -p doc-per-day=6 -t tuqquery.tuq_2i_index.QueriesIndexTests.test_count_distinct
Query executed:
select count(distinct VMs[1].os) from default where VMs[1].os='windows' and tasks_points.task1>1
Explain plan of above query:
{
|
"plan": { |
"#operator": "Sequence", |
"~children": [ |
{
|
"#operator": "IndexCountDistinctScan2", |
"covers": [ |
"cover ((((`default`.`VMs`)[1]).`os`))", |
"cover (((`default`.`tasks_points`).`task1`))", |
"cover ((meta(`default`).`id`))" |
],
|
"index": "idx2", |
"index_id": "fda272eda4be601", |
"keyspace": "default", |
"namespace": "default", |
"spans": [ |
{
|
"exact": true, |
"range": [ |
{
|
"high": "\"windows\"", |
"inclusion": 3, |
"low": "\"windows\"" |
},
|
{
|
"inclusion": 0, |
"low": "1" |
}
|
]
|
}
|
],
|
"using": "gsi" |
},
|
{
|
"#operator": "IndexCountProject", |
"result_terms": [ |
{
|
"expr": "count(distinct (((`default`.`VMs`)[1]).`os`))" |
}
|
]
|
}
|
]
|
},
|
|
Indexes present:
CREATE INDEX `idx` ON `default`(`job_title`) WHERE (`email` like "%@%.%")
CREATE INDEX `idx2` ON `default`(((`VMs`[1]).`os`),(`tasks_points`.`task1`))
CREATE INDEX `idx3` ON `default`(((`VMs`[1]).`os`),`name`) WHERE ((`tasks_points`.`task1`) = 1)
Result for query with secondary index:
[
]
Result for query with primary index:
[
]
Distinct query without count gives same results for primary and secondary index:
select (distinct VMs[1].os) from default where VMs[1].os='windows' and tasks_points.task1>1;
gives 10080 results.
Please let me know if you need the dataset.
Uploading dataset tar file.
I am still checking if its a regression.