Details
-
Bug
-
Resolution: Fixed
-
Major
-
5.5.0
-
5.1.0-1269
-
Untriaged
-
Yes
Description
Test which fails:
test_tokens_simple_syntax
How to run the test?
python testrunner.py -i query1.ini -c conf/tuq/py-n1ql-tokens.conf -p nodes_init=1,default_bucket=False
Query run:
explain select * from `beer-sample` where name like 'A%' and abv > 6
Plan:
|
[
|
{
|
"plan": { |
"#operator": "Sequence", |
"~children": [ |
{
|
"#operator": "DistinctScan", |
"scan": { |
"#operator": "IndexScan2", |
"index": "idx_suffixes", |
"index_id": "f637379b635c3d00", |
"index_projection": { |
"primary_key": true |
},
|
"keyspace": "beer-sample", |
"namespace": "default", |
"spans": [ |
{
|
"range": [ |
{
|
"inclusion": 1, |
"low": "null" |
}
|
]
|
}
|
],
|
"using": "gsi" |
}
|
},
|
{
|
"#operator": "Fetch", |
"keyspace": "beer-sample", |
"namespace": "default" |
},
|
{
|
"#operator": "Parallel", |
"~child": { |
"#operator": "Sequence", |
"~children": [ |
{
|
"#operator": "Filter", |
"condition": "(((`beer-sample`.`name`) like \"A%\") and (6 < (`beer-sample`.`abv`)))" |
},
|
{
|
"#operator": "InitialProject", |
"result_terms": [ |
{
|
"expr": "self", |
"star": true |
}
|
]
|
},
|
{
|
"#operator": "FinalProject" |
}
|
]
|
}
|
}
|
]
|
},
|
"text": "select * from `beer-sample` where name like 'A%' and abv > 6;" |
}
|
]
|
Indexes created:
CREATE INDEX `idx_suffixes` ON `beer-sample`((distinct (suffixes(`name`))))
CREATE INDEX `idx_tokens` ON `beer-sample`((distinct (tokens(`description`))))
CREATE INDEX `idx_pairs` ON `beer-sample`((distinct (pairs(self))))
CREATE INDEX `idx22` ON `beer-sample`((distinct (array `v` for `v` in tokens(`description`,
) end)))
CREATE PRIMARY INDEX `beer_primary` ON `beer-sample` WITH
CREATE PRIMARY INDEX `#primary` ON `beer-sample`