Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.0.20
-
debian jessie
Description
Hello,
I ran into a problem when testing MariaDB with my application. Transactions do not work as expected. To reproduce I opened two connections to the database and entered the following statements:
- connection 1: START TRANSACTION
- connection 2: START TRANSACTION
- connection 1: SELECT * FROM table WHERE field1=1; # SHOWS field2=0
- connection 2: SELECT * FROM table WHERE field1=1; # SHOWS field2=0
- connection 1: UPDATE table SET field2=1 WHERE field1=1;
- connection 2: UPDATE table SET field2=1 WHERE field1=1; # this shows 0 rows affected
- connection 1: COMMIT;
- connection 2: COMMIT; # this should fail if I understand ACID right
Am I missing something or is this a bug?
Regards,
Volker