Loading...

XML

Word

Printable

ADVISE SELECT COUNT(s.c1) AS num

FROM default AS s

UNNEST a1 AS us

WHERE us.type = "x1";

 "index_statement": "CREATE INDEX adv_ALL_a1_type_c1 ON `default`(ALL ARRAY `utype` FOR us IN `a1` END,`c1`)"

It must be us.type

This happens keyspace alias is postfix of unnest alias (i.e. matched at the end)

No reviews matched the request. Check your Options in the drop-down menu of this sections header.

There are no open Gerrit changes

Hide There are 5 closed Gerrit changes

MB-57729 Do not perform string replacement on the entire array key: Gerrit Review:

MB-57729 Do not perform string replacement on the entire array key: Gerrit Review:

MB-57729 Do not perform string replacement on the entire array key: Gerrit Review:

MB-57729 Do not perform string replacement on the entire array key: Gerrit Review:

MB-57729 Do not perform string replacement on the entire array key: Gerrit Review:

If a keyspace alias is a suffix of an unnest alias, Index advice is incorrect