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

RQG: Secondary indexing resulting in incorrect results for aggregate methods

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Critical
    • 4.0.0
    • 4.0.0
    • query
    • Security Level: Public
    • dev 07/27
    • Untriaged
    • Yes

    Description

      ./testrunner -i b/resources/dev-6-nodes-xdcr_n1ql_2i.ini -t rqg.test_rqg.RQGTests.test_rqg_concurrent_with_predefined_input,database=simple_table_db,reset_database=True,concurreny_count=1,index_quota_percent=40,use_mysql=False,replicas=0,input_rqg_path=/tmp/data_dump,populate_with_replay=True,reset_database=True,skip_cleanup=True,create_secondary_indexes=True,run_query_with_primary=True

      Seeing broken results for the following cases when using secondary indexes.

      Scenario :: run_query_without_index_hint
      Reason :: mismatch in results :: expected [0:1]:: [505], actual [0:1]:: [251]

      sql_query :: SELECT COUNT FROM simple_table WHERE NOT ((NOT (bool_field1) OR decimal_field1 = 5038))
      n1ql_query :: SELECT COUNT FROM simple_table WHERE NOT ((NOT (bool_field1) OR decimal_field1 = 5038))
      <<<<<<<<<< TEST 2 >>>>>>>>>>>
      keyword_list :: ['BY', 'DISTINCT', 'IN', 'IS', 'KEY', 'LIKE', 'NOT', 'OR', 'ORDER']
      run_result ::
      ____________________________________________________
      Scenario :: run_query_without_index_hint
      Reason :: mismatch in results :: expected [0:1]:: [2477542], actual [0:1]:: [1304139.0]

      sql_query :: SELECT SUM(DISTINCT decimal_field1 ) FROM simple_table WHERE NOT ((NOT (bool_field1) OR varchar_field1 LIKE 'YtADqqWuEr%')) ORDER BY primary_key_id , varchar_field1 , char_field1
      n1ql_query :: SELECT SUM(DISTINCT decimal_field1 ) FROM simple_table WHERE NOT ((NOT (bool_field1) OR varchar_field1 LIKE 'YtADqqWuEr%')) ORDER BY primary_key_id , varchar_field1 , char_field1

      Attachments

        1. data_dump.tar.gz
          475 kB
        2. logs.tar.gz
          29.22 MB
        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            isha Isha Kandaswamy (Inactive)
            parag Parag Agarwal (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty