Debian Codegraph @

mysql-test/suite/compat/oracle/r/events.result

raw
1 set sql_mode='ORACLE';
2 #
3 # MDEV-16891 EVENTs created with SQL_MODE=ORACLE fail to execute
4 #
5 SET GLOBAL event_scheduler=off;
6 SET sql_mode='ORACLE';
7 CREATE TABLE t1 (a TIMESTAMP);
8 CREATE EVENT e1
9 ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 MICROSECOND
10 DO INSERT INTO t1 VALUES(NOW());
11 Warnings:
12 Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it.
13 SET GLOBAL event_scheduler=on;
14 SELECT COUNT(*) FROM t1;
15 COUNT(*)
16 1
17 DROP TABLE t1;
18 SET GLOBAL event_scheduler=off;
19 #
20 # MDEV-28588 SIGSEGV in __memmove_avx_unaligned_erms, strmake_root
21 #
22 CREATE EVENT ev ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR DO BEGIN END;
23 Warnings:
24 Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it.
25 SELECT EVENT_DEFINITION FROM INFORMATION_SCHEMA.EVENTS WHERE EVENT_SCHEMA='test' AND EVENT_NAME='ev';
26 EVENT_DEFINITION BEGIN END
27 DROP EVENT ev;