[
https://issues.apache.org/jira/browse/IGNITE-27679?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Konstantin Orlov updated IGNITE-27679:
--------------------------------------
Release Note: Fixed an issue where the result of a SELECT COUNT(*) query
could be incorrect when it was followed by a DML statement modifying the same
table within the same SQL script
> Sql. SelectCount plan is affected by consequent DML in script
> -------------------------------------------------------------
>
> Key: IGNITE-27679
> URL: https://issues.apache.org/jira/browse/IGNITE-27679
> Project: Ignite
> Issue Type: Bug
> Components: sql ai3
> Affects Versions: 3.1
> Reporter: Konstantin Orlov
> Assignee: Konstantin Orlov
> Priority: Major
> Labels: ignite-3
> Fix For: 3.2
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> Take a look at the script below:
> {code:java}
> CREATE TABLE integers (i INT PRIMARY KEY);
> INSERT INTO integers SELECT * FROM TABLE(system_range(1, 1000));
> SELECT count(*) FROM integers;
> DELETE FROM integers;
> {code}
> Initially, SELECT count(\*) was not affected by consequent {{DELETE}}
> statement because it was executed in fair RO transaction. But after
> optimization introduced in IGNITE-22829 this invariant was broken as now, if
> aforementioned optimization is applied, the execution follows short path
> avoiding creation of transaction.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
