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."