Description
|
This passed with 4.7.0-1581:
Job which failed:
cen006-n1ql-vset03-02-rqg-fields-union-simple-table-primary-secondary-tests
Test which failed:
./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_unions.txt.zip,database=simple_table_db,reset_database=True,gsi_type=${gsi_type},concurreny_count=10,index_quota_percent=30,password=password,use_mysql=True,replicas=0,create_secondary_indexes=True,number_of_buckets=1,total_queries=${total_queries},record_failure=False,failure_record_path=/tmp,skip_cleanup=${skip_cleanup}
Union All and union queries are giving different results:
Total Queries Run = 1000, Pass = 994, Fail = 6, Pass Pecentage = 99 %
Queries which give different results:
sql_query :: (SELECT * FROM simple_table WHERE ((bool_field1 AND decimal_field1 != 5067)) AND ((char_field1 >= "N" AND int_field1 >= 5181)) ORDER BY primary_key_id , varchar_field1 ) UNION ALL (SELECT * FROM simple_table WHERE ((bool_field1 != false AND decimal_field1 BETWEEN 4 and 9991)) AND ((NOT (bool_field1) AND primary_key_id NOT LIKE '549%')) ORDER BY int_field1 , decimal_field1 )
n1ql_query :: (SELECT * FROM simple_table_db_6224_simple_table WHERE ((bool_field1 AND decimal_field1 != 5067)) AND ((char_field1 >= "N" AND int_field1 >= 5181)) ORDER BY primary_key_id , varchar_field1 ) UNION ALL (SELECT * FROM simple_table_db_6224_simple_table WHERE ((bool_field1 != false AND decimal_field1 BETWEEN 4 and 9991)) AND ((NOT (bool_field1) AND primary_key_id NOT LIKE '549%')) ORDER BY int_field1 , decimal_field1 )
sql_query :: (SELECT * FROM simple_table WHERE (bool_field1 != false AND (int_field1 BETWEEN 5 and 9992) OR (decimal_field1 >= 5067)) ORDER BY primary_key_id , varchar_field1 , char_field1 ) UNION (SELECT * FROM simple_table WHERE ((int_field1 = 5181 AND primary_key_id < "549" AND bool_field1 != true)) OR ((NOT (int_field1 != 5181) OR primary_key_id >= "549")) ORDER BY int_field1 , primary_key_id , varchar_field1 , bool_field1 ASC) UNION ALL (SELECT * FROM simple_table WHERE (decimal_field1 <= 5067) AND (bool_field1 = true) OR ((bool_field1 = false OR int_field1 IS NULL)) AND (varchar_field1 >= "ZizBxvQRSg") ORDER BY int_field1 , decimal_field1 , primary_key_id , bool_field1 )
n1ql_query :: (SELECT * FROM simple_table_db_6224_simple_table WHERE (bool_field1 != false AND (int_field1 BETWEEN 5 and 9992) OR (decimal_field1 >= 5067)) ORDER BY primary_key_id , varchar_field1 , char_field1 ) UNION (SELECT * FROM simple_table_db_6224_simple_table WHERE ((int_field1 = 5181 AND primary_key_id < "549" AND bool_field1 != true)) OR ((NOT (int_field1 != 5181) OR primary_key_id >= "549")) ORDER BY int_field1 , primary_key_id , varchar_field1 , bool_field1 ASC) UNION ALL (SELECT * FROM simple_table_db_6224_simple_table WHERE (decimal_field1 <= 5067) AND (bool_field1 = true) OR ((bool_field1 = false OR int_field1 IS NULL)) AND (varchar_field1 >= "ZizBxvQRSg") ORDER BY int_field1 , decimal_field1 , primary_key_id , bool_field1 )
sql_query :: (SELECT * FROM simple_table WHERE (bool_field1 = false) AND (int_field1 > 5181) ORDER BY int_field1 , primary_key_id , varchar_field1 ASC) UNION (SELECT * FROM simple_table WHERE ((bool_field1 = true AND decimal_field1 != 5067)) OR ((NOT (bool_field1) AND decimal_field1 <= 5067)) ORDER BY int_field1 , decimal_field1 , primary_key_id , varchar_field1 , char_field1 DESC) UNION ALL (SELECT * FROM simple_table WHERE NOT ((bool_field1 AND primary_key_id IS NOT NULL)) ORDER BY int_field1 , primary_key_id , varchar_field1 , char_field1 ASC)
n1ql_query :: (SELECT * FROM simple_table_db_6224_simple_table WHERE (bool_field1 = false) AND (int_field1 > 5181) ORDER BY int_field1 , primary_key_id , varchar_field1 ASC) UNION (SELECT * FROM simple_table_db_6224_simple_table WHERE ((bool_field1 = true AND decimal_field1 != 5067)) OR ((NOT (bool_field1) AND decimal_field1 <= 5067)) ORDER BY int_field1 , decimal_field1 , primary_key_id , varchar_field1 , char_field1 DESC) UNION ALL (SELECT * FROM simple_table_db_6224_simple_table WHERE NOT ((bool_field1 AND primary_key_id IS NOT NULL)) ORDER BY int_field1 , primary_key_id , varchar_field1 , char_field1 ASC)
sql_query :: (SELECT * FROM simple_table WHERE (((decimal_field1 <= 5067) OR (int_field1 != 5181) OR primary_key_id NOT BETWEEN "1" and "999")) AND (((NOT (char_field1 = "N")) OR (primary_key_id NOT LIKE '%549') AND int_field1 BETWEEN 5 and 9992)) ORDER BY int_field1 , decimal_field1 , primary_key_id , varchar_field1 ) UNION (SELECT * FROM simple_table WHERE NOT (((int_field1 <= 5181) OR (int_field1 > 5181) OR char_field1 IN ( "A" , "B" , "C" , "D" , "E" ))) ORDER BY int_field1 , decimal_field1 , primary_key_id ASC) UNION ALL (SELECT * FROM simple_table WHERE (((int_field1 <= 5181) AND (int_field1 < 5181) AND char_field1 != "N" AND NOT (bool_field1))) AND ((bool_field1 != true AND decimal_field1 < 5067)) OR ((bool_field1 != true AND int_field1 >= 5181)) AND ((bool_field1 AND (decimal_field1 IS NOT NULL) AND (decimal_field1 = 5067))) ORDER BY int_field1 , decimal_field1 ASC)
n1ql_query :: (SELECT * FROM simple_table_db_6224_simple_table WHERE (((decimal_field1 <= 5067) OR (int_field1 != 5181) OR primary_key_id NOT BETWEEN "1" and "999")) AND (((NOT (char_field1 = "N")) OR (primary_key_id NOT LIKE '%549') AND int_field1 BETWEEN 5 and 9992)) ORDER BY int_field1 , decimal_field1 , primary_key_id , varchar_field1 ) UNION (SELECT * FROM simple_table_db_6224_simple_table WHERE NOT (((int_field1 <= 5181) OR (int_field1 > 5181) OR char_field1 IN [ "A" , "B" , "C" , "D" , "E" ])) ORDER BY int_field1 , decimal_field1 , primary_key_id ASC) UNION ALL (SELECT * FROM simple_table_db_6224_simple_table WHERE (((int_field1 <= 5181) AND (int_field1 < 5181) AND char_field1 != "N" AND NOT (bool_field1))) AND ((bool_field1 != true AND decimal_field1 < 5067)) OR ((bool_field1 != true AND int_field1 >= 5181)) AND ((bool_field1 AND (decimal_field1 IS NOT NULL) AND (decimal_field1 = 5067))) ORDER BY int_field1 , decimal_field1 ASC)
sql_query :: (SELECT * FROM simple_table WHERE (bool_field1 != true AND primary_key_id IS NOT NULL) ORDER BY int_field1 , decimal_field1 , primary_key_id , varchar_field1 , bool_field1 ASC) UNION (SELECT * FROM simple_table WHERE (((NOT (int_field1 <= 5181)) OR (decimal_field1 BETWEEN 4 and 9991) OR char_field1 IS NULL)) AND ((decimal_field1 IS NULL OR varchar_field1 = "ZizBxvQRSg")) OR (varchar_field1 IS NOT NULL) AND ((bool_field1 = true AND (int_field1 IS NOT NULL) AND (decimal_field1 <= 5067))) ORDER BY int_field1 ) UNION (SELECT * FROM simple_table WHERE NOT ((int_field1 IS NULL OR char_field1 IS NOT NULL)) ORDER BY primary_key_id , varchar_field1 DESC)
n1ql_query :: (SELECT * FROM simple_table_db_6224_simple_table WHERE (bool_field1 != true AND primary_key_id IS NOT NULL) ORDER BY int_field1 , decimal_field1 , primary_key_id , varchar_field1 , bool_field1 ASC) UNION (SELECT * FROM simple_table_db_6224_simple_table WHERE (((NOT (int_field1 <= 5181)) OR (decimal_field1 BETWEEN 4 and 9991) OR char_field1 IS NULL)) AND ((decimal_field1 IS NULL OR varchar_field1 = "ZizBxvQRSg")) OR (varchar_field1 IS NOT NULL) AND ((bool_field1 = true AND (int_field1 IS NOT NULL) AND (decimal_field1 <= 5067))) ORDER BY int_field1 ) UNION (SELECT * FROM simple_table_db_6224_simple_table WHERE NOT ((int_field1 IS NULL OR char_field1 IS NOT NULL)) ORDER BY primary_key_id , varchar_field1 DESC)
sql_query :: (SELECT * FROM simple_table WHERE ((varchar_field1 NOT LIKE "ZizBxvQRSg" AND (decimal_field1 > 5067) AND (int_field1 >= 5181))) AND ((bool_field1 = true AND decimal_field1 BETWEEN 4 and 9991)) OR ((bool_field1 = true AND primary_key_id NOT LIKE '549%')) AND (int_field1 <= 5181) ORDER BY primary_key_id ) UNION ALL (SELECT * FROM simple_table WHERE NOT (NOT (int_field1 != 5181)) ORDER BY int_field1 , primary_key_id ) UNION ALL (SELECT * FROM simple_table WHERE ((bool_field1 AND decimal_field1 = 5067)) OR ((int_field1 IS NOT NULL OR varchar_field1 = "ZizBxvQRSg")) ORDER BY primary_key_id , varchar_field1 )
n1ql_query :: (SELECT * FROM simple_table_db_6224_simple_table WHERE ((varchar_field1 NOT LIKE "ZizBxvQRSg" AND (decimal_field1 > 5067) AND (int_field1 >= 5181))) AND ((bool_field1 = true AND decimal_field1 BETWEEN 4 and 9991)) OR ((bool_field1 = true AND primary_key_id NOT LIKE '549%')) AND (int_field1 <= 5181) ORDER BY primary_key_id ) UNION ALL (SELECT * FROM simple_table_db_6224_simple_table WHERE NOT (NOT (int_field1 != 5181)) ORDER BY int_field1 , primary_key_id ) UNION ALL (SELECT * FROM simple_table_db_6224_simple_table WHERE ((bool_field1 AND decimal_field1 = 5067)) OR ((int_field1 IS NOT NULL OR varchar_field1 = "ZizBxvQRSg")) ORDER BY primary_key_id , varchar_field1 )
|