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

There is no data on PERIOD FOR in information schema

Details

    Description

      The PERIOD FOR syntax registers a special constraint on a table. There can be only one period per table and it can be designated to be part of a unique index 'without overlaps'. However, it seems that it is impossible to track periods in the information schema:

      • The PERIOD FOR constraint translates to a CHECK constraint that just gets the same name as the period name (unless that name is already occupied in the table, in which case a new name gets generated). The CHECK constraint appears to be defined in CHECK_CONSTRAINTS as 'from_time_column < to_time_column', but there is no mention of this being a PERIOD in any of the information schema tables.
      • It is possible to register a unique index using the period 'WITHOUT OVERLAPS'. We will find the period's two columns to be part of the unique index in STATISTICS, but there is no mention of the WITHOUT OVERLAPS modifier.

      Attachments

        Issue Links

          Activity

            user2180613 Remy Fox created issue -
            serg Sergei Golubchik made changes -
            Field Original Value New Value

            Let's consider it a duplicate of MDEV-22597

            serg Sergei Golubchik added a comment - Let's consider it a duplicate of MDEV-22597
            serg Sergei Golubchik made changes -
            Component/s Information Schema [ 14413 ]
            Component/s Versioned Tables [ 14303 ]
            Fix Version/s N/A [ 14700 ]
            Assignee Sergei Golubchik [ serg ]
            Resolution Duplicate [ 3 ]
            Status Open [ 1 ] Closed [ 6 ]

            People

              serg Sergei Golubchik
              user2180613 Remy Fox
              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.