Details
-
Bug
-
Resolution: Fixed
-
Test Blocker
-
4.5.0
-
4.5.0-2100
-
Untriaged
-
Yes
Description
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_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=10000,skip_cleanup=True
URL:
http://172.23.107.87:8091/ui/index.html#/index
Example of ini:
[global]
port:8091
username:root
password:couchbase
index_port:9102
[servers]
1:SERVER_1
[SERVER_1]
ip:172.23.107.87
services=n1ql,kv,index
[membase]
rest_username:Administrator
rest_password:password
Mismatch seen in results of queries:
2016-04-12 11:40:03 | INFO | MainProcess | test_thread | [test_rqg._test_result_analysis] Total Queries Run = 10000, Pass = 9994, Fail = 6, Pass Pecentage = 99 %
2016-04-12 11:40:03 | INFO | MainProcess | test_thread | [test_rqg.test_rqg_concurrent] <<<<<<<<<< TEST 2570 >>>>>>>>>>>
keyword_list :: [' >= ', '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 :: [
], actual :: []
sql_query :: SELECT MIN( int_field1 ) FROM simple_table_1 WHERE char_field1 >= "N"
n1ql_query :: SELECT MIN( int_field1 ) FROM simple_table_1 WHERE char_field1 >= "N"
<<<<<<<<<< TEST 9584 >>>>>>>>>>>
keyword_list :: [' > ', 'AND', 'IN']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: mismatch in results :: expected [0:1]:: [236], actual [0:1]:: [500]
sql_query :: SELECT COUNT FROM simple_table_1 WHERE (int_field1 > 5042) AND (decimal_field1 > 5201)
n1ql_query :: SELECT COUNT FROM simple_table_1 WHERE (int_field1 > 5042) AND (decimal_field1 > 5201)
<<<<<<<<<< TEST 2358 >>>>>>>>>>>
keyword_list :: [' > ', 'AND', 'IN']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: mismatch in results :: expected [0:1]:: [236], actual [0:1]:: [498]
sql_query :: SELECT COUNT FROM simple_table_1 WHERE (varchar_field1 > "aYTUOeXhmw" AND int_field1 > 5042)
n1ql_query :: SELECT COUNT FROM simple_table_1 WHERE (varchar_field1 > "aYTUOeXhmw" AND int_field1 > 5042)
<<<<<<<<<< TEST 4959 >>>>>>>>>>>
keyword_list :: [' > ', '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 :: [
], actual :: []
sql_query :: SELECT MIN( int_field1 ) FROM simple_table_1 WHERE varchar_field1 > "aYTUOeXhmw"
n1ql_query :: SELECT MIN( int_field1 ) FROM simple_table_1 WHERE varchar_field1 > "aYTUOeXhmw"
<<<<<<<<<< TEST 4106 >>>>>>>>>>>
keyword_list :: [' < ', 'IN', 'NOT']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: the number of results do not match :: expected = 1, actual = 1
mismatch in results :: expected :: [
], actual :: []
sql_query :: SELECT MIN( int_field1 ) FROM simple_table_1 WHERE NOT (varchar_field1 < "aYTUOeXhmw")
n1ql_query :: SELECT MIN( int_field1 ) FROM simple_table_1 WHERE NOT (varchar_field1 < "aYTUOeXhmw")
<<<<<<<<<< TEST 8351 >>>>>>>>>>>
keyword_list :: [' > ', 'AND', '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 :: [
], actual :: []
sql_query :: SELECT MIN( int_field1 ) FROM simple_table_1 WHERE (varchar_field1 > "aYTUOeXhmw" AND decimal_field1 > 5201)
n1ql_query :: SELECT MIN( int_field1 ) FROM simple_table_1 WHERE (varchar_field1 > "aYTUOeXhmw" AND decimal_field1 > 5201)