[jira] [Updated] (IGNITE-18994) SQL requests within RW transactions should not see their own changes.

["Alexander Lapin (Jira)" <ji...@apache.org>]

     [ 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)