Details
Description
./testrunner -i b/resources/dev-6-nodes-xdcr_n1ql_2i.ini -t rqg.test_rqg.RQGTests.test_rqg_concurrent_with_predefined_input,database=simple_table_db,reset_database=True,concurreny_count=1,index_quota_percent=40,use_mysql=False,replicas=0,input_rqg_path=/tmp/data_dump,populate_with_replay=True,reset_database=True,skip_cleanup=True,create_secondary_indexes=True,run_query_with_primary=True
Seeing broken results for the following cases when using secondary indexes.
Scenario :: run_query_without_index_hint
Reason :: mismatch in results :: expected [0:1]:: [505], actual [0:1]:: [251]
sql_query :: SELECT COUNT FROM simple_table WHERE NOT ((NOT (bool_field1) OR decimal_field1 = 5038))
n1ql_query :: SELECT COUNT FROM simple_table WHERE NOT ((NOT (bool_field1) OR decimal_field1 = 5038))
<<<<<<<<<< TEST 2 >>>>>>>>>>>
keyword_list :: ['BY', 'DISTINCT', 'IN', 'IS', 'KEY', 'LIKE', 'NOT', 'OR', 'ORDER']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: mismatch in results :: expected [0:1]:: [2477542], actual [0:1]:: [1304139.0]
sql_query :: SELECT SUM(DISTINCT decimal_field1 ) FROM simple_table WHERE NOT ((NOT (bool_field1) OR varchar_field1 LIKE 'YtADqqWuEr%')) ORDER BY primary_key_id , varchar_field1 , char_field1
n1ql_query :: SELECT SUM(DISTINCT decimal_field1 ) FROM simple_table WHERE NOT ((NOT (bool_field1) OR varchar_field1 LIKE 'YtADqqWuEr%')) ORDER BY primary_key_id , varchar_field1 , char_field1