Details
-
Bug
-
Resolution: Resolved
-
Major
-
4.6.4
-
4.6.4-4554
-
Untriaged
-
No
Description
Query which times out:
SELECT AVG( DISTINCT int_field1 ) FROM multiple_table_db_3506_simple_table_1 WHERE ((bool_field1 OR (decimal_field1 IS NULL) OR (int_field1 < 5114))) OR ((((decimal_field1 IS NULL) AND (int_field1 IS NULL)) OR (int_field1 IN [ 8 , 14 , 18 , 36 , 58 ]) OR varchar_field1 <= "ZsRagOVllG")) GROUP BY primary_key_id , varchar_field1
Index created:
CREATE INDEX `idx_multiple_table_db_3506_simple_table_1` ON `multiple_table_db_3506_simple_table_1`((distinct (array `v` for `v` in pairs(self) end))) WITH
There are many such queries which are timing out.
I see these after removing like and not like operator.
Also removed NOT( condition ) from grammar.
Attaching logs.
Attachments
Issue Links
- relates to
-
MB-23891 [N1QL RQG Dynamic Indexing] ERROR _msg= panic=runtime error: invalid memory address or nil pointer dereference stack=goroutine 201
- Closed