RQG: Difference in results seen from aggregate queries

Test which fails:
cen006-n1ql-vset02-01-rqg-aggregate-methods-simple-table-primary-secondary-tests:

./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=True

Difference in results seen:
Reason :: mismatch in results :: expected [0:1]:: [2423052], actual [0:1]:: [1182858]

sql_query :: SELECT SUM(DISTINCT int_field1 ) FROM simple_table_1 WHERE ((NOT (bool_field1) AND char_field1 NOT LIKE 'N%')) AND ((decimal_field1 != 5016) OR (decimal_field1 = 5016))
n1ql_query :: SELECT SUM(DISTINCT int_field1 ) FROM simple_table_1 WHERE ((NOT (bool_field1) AND char_field1 NOT LIKE 'N%')) AND ((decimal_field1 != 5016) OR (decimal_field1 = 5016))
<<<<<<<<<< TEST 7516 >>>>>>>>>>>
keyword_list :: [' <= ', ' = ', ' >= ', 'AND', 'IN', 'OR', 'TRUE']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: mismatch in results :: expected [0:1]:: [3898776], actual [0:1]:: [2010251]

sql_query :: SELECT SUM( int_field1 ) FROM simple_table_1 WHERE ((bool_field1 = true AND (int_field1 <= 5193) OR (decimal_field1 <= 5016))) OR ((bool_field1 != true AND int_field1 >= 5193))
n1ql_query :: SELECT SUM( int_field1 ) FROM simple_table_1 WHERE ((bool_field1 = true AND (int_field1 <= 5193) OR (decimal_field1 <= 5016))) OR ((bool_field1 != true AND int_field1 >= 5193))
<<<<<<<<<< TEST 7518 >>>>>>>>>>>
keyword_list :: [' < ', ' > ', 'AND', 'BETWEEN', 'IN', 'NOT', 'OR']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: mismatch in results :: expected [0:1]:: [2926537], actual [0:1]:: [986644]

sql_query :: SELECT SUM( int_field1 ) FROM simple_table_1 WHERE ((NOT (bool_field1) AND NOT (int_field1 > 5193))) OR ((varchar_field1 < "aMEVrcLYit" AND decimal_field1 BETWEEN 23 and 9979))
n1ql_query :: SELECT SUM( int_field1 ) FROM simple_table_1 WHERE ((NOT (bool_field1) AND NOT (int_field1 > 5193))) OR ((varchar_field1 < "aMEVrcLYit" AND decimal_field1 BETWEEN 23 and 9979))
<<<<<<<<<< TEST 7519 >>>>>>>>>>>
keyword_list :: [' < ', ' = ', 'AND', 'BETWEEN', 'DISTINCT', 'IN', 'IS', 'KEY', 'NOT', 'NULL', 'OR', 'TRUE']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: mismatch in results :: expected [0:1]:: [3725663], actual [0:1]:: [2549524]

sql_query :: SELECT SUM(DISTINCT int_field1 ) FROM simple_table_1 WHERE ((bool_field1 OR decimal_field1 < 5016)) AND ((bool_field1 = true OR int_field1 IS NOT NULL)) OR ((bool_field1 AND primary_key_id < "549")) AND (char_field1 NOT BETWEEN "A" and "Z")
n1ql_query :: SELECT SUM(DISTINCT int_field1 ) FROM simple_table_1 WHERE ((bool_field1 OR decimal_field1 < 5016)) AND ((bool_field1 = true OR int_field1 IS NOT NULL)) OR ((bool_field1 AND primary_key_id < "549")) AND (char_field1 NOT BETWEEN "A" and "Z")
<<<<<<<<<< TEST 7522 >>>>>>>>>>>
keyword_list :: [' <= ', ' = ', 'AND', 'IN', 'IS', 'KEY', 'LIKE', 'NOT', 'NULL', 'OR', 'TRUE']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: the number of results do not match :: expected = 1, actual = 1
mismatch in results :: expected :: [

{u'MIN( decimal_field1 )': 934}

], actual :: []

