Major Description
|
This is a regression from 4.7.0-1533
Test which fails:
./testrunner -i local.ini -p gsi_type=forestdb -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=1000,skip_cleanup=True
Job which fails:
cen006-n1ql-vset02-01-rqg-aggregate-methods-simple-table-primary-secondary-tests
Number of secondary indexes created:131
Primary index is created.
Number of queries run:1000
Pass = 966, Fail = 34, Pass Pecentage = 96 %
Queries which give different results:
sql_query :: SELECT COUNT
FROM simple_table_1 WHERE char_field1 != "N"
n1ql_query :: SELECT COUNT FROM multiple_table_db_5322_simple_table_1 WHERE char_field1 != "N"
sql_query :: SELECT COUNT FROM simple_table_1 WHERE bool_field1 != false
n1ql_query :: SELECT COUNT FROM multiple_table_db_5322_simple_table_1 WHERE bool_field1 != false
Reason :: mismatch in results :: expected [0:1]:: [1], actual [0:1]:: [\{}]
sql_query :: SELECT COUNT FROM simple_table_1 WHERE (int_field1 IS NULL) OR (decimal_field1 = 4885)
n1ql_query :: SELECT COUNT FROM multiple_table_db_5322_simple_table_1 WHERE (int_field1 IS NULL) OR (decimal_field1 = 4885)
sql_query :: SELECT COUNT FROM simple_table_1 WHERE bool_field1 != false
n1ql_query :: SELECT COUNT FROM multiple_table_db_5322_simple_table_1 WHERE bool_field1 != false
sql_query :: SELECT COUNT FROM simple_table_1 WHERE (char_field1 >= "N") OR ((int_field1 BETWEEN 5 and 9995 OR varchar_field1 != "ZJQkwSgbnE"))
n1ql_query :: SELECT COUNT FROM multiple_table_db_5322_simple_table_1 WHERE (char_field1 >= "N") OR ((int_field1 BETWEEN 5 and 9995 OR varchar_field1 != "ZJQkwSgbnE"))
sql_query :: SELECT COUNT FROM simple_table_1 WHERE bool_field1 != true
n1ql_query :: SELECT COUNT FROM multiple_table_db_5322_simple_table_1 WHERE bool_field1 != true
sql_query :: SELECT COUNT FROM simple_table_1 WHERE (decimal_field1 IS NOT NULL OR char_field1 >= "N")
n1ql_query :: SELECT COUNT FROM multiple_table_db_5322_simple_table_1 WHERE (decimal_field1 IS NOT NULL OR char_field1 >= "N")
sql_query :: SELECT COUNT FROM simple_table_1 WHERE char_field1 <> "N"
n1ql_query :: SELECT COUNT FROM multiple_table_db_5322_simple_table_1 WHERE char_field1 <> "N"
sql_query :: SELECT COUNT( decimal_field1 ) FROM simple_table_1 WHERE NOT (decimal_field1 = 4885)
n1ql_query :: SELECT COUNT( decimal_field1 ) FROM multiple_table_db_5322_simple_table_1 WHERE NOT (decimal_field1 = 4885)
Please let me know if you need more queries and dataset backup.
The cluster on which you can check incorrest results is:
http://172.23.105.209:8091/ui/index.html#/query/workbench