2
CREATE PROCEDURE test_p1 ()
4
ALTER TABLE t_10 ADD UNIQUE INDEX USING BTREE (a);
5
ALTER TABLE tp ADD UNIQUE INDEX USING BTREE (a);
6
ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
7
ALTER TABLE tp DROP INDEX a;
8
ALTER TABLE t_10 DROP INDEX a;
17
SELECT * FROM tp WHERE a BETWEEN 0 AND 9;
23
DROP PROCEDURE test_p1;
24
SET @save_autocommit= @@autocommit;
25
SET @@autocommit= OFF;
26
SHOW VARIABLES LIKE '%autocommit%';
29
CREATE TRIGGER test_trg_1 BEFORE UPDATE ON tp FOR EACH ROW
31
ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
33
ERROR HY000: Explicit or implicit commit is not allowed in stored function or trigger.
34
CREATE FUNCTION test_f_1() RETURNS int
36
ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
38
ERROR HY000: Explicit or implicit commit is not allowed in stored function or trigger.
39
SET @@autocommit= @save_autocommit;
40
SET @save_event_scheduler= @@global.event_scheduler;
41
SET @@global.event_scheduler= ON;
42
CREATE EVENT test_ev_1
43
ON SCHEDULE AT CURRENT_TIMESTAMP
45
ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
52
SELECT * FROM tp WHERE a BETWEEN 0 AND 9;
58
SET @@global.event_scheduler= @save_event_scheduler;
59
DROP TABLE IF EXISTS t_10;
60
DROP TABLE IF EXISTS t_100;
61
DROP TABLE IF EXISTS t_1000;
62
DROP TABLE IF EXISTS tp;
63
DROP TABLE IF EXISTS tsp;
64
DROP TABLE IF EXISTS tsp_00;
65
DROP TABLE IF EXISTS tsp_01;
66
DROP TABLE IF EXISTS tsp_02;
67
DROP TABLE IF EXISTS tsp_03;
68
DROP TABLE IF EXISTS tsp_04;
69
DROP TABLE IF EXISTS t_empty;
70
DROP TABLE IF EXISTS t_null;