You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Alexander Lapin (Jira)" <ji...@apache.org> on 2023/03/10 04:02:00 UTC
[jira] [Created] (IGNITE-18994) SQL requests within RW transactions should not see their own changes.
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)