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

Foreign Key Constraint actions don't affect Virtual Column

Details

    Description

      One of my tables has several columns with FK ON DELETE SET NULL constraints on them, plus one virtual column with mildly complex expression based on these FK columns.

      When a DELETE is issued on the foreign table, the FK fields get set to NULL but the STORED Virtual column is not updated.

      There is no trace of this behaviour on the documentation.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31931 FK fields cannot be used anymore in generated columns

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32030 Error in restoring SQL dump with virtual columns after upgrade to version 10.6.15

          • Major - Major loss of function.
          • Closed
          includes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31322 FKs with 'ON UPDATE CASCADE' can be set in some contexts but not others

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32764 Segmentation fault at /mariadb-11.3.0/strings/ctype-utf8.c:831

          • Major - Major loss of function.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31434 stored generated columns are not properly updated after update

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22602 WITHOUT OVERLAPS constraint is ignored when update is performed via foreign key cascade

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

          Task - A task that needs to be done. MDEV-30674 Implement CHECK constraints validation on cascading updates

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-31654 Support STORED generated columns with FK cascade changes

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31112 vcol circular references lead to stack overflow

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

          Activity

            Transition Time In Source Status Execution Times
            Elena Stepanova made transition -
            Open Confirmed
            		23d 2h 51m 1
            Sergei Golubchik made transition -
            Confirmed In Progress
            		1617d 23h 40m 1
            Sergei Golubchik made transition -
            In Progress In Testing
            		8m 23s 1
            Sergei Golubchik made transition -
            In Testing Stalled
            		26m 1
            Sergei Golubchik made transition -
            Stalled In Review
            		7d 2h 20m 2
            Nikita Malyavin made transition -
            In Review Stalled
            		26d 14h 38m 2
            Sergei Golubchik made transition -
            Stalled Closed
            		47m 27s 1

            People

              elenst Elena Stepanova
              a_marchand_canada Aurelien Marchand
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.