Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-41829

Error expected when STARTUP with BEFORE, SHUTDOWN with AFTER in system triggers

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • N/A
    • 13.2
    • Triggers
    • 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

          Activity

            People

              shulga Dmitry Shulga
              alice Alice Sherepa
              Dmitry Shulga Dmitry Shulga
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 8.05d
                  8.05d
                  Remaining:
                  Remaining Estimate - 8.05d
                  8.05d
                  Logged:
                  Time Spent - Not Specified
                  Not Specified

                  Git Integration

                    Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.