sql_query :: SELECT MIN( decimal_field1 ) FROM simple_table_1 WHERE ((NOT (NOT (primary_key_id IS NOT NULL)) AND decimal_field1 = 5016)) AND ((decimal_field1 <= 5016 AND (varchar_field1 LIKE '%aMEVrcLYit%') OR (primary_key_id IN ( "1" , "10" , "100" , "1000" , "101" )) AND bool_field1)) OR ((char_field1 = "N" AND int_field1 != 5193)) AND ((bool_field1 = true AND int_field1 != 5193))
n1ql_query :: SELECT MIN( decimal_field1 ) FROM simple_table_1 WHERE ((NOT (NOT (primary_key_id IS NOT NULL)) AND decimal_field1 = 5016)) AND ((decimal_field1 <= 5016 AND (varchar_field1 LIKE '%aMEVrcLYit%') OR (primary_key_id IN [ "1" , "10" , "100" , "1000" , "101" ]) AND bool_field1)) OR ((char_field1 = "N" AND int_field1 != 5193)) AND ((bool_field1 = true AND int_field1 != 5193))
<<<<<<<<<< TEST 7529 >>>>>>>>>>>
keyword_list :: ['DISTINCT', 'IN', 'IS', 'OR']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: mismatch in results :: expected [0:1]:: [5099], actual [0:1]:: [2637.0]

sql_query :: SELECT AVG( DISTINCT int_field1 ) FROM simple_table_1 WHERE (int_field1 != 5193) OR (bool_field1)
n1ql_query :: SELECT AVG( DISTINCT int_field1 ) FROM simple_table_1 WHERE (int_field1 != 5193) OR (bool_field1)
<<<<<<<<<< TEST 7531 >>>>>>>>>>>
keyword_list :: [' = ', 'AND', 'IN', 'NOT', 'OR', 'TRUE']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: mismatch in results :: expected [0:1]:: [5141], actual [0:1]:: [5260.0]

sql_query :: SELECT AVG( int_field1 ) FROM simple_table_1 WHERE ((bool_field1 = true OR (decimal_field1 IN ( 23 , 52 , 63 , 69 , 76 )) AND (NOT (int_field1 != 5193)))) OR ((bool_field1 != true OR varchar_field1 IN ( "AAiZPgUqut" , "AHKlEfLroy" , "ARJtcvtGCm" , "ASbMJuTcvo" , "ASkcAiGrKv" )))
n1ql_query :: SELECT AVG( int_field1 ) FROM simple_table_1 WHERE ((bool_field1 = true OR (decimal_field1 IN [ 23 , 52 , 63 , 69 , 76 ]) AND (NOT (int_field1 != 5193)))) OR ((bool_field1 != true OR varchar_field1 IN [ "AAiZPgUqut" , "AHKlEfLroy" , "ARJtcvtGCm" , "ASbMJuTcvo" , "ASkcAiGrKv" ]))
<<<<<<<<<< TEST 7537 >>>>>>>>>>>
keyword_list :: [' <= ', ' >= ', 'AND', 'DISTINCT', 'IN', 'IS', 'KEY', 'NOT', 'OR']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: mismatch in results :: expected [0:1]:: [489], actual [0:1]:: [240]

sql_query :: SELECT COUNT( DISTINCT int_field1 ) FROM simple_table_1 WHERE ((int_field1 <= 5193 OR primary_key_id <= "549")) AND (NOT (primary_key_id >= "549"))
n1ql_query :: SELECT COUNT( DISTINCT int_field1 ) FROM simple_table_1 WHERE ((int_field1 <= 5193 OR primary_key_id <= "549")) AND (NOT (primary_key_id >= "549"))
<<<<<<<<<< TEST 7538 >>>>>>>>>>>
keyword_list :: [' <= ', ' = ', ' > ', ' >= ', 'AND', 'DISTINCT', 'IN', 'IS', 'KEY', 'NOT', 'OR']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: mismatch in results :: expected [0:1]:: [706], actual [0:1]:: [490]

sql_query :: SELECT COUNT( DISTINCT decimal_field1 ) FROM simple_table_1 WHERE ((bool_field1 AND decimal_field1 > 5016)) OR ((NOT (decimal_field1 >= 5016) OR (primary_key_id = "549") AND (char_field1 <= "N")))
n1ql_query :: SELECT COUNT( DISTINCT decimal_field1 ) FROM simple_table_1 WHERE ((bool_field1 AND decimal_field1 > 5016)) OR ((NOT (decimal_field1 >= 5016) OR (primary_key_id = "549") AND (char_field1 <= "N")))
<<<<<<<<<< TEST 7539 >>>>>>>>>>>
keyword_list :: ['IN', 'OR']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: mismatch in results :: expected [0:1]:: [5136098], actual [0:1]:: [3247573]

sql_query :: SELECT SUM( int_field1 ) FROM simple_table_1 WHERE (bool_field1 OR int_field1 != 5193)
n1ql_query :: SELECT SUM( int_field1 ) FROM simple_table_1 WHERE (bool_field1 OR int_field1 != 5193)
<<<<<<<<<< TEST 7545 >>>>>>>>>>>
keyword_list :: [' = ', ' > ', 'AND', 'FALSE', 'IN', 'IS', 'KEY', 'LIKE', 'NOT', 'NULL', 'OR', 'TRUE']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: the number of results do not match :: expected = 1, actual = 1
mismatch in results :: expected :: [

{u'MIN( decimal_field1 )': 23}

], actual :: []

sql_query :: SELECT MIN( decimal_field1 ) FROM simple_table_1 WHERE ((bool_field1 = false OR decimal_field1 != 5016)) AND ((bool_field1 = true OR (((char_field1 <> "N") OR (char_field1 NOT LIKE "N")) AND (primary_key_id > "549")) OR (char_field1 NOT LIKE '%N'))) OR ((NOT (bool_field1) AND int_field1 IS NOT NULL)) AND (NOT (decimal_field1 IS NULL))
n1ql_query :: SELECT MIN( decimal_field1 ) FROM simple_table_1 WHERE ((bool_field1 = false OR decimal_field1 != 5016)) AND ((bool_field1 = true OR (((char_field1 <> "N") OR (char_field1 NOT LIKE "N")) AND (primary_key_id > "549")) OR (char_field1 NOT LIKE '%N'))) OR ((NOT (bool_field1) AND int_field1 IS NOT NULL)) AND (NOT (decimal_field1 IS NULL))
<<<<<<<<<< TEST 7548 >>>>>>>>>>>
keyword_list :: [' <= ', 'FALSE', 'IN', 'NOT', 'OR']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: the number of results do not match :: expected = 1, actual = 1
mismatch in results :: expected :: [

{u'MIN( decimal_field1 )': 23}

], actual :: []

sql_query :: SELECT MIN( decimal_field1 ) FROM simple_table_1 WHERE (bool_field1 != false OR NOT (int_field1 <= 5193))
n1ql_query :: SELECT MIN( decimal_field1 ) FROM simple_table_1 WHERE (bool_field1 != false OR NOT (int_field1 <= 5193))
<<<<<<<<<< TEST 7552 >>>>>>>>>>>
keyword_list :: [' < ', 'IN', 'NOT', 'OR']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: mismatch in results :: expected [0:1]:: [9991], actual [0:1]:: [5193]

