Details
-
Bug
-
Resolution: Fixed
-
Major
-
Cheshire-Cat
-
7.0.0-1902
-
Untriaged
-
1
-
Unknown
Description
When I run this query
ADVISE MERGE INTO `travel-sample` t
USING [
,
{"id":"21730", "vacancy": true}] source
ON meta(t).id = "hotel_" || source.id
WHEN MATCHED THEN
UPDATE SET t.old_vacancy = t.vacancy,
t.vacancy = source.vacancy
RETURNING meta(t).id, t.old_vacancy, t.vacancy;
I get this advise output (which is incorrect):
"recommended_indexes": {
"indexes": [
{
"index_statement": "CREATE INDEX adv_hotel ON `travel-sample`('hotel_')",
"keyspace_alias": "travel-sample_t",
"recommending_rule": "Index keys follow order of predicate types: 9. non-static join predicate."
Attachments
For Gerrit Dashboard: MB-39093 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
127111,2 | MB-39093 Collect keyspaceName map for index advisor | master | query | Status: MERGED | +2 | +1 |
127112,2 | MB-39093 Use CountKeyspace to check both sides of EQ/LE/LT when extracting index keys | master | query-ee | Status: MERGED | +2 | +1 |
127557,2 | MB-39093 Use CountKeyspace to check both sides of EQ/LE/LT when extracting index keys | mad-hatter | query-ee | Status: MERGED | +2 | +1 |
127558,1 | MB-39093 Add testcases for mad-hatter | master | query | Status: ABANDONED | 0 | 0 |
127559,2 | MB-39093 Add testcases for Mad-Hatter | mad-hatter | query | Status: MERGED | +2 | +1 |