Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-4171

Investigate and possibly remove error on FK constraint

    Details

    • Type: Bug
    • Status: On Hold
    • Priority: Low
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: MyRocks
    • Labels:

      Description

      This upstream commit https://github.com/facebook/mysql-5.6/commit/8b34f82b403ad2904ff0f6f5bb65cf90bf274fdf introduced a check on create table that throws an error if a FOREIGN KEY constraint is specified during create table. It seems to not check if a new FK constraint is added via ALTER.

      This is inconsistent behavior w.r.t. MySAM, Memory, TokuDB, and possibly other engines that ignore and absorb the constraint, leaving the burden of detection on the user.

      This also prevents the use of many mtr template type tests such as those in extra/rpl_tests (see MYR-137)

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                george.lorch George Lorch
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: