Details
-
Bug
-
Resolution: Fixed
-
Major
-
6.6.0
-
Untriaged
-
1
-
Unknown
Description
Pls see the scenario in MB-39296.
advise select min(addr) from `beer-sample` unnest address as addr
is recommending the following -
[
|
{
|
"#operator": "Advise",
|
"advice": {
|
"#operator": "IndexAdvice",
|
"adviseinfo": {
|
"current_indexes": [
|
{
|
"index_statement": "CREATE INDEX idx_pairs ON `beer-sample`((distinct (pairs(self))))",
|
"keyspace_alias": "beer-sample"
|
}
|
],
|
"recommended_indexes": {
|
"indexes": [
|
{
|
"index_statement": "CREATE INDEX adv_ALL_address ON `beer-sample`(ALL `address`)",
|
"keyspace_alias": "beer-sample",
|
"recommending_rule": "Index keys follow order of predicate types: 1. leading array index for unnest."
|
}
|
]
|
}
|
}
|
},
|
"query": "select min(addr) from `beer-sample` unnest address as addr"
|
}
|
]
|
While the same index already exists -
CREATE INDEX `idx_addresses` ON `beer-sample`((all (`address`)))
– Recommended index to be compared with all the existing indexes for this keyspace to deduplicate.