1 include/master-slave.inc
3 DROP DATABASE IF EXISTS mysqltest;
4 CREATE DATABASE IF NOT EXISTS mysqltest;
6 CREATE TABLE IF NOT EXISTS t(c1 int);
7 CREATE TABLE IF NOT EXISTS t1 LIKE t;
8 CREATE TABLE IF NOT EXISTS t2 SELECT * FROM t;
9 CREATE EVENT IF NOT EXISTS e
10 ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR
12 DROP DATABASE mysqltest;
13 CREATE DATABASE IF NOT EXISTS mysqltest;
15 CREATE TABLE IF NOT EXISTS t(c1 int);
16 CREATE TABLE IF NOT EXISTS t1 LIKE t;
17 CREATE TABLE IF NOT EXISTS t2 SELECT * FROM t;
18 CREATE EVENT IF NOT EXISTS e
19 ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR
21 SHOW TABLES in mysqltest;
26 SHOW EVENTS in mysqltest;
27 Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation
28 mysqltest e root@localhost SYSTEM ONE TIME # NULL NULL NULL NULL SLAVESIDE_DISABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci
29 DROP DATABASE IF EXISTS mysqltest;
30 -------------BUG#47418-------------
32 DROP TABLE IF EXISTS t3;
33 CREATE TABLE t3(c1 INTEGER);
34 INSERT INTO t3 VALUES(33);
35 CREATE TEMPORARY TABLE t1(c1 INTEGER);
36 CREATE TEMPORARY TABLE t2(c1 INTEGER);
37 INSERT INTO t1 VALUES(1);
38 INSERT INTO t2 VALUES(1);
39 CREATE TABLE IF NOT EXISTS t1(c1 INTEGER) SELECT c1 FROM t3;
40 CREATE TABLE t2(c1 INTEGER) SELECT c1 FROM t3;
53 DROP TEMPORARY TABLE t1;
54 DROP TEMPORARY TABLE t2;
65 # Bug#55616 Killing thread or query during CREATE IF NOT EXISTS makes
66 # slave SQL thread abort
68 CREATE TABLE t1 ( i INT );
69 CREATE TABLE IF NOT EXISTS t1