Details
-
Bug
-
Resolution: Fixed
-
Major
-
5.0.0
-
4.7.0-1148
-
Untriaged
-
Yes
Description
This is a regression from 4.6
Test which fails:
|
./testrunner -i query.ini -t tuqquery.tuq_tokens.TokenTests.test_tokens_secondary_indexes -p doc-per-day=1
|
|
Dataset Used:
|
beer-sample
|
|
Index created:
|
CREATE INDEX `idx2` ON `beer-sample`((distinct (array `v` for `v` in tokens(`description`) end)),`description`,`name`)
|
|
Query issued:
|
explain select name from `beer-sample` where any v in tokens(description) satisfies v = "golden" END limit 10
|
|
Plan in 4.6:
|
|
"plan": {
|
"#operator": "Sequence",
|
"~children": [
|
{
|
"#operator": "Sequence",
|
"~children": [
|
{
|
"#operator": "DistinctScan",
|
"scan": {
|
"#operator": "IndexScan",
|
"covers": [
|
"cover ((distinct (array `v` for `v` in tokens((`beer-sample`.`description`)) end)))",<<This array index is missing from covers in spock>>
|
"cover ((`beer-sample`.`description`))",
|
"cover ((`beer-sample`.`name`))",
|
"cover ((meta(`beer-sample`).`id`))"
|
],
|
"index": "idx2",
|
"index_id": "e79b55689f3ae8be",
|
"keyspace": "beer-sample",
|
"namespace": "default",
|
"spans": [
|
{
|
"Range": {
|
"High": [
|
"successor(\"golden\")"
|
],
|
"Inclusion": 1,
|
"Low": [
|
"\"golden\""
|
]
|
}
|
}
|
],
|
"using": "gsi"
|
}
|
},
|
{
|
"#operator": "Parallel",
|
"~child": {
|
"#operator": "Sequence",
|
"~children": [
|
{
|
"#operator": "Filter",
|
"condition": "any `v` in tokens(cover ((`beer-sample`.`description`))) satisfies (`v` = \"golden\") end"
|
},
|
{
|
"#operator": "InitialProject",
|
"result_terms": [
|
{
|
"expr": "cover ((`beer-sample`.`name`))"
|
}
|
]
|
},
|
{
|
"#operator": "FinalProject"
|
}
|
]
|
}
|
}
|
]
|
},
|
{
|
"#operator": "Limit",
|
"expr": "10"
|
}
|
]
|
},
|
|
|
Plan in spock:
|
|
"plan": {
|
"#operator": "Sequence",
|
"~children": [
|
{
|
"#operator": "Sequence",
|
"~children": [
|
{
|
"#operator": "DistinctScan",
|
"scan": {
|
"#operator": "IndexScan",
|
"covers": [
|
"cover ((`beer-sample`.`description`))",
|
"cover ((`beer-sample`.`name`))",
|
"cover ((meta(`beer-sample`).`id`))"
|
],
|
"filter_covers": {
|
"cover (any `v` in tokens((`beer-sample`.`description`)) satisfies (`v` = \"golden\") end)": true
|
},
|
"index": "idx2",
|
"index_id": "71545cbb0a2a3f9d",
|
"keyspace": "beer-sample",
|
"namespace": "default",
|
"spans": [
|
{
|
"Range": {
|
"High": [
|
"successor(\"golden\")"
|
],
|
"Inclusion": 1,
|
"Low": [
|
"\"golden\""
|
]
|
}
|
}
|
],
|
"using": "gsi"
|
}
|
},
|
{
|
"#operator": "Parallel",
|
"~child": {
|
"#operator": "Sequence",
|
"~children": [
|
{
|
"#operator": "Filter",
|
"condition": "cover (any `v` in tokens((`beer-sample`.`description`)) satisfies (`v` = \"golden\") end)"
|
},
|
{
|
"#operator": "InitialProject",
|
"result_terms": [
|
{
|
"expr": "cover ((`beer-sample`.`name`))"
|
}
|
]
|
},
|
{
|
"#operator": "FinalProject"
|
}
|
]
|
}
|
}
|
]
|
},
|
{
|
"#operator": "Limit",
|
"expr": "10"
|
}
|
]
|
},
|
|
Attachments
Issue Links
- blocks
-
MB-22188 4.6.2 Minor Release
- Closed