Debian Codegraph @

mysql-test/suite/parts/t/partition_exch_qa_10.test

raw
1 # Author: Horst Hunger
2 # Created: 2010-07-13
3
4 --source include/not_embedded.inc
5 --source include/have_partition.inc
6 --source include/have_innodb.inc
7
8 let $engine_table= InnoDB;
9 let $engine_part= InnoDB;
10 let $engine_subpart= InnoDB;
11
12 use test;
13
14 --disable_result_log
15 --disable_query_log
16 --source suite/parts/inc/part_exch_tabs.inc
17 --enable_result_log
18 --enable_query_log
19
20 # 17) Exchanges in Procedure, triggers and events.
21 DELIMITER |;
22 CREATE PROCEDURE test_p1 ()
23 BEGIN
24 ALTER TABLE t_10 ADD UNIQUE INDEX USING BTREE (a);
25 ALTER TABLE tp ADD UNIQUE INDEX USING BTREE (a);
26 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
27 ALTER TABLE tp DROP INDEX a;
28 ALTER TABLE t_10 DROP INDEX a;
29 END|
30 DELIMITER ;|
31 CALL test_p1;
32 --sorted_result
33 SELECT * FROM t_10;
34 --sorted_result
35 SELECT * FROM tp WHERE a BETWEEN 0 AND 9;
36 DROP PROCEDURE test_p1;
37
38 SET @save_autocommit= @@autocommit;
39 SET @@autocommit= OFF;
40 SHOW VARIABLES LIKE 'autocommit%';
41 DELIMITER |;
42 --error ER_COMMIT_NOT_ALLOWED_IN_SF_OR_TRG
43 CREATE TRIGGER test_trg_1 BEFORE UPDATE ON tp FOR EACH ROW
44 BEGIN
45 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
46 END|
47 --error ER_COMMIT_NOT_ALLOWED_IN_SF_OR_TRG
48 CREATE FUNCTION test_f_1() RETURNS int
49 BEGIN
50 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
51 END|
52 DELIMITER ;|
53 SET @@autocommit= @save_autocommit;
54
55 SET @save_event_scheduler= @@global.event_scheduler;
56 SET @@global.event_scheduler= ON;
57 CREATE EVENT test_ev_1
58 ON SCHEDULE AT CURRENT_TIMESTAMP
59 DO
60 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
61 sleep 1;
62 --sorted_result
63 SELECT * FROM t_10;
64 --sorted_result
65 SELECT * FROM tp WHERE a BETWEEN 0 AND 9;
66 SET @@global.event_scheduler= @save_event_scheduler;
67
68 --source suite/parts/inc/part_exch_drop_tabs.inc
69