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

Application-time periods: foreign key

    XMLWordPrintable

    Details

      Description

      The syntax as follows:

      <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>

       
      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

          relates to

          Technical task - A technical task. MDEV-20865 Store foreign key info in TABLE_SHARE

          • Major - Major loss of function.
          • In Review

            Activity

              People

              Assignee:
              serg Sergei Golubchik
              Reporter:
              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.