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

Enhance Support For Partition Truncate

        Details

        • Type: Task
        • Status: Open
        • Priority: Major
        • Resolution: Unresolved
        • Fix Version/s: 10.2
        • Component/s: None
        • Labels:
          None

          Description

          Extend current partition truncation to better support rolling dates in tables.

          CREATE TABLE members (
    firstname VARCHAR(25) NOT NULL,
    lastname VARCHAR(25) NOT NULL,
    username VARCHAR(16) NOT NULL,
    joined DATETIME NOT NULL
)
PARTITION BY HASH(TO_DAYS(joined))
PARTITIONS 7;

          ALTER TABLE t1 TRUNCATE PARTITION WHERE joined='2014-01-01'

          The effect would be that the partition that would be mapped from the value '2014-01-01' would be truncated.

            Gliffy Diagrams

              Attachments

                Activity

                There are no comments yet on this issue.

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    belugabehr BELUGABEHR
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    3 Start watching this issue

                    Dates

                    • Created:
                      Updated: