When Indexkeys are conditional functions and query used those functions exactly "index_projection" of EXPLAIN doesn't contain keypos of the that function this result in indexer not sending those keys and eventually query considers those MISSING.
The impacted functions and corresponding sample query usages are.
CREATE INDEX ix25 ON default(x1, IFMISSING(c1,c2), IFMISSINGORNULL(c1,c2), IFNULL(c1,c2), MISSINGIF(c1,c2), NULLIF(c1,c2),x100);
|
EXPLAIN SELECT IFMISSING(c1,c2), IFMISSINGORNULL(c1,c2), IFNULL(c1,c2), MISSINGIF(c1,c2), NULLIF(c1,c2) FROM default WHERE x1 = 10;
|
|
CREATE INDEX ix26 ON default(x2, IFINF(c1,c2), IFNAN(c1,c2), IFNANORINF(c1,c2), NANIF(c1,c2), NEGINFIF(c1,c2), POSINFIF(c1,c2),x200);
|
EXPLAIN SELECT IFINF(c1,c2), IFNAN(c1,c2), IFNANORINF(c1,c2), NANIF(c1,c2), NEGINFIF(c1,c2), POSINFIF(c1,c2) FROM default WHERE x2 = 10;
|
Major