[RQG DYNAMIC INDEXING] Queries with count(*) with <NOT like> not using dynamic indexes

Index created:

CREATE INDEX idx_multiple_table_db_9884_simple_table_1 ON multiple_table_db_9884_simple_table_1(DISTINCT ARRAY v FOR v IN PAIRS(SELF) END) WITH {'defer_build': 'true'}

Queries not using the dynamic index:

SELECT COUNT FROM multiple_table_db_9884_simple_table_1 WHERE varchar_field1 NOT LIKE '%aHZBOxoEpc'

SELECT COUNT FROM multiple_table_db_9884_simple_table_1 WHERE ((NOT (varchar_field1 LIKE '%aHZBOxoEpc')) OR (char_field1 NOT LIKE "N")) OR (char_field1 IN [ "A" , "B" , "C" , "D" , "E" ])

SELECT AVG( DISTINCT int_field1 ) FROM multiple_table_db_9884_simple_table_1 WHERE ((int_field1 >= 5098 OR primary_key_id NOT LIKE '%549%')) OR ((bool_field1 != true OR primary_key_id = "549")) ORDER BY MAX( decimal_field1 )

SELECT MIN( int_field1 ) FROM multiple_table_db_9884_simple_table_1 WHERE NOT ((varchar_field1 LIKE '%aHZBOxoEpc%' AND int_field1 BETWEEN 44 and 9997)) ORDER BY COUNT( int_field1 )

SELECT COUNT FROM multiple_table_db_9884_simple_table_1 WHERE varchar_field1 NOT LIKE '%aHZBOxoEpc'

SELECT COUNT FROM multiple_table_db_9884_simple_table_1 WHERE (primary_key_id != "549") OR (varchar_field1 NOT LIKE '%aHZBOxoEpc')

SELECT AVG( decimal_field1 ) FROM multiple_table_db_9884_simple_table_1 WHERE (NOT (bool_field1) OR (varchar_field1 NOT LIKE '%aHZBOxoEpc') OR (primary_key_id > "549")) GROUP BY primary_key_id , varchar_field1

SELECT AVG( DISTINCT decimal_field1 ) FROM multiple_table_db_9884_simple_table_1 WHERE ((bool_field1 AND int_field1 IS NULL)) OR ((bool_field1 = true OR varchar_field1 NOT LIKE '%aHZBOxoEpc')) GROUP BY primary_key_id , varchar_field1 , char_field1

SELECT COUNT FROM multiple_table_db_9884_simple_table_1 WHERE primary_key_id NOT LIKE '%549'

SELECT AVG( decimal_field1 ) FROM multiple_table_db_9884_simple_table_1 WHERE (int_field1 IN [ 44 , 46 , 52 , 53 , 54 ] OR char_field1 NOT LIKE '%N%') GROUP BY int_field1

SELECT MAX( int_field1 ) FROM multiple_table_db_9884_simple_table_1 WHERE NOT ((bool_field1 AND primary_key_id LIKE '%549%')) GROUP BY int_field1 , decimal_field1 , primary_key_id , varchar_field1 , bool_field1

Job failing:
cen006-n1ql-vset02-01-rqg-aggregate-methods-DynamicIndexing-primary-secondary-tests

How to run the test?

Result from the job:
Total Queries Run = 10000, Pass = 9931,* Fail = 69*