Details
-
Bug
-
Resolution: Fixed
-
Minor
-
5.5.0
-
None
-
Untriaged
-
Unknown
Description
Create primary index
Run query: SELECT COUNT FROM simple_table_db_30474951_simple_table WHERE (decimal_field1 BETWEEN 17 and 9996 AND char_field1 > "N" AND bool_field1 = false) ORDER BY AVG( int_field1 )
Returns correct results
Create secondary index: CREATE INDEX simple_table_expression_based_93442871 ON simple_table_db_30474951_simple_table( (decimal_field1 BETWEEN 17 and 9996 AND char_field1 > "N" AND bool_field1 = false) ) USING GSI
Run same query:
SELECT COUNT FROM simple_table_db_30474951_simple_table WHERE (decimal_field1 BETWEEN 17 and 9996 AND char_field1 > "N" AND bool_field1 = false) ORDER BY AVG( int_field1 )
returns incorrect results
You can run the rqg test with:
./testrunner.py -i /Users/korrigan.clark/Desktop/resources/rqg-local.ini -p gsi_type=plasma -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,database=simple_table_db,reset_database=True,concurreny_count=5,index_quota_percent=30,password=password,use_mysql=True,replicas=0,run_query_with_secondary=True,run_explain_with_hints=True,total_queries=10,record_failure=True,check_covering_index=True,failure_record_path=/tmp,skip_cleanup=true,ram_quota=10000,indexer_memQuota=1000
This will load the correct data, just kill the test after data loading and run the repro.