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

RQG: Difference in results for sql and n1ql delete queries with where predicates

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Critical
    • 4.1.0
    • 4.1.0, 4.5.0
    • query
    • Security Level: Public
    • Untriaged
    • Unknown

    Description

      This RQG test failed:
      ./testrunner -i /root/tuqvm.ini -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,total_queries=10000,crud_type=delete

      Error:
      ____________________________________________________
      Scenario :: crud_verification_test
      Reason :: CBQError: host 172.23.106.40: ERROR:{u'status': u'errors', u'errors': [

      {u'msg': u'index is deleted or node hosting index is down - cause: Index not found', u'code': 5000}

      ], u'results': [], u'metrics':

      {u'elapsedTime': u'77.467189ms', u'executionTime': u'77.359494ms', u'resultSize': 0, u'resultCount': 0, u'errorCount': 1}

      , u'requestID': u'6b61b3d1-0b71-4c8c-9317-a1b197f85ff6', u'signature': None}

      sql_query :: DELETE FROM simple_table_3 WHERE ((primary_key_id < "549" AND int_field1 IS NOT NULL)) AND ((char_field1 LIKE "N" AND decimal_field1 < 4849)) OR ((bool_field1 = false AND primary_key_id <= "549")) AND ((bool_field1 AND int_field1 IS NOT NULL));

      n1ql_query :: DELETE FROM simple_table_3 WHERE ((primary_key_id < "549" AND int_field1 IS NOT NULL)) AND ((char_field1 LIKE "N" AND decimal_field1 < 4849)) OR ((bool_field1 = false AND primary_key_id <= "549")) AND ((bool_field1 AND int_field1 IS NOT NULL));

      <<<<<<<<<< TEST 10 >>>>>>>>>>>
      keyword_list :: ['AND', 'BETWEEN', 'DELETE', 'LET', 'NOT']
      run_result ::
      ____________________________________________________
      Scenario :: crud_verification_test
      Reason :: Results are incorrect.Actual num 984. Expected num: 1000.:: mismatch in results :: expected :: [

      {u'datetime_field1': '2000-12-10 00:00:00', u'int_field1': 1591, u'primary_key_id': u'716', u'varchar_field1': u'XldMmfTOWd', u'decimal_field1': 5955, u'char_field1': u'A', u'bool_field1': False}

      ,

      {u'datetime_field1': '2000-12-17 00:00:00', u'int_field1': 5477, u'primary_key_id': u'807', u'varchar_field1': u'zieLViHgTF', u'decimal_field1': 5326, u'char_field1': u'A', u'bool_field1': False}

      ,

      {u'datetime_field1': '2002-04-25 00:00:00', u'int_field1': 9500, u'primary_key_id': u'387', u'varchar_field1': u'BOtIGaqXqt', u'decimal_field1': 7875, u'char_field1': u'A', u'bool_field1': False}

      ,

      {u'datetime_field1': '2002-06-15 00:00:00', u'int_field1': 4092, u'primary_key_id': u'107', u'varchar_field1': u'ALZUdbeeUr', u'decimal_field1': 3335, u'char_field1': u'A', u'bool_field1': False}

      ,

      {u'datetime_field1': '2003-06-28 00:00:00', u'int_field1': 1665, u'primary_key_id': u'438', u'varchar_field1': u'aKmwCTgJvQ', u'decimal_field1': 2048, u'char_field1': u'A', u'bool_field1': False}

      ], actual :: [

      {u'datetime_field1': u'2000-12-10 00:00:00', u'bool_field1': False, u'primary_key_id': u'716', u'varchar_field1': u'XldMmfTOWd', u'decimal_field1': 5955, u'char_field1': u'A', u'int_field1': 1591}

      ,

      {u'datetime_field1': u'2000-12-17 00:00:00', u'bool_field1': False, u'primary_key_id': u'807', u'varchar_field1': u'zieLViHgTF', u'decimal_field1': 5326, u'char_field1': u'A', u'int_field1': 5477}

      ,

      {u'datetime_field1': u'2002-04-25 00:00:00', u'bool_field1': False, u'primary_key_id': u'387', u'varchar_field1': u'BOtIGaqXqt', u'decimal_field1': 7875, u'char_field1': u'A', u'int_field1': 9500}

      ,

      {u'datetime_field1': u'2002-06-15 00:00:00', u'bool_field1': False, u'primary_key_id': u'107', u'varchar_field1': u'ALZUdbeeUr', u'decimal_field1': 3335, u'char_field1': u'A', u'int_field1': 4092}

      ,

      {u'datetime_field1': u'2003-06-28 00:00:00', u'bool_field1': False, u'primary_key_id': u'438', u'varchar_field1': u'aKmwCTgJvQ', u'decimal_field1': 2048, u'char_field1': u'A', u'int_field1': 1665}

      ]

      sql_query :: DELETE FROM simple_table_2 WHERE (bool_field1 AND varchar_field1 NOT BETWEEN "AArPyqfxSB" and "zieLViHgTF");

      n1ql_query :: DELETE FROM simple_table_2 WHERE (bool_field1 AND varchar_field1 NOT BETWEEN "AArPyqfxSB" and "zieLViHgTF");

      <<<<<<<<<< TEST 13 >>>>>>>>>>>
      keyword_list :: [' < ', 'AND', 'DELETE', 'FALSE', 'KEY', 'LET']
      run_result ::
      ____________________________________________________
      Scenario :: crud_verification_test
      Reason :: Results are incorrect.Actual num 745. Expected num: 744.:: mismatch in results :: expected :: [

      {u'datetime_field1': '2000-12-10 00:00:00', u'int_field1': 1591, u'primary_key_id': u'716', u'varchar_field1': u'XldMmfTOWd', u'decimal_field1': 5955, u'char_field1': u'A', u'bool_field1': False}

      ,

      {u'datetime_field1': '2000-12-17 00:00:00', u'int_field1': 5477, u'primary_key_id': u'807', u'varchar_field1': u'zieLViHgTF', u'decimal_field1': 5326, u'char_field1': u'A', u'bool_field1': False}

      ,

      {u'datetime_field1': '2002-04-25 00:00:00', u'int_field1': 9500, u'primary_key_id': u'387', u'varchar_field1': u'BOtIGaqXqt', u'decimal_field1': 7875, u'char_field1': u'A', u'bool_field1': False}

      ,

      {u'datetime_field1': '2002-06-15 00:00:00', u'int_field1': 4092, u'primary_key_id': u'107', u'varchar_field1': u'ALZUdbeeUr', u'decimal_field1': 3335, u'char_field1': u'A', u'bool_field1': False}

      ,

      {u'datetime_field1': '2003-06-28 00:00:00', u'int_field1': 1665, u'primary_key_id': u'438', u'varchar_field1': u'aKmwCTgJvQ', u'decimal_field1': 2048, u'char_field1': u'A', u'bool_field1': False}

      ], actual :: [

      {u'datetime_field1': u'2000-12-10 00:00:00', u'bool_field1': False, u'primary_key_id': u'716', u'varchar_field1': u'XldMmfTOWd', u'decimal_field1': 5955, u'char_field1': u'A', u'int_field1': 1591}

      ,

      {u'datetime_field1': u'2000-12-17 00:00:00', u'bool_field1': False, u'primary_key_id': u'807', u'varchar_field1': u'zieLViHgTF', u'decimal_field1': 5326, u'char_field1': u'A', u'int_field1': 5477}

      ,

      {u'datetime_field1': u'2002-04-25 00:00:00', u'bool_field1': False, u'primary_key_id': u'387', u'varchar_field1': u'BOtIGaqXqt', u'decimal_field1': 7875, u'char_field1': u'A', u'int_field1': 9500}

      ,

      {u'datetime_field1': u'2002-06-15 00:00:00', u'bool_field1': False, u'primary_key_id': u'107', u'varchar_field1': u'ALZUdbeeUr', u'decimal_field1': 3335, u'char_field1': u'A', u'int_field1': 4092}

      ,

      {u'datetime_field1': u'2003-06-28 00:00:00', u'bool_field1': False, u'primary_key_id': u'438', u'varchar_field1': u'aKmwCTgJvQ', u'decimal_field1': 2048, u'char_field1': u'A', u'int_field1': 1665}

      ]

      sql_query :: DELETE FROM simple_table_5 WHERE ((decimal_field1 != 4849 AND primary_key_id < "549" AND bool_field1 != false)) AND (bool_field1);

      n1ql_query :: DELETE FROM simple_table_5 WHERE ((decimal_field1 != 4849 AND primary_key_id < "549" AND bool_field1 != false)) AND (bool_field1);

      <<<<<<<<<< TEST 12 >>>>>>>>>>>
      keyword_list :: ['DELETE', 'IN', 'IS', 'LET', 'NOT', 'NULL', 'OR']
      run_result ::
      ____________________________________________________
      Scenario :: crud_verification_test
      Reason :: Results are incorrect.Actual num 931. Expected num: 1000.:: mismatch in results :: expected :: [

      {u'datetime_field1': '2000-12-10 00:00:00', u'int_field1': 1591, u'primary_key_id': u'716', u'varchar_field1': u'XldMmfTOWd', u'decimal_field1': 5955, u'char_field1': u'A', u'bool_field1': False}

      ,

      {u'datetime_field1': '2000-12-17 00:00:00', u'int_field1': 5477, u'primary_key_id': u'807', u'varchar_field1': u'zieLViHgTF', u'decimal_field1': 5326, u'char_field1': u'A', u'bool_field1': False}

      ,

      {u'datetime_field1': '2002-04-25 00:00:00', u'int_field1': 9500, u'primary_key_id': u'387', u'varchar_field1': u'BOtIGaqXqt', u'decimal_field1': 7875, u'char_field1': u'A', u'bool_field1': False}

      ,

      {u'datetime_field1': '2002-06-15 00:00:00', u'int_field1': 4092, u'primary_key_id': u'107', u'varchar_field1': u'ALZUdbeeUr', u'decimal_field1': 3335, u'char_field1': u'A', u'bool_field1': False}

      ,

      {u'datetime_field1': '2003-06-28 00:00:00', u'int_field1': 1665, u'primary_key_id': u'438', u'varchar_field1': u'aKmwCTgJvQ', u'decimal_field1': 2048, u'char_field1': u'A', u'bool_field1': False}

      ], actual :: [

      {u'datetime_field1': u'2000-12-10 00:00:00', u'bool_field1': False, u'primary_key_id': u'716', u'varchar_field1': u'XldMmfTOWd', u'decimal_field1': 5955, u'char_field1': u'A', u'int_field1': 1591}

      ,

      {u'datetime_field1': u'2000-12-17 00:00:00', u'bool_field1': False, u'primary_key_id': u'807', u'varchar_field1': u'zieLViHgTF', u'decimal_field1': 5326, u'char_field1': u'A', u'int_field1': 5477}

      ,

      {u'datetime_field1': u'2002-04-25 00:00:00', u'bool_field1': False, u'primary_key_id': u'387', u'varchar_field1': u'BOtIGaqXqt', u'decimal_field1': 7875, u'char_field1': u'A', u'int_field1': 9500}

      ,

      {u'datetime_field1': u'2002-06-15 00:00:00', u'bool_field1': False, u'primary_key_id': u'107', u'varchar_field1': u'ALZUdbeeUr', u'decimal_field1': 3335, u'char_field1': u'A', u'int_field1': 4092}

      ,

      {u'datetime_field1': u'2003-06-28 00:00:00', u'bool_field1': False, u'primary_key_id': u'438', u'varchar_field1': u'aKmwCTgJvQ', u'decimal_field1': 2048, u'char_field1': u'A', u'int_field1': 1665}

      ]

      sql_query :: DELETE FROM simple_table_4 WHERE NOT ((bool_field1 OR int_field1 IS NOT NULL));

      n1ql_query :: DELETE FROM simple_table_4 WHERE NOT ((bool_field1 OR int_field1 IS NOT NULL));

      <<<<<<<<<< TEST 15 >>>>>>>>>>>
      keyword_list :: ['AND', 'DELETE', 'FALSE', 'IS', 'LET', 'NOT', 'NULL']
      run_result ::

      Attachments

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

        Activity

          People

            keshav Keshav Murthy
            Prerna.Manaktala Prerna Manaktala (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty