Description
CREATE INDEX ix5 ON default(orders.order_id); |
-- The following two queries uses ix5 which is not right
|
EXPLAIN SELECT meta().id FROM default orders WHERE order_id = 10; |
EXPLAIN SELECT meta().id FROM default orders WHERE orders.order_id = 10; |
-- The following query is NOT uses ix5 which is right
|
EXPLAIN SELECT meta().id FROM default d WHERE order_id = 10; |
Attachments
Issue Links
- duplicates
-
MB-26740 Select query throwing the error "Duplicate variable v already in scope", since an index contains the variable v
- Closed