Alexander Lapin created IGNITE-18994:
----------------------------------------
Summary: SQL requests within RW transactions should not see their
own changes.
Key: IGNITE-18994
URL: https://issues.apache.org/jira/browse/IGNITE-18994
Project: Ignite
Issue Type: Improvement
Reporter: Alexander Lapin
Following requests
{code:java}
INSERT INTO bigtable SELECT * FROM bigtable{code}
should not see their own changes.
Consider following reproducer for more details:
{code:java}
// ItDmlTest.java
@Test
@WithSystemProperty(key = "IMPLICIT_PK_ENABLED", value = "true")
public void test() {
sql("CREATE TABLE test (x INT)");
long size = 1024;
// initial state
sql("INSERT INTO test SELECT * FROM TABLE(system_range(1, ?))", size);
for (int i = 0; i < 5; i++) {
sql("INSERT INTO test SELECT * FROM test");
assertQuery("SELECT count(*) FROM test")
.returns(size * 2)
.check();
size *= 2;
}
} {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
