[MariaDB discuss] Re: Running events on same time

16 Aug 2023

      Hi!

On Wed, Aug 16, 2023 at 2:50 PM Michael Widenius
<michael.widenius@gmail.com> wrote:
...
Hi!
Hi!
On Tue, Aug 15, 2023 at 11:24 PM kpesio--- via discuss
<discuss@lists.mariadb.org> wrote:
...
Hi. Could someone confirm in some way about running multiple events at same time.
Confirmed.
Here is a test case that proves this:

drop table if exists t1;
drop event ev1;
drop event ev2;
SET GLOBAL event_scheduler=ON;
set @n=now();
select @n, addtime(@n,1);
CREATE TABLE t1 (a INT);
CREATE EVENT ev1 ON SCHEDULE AT ADDTIME(@n,2) DO INSERT INTO t1 VALUES
(10+sleep(10));
show warnings;
CREATE EVENT ev2 ON SCHEDULE AT ADDTIME(@n,3) DO INSERT INTO t1 VALUES (13);
select sleep(12);
select * from t1;

The last select returns rows 10 & 13

Regards,
Monty