Bug #121423 BEFORE INSERT trigger causes ER_BAD_NULL_ERROR on NOT NULL generated column

• Submitted: 2 Oct 10:58
• Reporter: Laurynas Biveinis (OCA)
• Status: Open
• Category: MySQL Server: DML
• Severity: S2 (Serious)
• Version: 8.4.11, 9.7.2, 26.10.0-er
• OS: Any
• CPU Architecture: Any

[2 Oct 10:58] Laurynas Biveinis

Description:
CREATE TABLE t (a INT, g INT AS (a + 1) STORED NOT NULL);

# Works
INSERT INTO t (a) VALUES (1);
TRUNCATE TABLE t;

CREATE TRIGGER t_before BEFORE INSERT ON t FOR EACH ROW SET @x = 1;

# Fails
INSERT INTO t (a) VALUES (1);

mysqltest: At line 10: Query 'INSERT INTO t (a) VALUES (1)' failed.
ERROR 1048 (23000): Column 'g' cannot be null

See also bug 121393

How to repeat:
See above