Details
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
For Gerrit Dashboard: MB-19456 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
63562,2 | Fix MB-19455, MB-19456. Remove race conditions in MERGE. | master | query | Status: MERGED | +2 | +1 |