sql_query :: SELECT MAX( int_field1 ) FROM simple_table_1 WHERE ((NOT (int_field1 != 5193) OR varchar_field1 IN ( "AAiZPgUqut" , "AHKlEfLroy" , "ARJtcvtGCm" , "ASbMJuTcvo" , "ASkcAiGrKv" ))) OR ((NOT (bool_field1) OR decimal_field1 < 5016))
n1ql_query :: SELECT MAX( int_field1 ) FROM simple_table_1 WHERE ((NOT (int_field1 != 5193) OR varchar_field1 IN [ "AAiZPgUqut" , "AHKlEfLroy" , "ARJtcvtGCm" , "ASbMJuTcvo" , "ASkcAiGrKv" ])) OR ((NOT (bool_field1) OR decimal_field1 < 5016))
<<<<<<<<<< TEST 7553 >>>>>>>>>>>
keyword_list :: [' <= ', ' = ', 'AND', 'DISTINCT', 'FALSE', 'IN', 'IS', 'KEY', 'LIKE', 'NULL', 'OR', 'TRUE']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: the number of results do not match :: expected = 1, actual = 1
mismatch in results :: expected :: [

{u'SUM(DISTINCT decimal_field1 )': 479045}

], actual :: []

sql_query :: SELECT SUM(DISTINCT decimal_field1 ) FROM simple_table_1 WHERE (bool_field1 = false) AND ((decimal_field1 IS NULL OR char_field1 IN ( "A" , "B" , "C" , "D" , "E" ))) OR ((bool_field1 != true OR char_field1 <= "N")) AND ((primary_key_id IN ( "1" , "10" , "100" , "1000" , "101" )) AND (varchar_field1 LIKE 'aMEVrcLYit%'))
n1ql_query :: SELECT SUM(DISTINCT decimal_field1 ) FROM simple_table_1 WHERE (bool_field1 = false) AND ((decimal_field1 IS NULL OR char_field1 IN [ "A" , "B" , "C" , "D" , "E" ])) OR ((bool_field1 != true OR char_field1 <= "N")) AND ((primary_key_id IN [ "1" , "10" , "100" , "1000" , "101" ]) AND (varchar_field1 LIKE 'aMEVrcLYit%'))
<<<<<<<<<< TEST 7554 >>>>>>>>>>>
keyword_list :: ['AND', 'IN', 'NOT', 'OR']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: mismatch in results :: expected [0:1]:: [9991], actual [0:1]:: [9983]

sql_query :: SELECT MAX( int_field1 ) FROM simple_table_1 WHERE NOT ((NOT (bool_field1) AND (decimal_field1 IN ( 23 , 52 , 63 , 69 , 76 )) OR (int_field1 IN ( 5 , 16 , 28 , 55 , 66 ))))
n1ql_query :: SELECT MAX( int_field1 ) FROM simple_table_1 WHERE NOT ((NOT (bool_field1) AND (decimal_field1 IN [ 23 , 52 , 63 , 69 , 76 ]) OR (int_field1 IN [ 5 , 16 , 28 , 55 , 66 ])))
<<<<<<<<<< TEST 7556 >>>>>>>>>>>
keyword_list :: [' = ', 'AND', 'DISTINCT', 'IN', 'IS', 'NOT', 'NULL', 'TRUE']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: mismatch in results :: expected [0:1]:: [5099], actual [0:1]:: [4333.0]

sql_query :: SELECT AVG( DISTINCT int_field1 ) FROM simple_table_1 WHERE NOT ((bool_field1 = true AND decimal_field1 IS NULL))
n1ql_query :: SELECT AVG( DISTINCT int_field1 ) FROM simple_table_1 WHERE NOT ((bool_field1 = true AND decimal_field1 IS NULL))
<<<<<<<<<< TEST 7566 >>>>>>>>>>>
keyword_list :: [' < ', ' <= ', ' = ', 'AND', 'DISTINCT', 'FALSE', 'IN', 'IS', 'KEY', 'LIKE', 'NOT', 'OR', 'TRUE']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: mismatch in results :: expected [0:1]:: [721], actual [0:1]:: [472]

