Details
-
Bug
-
Status: In Review (View Workflow)
-
Critical
-
Resolution: Unresolved
-
13.2
-
None
-
Not for Release Notes
-
Q4/2026 Server Development
Description
Test case 1
1. SELECT of a column named old (fails at CREATE TRIGGER):
CREATE TABLE t (old INT); |
CREATE TABLE t1 (a INT); |
CREATE TRIGGER tr BEFORE INSERT ON t1 FOR EACH ROW SELECT old FROM t INTO @x; |
-- ERROR 1363 (HY000): There is no OLD row in on INSERT trigger |
Test case 2
2. Expression on a column named new (fails when the trigger fires):
CREATE TABLE t (new INT); |
CREATE TABLE t1 (a INT); |
CREATE TRIGGER tr BEFORE INSERT ON t1 FOR EACH ROW UPDATE t SET new = new + 1; |
INSERT INTO t1 VALUES (1); |
-- ERROR 4078 (HY000): Illegal parameter data types row and int for operation '+' |
Attachments
Issue Links
- is caused by
-
MDEV-34723 NEW and OLD in a trigger as row variables
-
- In Testing
-