Details
-
Bug
-
Resolution: Fixed
-
Major
-
4.6.2, 5.0.0
-
4.6.2-3889,5.0.0-2873
-
Triaged
-
No
Description
Index created:
create index ix1 on default(distinct pairs(self));
Query issued:
select meta().id from default where a not like "a%";
This query does not use the dynamic index created.
All queries for MB-22808 pass except:
SELECT COUNT FROM simple_table_db_2483_simple_table WHERE char_field1 NOT LIKE '%N'
AND
SELECT MAX( decimal_field1 ) FROM simple_table_db_2483_simple_table WHERE (char_field1 NOT LIKE 'N%') OR ((bool_field1 != false AND int_field1 > 4821)) ORDER BY MAX( int_field1 );
Attachments
Issue Links
- depends on
-
MB-23981 [RQG DYNAMIC INDEXING] Queries with count(*) with <NOT like> not using dynamic indexes
- Closed