4227
4226
# -- End of test case for Bug#32538.
4229
4228
SET @@GLOBAL.CONCURRENT_INSERT = @OLD_CONCURRENT_INSERT;
4230
Bug #34861 - mysqldump with --tab gives weird output for triggers.
4232
CREATE TABLE t1 (f1 INT);
4233
CREATE TRIGGER tr1 BEFORE UPDATE ON t1 FOR EACH ROW SET @f1 = 1;
4234
CREATE PROCEDURE pr1 () SELECT "Meow";
4235
CREATE EVENT ev1 ON SCHEDULE AT '2030-01-01 00:00:00' DO SELECT "Meow";
4238
Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation
4239
tr1 UPDATE t1 SET @f1 = 1 BEFORE NULL root@localhost latin1 latin1_swedish_ci latin1_swedish_ci
4241
Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation
4242
test ev1 root@localhost SYSTEM ONE TIME 2030-01-01 00:00:00 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci
4243
SELECT name,body FROM mysql.proc WHERE NAME = 'pr1';
4247
dump table; if anything goes to stdout, it ends up here: ---------------
4255
reload table; this should restore table and trigger
4257
Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation
4258
tr1 UPDATE t1 SET @f1 = 1 BEFORE NULL root@localhost latin1 latin1_swedish_ci latin1_swedish_ci
4260
Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation
4261
SELECT name,body FROM mysql.proc WHERE NAME = 'pr1';
4264
reload db; this should restore routines and events
4266
Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation
4267
tr1 UPDATE t1 SET @f1 = 1 BEFORE NULL root@localhost latin1 latin1_swedish_ci latin1_swedish_ci
4269
Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation
4270
test ev1 root@localhost SYSTEM ONE TIME 2030-01-01 00:00:00 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci
4271
SELECT name,body FROM mysql.proc WHERE NAME = 'pr1';
4276
DROP EVENT IF EXISTS ev1;
4277
DROP PROCEDURE IF EXISTS pr1;
4278
DROP TRIGGER IF EXISTS tr1;
4279
DROP TABLE IF EXISTS t1;
4231
4281
# End of 5.1 tests