Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
N/A
-
None
-
Can result in hang or crash
-
Q3/2026 Server Development, Q4/2026 Server Maintenance, Q1/2027 Server Development
Description
CREATE TABLE t (a INT) ENGINE=MyISAM; |
CREATE TRIGGER mk AFTER STARTUP INSERT INTO test.t VALUES (1); |
UPDATE mysql.event SET kind='STARTUP,SHUTDOWN' WHERE name='mk'; |
|
|
SHOW CREATE TRIGGER mk; |
|
|
--source include/restart_mysqld.inc
|
|
|
SELECT a FROM t; |
SELECT name, kind, status FROM mysql.event WHERE name='mk'; |
|
|
DROP TRIGGER mk; |
DROP TABLE t; |
|
SHOW CREATE TRIGGER prints TRIGGER mk AFTER STARTUP,SHUTDOWN INSERT - which is invalid syntax. The trigger fires only at startup. Expected ER_SYSTEM_TRG_INVALID_METADATA as with kind=0
bb-13.2-MDEV-30645 0c40227d1ae9f7fa6c62d
|
|
|
CREATE TABLE t (a INT) ENGINE=MyISAM;
|
CREATE TRIGGER mk AFTER STARTUP INSERT INTO test.t VALUES (1);
|
UPDATE mysql.event SET kind='STARTUP,SHUTDOWN' WHERE name='mk';
|
|
|
SHOW CREATE TRIGGER mk;
|
Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
|
mk STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` TRIGGER `mk` AFTER STARTUP,SHUTDOWN INSERT INTO test.t VALUES (1) latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci 2026-10-27 12:23:57.00
|
|
|
|
|
SELECT a FROM t;
|
a
|
1
|
SELECT name, kind, status FROM mysql.event WHERE name='mk';
|
name kind status
|
mk STARTUP,SHUTDOWN ENABLED
|
DROP TRIGGER mk;
|
DROP TABLE t;
|
Attachments
Issue Links
- is caused by
-
MDEV-30645 CREATE TRIGGER FOR { STARTUP | SHUTDOWN }
-
- Stalled
-