From a175314c3e5827eb193872241446f2f8f5c9d33c Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 20:07:14 +0200 Subject: Adding upstream version 1:10.5.12. Signed-off-by: Daniel Baumann --- mysql-test/suite/innodb/t/trigger_error.test | 31 ++++++++++++++++++++++++++++ 1 file changed, 31 insertions(+) create mode 100644 mysql-test/suite/innodb/t/trigger_error.test (limited to 'mysql-test/suite/innodb/t/trigger_error.test') diff --git a/mysql-test/suite/innodb/t/trigger_error.test b/mysql-test/suite/innodb/t/trigger_error.test new file mode 100644 index 00000000..0334f2b3 --- /dev/null +++ b/mysql-test/suite/innodb/t/trigger_error.test @@ -0,0 +1,31 @@ +--source include/have_innodb.inc + +CREATE TABLE t1 (i INT) ENGINE=InnoDB; +CREATE TABLE t2 (i INT) ENGINE=InnoDB; + +CREATE OR REPLACE TRIGGER tr1 + AFTER UPDATE ON t2 + FOR EACH ROW + INSERT INTO tlog (i) VALUES (1); + +INSERT IGNORE INTO t2 VALUES (1); + +CREATE TRIGGER IF NOT EXISTS tr2 + BEFORE INSERT ON t2 + FOR EACH ROW + INSERT INTO tlog (i) VALUES (2); + +START TRANSACTION; +INSERT INTO t1 VALUES (1); +--error ER_NO_SUCH_TABLE +UPDATE t2 SET i = 3; +INSERT INTO t1 VALUES (2); +--error ER_NO_SUCH_TABLE +INSERT INTO t2 VALUES (4); +UPDATE t1 SET i = 4 LIMIT 1; +COMMIT; + +SELECT * FROM t1; +SELECT * FROM t2; + +DROP TABLE t1,t2; -- cgit v1.2.3