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

Alter tables in transactions

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Duplicate
    • N/A
    • Server
    • None

    Description

      Hi, I saw that 11.0 is on the way, so I want to ask, how difficult it would be, to implement DDLs commands to work in transactions. Since it's barely mentioned these days, but that's one of the main reasons people are choosing other DB platforms for serious projects instead of MariaDB, even though MariaDB is faster in most cases.

      In most modern apps, there are migrations executed in deploy process, if that database migration fails in the middle for some reason (oom killer, wrong sql, different data in production env and so on) and there are some alter tables, database will be broken and there is no simple way to fix it, in platforms like pgsql, whole migration can be packed in transaction, so if something fails, all changes will be reverted and no harm is made.

      There is a famous quote regarding that:

      I am marking this as a feature request.
      Heikki Tuuri, 2007

      source:
      https://bugs.mysql.com/bug.php?id=28727

      So I guess it won't be easy, or there is a reason for that?

      Attachments

        Activity

          People

            Unassigned Unassigned
            rixafy Rick Strafy
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.