mysql-test/suite/galera/t/MDEV-30612.test
raw| 1 | # |
| 2 | # MDEV-30612: Executing CREATE TRIGGER prepared statement twice led to a crash. |
| 3 | # |
| 4 | |
| 5 | --source include/galera_cluster.inc |
| 6 | --source include/have_innodb.inc |
| 7 | |
| 8 | CREATE TABLE t(a INT) ENGINE=INNODB; |
| 9 | PREPARE s FROM 'CREATE TRIGGER tr AFTER DELETE ON t FOR EACH ROW SET @a=1'; |
| 10 | EXECUTE s; |
| 11 | --error ER_TRG_ALREADY_EXISTS |
| 12 | EXECUTE s; |
| 13 | |
| 14 | DROP TRIGGER tr; |
| 15 | DROP TABLE t; |
| 16 | |
| 17 | --source include/galera_end.inc |