sql_query :: SELECT COUNT( DISTINCT decimal_field1 ) FROM simple_table_1 WHERE ((decimal_field1 <= 5016) OR ((decimal_field1 < 5016) OR (decimal_field1 = 5016))) AND (bool_field1 != false) OR ((decimal_field1 IN ( 23 , 52 , 63 , 69 , 76 ) OR primary_key_id NOT LIKE '%549')) AND (bool_field1 != true)
n1ql_query :: SELECT COUNT( DISTINCT decimal_field1 ) FROM simple_table_1 WHERE ((decimal_field1 <= 5016) OR ((decimal_field1 < 5016) OR (decimal_field1 = 5016))) AND (bool_field1 != false) OR ((decimal_field1 IN [ 23 , 52 , 63 , 69 , 76 ] OR primary_key_id NOT LIKE '%549')) AND (bool_field1 != true)
<<<<<<<<<< TEST 7579 >>>>>>>>>>>
keyword_list :: [' <= ', ' = ', ' >= ', 'AND', 'BETWEEN', 'DISTINCT', 'FALSE', 'IN', 'IS', 'NOT', 'NULL', 'OR', 'TRUE']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: mismatch in results :: expected [0:1]:: [960], actual [0:1]:: [149]

sql_query :: SELECT COUNT( DISTINCT int_field1 ) FROM simple_table_1 WHERE ((bool_field1 != false OR int_field1 BETWEEN 5 and 9991)) AND ((bool_field1 != true OR decimal_field1 IS NOT NULL)) OR ((bool_field1 = false AND (int_field1 <= 5193) OR ((decimal_field1 IS NULL) AND (int_field1 <= 5193)))) AND (decimal_field1 >= 5016)
n1ql_query :: SELECT COUNT( DISTINCT int_field1 ) FROM simple_table_1 WHERE ((bool_field1 != false OR int_field1 BETWEEN 5 and 9991)) AND ((bool_field1 != true OR decimal_field1 IS NOT NULL)) OR ((bool_field1 = false AND (int_field1 <= 5193) OR ((decimal_field1 IS NULL) AND (int_field1 <= 5193)))) AND (decimal_field1 >= 5016)
<<<<<<<<<< TEST 7580 >>>>>>>>>>>
keyword_list :: [' < ', ' = ', 'AND', 'FALSE', 'IN', 'IS', 'NULL', 'OR', 'TRUE']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: the number of results do not match :: expected = 1, actual = 1
mismatch in results :: expected :: [

{u'MAX( int_field1 )': 9983}

], actual :: []

sql_query :: SELECT MAX( int_field1 ) FROM simple_table_1 WHERE ((bool_field1 = true AND decimal_field1 = 5016)) AND ((bool_field1 != false AND int_field1 IS NULL)) OR (char_field1 IN ( "A" , "B" , "C" , "D" , "E" )) AND ((decimal_field1 IN ( 23 , 52 , 63 , 69 , 76 ) OR varchar_field1 < "aMEVrcLYit"))
n1ql_query :: SELECT MAX( int_field1 ) FROM simple_table_1 WHERE ((bool_field1 = true AND decimal_field1 = 5016)) AND ((bool_field1 != false AND int_field1 IS NULL)) OR (char_field1 IN [ "A" , "B" , "C" , "D" , "E" ]) AND ((decimal_field1 IN [ 23 , 52 , 63 , 69 , 76 ] OR varchar_field1 < "aMEVrcLYit"))
<<<<<<<<<< TEST 7583 >>>>>>>>>>>
keyword_list :: [' < ', ' = ', ' > ', 'AND', 'BETWEEN', 'DISTINCT', 'IN', 'IS', 'KEY', 'LIKE', 'NOT', 'NULL', 'OR', 'TRUE']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: mismatch in results :: expected [0:1]:: [4894319], actual [0:1]:: [1264914]

