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

RQG: CountScan() returns wrong results (Difference in number of results for same n1ql queries with not keyword with same dataset for 4.1 and 4.5)

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Test Blocker
    • 4.5.0
    • 4.5.0
    • secondary-index
    • 4.5.0-1712
    • Untriaged
    • Yes

    Description

      As part of rqg subquery run:
      cen006-n1ql-vset04-01-rqg-subquery-multiple-table-primary-secondary-tests

      Test run:
      ./testrunner -i adv.ini  -t rqg.test_rqg.RQGTests.test_rqg_concurrent,test_file_path=b/resources/rqg/multiple_table_db/query_test_using_templates/query_50000_subquery.txt.zip,database=multiple_table_db,reset_database=True,concurreny_count=10,index_quota_percent=30,password=password,use_mysql=True,replicas=0,nodes_init=1,total_queries=2000,skip_cleanup=True
       
      This test creates only primary indexes using gsi.
      There is no crud operation during the test.
      No indexes are created/dropped during the test.
      It compares various subquery results from n1ql/s1l based on fields. 
       
      There was a mismatch in n1ql and sql subqueries.
      Example of 1 such n1ql subquery:
      SELECT  t_1.*  FROM  simple_table_2  t_1   WHERE  EXISTS      (SELECT * FROM  simple_table_10  t_4 USE KEYS META(t_1).id   WHERE   ((t_4.int_field1 != 5185 OR (t_4.varchar_field1 IS NOT NULL) AND (t_4.primary_key_id LIKE '549%'))) AND (((NOT (t_4.bool_field1) AND t_4.int_field1 > 5185)) AND (NOT ((t_4.primary_key_id  IN [  "1" , "10" , "100" , "1000" , "101"  ] AND t_4.int_field1 > 5185)))) );
       
      I narrowed down the subquery to:
      SELECT * FROM  simple_table_10  t_4   WHERE    (((NOT (t_4.bool_field1) AND t_4.int_field1 > 5185)) ) ;
       
       This query can be executed only with primary index on simple_table_10.
      This results 247 results in 4.5 while 258 results in 4.1
       
      Uploading logs and dataset for both cases.
      

      Attachments

        1. bucketbackup4.5.tar.gz
          345 kB
        2. bucketinfo4.1.tar.gz
          347 kB
        3. logs4.1.zip.gz
          3.90 MB
        4. logs4.5.zip.gz
          5.22 MB
        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            Prerna.Manaktala Prerna Manaktala (Inactive)
            Prerna.Manaktala Prerna Manaktala (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty