[ https://issues.apache.org/jira/browse/IGNITE-18994?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Alexander Lapin updated IGNITE-18994: ------------------------------------- Component/s: sql > 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 > Components: sql > Reporter: Alexander Lapin > Priority: Major > Labels: ignite-3 > > 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)