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

RQG: Merge into and delete queries reporting wrong results

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Test Blocker
    • 4.5.0
    • 4.5.0
    • query
    • 4.5.0-2436
    • Untriaged
    • Yes

    Description

      Job Failed:
      cen006-n1ql-vset08-01-rqg-crud-merge-delete-primary-secondary-tests

      Queries reporting mismatch:
      sql_query :: DELETE FROM simple_table_2 WHERE simple_table_2.int_field1 <= 4820;

      n1ql_query :: MERGE INTO simple_table_2 USING copy_simple_table ON KEY copy_simple_table.primary_key_id WHEN MATCHED THEN DELETE WHERE simple_table_2.int_field1 <= 4820

      sql_query :: DELETE FROM simple_table_9 WHERE NOT ((simple_table_9.decimal_field1 != 5153 AND simple_table_9.primary_key_id IS NOT NULL AND simple_table_9.bool_field1));

      n1ql_query :: MERGE INTO simple_table_9 USING copy_simple_table ON KEY copy_simple_table.primary_key_id WHEN MATCHED THEN DELETE WHERE NOT ((simple_table_9.decimal_field1 != 5153 AND simple_table_9.primary_key_id IS NOT NULL AND simple_table_9.bool_field1))

      sql_query :: DELETE FROM simple_table_1 WHERE NOT ((simple_table_1.primary_key_id != "549" AND simple_table_1.int_field1 IS NULL));

      n1ql_query :: MERGE INTO simple_table_1 USING copy_simple_table ON KEY copy_simple_table.primary_key_id WHEN MATCHED THEN DELETE WHERE NOT ((simple_table_1.primary_key_id != "549" AND simple_table_1.int_field1 IS NULL))

      sql_query :: DELETE FROM simple_table_9 WHERE NOT ((NOT (simple_table_9.bool_field1) OR simple_table_9.int_field1 < 4820));

      n1ql_query :: MERGE INTO simple_table_9 USING copy_simple_table ON KEY copy_simple_table.primary_key_id WHEN MATCHED THEN DELETE WHERE NOT ((NOT (simple_table_9.bool_field1) OR simple_table_9.int_field1 < 4820))

      sql_query :: DELETE FROM simple_table_5 WHERE (simple_table_5.bool_field1 != false AND NOT (simple_table_5.int_field1 >= 4820));

      n1ql_query :: MERGE INTO simple_table_5 USING copy_simple_table ON KEY copy_simple_table.primary_key_id WHEN MATCHED THEN DELETE WHERE (simple_table_5.bool_field1 != false AND NOT (simple_table_5.int_field1 >= 4820))

      Index used: primary.

      I will rerun the test with skip_cleanup=False and hand over the env to dev.

      Link to couchbase url: http://172.23.106.43:8091/ui/index.html#/auth

      Attachments

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

        Activity

          People

            gerald Gerald Sangudi (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