Details
-
Bug
-
Resolution: Fixed
-
Major
-
6.5.0
-
Untriaged
-
Unknown
Description
Build 4429
As per some recent changes in https://issues.couchbase.com/browse/MB-34548, the advise statement is now returning a bit more information when no indexes can be recommended. However, the QWB isn't showing this full information when pressing the "Advise" button:
1) "select * from default"
Manual advise output:
[
|
{
|
"#operator": "Advise", |
"advice": { |
"#operator": "IndexAdvice", |
"adviseinfo": [ |
{
|
"recommended_indexes": "No secondary index recommendation at this time, primary index may apply." |
}
|
]
|
},
|
"query": "select * from `default`;" |
}
|
]
|
QWB output from Advise button:
"No index recommendation at this time." (missing "primary index may apply"). We might also consider changing the color from green to yellow/orange since this wouldn't be considered a "successful" recommendation
2) "select * from non_bucket" (where the bucket/keyspace doesn't exist)
Manual advise output:
[
|
{
|
"#operator": "Advise", |
"advice": { |
"#operator": "IndexAdvice", |
"adviseinfo": [ |
{
|
"recommended_indexes": "No index recommendation at this time: no keyspace found." |
}
|
]
|
},
|
"query": "select id from test where id = 5;" |
}
|
]
|
QWB output:
QWB output from Advise button:
"No index recommendation at this time." (missing "no keyspace found"). We might also consider changing the color from green to yellow/orange since this wouldn't be considered a "successful" recommendation