Description
This test creates secondary indexes on random fields and issues queries accordingly.Results for few specific queries are different when issued against sql vs n1ql. Here I have limited the test to just run 20 queries.
./testrunner.py -i myfile.ini -t rqg.test_rqg.RQGTests.test_rqg_concurrent_with_secondary,test_file_path=b/resources/rqg/simple_table_db/query_tests_using_templates/query_50000_aggregate_functions.txt.zip,database=simple_table_db,reset_database=True,concurreny_count=1,index_quota_percent=30,password=password,use_mysql=True,replicas=0,run_query_with_secondary=True,run_explain_with_hints=True,total_queries=20,record_failure=True,failure_record_path=/tmp,username=root,password=couchbase,skip_cleanup=True
SQL QUERY :: SELECT AVG( DISTINCT decimal_field1 ) FROM simple_table WHERE ((decimal_field1 < 4968 AND varchar_field1 NOT LIKE '%ZevZlWYRxq' AND NOT (bool_field1))) AND (((primary_key_id LIKE '549%') AND ((NOT (primary_key_id LIKE '%549')) OR ((varchar_field1 > "ZevZlWYRxq") OR (varchar_field1 IS NOT NULL))) AND decimal_field1 <= 4968)) GROUP BY int_field1 , primary_key_id , bool_field1
2015-10-09 11:13:48 | INFO | MainProcess | Thread-12 | [tuq_helper.run_cbq_query] RUN QUERY SELECT AVG( DISTINCT decimal_field1 ) FROM simple_table WHERE ((decimal_field1 < 4968 AND varchar_field1 NOT LIKE '%ZevZlWYRxq' AND NOT (bool_field1))) AND (((primary_key_id LIKE '549%') AND ((NOT (primary_key_id LIKE '%549')) OR ((varchar_field1 > "ZevZlWYRxq") OR (varchar_field1 IS NOT NULL))) AND decimal_field1 <= 4968)) GROUP BY int_field1 , primary_key_id , bool_field1
[test_rqg._run_queries_and_verify] result from n1ql query returns 1 items
2015-10-09 11:13:48 | INFO | MainProcess | Thread-12 | [test_rqg._run_queries_and_verify] result from sql query returns 0 items
2015-10-09 11:13:48 | INFO | MainProcess | Thread-12 | [test_rqg._run_queries_and_verify] number of results returned from sql and n1ql are different
Another one:
SQL QUERY :: SELECT SUM(DISTINCT int_field1 ) FROM simple_table WHERE (bool_field1 AND decimal_field1 IN ( 1 , 3 , 15 , 21 , 22 )) GROUP BY primary_key_id
2015-10-09 11:15:36 | INFO | MainProcess | Thread-22 | [tuq_helper.run_cbq_query] RUN QUERY SELECT SUM(DISTINCT int_field1 ) FROM simple_table WHERE (bool_field1 AND decimal_field1 IN [ 1 , 3 , 15 , 21 , 22 ]) GROUP BY primary_key_id
[test_rqg._run_queries_and_verify] result from n1ql query returns 1 items
2015-10-09 11:15:36 | INFO | MainProcess | Thread-22 | [test_rqg._run_queries_and_verify] result from sql query returns 0 items
2015-10-09 11:15:36 | INFO | MainProcess | Thread-22 | [test_rqg._run_queries_and_verify] number of results returned from sql and n1ql are different