Details
-
Bug
-
Resolution: Cannot Reproduce
-
Test Blocker
-
4.5.0
-
2151 with 50000 queries
-
Untriaged
-
Unknown
Description
Difference in results from sql seen with following queries:
sql_query :: SELECT DISTINCT( decimal_field1 ) FROM simple_table WHERE ( ( ( ( char_field1 = LOWER( "N" ) ) OR ( primary_key_id IN ( "1" , "10" , "100" , "1000" , "101" ) ) ) AND ( char_field1 = SUBSTR( "N", 1 ) ) )) OR ( NOT ( ( ( int_field1 BETWEEN 4 and 10000 ) ) OR ( ( bool_field1 != false ) ) ) )
n1ql_query :: SELECT DISTINCT( decimal_field1 ) FROM simple_table WHERE ( ( ( ( char_field1 = LOWER( "N" ) ) OR ( primary_key_id IN [ "1" , "10" , "100" , "1000" , "101" ] ) ) AND ( char_field1 = SUBSTR( "N", 0 ) ) )) OR ( NOT ( ( ( int_field1 BETWEEN 4 and 10000 ) ) OR ( ( bool_field1 != false ) ) ) )
sql Results expected: 35
n1ql results: 0
Another difference:
sql_query :: SELECT DISTINCT( int_field1 ) FROM simple_table WHERE ( ( NOT ( bool_field1 ) )) OR ( ( bool_field1 ) )
n1ql_query :: SELECT DISTINCT( int_field1 ) FROM simple_table WHERE ( ( NOT ( bool_field1 ) )) OR ( ( bool_field1 ) )
sql Expected num: 935
n1ql results: 489
Job which fails:
cen006-n1ql-vset03-01-rqg-functions-numeric-string-datetime-simple-table-primary-secondary-tests
Test which fails:
./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_functions_numeric_string_datetime.txt.zip,database=simple_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=False,build_index_batch_size=1000,total_queries=${total_queries},skip_cleanup=True