-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Critical
-
Resolution: Fixed
-
Affects Version/s: 10.2, 10.3, 10.3.14, 10.3.15, 10.4
-
Component/s: Triggers, Virtual Columns
-
Labels:
-
Environment:Production: Ubuntu 16.04 LTS
Development: Centos 7, using 10.3.15-MariaDB-debug
When you have a table that has 9 (or more) virtual columns, with any type (tested VARCHAR and INT) or expression (initially found the bug where JSON_VALID was used, then tested with referring to another column or just a constant expression) and a BEFORE INSERT or BEFORE UPDATE trigger (with any content or where the trigger is empty); then any INSERT or UPDATE will crash the server; even if the trigger is a BEFORE INSERT trigger and an UPDATE is run, or the other way round, or an INSERT is run with the trigger being a BEFORE INSERT trigger, etc.
In the event that the INSERT is done via an INSERT INTO ... SELECT statement, no crash occurs.