Debian Codegraph @

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

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