Details
-
Bug
-
Resolution: Fixed
-
Minor
-
6.5.0
-
6.5.0-4920
-
Triaged
-
Unknown
Description
Create a bucket bucket0
Run this query:
advise select id,url,address,title,city,name,country,public_likes from bucket0 use index (def_primary) where some p in public_likes satisfies p like "Ge%" END AND type = "hotel" order by id, url, address, title, city DESC, name, country
No index recommendation at this time: no keyspace found.
You will get an error that there is no keyspace, this isn't very clear as the issue is that you have the use index keyword, the keyspace itself exists.
Attachments
For Gerrit Dashboard: MB-37176 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
121101,2 | MB-37176 Bypass the check for USE INDEX hint for Index Advisor | master | query | Status: ABANDONED | 0 | 0 |
121104,2 | MB-37176 Bypass USE INDEX hints for index advisor | mad-hatter | query | Status: MERGED | +2 | +1 |