sql_query :: SELECT SUM(DISTINCT int_field1 ) FROM simple_table_1 WHERE ((NOT (primary_key_id LIKE '%549%') AND decimal_field1 BETWEEN 23 and 9979)) AND ((int_field1 != 5193 OR ((NOT (NOT (char_field1 < "N"))) OR (primary_key_id > "549")) OR (varchar_field1 IS NULL))) OR ((bool_field1 = true OR (decimal_field1 IS NULL) OR (int_field1 = 5193))) AND ((bool_field1 AND char_field1 > "N"))
n1ql_query :: SELECT SUM(DISTINCT int_field1 ) FROM simple_table_1 WHERE ((NOT (primary_key_id LIKE '%549%') AND decimal_field1 BETWEEN 23 and 9979)) AND ((int_field1 != 5193 OR ((NOT (NOT (char_field1 < "N"))) OR (primary_key_id > "549")) OR (varchar_field1 IS NULL))) OR ((bool_field1 = true OR (decimal_field1 IS NULL) OR (int_field1 = 5193))) AND ((bool_field1 AND char_field1 > "N"))
<<<<<<<<<< TEST 7584 >>>>>>>>>>>
keyword_list :: [' <= ', ' >= ', 'AND', 'FALSE', 'IN', 'IS', 'KEY', 'LIKE', 'NOT', 'NULL', 'OR', 'TRUE']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: the number of results do not match :: expected = 1, actual = 1
mismatch in results :: expected :: [

{u'SUM( int_field1 )': 2497776}

], actual :: []

sql_query :: SELECT SUM( int_field1 ) FROM simple_table_1 WHERE ((bool_field1 != false AND varchar_field1 IS NULL)) AND ((bool_field1 != true AND (primary_key_id IS NOT NULL) AND (primary_key_id <= "549"))) OR ((NOT (char_field1 NOT LIKE '%N%')) OR (char_field1 >= "N")) AND (decimal_field1 IS NOT NULL)
n1ql_query :: SELECT SUM( int_field1 ) FROM simple_table_1 WHERE ((bool_field1 != false AND varchar_field1 IS NULL)) AND ((bool_field1 != true AND (primary_key_id IS NOT NULL) AND (primary_key_id <= "549"))) OR ((NOT (char_field1 NOT LIKE '%N%')) OR (char_field1 >= "N")) AND (decimal_field1 IS NOT NULL)
<<<<<<<<<< TEST 7586 >>>>>>>>>>>
keyword_list :: [' < ', ' = ', ' > ', 'AND', 'DISTINCT', 'IN', 'IS', 'KEY', 'NOT', 'TRUE']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: mismatch in results :: expected [0:1]:: [5075], actual [0:1]:: [4563.0]

sql_query :: SELECT AVG( DISTINCT int_field1 ) FROM simple_table_1 WHERE NOT ((decimal_field1 < 5016 AND primary_key_id > "549" AND bool_field1 = true))
n1ql_query :: SELECT AVG( DISTINCT int_field1 ) FROM simple_table_1 WHERE NOT ((decimal_field1 < 5016 AND primary_key_id > "549" AND bool_field1 = true))
<<<<<<<<<< TEST 7589 >>>>>>>>>>>
keyword_list :: [' <= ', ' = ', 'AND', 'FALSE', 'IN', 'IS', 'KEY', 'NOT', 'NULL', 'OR']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: mismatch in results :: expected [0:1]:: [9979], actual [0:1]:: [9975]

sql_query :: SELECT MAX( decimal_field1 ) FROM simple_table_1 WHERE ((bool_field1 OR ((char_field1 IN ( "A" , "B" , "C" , "D" , "E" )) AND (primary_key_id <= "549")) OR (varchar_field1 <= "aMEVrcLYit"))) OR ((bool_field1 = false OR char_field1 IS NOT NULL))
n1ql_query :: SELECT MAX( decimal_field1 ) FROM simple_table_1 WHERE ((bool_field1 OR ((char_field1 IN [ "A" , "B" , "C" , "D" , "E" ]) AND (primary_key_id <= "549")) OR (varchar_field1 <= "aMEVrcLYit"))) OR ((bool_field1 = false OR char_field1 IS NOT NULL))
<<<<<<<<<< TEST 7590 >>>>>>>>>>>
keyword_list :: [' < ', ' <= ', ' > ', 'AND', 'IS', 'KEY', 'NOT', 'NULL', 'OR']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: mismatch in results :: expected [0:1]:: [9979], actual [0:1]:: [5003]

