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

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

    XMLWordPrintable

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

              wlad Vladislav Vaintroub
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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