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

RQG: Merge into and delete queries give different results with primary indexes

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Critical
    • 4.1.0
    • 4.1.0, 4.5.0
    • query
    • Security Level: Public
    • Untriaged
    • uploading the dataset
    • Yes

    Description

      Primary indexes on buckets created using GSI

      Test failing:
      ./testrunner -i ${resource_tuq} -t rqg.test_rqg.RQGTests.test_rqg_crud_ops,test_file_path=b/resources/rqg/simple_table_db/query_tests_using_templates/crud_delete_ops_50000.txt.zip,database=crud_db,reset_database=True,concurreny_count=1,index_quota_percent=30,password=password,use_mysql=True,replicas=0,merge_operation=True,crud_type=merge_delete,total_queries=10000,skip_cleanup=false

      Error:

      2015-09-16 16:20:08 | INFO | MainProcess | Thread-3 | [test_rqg._run_basic_crud_test] <<<<<<<<<<<<<<<<<<<<<<<<<<<< BEGIN RUNNING TEST 9 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
      2015-09-16 16:20:08 | INFO | MainProcess | Thread-3 | [test_rqg._run_basic_crud_test] SQL :: DELETE FROM simple_table_1 WHERE (simple_table_1.varchar_field1 NOT BETWEEN "ACdGvhTwgL" and "zztGiHnDPT") AND ((simple_table_1.bool_field1 = false AND simple_table_1.decimal_field1 = 5110));

      2015-09-16 16:20:08 | INFO | MainProcess | Thread-3 | [test_rqg._run_basic_crud_test] N1QL :: MERGE INTO simple_table_1 USING copy_simple_table ON KEY copy_simple_table.primary_key_id WHEN MATCHED THEN DELETE WHERE (simple_table_1.varchar_field1 NOT BETWEEN "ACdGvhTwgL" and "zztGiHnDPT") AND ((simple_table_1.bool_field1 = false AND simple_table_1.decimal_field1 = 5110))

      2015-09-16 16:20:08 | INFO | MainProcess | Thread-3 | [test_rqg._run_queries_and_verify_crud] SQL QUERY :: SELECT * from simple_table_1 ORDER by primary_key_id
      2015-09-16 16:20:08 | INFO | MainProcess | Thread-3 | [test_rqg._run_queries_and_verify_crud] N1QL QUERY :: SELECT * from simple_table_1 ORDER by primary_key_id
      2015-09-16 16:20:08 | INFO | MainProcess | Thread-3 | [tuq_helper.run_cbq_query] RUN QUERY SELECT * from simple_table_1 ORDER by primary_key_id
      2015-09-16 16:20:08 | INFO | MainProcess | Thread-4 | [tuq_helper.run_cbq_query] TOTAL ELAPSED TIME: 607.211678ms
      2015-09-16 16:20:08 | INFO | MainProcess | Thread-3 | [rest_client.query_tool] query params : scan_consistency=request_plus&statement=SELECT+%2A+from+simple_table_1+ORDER+by+primary_key_id

      2015-09-16 16:20:11 | INFO | MainProcess | Thread-3 | [test_rqg._run_queries_and_verify_crud] result from n1ql query returns 916 items
      2015-09-16 16:20:11 | INFO | MainProcess | Thread-3 | [test_rqg._run_queries_and_verify_crud] result from sql query returns 1000 items
      2015-09-16 16:20:11 | INFO | MainProcess | Thread-3 | [test_rqg._run_queries_and_verify_crud] Results are incorrect.Actual num 916. Expected num: 1000.:: mismatch in results :: expected :: [

      {u'datetime_field1': '1999-01-09 00:00:00', u'int_field1': 1745, u'primary_key_id': u'620', u'varchar_field1': u'zYnMIyoPYp', u'decimal_field1': 6797, u'char_field1': u'A', u'bool_field1': False}

      ,

      {u'datetime_field1': '2002-12-25 00:00:00', u'int_field1': 1758, u'primary_key_id': u'739', u'varchar_field1': u'ppkJzqGSHL', u'decimal_field1': 5068, u'char_field1': u'A', u'bool_field1': False}

      ,

      {u'datetime_field1': '2003-10-07 00:00:00', u'int_field1': 3557, u'primary_key_id': u'475', u'varchar_field1': u'zMUbnKqJqA', u'decimal_field1': 6458, u'char_field1': u'A', u'bool_field1': False}

      ,

      {u'datetime_field1': '2004-01-06 00:00:00', u'int_field1': 333, u'primary_key_id': u'157', u'varchar_field1': u'JlIAfgfScB', u'decimal_field1': 1150, u'char_field1': u'A', u'bool_field1': False}

      ,

      {u'datetime_field1': '2004-03-20 00:00:00', u'int_field1': 6107, u'primary_key_id': u'335', u'varchar_field1': u'rVItgdSuFB', u'decimal_field1': 5364, u'char_field1': u'A', u'bool_field1': False}

      ], actual :: [

      {u'datetime_field1': u'1999-01-09 00:00:00', u'bool_field1': False, u'primary_key_id': u'620', u'varchar_field1': u'zYnMIyoPYp', u'decimal_field1': 6797, u'char_field1': u'A', u'int_field1': 1745}

      ,

      {u'datetime_field1': u'2002-12-25 00:00:00', u'bool_field1': False, u'primary_key_id': u'739', u'varchar_field1': u'ppkJzqGSHL', u'decimal_field1': 5068, u'char_field1': u'A', u'int_field1': 1758}

      ,

      {u'datetime_field1': u'2003-10-07 00:00:00', u'bool_field1': False, u'primary_key_id': u'475', u'varchar_field1': u'zMUbnKqJqA', u'decimal_field1': 6458, u'char_field1': u'A', u'int_field1': 3557}

      ,

      {u'datetime_field1': u'2004-01-06 00:00:00', u'bool_field1': False, u'primary_key_id': u'157', u'varchar_field1': u'JlIAfgfScB', u'decimal_field1': 1150, u'char_field1': u'A', u'int_field1': 333}

      ,

      {u'datetime_field1': u'2004-03-20 00:00:00', u'bool_field1': False, u'primary_key_id': u'335', u'varchar_field1': u'rVItgdSuFB', u'decimal_field1': 5364, u'char_field1': u'A', u'int_field1': 6107}

      ]

      2015-09-16 16:20:11 | INFO | MainProcess | Thread-3 | [tuq_helper.run_cbq_query] RUN QUERY MERGE INTO simple_table_1 USING copy_simple_table ON KEY copy_simple_table.primary_key_id WHEN MATCHED THEN DELETE WHERE (simple_table_1.varchar_field1 NOT BETWEEN "ACdGvhTwgL" and "zztGiHnDPT") AND ((simple_table_1.bool_field1 = false AND simple_table_1.decimal_field1 = 5110))

      Attachments

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

        Activity

          People

            isha Isha Kandaswamy (Inactive)
            Prerna.Manaktala Prerna Manaktala (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty