DELIMITER ||
CREATE EVENT querytimeout ON SCHEDULE EVERY 20 SECOND DO BEGIN
SET @id:='';
SET @id:=(SELECT id FROM INFORMATION_SCHEMA.PROCESSLIST WHERE ID<>CONNECTION_ID() AND STATE<>'killed' AND TIME>$QUERYTIMEOUT ORDER BY TIME DESC LIMIT 1);
IF @id > 1 THEN KILL QUERY @id; END IF;
END ||
DELIMITER ;
DROP DATABASE transforms;CREATE DATABASE transforms;DROP DATABASE test;CREATE DATABASE test;USE test;
DROP DATABASE test;CREATE DATABASE test;USE test;
INSERT INTO t1 VALUES(0xCFFB);
insert INTO t1(a,b)values(0,0);
CREATE TEMPORARY TABLE t1(a INT);
SET GLOBAL EVENT_SCHEDULER=on;
SELECT hex(a),STRCMP(a,0),STRCMP(a,'a ') FROM t1;
handler t1 open;
BINLOG ' SOgWTg8BAAAAbgAAAHIAAAAAAAQANS42LjMtbTUtZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAABI6BZOEzgNAAgAEgAEBAQEEgAAVgAEGggAAAAICAgCAAAAAAVAYI8=';
select name as'',type as'',isnuable as'',columnk as'',column_default as'',extra as''from information_schema.columns;
insert INTO t1 values(0,repeat('',0));
