Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
N/A
-
None
-
Q4/2026 Server Maintenance, Q1/2027 Server Development
Description
CREATE TABLE t (a int); |
|
|
CREATE TRIGGER k1 AFTER STARTUP INSERT INTO test.t VALUES (1); |
CREATE TRIGGER k2 BEFORE SHUTDOWN INSERT INTO test.t VALUES (2); |
UPDATE mysql.event SET `when`='BEFORE' WHERE name='k1'; |
UPDATE mysql.event SET `when`='AFTER' WHERE name='k2'; |
|
|
SHOW CREATE TRIGGER k1; |
SHOW CREATE TRIGGER k2; |
|
|
DROP TRIGGER k1,k2; |
DROP TABLE t; |
Server version: 13.2.0-MariaDB-asan-debug-log source revision: d0127c512ccf492c4f25176
|
SHOW CREATE TRIGGER k1;
|
Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
|
k1 STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` TRIGGER `k1` BEFORE STARTUP INSERT INTO test.t VALUES (1) latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci 2026-10-27 18:15:51.00
|
SHOW CREATE TRIGGER k2;
|
Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
|
k2 STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` TRIGGER `k2` AFTER SHUTDOWN INSERT INTO test.t VALUES (2) latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci 2026-10-27 18:15:51.00
|
CREATE TRIGGER d1 AFTER STARTUP SET @x=1; |
UPDATE mysql.event SET kind='DDL' WHERE name='d1'; |
SHOW CREATE TRIGGER d1; |
DROP TRIGGER d1; |
Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
|
d1 STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` TRIGGER `d1` AFTER DDL SET @x=1 latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci 2026-10-27 18:29:49.00
|
Attachments
Issue Links
- is caused by
-
MDEV-30645 CREATE TRIGGER FOR { STARTUP | SHUTDOWN }
-
- Stalled
-