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

Delete with table name on system versioned table with cascading delete fails

    XMLWordPrintable

    Details

      Description

      Version 10.3.27 on Debian tested, have not tested other platforms.

      Create two tables, both with system versioning. Table one has some random records in it. Table two has a foreign key reference to table one with a cascading delete. Create some records.

      Running a delete query of the format "DELETE table1 FROM table1" does not cascade the deletion to table2 while the query "DELETE FROM table1" does cascade as expected.

        Attachments

          Activity

            People

            Assignee:
            midenok Aleksey Midenkov
            Reporter:
            rstark@orbitform.com Ryan Stark
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration