mariadb/mysql-test/suite/events/events_skip_grant_tables.result
Sergei Golubchik 279b0db8c6 MDEV-29827 collateral cleanup
* 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
2023-07-02 12:15:11 +02:00

12 lines
690 B
Text

call mtr.add_suppression("Event Scheduler will not function when starting with --skip-grant-tables");
#
# MDEV-29827 Misleading error messages about event scheduler when using --skip-grant-tables
#
FOUND 1 /Event Scheduler will not function when starting with --skip-grant-tables/ in mysqld.1.err
CREATE EVENT test ON SCHEDULE AT CURRENT_TIMESTAMP DO DO NULL;
ERROR HY000: The MariaDB server is running with the --skip-grant-tables option so it cannot execute this statement
select (@@global.event_scheduler='DISABLED') as expect_1;
expect_1
1
set global event_scheduler=1;
ERROR HY000: The MariaDB server is running with the --skip-grant-tables option so it cannot execute this statement