sql_query :: SELECT MAX( decimal_field1 ) FROM simple_table_1 WHERE ((primary_key_id <= "549" AND decimal_field1 < 5016)) OR ((decimal_field1 IS NOT NULL OR varchar_field1 > "aMEVrcLYit"))
n1ql_query :: SELECT MAX( decimal_field1 ) FROM simple_table_1 WHERE ((primary_key_id <= "549" AND decimal_field1 < 5016)) OR ((decimal_field1 IS NOT NULL OR varchar_field1 > "aMEVrcLYit"))
<<<<<<<<<< TEST 7594 >>>>>>>>>>>
keyword_list :: [' < ', ' = ', ' > ', 'AND', 'DISTINCT', 'FALSE', 'IN', 'IS', 'OR']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: the number of results do not match :: expected = 1, actual = 1
mismatch in results :: expected :: [

{u'AVG( DISTINCT decimal_field1 )': 5212}

], actual :: []

sql_query :: SELECT AVG( DISTINCT decimal_field1 ) FROM simple_table_1 WHERE ((varchar_field1 IN ( "AAiZPgUqut" , "AHKlEfLroy" , "ARJtcvtGCm" , "ASbMJuTcvo" , "ASkcAiGrKv" ) AND int_field1 > 5193)) AND ((bool_field1 AND int_field1 < 5193)) OR ((bool_field1 AND char_field1 = "N")) AND ((bool_field1 != false OR decimal_field1 != 5016))
n1ql_query :: SELECT AVG( DISTINCT decimal_field1 ) FROM simple_table_1 WHERE ((varchar_field1 IN [ "AAiZPgUqut" , "AHKlEfLroy" , "ARJtcvtGCm" , "ASbMJuTcvo" , "ASkcAiGrKv" ] AND int_field1 > 5193)) AND ((bool_field1 AND int_field1 < 5193)) OR ((bool_field1 AND char_field1 = "N")) AND ((bool_field1 != false OR decimal_field1 != 5016))
<<<<<<<<<< TEST 7606 >>>>>>>>>>>
keyword_list :: [' = ', ' >= ', 'AND', 'FALSE', 'KEY', 'OR', 'TRUE']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: the number of results do not match :: expected = 1, actual = 1
mismatch in results :: expected :: [

{u'COUNT(*)': 256}

], actual :: []

sql_query :: SELECT COUNT FROM simple_table_1 WHERE ((bool_field1 = true AND char_field1 != "N")) AND ((bool_field1 = false OR primary_key_id >= "549"))
n1ql_query :: SELECT COUNT FROM simple_table_1 WHERE ((bool_field1 = true AND char_field1 != "N")) AND ((bool_field1 = false OR primary_key_id >= "549"))
<<<<<<<<<< TEST 7609 >>>>>>>>>>>
keyword_list :: [' < ', 'AND', 'DISTINCT', 'IN', 'IS', 'KEY', 'NOT', 'NULL']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: mismatch in results :: expected [0:1]:: [5094], actual [0:1]:: [4606.0]

sql_query :: SELECT AVG( DISTINCT decimal_field1 ) FROM simple_table_1 WHERE NOT ((int_field1 < 5193 AND primary_key_id IS NOT NULL AND bool_field1))
n1ql_query :: SELECT AVG( DISTINCT decimal_field1 ) FROM simple_table_1 WHERE NOT ((int_field1 < 5193 AND primary_key_id IS NOT NULL AND bool_field1))
<<<<<<<<<< TEST 7610 >>>>>>>>>>>
keyword_list :: [' = ', 'AND', 'FALSE', 'IS', 'KEY', 'NULL', 'OR', 'TRUE']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: the number of results do not match :: expected = 1, actual = 1
mismatch in results :: expected :: [

{u'COUNT(*)': 499}

], actual :: []

