[jira] [Commented] (IGNITE-9427) SQL MVCC: old data read after parallel update with autoCommit=false

["Stepan Pilschikov (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IGNITE-9427?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16597279#comment-16597279 ] 

Stepan Pilschikov commented on IGNITE-9427:
-------------------------------------------

Close ticket
Don't mind of REPEATABLE_READ
If *user_1* make *update* then updated data from *user_2* has come

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