Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10561

Transactions not ACID compliant?

    XMLWordPrintable

Details

    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:

      1. connection 1: START TRANSACTION
      2. connection 2: START TRANSACTION
      3. connection 1: SELECT * FROM table WHERE field1=1; # SHOWS field2=0
      4. connection 2: SELECT * FROM table WHERE field1=1; # SHOWS field2=0
      5. connection 1: UPDATE table SET field2=1 WHERE field1=1;
      6. connection 2: UPDATE table SET field2=1 WHERE field1=1; # this shows 0 rows affected
      7. connection 1: COMMIT;
      8. connection 2: COMMIT; # this should fail if I understand ACID right

      Am I missing something or is this a bug?

      Regards,
      Volker

      Attachments

        Activity

          People

            Unassigned Unassigned
            vc1979 Volker Cordes
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.