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

Application-time periods: foreign key

    XMLWordPrintable

Details

    • New Feature
    • Status: In Review (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • Versioned Tables
    • None

    Description

      The syntax as follows:
      {code}<referential constraint definition> ::= FOREIGN KEY
      <left paren> <referencing column list>
      [ <comma> <referencing period specification> ]
      <right paren> <references specification>
      <references specification> ::= REFERENCES <referenced table and columns>...

      <referencing period specification> ::= PERIOD <application time period name>
      <referenced table and columns> ::= <table name>
      [ <left paren> <referenced column list>
      [ <comma> <referenced period specification> ]
      <right paren> ]
      <referenced period specification> ::= PERIOD <application time period name>
      {code}
       
      -This task looks very much like a semantic one, i.e. it should be possible to create such a reference to period-driven primary keys. This syntax adds no complex logic, like the PRIMARY KEY does.

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              nikitamalyavin Nikita Malyavin
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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