modules/calcite/src/test/sql/update/test_update.test_ignore

# name: test/sql/update/test_update.test
# description: Test standard update behavior
# group: [update]
# Ignore https://issues.apache.org/jira/browse/IGNITE-15624

# create a table
statement ok con1
CREATE TABLE test (a INTEGER);

statement ok con1
INSERT INTO test VALUES (3)

query I con1
SELECT * FROM test
----
3

# test simple update
statement ok con1
BEGIN TRANSACTION

statement ok con1
UPDATE test SET a=1

# not seen yet by con2, only by con1
query I con1
SELECT * FROM test
----
1

query I con2
SELECT * FROM test
----
3

# commit
statement ok con1
COMMIT

query I con1
SELECT * FROM test
----
1

query I con2
SELECT * FROM test
----
1

# now test a rollback
statement ok con1
BEGIN TRANSACTION

statement ok con1
UPDATE test SET a=4

# not seen yet by con2, only by con1
query I con1
SELECT * FROM test
----
4

query I con2
SELECT * FROM test
----
1

statement ok con1
ROLLBACK

query I con1
SELECT * FROM test
----
1

query I con2
SELECT * FROM test
----
1