1reset master; 2CREATE OR REPLACE DATABASE d1; 3CREATE OR REPLACE DATABASE d1; 4DROP DATABASE d1; 5CREATE DATABASE IF NOT EXISTS d1; 6CREATE DATABASE IF NOT EXISTS d1; 7Warnings: 8Note 1007 Can't create database 'd1'; database exists 9DROP DATABASE IF EXISTS d1; 10DROP DATABASE IF EXISTS d1; 11Warnings: 12Note 1008 Can't drop database 'd1'; database doesn't exist 13"Runnig SHOW BINLOG EVENTS" 14Log_name Pos Event_type Server_id End_log_pos Info 15# # Gtid 1 # GTID #-#-# 16# # Query 1 # CREATE OR REPLACE DATABASE d1 17# # Gtid 1 # GTID #-#-# 18# # Query 1 # CREATE OR REPLACE DATABASE d1 19# # Gtid 1 # GTID #-#-# 20# # Query 1 # DROP DATABASE d1 21# # Gtid 1 # GTID #-#-# 22# # Query 1 # CREATE DATABASE IF NOT EXISTS d1 23# # Gtid 1 # GTID #-#-# 24# # Query 1 # CREATE DATABASE IF NOT EXISTS d1 25# # Gtid 1 # GTID #-#-# 26# # Query 1 # DROP DATABASE IF EXISTS d1 27# # Gtid 1 # GTID #-#-# 28# # Query 1 # DROP DATABASE IF EXISTS d1 29RESET MASTER; 30USE test; 31CREATE OR REPLACE FUNCTION f1() RETURNS INT RETURN 1; 32CREATE OR REPLACE FUNCTION f1() RETURNS INT RETURN 1; 33DROP FUNCTION f1; 34CREATE FUNCTION IF NOT EXISTS f1() RETURNS INT RETURN 1; 35CREATE FUNCTION IF NOT EXISTS f1() RETURNS INT RETURN 1; 36Warnings: 37Note 1304 FUNCTION f1 already exists 38DROP FUNCTION IF EXISTS f1; 39DROP FUNCTION IF EXISTS f1; 40Warnings: 41Note 1305 FUNCTION test.f1 does not exist 42SHOW BINLOG EVENTS; 43Log_name Pos Event_type Server_id End_log_pos Info 44# # Format_desc 1 # VER 45# # Gtid_list 1 # [] 46# # Binlog_checkpoint 1 # master-bin.000001 47# # Gtid 1 # GTID #-#-# 48# # Query 1 # use `test`; CREATE OR REPLACE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int(11) 49RETURN 1 50# # Gtid 1 # GTID #-#-# 51# # Query 1 # use `test`; CREATE OR REPLACE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int(11) 52RETURN 1 53# # Gtid 1 # GTID #-#-# 54# # Query 1 # use `test`; DROP FUNCTION f1 55# # Gtid 1 # GTID #-#-# 56# # Query 1 # use `test`; CREATE DEFINER=`root`@`localhost` FUNCTION IF NOT EXISTS `f1`() RETURNS int(11) 57RETURN 1 58# # Gtid 1 # GTID #-#-# 59# # Query 1 # use `test`; CREATE DEFINER=`root`@`localhost` FUNCTION IF NOT EXISTS `f1`() RETURNS int(11) 60RETURN 1 61# # Gtid 1 # GTID #-#-# 62# # Query 1 # use `test`; DROP FUNCTION IF EXISTS f1 63# # Gtid 1 # GTID #-#-# 64# # Query 1 # use `test`; DROP FUNCTION IF EXISTS f1 65RESET MASTER; 66CREATE TABLE t1 (a DATETIME); 67CREATE OR REPLACE PROCEDURE p1() DELETE FROM t1; 68CREATE OR REPLACE PROCEDURE p1() DELETE FROM t1; 69DROP PROCEDURE p1; 70CREATE PROCEDURE IF NOT EXISTS p1() DELETE FROM t1; 71CREATE PROCEDURE IF NOT EXISTS p1() DELETE FROM t1; 72Warnings: 73Note 1304 PROCEDURE p1 already exists 74DROP PROCEDURE IF EXISTS p1; 75DROP PROCEDURE IF EXISTS p1; 76Warnings: 77Note 1305 PROCEDURE test.p1 does not exist 78SHOW BINLOG EVENTS; 79Log_name Pos Event_type Server_id End_log_pos Info 80# # Format_desc 1 # VER 81# # Gtid_list 1 # [] 82# # Binlog_checkpoint 1 # master-bin.000001 83# # Gtid 1 # GTID #-#-# 84# # Query 1 # use `test`; CREATE TABLE t1 (a DATETIME) 85# # Gtid 1 # GTID #-#-# 86# # Query 1 # use `test`; CREATE OR REPLACE DEFINER=`root`@`localhost` PROCEDURE `p1`() 87DELETE FROM t1 88# # Gtid 1 # GTID #-#-# 89# # Query 1 # use `test`; CREATE OR REPLACE DEFINER=`root`@`localhost` PROCEDURE `p1`() 90DELETE FROM t1 91# # Gtid 1 # GTID #-#-# 92# # Query 1 # use `test`; DROP PROCEDURE p1 93# # Gtid 1 # GTID #-#-# 94# # Query 1 # use `test`; CREATE DEFINER=`root`@`localhost` PROCEDURE IF NOT EXISTS `p1`() 95DELETE FROM t1 96# # Gtid 1 # GTID #-#-# 97# # Query 1 # use `test`; CREATE DEFINER=`root`@`localhost` PROCEDURE IF NOT EXISTS `p1`() 98DELETE FROM t1 99# # Gtid 1 # GTID #-#-# 100# # Query 1 # use `test`; DROP PROCEDURE IF EXISTS p1 101# # Gtid 1 # GTID #-#-# 102# # Query 1 # use `test`; DROP PROCEDURE IF EXISTS p1 103DROP TABLE t1; 104RESET MASTER; 105CREATE OR REPLACE FUNCTION metaphon RETURNS STRING SONAME 'UDF_EXAMPLE_LIB'; 106CREATE OR REPLACE FUNCTION metaphon RETURNS STRING SONAME 'UDF_EXAMPLE_LIB'; 107DROP FUNCTION metaphon; 108CREATE FUNCTION IF NOT EXISTS metaphon RETURNS STRING SONAME 'UDF_EXAMPLE_LIB'; 109CREATE FUNCTION IF NOT EXISTS metaphon RETURNS STRING SONAME 'UDF_EXAMPLE_LIB'; 110Warnings: 111Note 1125 Function 'metaphon' already exists 112DROP FUNCTION IF EXISTS metaphon; 113DROP FUNCTION IF EXISTS metaphon; 114Warnings: 115Note 1305 FUNCTION test.metaphon does not exist 116SHOW BINLOG EVENTS; 117Log_name Pos Event_type Server_id End_log_pos Info 118# # Format_desc 1 # VER 119# # Gtid_list 1 # [] 120# # Binlog_checkpoint 1 # master-bin.000001 121# # Gtid 1 # GTID #-#-# 122# # Query 1 # use `test`; CREATE OR REPLACE FUNCTION metaphon RETURNS STRING SONAME 'UDM_EXAMPLE_LIB' 123# # Gtid 1 # GTID #-#-# 124# # Query 1 # use `test`; CREATE OR REPLACE FUNCTION metaphon RETURNS STRING SONAME 'UDM_EXAMPLE_LIB' 125# # Gtid 1 # GTID #-#-# 126# # Query 1 # use `test`; DROP FUNCTION metaphon 127# # Gtid 1 # GTID #-#-# 128# # Query 1 # use `test`; CREATE FUNCTION IF NOT EXISTS metaphon RETURNS STRING SONAME 'UDM_EXAMPLE_LIB' 129# # Gtid 1 # GTID #-#-# 130# # Query 1 # use `test`; CREATE FUNCTION IF NOT EXISTS metaphon RETURNS STRING SONAME 'UDM_EXAMPLE_LIB' 131# # Gtid 1 # GTID #-#-# 132# # Query 1 # use `test`; DROP FUNCTION IF EXISTS metaphon 133# # Gtid 1 # GTID #-#-# 134# # Query 1 # use `test`; DROP FUNCTION IF EXISTS metaphon 135RESET MASTER; 136# 137# CREATE SERVER is not logged 138# 139CREATE OR REPLACE SERVER s1 FOREIGN DATA WRAPPER mysql OPTIONS (USER 'root', HOST 'localhost', DATABASE 'test'); 140CREATE OR REPLACE SERVER s1 FOREIGN DATA WRAPPER mysql OPTIONS (USER 'root', HOST 'localhost', DATABASE 'test'); 141DROP SERVER s1; 142CREATE SERVER IF NOT EXISTS s1 FOREIGN DATA WRAPPER mysql OPTIONS (USER 'root', HOST 'localhost', DATABASE 'test'); 143CREATE SERVER IF NOT EXISTS s1 FOREIGN DATA WRAPPER mysql OPTIONS (USER 'root', HOST 'localhost', DATABASE 'test'); 144Warnings: 145Note 1476 The foreign server, s1, you are trying to create already exists 146DROP SERVER IF EXISTS s1; 147DROP SERVER IF EXISTS s1; 148SHOW BINLOG EVENTS; 149Log_name Pos Event_type Server_id End_log_pos Info 150# # Format_desc 1 # VER 151# # Gtid_list 1 # [] 152# # Binlog_checkpoint 1 # master-bin.000001 153RESET MASTER; 154CREATE OR REPLACE VIEW v1 AS SELECT 1; 155CREATE OR REPLACE VIEW v1 AS SELECT 1; 156DROP VIEW v1; 157CREATE VIEW IF NOT EXISTS v1 AS SELECT 1; 158CREATE VIEW IF NOT EXISTS v1 AS SELECT 1; 159Warnings: 160Note 1050 Table 'v1' already exists 161DROP VIEW IF EXISTS v1; 162DROP VIEW IF EXISTS v1; 163Warnings: 164Note 4092 Unknown VIEW: 'test.v1' 165SHOW BINLOG EVENTS; 166Log_name Pos Event_type Server_id End_log_pos Info 167# # Format_desc 1 # VER 168# # Gtid_list 1 # [] 169# # Binlog_checkpoint 1 # master-bin.000001 170# # Gtid 1 # GTID #-#-# 171# # Query 1 # use `test`; CREATE OR REPLACE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS SELECT 1 172# # Gtid 1 # GTID #-#-# 173# # Query 1 # use `test`; CREATE OR REPLACE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS SELECT 1 174# # Gtid 1 # GTID #-#-# 175# # Query 1 # use `test`; DROP VIEW v1 176# # Gtid 1 # GTID #-#-# 177# # Query 1 # use `test`; CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW IF NOT EXISTS `v1` AS SELECT 1 178# # Gtid 1 # GTID #-#-# 179# # Query 1 # use `test`; CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW IF NOT EXISTS `v1` AS SELECT 1 180# # Gtid 1 # GTID #-#-# 181# # Query 1 # use `test`; DROP VIEW IF EXISTS v1 182# # Gtid 1 # GTID #-#-# 183# # Query 1 # use `test`; DROP VIEW IF EXISTS v1 184RESET MASTER; 185CREATE OR REPLACE ROLE r1; 186CREATE OR REPLACE ROLE r1; 187DROP ROLE r1; 188CREATE ROLE IF NOT EXISTS r1; 189CREATE ROLE IF NOT EXISTS r1; 190Warnings: 191Note 1975 Can't create role 'r1'; it already exists 192DROP ROLE IF EXISTS r1; 193DROP ROLE IF EXISTS r1; 194Warnings: 195Note 1976 Can't drop role 'r1'; it doesn't exist 196SHOW BINLOG EVENTS; 197Log_name Pos Event_type Server_id End_log_pos Info 198# # Format_desc 1 # VER 199# # Gtid_list 1 # [] 200# # Binlog_checkpoint 1 # master-bin.000001 201# # Gtid 1 # GTID #-#-# 202# # Query 1 # use `test`; CREATE OR REPLACE ROLE r1 203# # Gtid 1 # GTID #-#-# 204# # Query 1 # use `test`; CREATE OR REPLACE ROLE r1 205# # Gtid 1 # GTID #-#-# 206# # Query 1 # use `test`; DROP ROLE r1 207# # Gtid 1 # GTID #-#-# 208# # Query 1 # use `test`; CREATE ROLE IF NOT EXISTS r1 209# # Gtid 1 # GTID #-#-# 210# # Query 1 # use `test`; CREATE ROLE IF NOT EXISTS r1 211# # Gtid 1 # GTID #-#-# 212# # Query 1 # use `test`; DROP ROLE IF EXISTS r1 213# # Gtid 1 # GTID #-#-# 214# # Query 1 # use `test`; DROP ROLE IF EXISTS r1 215RESET MASTER; 216CREATE OR REPLACE USER u1@localhost; 217CREATE OR REPLACE USER u1@localhost; 218DROP USER u1@localhost; 219CREATE USER IF NOT EXISTS u1@localhost; 220CREATE USER IF NOT EXISTS u1@localhost; 221Warnings: 222Note 1973 Can't create user 'u1'@'localhost'; it already exists 223DROP USER IF EXISTS u1@localhost; 224DROP USER IF EXISTS u1@localhost; 225Warnings: 226Note 1974 Can't drop user 'u1'@'localhost'; it doesn't exist 227SHOW BINLOG EVENTS; 228Log_name Pos Event_type Server_id End_log_pos Info 229# # Format_desc 1 # VER 230# # Gtid_list 1 # [] 231# # Binlog_checkpoint 1 # master-bin.000001 232# # Gtid 1 # GTID #-#-# 233# # Query 1 # use `test`; CREATE OR REPLACE USER u1@localhost 234# # Gtid 1 # GTID #-#-# 235# # Query 1 # use `test`; CREATE OR REPLACE USER u1@localhost 236# # Gtid 1 # GTID #-#-# 237# # Query 1 # use `test`; DROP USER u1@localhost 238# # Gtid 1 # GTID #-#-# 239# # Query 1 # use `test`; CREATE USER IF NOT EXISTS u1@localhost 240# # Gtid 1 # GTID #-#-# 241# # Query 1 # use `test`; CREATE USER IF NOT EXISTS u1@localhost 242# # Gtid 1 # GTID #-#-# 243# # Query 1 # use `test`; DROP USER IF EXISTS u1@localhost 244# # Gtid 1 # GTID #-#-# 245# # Query 1 # use `test`; DROP USER IF EXISTS u1@localhost 246RESET MASTER; 247SET timestamp=UNIX_TIMESTAMP('2014-11-01 10:20:30'); 248CREATE OR REPLACE EVENT ev1 ON SCHEDULE EVERY 1 SECOND DO DROP TABLE IF EXISTS t1; 249Warnings: 250Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it. 251CREATE OR REPLACE EVENT ev1 ON SCHEDULE EVERY 1 SECOND DO DROP TABLE IF EXISTS t2; 252Warnings: 253Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it. 254SELECT EVENT_NAME, EVENT_DEFINITION FROM INFORMATION_SCHEMA.EVENTS; 255EVENT_NAME EVENT_DEFINITION 256ev1 DROP TABLE IF EXISTS t2 257DROP EVENT ev1; 258DROP EVENT IF EXISTS ev1; 259Warnings: 260Note 1305 Event ev1 does not exist 261SHOW BINLOG EVENTS; 262Log_name Pos Event_type Server_id End_log_pos Info 263# # Format_desc 1 # VER 264# # Gtid_list 1 # [] 265# # Binlog_checkpoint 1 # master-bin.000001 266# # Gtid 1 # GTID #-#-# 267# # Query 1 # use `test`; CREATE OR REPLACE DEFINER=`root`@`localhost` EVENT ev1 ON SCHEDULE EVERY 1 SECOND DO DROP TABLE IF EXISTS t1 268# # Gtid 1 # GTID #-#-# 269# # Query 1 # use `test`; CREATE OR REPLACE DEFINER=`root`@`localhost` EVENT ev1 ON SCHEDULE EVERY 1 SECOND DO DROP TABLE IF EXISTS t2 270# # Gtid 1 # GTID #-#-# 271# # Query 1 # use `test`; DROP EVENT ev1 272# # Gtid 1 # GTID #-#-# 273# # Query 1 # use `test`; DROP EVENT IF EXISTS ev1 274RESET MASTER; 275CREATE TABLE t1 (a INT); 276CREATE OR REPLACE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW SET NEW.a=10; 277CREATE OR REPLACE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW SET NEW.a=11; 278DROP TRIGGER tr1; 279CREATE TRIGGER IF NOT EXISTS tr1 BEFORE INSERT ON t1 FOR EACH ROW SET NEW.a=20; 280CREATE TRIGGER IF NOT EXISTS tr1 BEFORE INSERT ON t1 FOR EACH ROW SET NEW.a=21; 281Warnings: 282Note 1359 Trigger 'test.tr1' already exists 283DROP TRIGGER IF EXISTS tr1; 284DROP TRIGGER IF EXISTS tr1; 285Warnings: 286Note 1360 Trigger does not exist 287DROP TABLE t1; 288SHOW BINLOG EVENTS; 289Log_name Pos Event_type Server_id End_log_pos Info 290# # Format_desc 1 # VER 291# # Gtid_list 1 # [] 292# # Binlog_checkpoint 1 # master-bin.000001 293# # Gtid 1 # GTID #-#-# 294# # Query 1 # use `test`; CREATE TABLE t1 (a INT) 295# # Gtid 1 # GTID #-#-# 296# # Query 1 # use `test`; CREATE OR REPLACE DEFINER=`root`@`localhost` TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW SET NEW.a=10 297# # Gtid 1 # GTID #-#-# 298# # Query 1 # use `test`; CREATE OR REPLACE DEFINER=`root`@`localhost` TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW SET NEW.a=11 299# # Gtid 1 # GTID #-#-# 300# # Query 1 # use `test`; DROP TRIGGER tr1 301# # Gtid 1 # GTID #-#-# 302# # Query 1 # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER IF NOT EXISTS tr1 BEFORE INSERT ON t1 FOR EACH ROW SET NEW.a=20 303# # Gtid 1 # GTID #-#-# 304# # Query 1 # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER IF NOT EXISTS tr1 BEFORE INSERT ON t1 FOR EACH ROW SET NEW.a=21 305# # Gtid 1 # GTID #-#-# 306# # Query 1 # use `test`; DROP TRIGGER IF EXISTS tr1 307# # Gtid 1 # GTID #-#-# 308# # Query 1 # use `test`; DROP TRIGGER IF EXISTS tr1 309# # Gtid 1 # GTID #-#-# 310# # Query 1 # use `test`; DROP TABLE `t1` /* generated by server */ 311RESET MASTER; 312CREATE TABLE t1(a INT, b INT); 313CREATE TABLE IF NOT EXISTS t1(a INT, b INT); 314Warnings: 315Note 1050 Table 't1' already exists 316CREATE OR REPLACE INDEX i1 ON t1(a); 317CREATE OR REPLACE INDEX i1 ON t1(a); 318CREATE OR REPLACE INDEX i1 ON t1(a,b); 319CREATE OR REPLACE INDEX i1 ON t1(a,b); 320DROP TABLE t1; 321SHOW BINLOG EVENTS; 322Log_name Pos Event_type Server_id End_log_pos Info 323# # Format_desc 1 # VER 324# # Gtid_list 1 # [] 325# # Binlog_checkpoint 1 # master-bin.000001 326# # Gtid 1 # GTID #-#-# 327# # Query 1 # use `test`; CREATE TABLE t1(a INT, b INT) 328# # Gtid 1 # GTID #-#-# 329# # Query 1 # use `test`; CREATE OR REPLACE INDEX i1 ON t1(a) 330# # Gtid 1 # GTID #-#-# 331# # Query 1 # use `test`; CREATE OR REPLACE INDEX i1 ON t1(a) 332# # Gtid 1 # GTID #-#-# 333# # Query 1 # use `test`; CREATE OR REPLACE INDEX i1 ON t1(a,b) 334# # Gtid 1 # GTID #-#-# 335# # Query 1 # use `test`; CREATE OR REPLACE INDEX i1 ON t1(a,b) 336# # Gtid 1 # GTID #-#-# 337# # Query 1 # use `test`; DROP TABLE `t1` /* generated by server */ 338RESET MASTER; 339RESET MASTER; 340SHOW MASTER STATUS; 341File Position Binlog_Do_DB Binlog_Ignore_DB 342master-bin.000001 <pos> 343RESET MASTER TO 100; 344SHOW MASTER STATUS; 345File Position Binlog_Do_DB Binlog_Ignore_DB 346master-bin.000100 <pos> 347RESET MASTER; 348SHOW MASTER STATUS; 349File Position Binlog_Do_DB Binlog_Ignore_DB 350master-bin.000001 <pos> 351CREATE TABLE t1(a INT, b INT); 352CREATE TABLE IF NOT EXISTS t1(a INT, b INT); 353Warnings: 354Note 1050 Table 't1' already exists 355CREATE INDEX IF NOT EXISTS i1 ON t1(a); 356CREATE INDEX IF NOT EXISTS i1 ON t1(a); 357Warnings: 358Note 1061 Duplicate key name 'i1' 359SHOW CREATE TABLE t1; 360Table Create Table 361t1 CREATE TABLE `t1` ( 362 `a` int(11) DEFAULT NULL, 363 `b` int(11) DEFAULT NULL, 364 KEY `i1` (`a`) 365) ENGINE=MyISAM DEFAULT CHARSET=latin1 366DROP INDEX IF EXISTS i1 ON t1; 367DROP INDEX IF EXISTS i1 ON t1; 368Warnings: 369Note 1091 Can't DROP INDEX `i1`; check that it exists 370DROP TABLE t1; 371DROP TABLE IF EXISTS t1; 372Warnings: 373Note 1051 Unknown table 'test.t1' 374SHOW BINLOG EVENTS; 375Log_name Pos Event_type Server_id End_log_pos Info 376# # Format_desc 1 # VER 377# # Gtid_list 1 # [] 378# # Binlog_checkpoint 1 # master-bin.000001 379# # Gtid 1 # GTID #-#-# 380# # Query 1 # use `test`; CREATE TABLE t1(a INT, b INT) 381# # Gtid 1 # GTID #-#-# 382# # Query 1 # use `test`; CREATE INDEX IF NOT EXISTS i1 ON t1(a) 383# # Gtid 1 # GTID #-#-# 384# # Query 1 # use `test`; CREATE INDEX IF NOT EXISTS i1 ON t1(a) 385# # Gtid 1 # GTID #-#-# 386# # Query 1 # use `test`; DROP INDEX IF EXISTS i1 ON t1 387# # Gtid 1 # GTID #-#-# 388# # Query 1 # use `test`; DROP INDEX IF EXISTS i1 ON t1 389# # Gtid 1 # GTID #-#-# 390# # Query 1 # use `test`; DROP TABLE `t1` /* generated by server */ 391# # Gtid 1 # GTID #-#-# 392# # Query 1 # use `test`; DROP TABLE IF EXISTS `t1` /* generated by server */ 393RESET MASTER; 394