Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.3.14, 10.3.15, 10.2(EOL), 10.3(EOL), 10.4(EOL)
-
Production: Ubuntu 16.04 LTS
Development: Centos 7, using 10.3.15-MariaDB-debug
Description
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.