Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-29586

COUNT(*) breaks when using secondary index

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Minor
    • bug-backlog
    • 5.5.0
    • query
    • 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.

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            isha Isha Kandaswamy (Inactive)
            korrigan.clark Korrigan Clark (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty