diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2020-03-11 14:05:41 +0100 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2020-03-11 14:05:41 +0100 |
| commit | 3c9bc0ce19c260401b4dd4c33273487829b29df5 (patch) | |
| tree | c0ac64399b70d571ec2e41d4dde2d38e6ebb1322 /mysql-test/main/events_restart.result | |
| parent | 8fa1b6bb88be39001b98bab071b957da3c271a17 (diff) | |
| parent | 02343c4a54b055ea3483075219bb3ce010c33671 (diff) | |
| download | mariadb-git-3c9bc0ce19c260401b4dd4c33273487829b29df5.tar.gz | |
Merge branch '10.2' into 10.3
Diffstat (limited to 'mysql-test/main/events_restart.result')
| -rw-r--r-- | mysql-test/main/events_restart.result | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/mysql-test/main/events_restart.result b/mysql-test/main/events_restart.result index e22cfa011f2..ab90f7ff2f7 100644 --- a/mysql-test/main/events_restart.result +++ b/mysql-test/main/events_restart.result @@ -110,3 +110,30 @@ 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 +# +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 +# +select @@global.server_id; +@@global.server_id +1 +select name, originator, status from mysql.event; +name originator status +ev 1 ENABLED +drop event ev; |