[MDEV-18114] Foreign Key Constraint actions don't affect Virtual Column - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.3.11, 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL)
Fix Version/s: 10.5.22, 10.6.15, 10.9.8, 10.10.6, 10.11.5, 11.0.3, 11.1.2
Component/s: Storage Engine - InnoDB, Virtual Columns
Labels:
None
Environment:
CentOS 7

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

MDEV-31931 FK fields cannot be used anymore in generated columns

Closed

MDEV-32030 Error in restoring SQL dump with virtual columns after upgrade to version 10.6.15

Closed

includes

MDEV-31322 FKs with 'ON UPDATE CASCADE' can be set in some contexts but not others

Closed

MDEV-32764 Segmentation fault at /mariadb-11.3.0/strings/ctype-utf8.c:831

Closed

is duplicated by

MDEV-31434 stored generated columns are not properly updated after update

Closed

relates to

MDEV-22602 WITHOUT OVERLAPS constraint is ignored when update is performed via foreign key cascade

Closed

MDEV-30674 Implement CHECK constraints validation on cascading updates

Closed

MDEV-31654 Support STORED generated columns with FK cascade changes

Open

MDEV-31112 vcol circular references lead to stack overflow

Closed

(4 relates to)

Activity

People

Assignee:: Elena Stepanova

Reporter:: Aurelien Marchand

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2018-12-31 16:33

Updated:: 2023-11-10 16:54

Resolved:: 2023-08-02 13:26

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.