[ https://issues.apache.org/jira/browse/IGNITE-9427?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Stepan Pilschikov resolved IGNITE-9427. --------------------------------------- Resolution: Not A Problem > SQL MVCC: old data read after parallel update with autoCommit=false > -------------------------------------------------------------------- > > Key: IGNITE-9427 > URL: https://issues.apache.org/jira/browse/IGNITE-9427 > Project: Ignite > Issue Type: Bug > Components: mvcc > Affects Versions: 2.5 > Reporter: Stepan Pilschikov > Priority: Major > > Second user don't seeing first user update right after select before commit > Table: > {code:sql}create table test(id int, field_int int, field_var varchar(50), > primary key (id, field_int)) with "template=replicated, > ATOMICITY=TRANSACTIONAL{code} > With one row of data: > {code:sql}insert into test(id, field_int, field_var) values (1, 1, > 'test_1'){code} > With two connections to sqlline > {code}sqlline.sh --autoCommit=false --color=true --outputFormat=csv > --showNestedErrs=true --showWarnings=true --verbose=true -u > jdbc:ignite:thin://127.0.0.1:10800 {code} > for *user_1* and *user_2* > *user_1*: > {code:sql} > begin transaction; > select * from test where id = 1 for update; > {code} > *user_2*: > {code:sql} > update test set field_var = 'updated' where id = 1; - transaction get locked > {code} > *user_1*: > {code:sql} > commit; > select * from test; - 1, 1, 'test_1' > {code} > *user_2*: > {code:sql} > 1 row affected > commit; > select * from test; - 1, 1, 'updated' > {code} > *user_1*: > {code:sql} > select * from test; - 1, 1, 'test_1' <---- should be 'updated' > {code} > if *user_1* do commit then he will be seeing update -- This message was sent by Atlassian JIRA (v7.6.3#76005)