sql_query :: SELECT COUNT FROM simple_table_1 WHERE ((bool_field1 = true OR primary_key_id IS NULL)) AND (bool_field1 != false)
n1ql_query :: SELECT COUNT FROM simple_table_1 WHERE ((bool_field1 = true OR primary_key_id IS NULL)) AND (bool_field1 != false)
<<<<<<<<<< TEST 7613 >>>>>>>>>>>
keyword_list :: [' > ', ' >= ', 'AND', 'FALSE', 'IN', 'KEY', 'OR']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: the number of results do not match :: expected = 1, actual = 1
mismatch in results :: expected :: [

{u'MAX( int_field1 )': 9983}

], actual :: []

sql_query :: SELECT MAX( int_field1 ) FROM simple_table_1 WHERE ((bool_field1 != false AND decimal_field1 >= 5016)) OR ((bool_field1 AND primary_key_id > "549"))
n1ql_query :: SELECT MAX( int_field1 ) FROM simple_table_1 WHERE ((bool_field1 != false AND decimal_field1 >= 5016)) OR ((bool_field1 AND primary_key_id > "549"))
<<<<<<<<<< TEST 7614 >>>>>>>>>>>
keyword_list :: [' >= ', 'AND', 'DISTINCT', 'FALSE', 'IN', 'IS']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: the number of results do not match :: expected = 1, actual = 1
mismatch in results :: expected :: [

{u'SUM(DISTINCT int_field1 )': 1213957}

], actual :: []

sql_query :: SELECT SUM(DISTINCT int_field1 ) FROM simple_table_1 WHERE (bool_field1 != false AND char_field1 >= "N")
n1ql_query :: SELECT SUM(DISTINCT int_field1 ) FROM simple_table_1 WHERE (bool_field1 != false AND char_field1 >= "N")
<<<<<<<<<< TEST 7624 >>>>>>>>>>>
keyword_list :: ['AND', 'BETWEEN', 'IN', 'NOT', 'OR']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: unable to reach the host @ 172.23.107.87

sql_query :: SELECT MIN( decimal_field1 ) FROM simple_table_1 WHERE NOT (NOT ((int_field1 BETWEEN 5 and 9991) AND (NOT (NOT ((decimal_field1 != 5016) OR (decimal_field1 IN ( 23 , 52 , 63 , 69 , 76 )))))))
n1ql_query :: SELECT MIN( decimal_field1 ) FROM simple_table_1 WHERE NOT (NOT ((int_field1 BETWEEN 5 and 9991) AND (NOT (NOT ((decimal_field1 != 5016) OR (decimal_field1 IN [ 23 , 52 , 63 , 69 , 76 ]))))))
<<<<<<<<<< TEST 7625 >>>>>>>>>>>
keyword_list :: [' < ', ' <= ', 'OR']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: mismatch in results :: expected [0:1]:: [3210862], actual [0:1]:: [1300584]

sql_query :: SELECT SUM( decimal_field1 ) FROM simple_table_1 WHERE (decimal_field1 < 5016 OR varchar_field1 <= "aMEVrcLYit")
n1ql_query :: SELECT SUM( decimal_field1 ) FROM simple_table_1 WHERE (decimal_field1 < 5016 OR varchar_field1 <= "aMEVrcLYit")
<<<<<<<<<< TEST 7628 >>>>>>>>>>>
keyword_list :: [' <= ', 'AND', 'FALSE', 'IN']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: the number of results do not match :: expected = 1, actual = 1
mismatch in results :: expected :: [

{u'SUM( int_field1 )': 1394476}

], actual :: []

sql_query :: SELECT SUM( int_field1 ) FROM simple_table_1 WHERE (bool_field1 != false AND decimal_field1 <= 5016)
n1ql_query :: SELECT SUM( int_field1 ) FROM simple_table_1 WHERE (bool_field1 != false AND decimal_field1 <= 5016)