[MDEV-19265] Server should throw warning if event is created and event_scheduler = OFF Created: 2019-04-16  Updated: 2020-08-25  Resolved: 2019-04-28

Status: Closed
Project: MariaDB Server
Component/s: Events
Affects Version/s: 10.1.38, 10.2.23, 10.3.14
Fix Version/s: 10.2.24, 10.1.39, 10.3.15, 10.4.5

Type: Bug Priority: Major
Reporter: Geoff Montee (Inactive) Assignee: Vladislav Vaintroub
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-19262 Server error message is unclear if ev... Closed

 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)


Generated at Thu Feb 08 08:50:18 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.