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

Server should throw warning if event is created and event_scheduler = OFF

    Details

      Description

      The server currently allows events to be created when event_scheduler = OFF without even throwing a warning. Shouldn't a warning be thrown, at least?

      MariaDB [(none)]> SHOW GLOBAL VARIABLES LIKE 'event_scheduler';
      +-----------------+-------+
      | Variable_name   | Value |
      +-----------------+-------+
      | event_scheduler | OFF   |
      +-----------------+-------+
      1 row in set (0.00 sec)
       
      MariaDB [(none)]> CREATE EVENT db1.myevent
          ->     ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR
          ->     DO SELECT NOW();
      Query OK, 0 rows affected (0.00 sec)
       
      MariaDB [(none)]> SHOW WARNINGS;
      Empty set (0.00 sec)
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                wlad Vladislav Vaintroub
                Reporter:
                GeoffMontee Geoff Montee
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: