mirror of
https://github.com/MariaDB/server.git
synced 2025-02-06 22:02:20 +01:00
279b0db8c6
* removed universal suppression of everything "Event Schedule" everywhere * added suppressions in tests as needed * moved events test to the events suite * renamed -master.opt -> .opt * added standard test header * verified in the test that the error, indeed, was written into the log * removed useless suppressions * removed ER_EVENTS_NO_ACL, replaced with ER_OPTION_PREVENTS_STATEMENT * fixed error message to say exactly what option disabled event scheduler instead of "this or that or that, you figure it out" * also fixed old message for SET event_scheduler= (it was also non-translatable) * changed to use sql_print_error() when an error is not sent to the user * removed duplicate hard-coded error message
26 lines
1 KiB
Text
26 lines
1 KiB
Text
# Can't test with embedded server that doesn't support grants
|
|
-- source include/not_embedded.inc
|
|
call mtr.add_suppression("Event Scheduler will not function when starting with --skip-grant-tables");
|
|
|
|
--echo #
|
|
--echo # MDEV-29827 Misleading error messages about event scheduler when using --skip-grant-tables
|
|
--echo #
|
|
|
|
# Verify that if server is started with
|
|
# --event-scheduler=ON --skip-grant-tables, we get an error
|
|
# with a distinct explanation that the latter disables the former.
|
|
|
|
let SEARCH_FILE=$MYSQLTEST_VARDIR/log/mysqld.1.err;
|
|
let SEARCH_PATTERN=Event Scheduler will not function when starting with --skip-grant-tables;
|
|
source include/search_pattern_in_file.inc;
|
|
|
|
--error ER_OPTION_PREVENTS_STATEMENT
|
|
CREATE EVENT test ON SCHEDULE AT CURRENT_TIMESTAMP DO DO NULL;
|
|
|
|
# Although --event-scheduler=ON was specified (see -master.opt), it should
|
|
# have been changed to 'DISABLED' at startup.
|
|
select (@@global.event_scheduler='DISABLED') as expect_1;
|
|
|
|
# Verify that we cannot (re)enable event scheduler
|
|
--error ER_OPTION_PREVENTS_STATEMENT
|
|
set global event_scheduler=1;
|