Command window - strange commit behavior

[sdi68]

Hi

it seems performing a commit in the command window does not work if a select statement is executed before the commit.

I did an update, a select and a commit and the update was suprisingly 'lost'.

SQL> select id, modified_by from test_table;

ID MODIFIED_BY
------------------- ------------------------------------------
1122 test_user
1123 test_user
1124 test_user

SQL> update test_table set modified_by = 'me' where id = 1122;

1 row updated

SQL> select id, modified_by from test_table;

ID MODIFIED_BY
------------------- ------------------------------------------
1122 me
1123 test_user
1124 test_user

SQL> commit;

Commit complete

SQL> select id, modified_by from test_table;

ID MODIFIED_BY
------------------- ------------------------------------------
1122 test_user
1123 test_user
1124 test_user

Is this a configuration issue or a bug? The plsql developer version used is 13.0.2.1898 (64 bit).

Thanks
Sandro

 

[Marco Kalter]

Can you update to 13.0.5 and try again?

 

[sdi68]

We retested this scenario with 13.0.6 and the issue seems to be fixed .