Debian Codegraph @

mysql-test/suite/parts/r/partition_exch_qa_10.result

raw
1 use test;
2 CREATE PROCEDURE test_p1 ()
3 BEGIN
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;
9 END|
10 CALL test_p1;
11 SELECT * FROM t_10;
12 a b
13 2 Two
14 4 Four
15 6 Six
16 8 Eight
17 SELECT * FROM tp WHERE a BETWEEN 0 AND 9;
18 a b
19 1 One
20 3 Three
21 5 Five
22 9 Nine
23 DROP PROCEDURE test_p1;
24 SET @save_autocommit= @@autocommit;
25 SET @@autocommit= OFF;
26 SHOW VARIABLES LIKE '%autocommit%';
27 Variable_name Value
28 autocommit OFF
29 CREATE TRIGGER test_trg_1 BEFORE UPDATE ON tp FOR EACH ROW
30 BEGIN
31 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
32 END|
33 ERROR HY000: Explicit or implicit commit is not allowed in stored function or trigger.
34 CREATE FUNCTION test_f_1() RETURNS int
35 BEGIN
36 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
37 END|
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
44 DO
45 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
46 SELECT * FROM t_10;
47 a b
48 1 One
49 3 Three
50 5 Five
51 9 Nine
52 SELECT * FROM tp WHERE a BETWEEN 0 AND 9;
53 a b
54 2 Two
55 4 Four
56 6 Six
57 8 Eight
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;