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

support foreign keys in tables partitioned by system time

    XMLWordPrintable

Details

    Description

      foreign keys aren't supported for partitioned tables yet (MDEV-12483) fixing this is a rather big task.

      but a special case of tables partitioned by system time is much simpler — it's can work by adding foreign keys only to the current partition.

      as partitioning system versioned tables is pretty much the only way to make them faster, this is an important use case that justifies a special fix.

      Attachments

        Issue Links

          duplicates

          New Feature - A new feature of the product, which has yet to be developed. MDEV-19191 FK support for CURRENT partition of versioned tables

          • Critical - Crashes, loss of data, severe memory leak.
          • Stalled
          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-12483 Add foreign keys support for partitioned tables

          • Major - Major loss of function.
          • Stalled

          Activity

            People

              midenok Aleksey Midenkov
              serg Sergei Golubchik
              Votes:
              1 Vote for this issue
              Watchers:
              4 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.