[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

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?

./testrunner -i ${resource_tuq} -p gsi_type=${gsi_type} -t rqg.test_rqg.RQGTests.test_rqg_concurrent,test_file_path=b/resources/rqg/simple_table_db/query_tests_using_templates/query_50000_aggregate_functions.txt.zip,database=multiple_table_db,reset_database=True,concurreny_count=10,index_quota_percent=30,password=password,use_mysql=True,replicas=0,create_secondary_indexes=True,run_query_with_primary=True,record_failure=True,failure_record_path=/tmp,nodes_init=1,build_index_batch_size=1000,build_secondary_index_in_seq=True,nodes_init=1,number_of_buckets=1,total_queries=${total_queries},skip_cleanup=${skip_cleanup},dynamic_indexing=True,create_primary_index=False

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