diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2020-03-11 14:28:24 +0100 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2020-03-11 14:28:24 +0100 |
| commit | b7362d5fbc37dec340aeacd1fb0967c4226c022a (patch) | |
| tree | a11789da64e27f66ea9bd83e365f3038c58d9cd8 /mysql-test/main/events_restart.result | |
| parent | b8c0e4967098fa40094229775e3560fa9052005e (diff) | |
| parent | 3c9bc0ce19c260401b4dd4c33273487829b29df5 (diff) | |
| download | mariadb-git-b7362d5fbc37dec340aeacd1fb0967c4226c022a.tar.gz | |
Merge branch '10.3' into 10.4
Diffstat (limited to 'mysql-test/main/events_restart.result')
| -rw-r--r-- | mysql-test/main/events_restart.result | 29 |
1 files changed, 29 insertions, 0 deletions
diff --git a/mysql-test/main/events_restart.result b/mysql-test/main/events_restart.result index 68343fcf994..47092beed0e 100644 --- a/mysql-test/main/events_restart.result +++ b/mysql-test/main/events_restart.result @@ -113,3 +113,32 @@ Db Name Definer Time zone Type Execute at Interval value Interval field Starts E test e1 root@localhost SYSTEM RECURRING # 1 SECOND # # DISABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci DROP EVENT e1; # end test for bug#11748899 +# +# Test for MDEV-21758 Events switched randomly to SLAVESIDE_DISABLED +# +create event ev on schedule every 1 minute do set @a= 1; +select name, originator, status from mysql.event; +name originator status +ev 1 ENABLED +# +# Restarting server with server_id=100 +# +# restart: --server-id=100 +select @@global.server_id; +@@global.server_id +100 +select name, originator, status from mysql.event; +name originator status +ev 1 ENABLED +set global server_id= 1; +# +# Restarting server with the original server_id=1 +# +# restart +select @@global.server_id; +@@global.server_id +1 +select name, originator, status from mysql.event; +name originator status +ev 1 ENABLED +drop event ev; |