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

Obsolete internal parser for FK in InnoDB

Details

    Description

      Currently InnoDB uses internal parser for adding foreign keys. Remove internal parser and use data parsed by SQL parser (sql_yacc) for adding foreign keys. This allows to pass some additional data from SQL layer like whether the referenced table is SYSTEM_TIME partitioned (MDEV-19191) and is required for further improvements (MDEV-16417, MDEV-10393, MDEV-12483).

      Attachments

        Issue Links

          blocks

          Task - A task that needs to be done. MDEV-10393 Foreign keys SET DEFAULT action

          • Major - Major loss of function.
          • Open

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

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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-16417 Store Foreign Key metadata outside of InnoDB

          • Critical - Crashes, loss of data, severe memory leak.
          • In Review

          Task - A task that needs to be done. MDEV-20729 Fix REFERENCES constraint in column definition

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21127 Assertion `(size_t)(ptr - buf) < MAX_TEXT - 4' failed in key_text::key_text

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22817 InnoDB: Failing assertion: idlen <= MAX_TABLE_NAME_LEN upon long partition name with innodb_file_per_table OFF

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26439 Typo in Foreign Key error message

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26824 Can't add foreign key with empty referenced columns list

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21690 LeakSanitizer: detected memory leaks in mem_heap_create_block_func

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22230 Unexpected ER_ERROR_ON_RENAME upon DROP non-existing FOREIGN KEY with ALGORITHM=COPY

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35916 REFERENCES clause fails to infer multiple column names

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29092 FOREIGN_KEY_CHECKS does not prevent non-copy alter from creating invalid FK structure

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            Transition Time In Source Status Execution Times
            Aleksey Midenkov made transition -
            Open In Progress
            		1m 15s 1
            Aleksey Midenkov made transition -
            In Progress Stalled
            		33d 16h 1m 1
            Aleksey Midenkov made transition -
            Stalled In Review
            		19s 1
            Marko Mäkelä made transition -
            In Review Stalled
            		6d 23h 36m 1
            Aleksey Midenkov made transition -
            Stalled In Progress
            		2d 11h 54m 1
            Aleksey Midenkov made transition -
            In Progress Closed
            		34d 21h 7m 1

            People

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