Debian Codegraph @

mysql-test/suite/rpl/r/rpl_partition_id_check.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 CREATE TABLE func(id INT, age INT) PARTITION BY RANGE(age) (PARTITION P0 VALUES LESS THAN (25), PARTITION P1 VALUES LESS THAN (50));
7 CREATE FUNCTION insert_data() RETURNS INT DETERMINISTIC
8 BEGIN
9 INSERT INTO func VALUES (100, 36);
10 RETURN (SELECT COUNT(*) FROM func);
11 END//
12 CREATE FUNCTION update_data() RETURNS INT DETERMINISTIC
13 BEGIN
14 UPDATE func SET age=age-12 WHERE id=100;
15 RETURN (SELECT COUNT(*) FROM func);
16 END//
17 CREATE FUNCTION delete_data() RETURNS INT DETERMINISTIC
18 BEGIN
19 DELETE FROM func WHERE id=100;
20 RETURN (SELECT COUNT(*) FROM func);
21 END//
22 include/save_binlog_position.inc
23 BEGIN;
24 SELECT insert_data();
25 insert_data()
26 1
27 COMMIT;
28 include/rpl_partition_info.inc
29 BEGIN;
30 SELECT update_data();
31 update_data()
32 1
33 COMMIT;
34 include/rpl_partition_info_update.inc
35 BEGIN;
36 SELECT delete_data();
37 delete_data()
38 0
39 COMMIT;
40 include/rpl_partition_info.inc
41 CREATE TABLE proc(id INT, age INT) PARTITION BY RANGE(age) (PARTITION P0 VALUES LESS THAN (35), PARTITION P1 VALUES LESS THAN (60));
42 CREATE PROCEDURE insert_data()
43 BEGIN
44 INSERT INTO proc VALUES (100, 30);
45 END//
46 CREATE PROCEDURE update_data()
47 BEGIN
48 UPDATE proc SET age=age+10 WHERE id=100;
49 END//
50 CREATE PROCEDURE delete_data()
51 BEGIN
52 DELETE FROM proc WHERE id=100;
53 END//
54 include/save_binlog_position.inc
55 BEGIN;
56 CALL insert_data();
57 COMMIT;
58 include/rpl_partition_info.inc
59 include/save_binlog_position.inc
60 BEGIN;
61 CALL update_data();
62 COMMIT;
63 include/rpl_partition_info_update.inc
64 include/save_binlog_position.inc
65 BEGIN;
66 CALL delete_data();
67 COMMIT;
68 include/rpl_partition_info.inc
69 CREATE TABLE t1(a INT);
70 CREATE TABLE trigg(id INT, age INT) PARTITION BY RANGE(age) (PARTITION P0 VALUES LESS THAN (25), PARTITION P1 VALUES LESS THAN (60));
71 CREATE TRIGGER insert_data AFTER INSERT ON t1 FOR EACH ROW
72 BEGIN
73 INSERT INTO trigg VALUES (100, 36);
74 END//
75 CREATE TRIGGER update_data AFTER UPDATE ON t1 FOR EACH ROW
76 BEGIN
77 UPDATE trigg SET age=age-13 WHERE id=100;
78 END//
79 CREATE TRIGGER delete_data AFTER DELETE ON t1 FOR EACH ROW
80 BEGIN
81 DELETE FROM trigg WHERE id=100;
82 END//
83 include/save_binlog_position.inc
84 BEGIN;
85 INSERT INTO t1 VALUES(1);
86 COMMIT;
87 include/rpl_partition_info.inc
88 include/save_binlog_position.inc
89 BEGIN;
90 UPDATE t1 SET a=a+10;
91 COMMIT;
92 include/rpl_partition_info_update.inc
93 include/save_binlog_position.inc
94 BEGIN;
95 DELETE FROM t1;
96 COMMIT;
97 include/rpl_partition_info.inc
98 CREATE TABLE trans(id INT, age INT) PARTITION BY RANGE(age) SUBPARTITION BY KEY(id)
99 (
100 PARTITION P0 VALUES LESS THAN (30)
101 (SUBPARTITION P0A, SUBPARTITION P0B)
102 ,
103 PARTITION P1 VALUES LESS THAN (60)
104 (SUBPARTITION P1A, SUBPARTITION P1B)
105 );
106 include/save_binlog_position.inc
107 BEGIN;
108 INSERT INTO trans VALUES(100,46);
109 COMMIT;
110 include/rpl_partition_info.inc
111 include/save_binlog_position.inc
112 BEGIN;
113 UPDATE trans SET age=age-20 WHERE id=100;
114 COMMIT;
115 include/rpl_partition_info_update.inc
116 include/save_binlog_position.inc
117 BEGIN;
118 DELETE FROM trans WHERE id=100;
119 COMMIT;
120 include/rpl_partition_info.inc
121 include/save_binlog_position.inc
122 BEGIN;
123 INSERT INTO trans VALUES(1,55),(1,55);
124 UPDATE trans SET id=id+10;
125 DELETE FROM trans WHERE id=11;
126 COMMIT;
127 include/assert_binlog_events.inc
128 include/save_binlog_position.inc
129 BEGIN;
130 INSERT INTO trans VALUES(101,46),(102,23);
131 UPDATE trans SET id=id+100;
132 DELETE FROM trans WHERE id=201;
133 COMMIT;
134 include/assert_binlog_events.inc
135 CREATE TABLE t2(a INT);
136 include/save_binlog_position.inc
137 BEGIN;
138 INSERT INTO trans VALUES(301,55),(301,55);
139 INSERT INTO t2 VALUES(10);
140 UPDATE trans SET id=id+10;
141 UPDATE t2 SET a=a+10;
142 DELETE FROM trans WHERE id=11;
143 DELETE FROM t2 WHERE a=20;
144 COMMIT;
145 include/assert_binlog_events.inc
146 include/sync_slave_sql_with_master.inc
147 include/diff_tables.inc [master:trans, slave:trans]
148 include/diff_tables.inc [master:func, slave:func]
149 include/diff_tables.inc [master:proc, slave:proc]
150 include/diff_tables.inc [master:trigg, slave:trigg]
151 DROP FUNCTION insert_data;
152 DROP FUNCTION update_data;
153 DROP FUNCTION delete_data;
154 DROP PROCEDURE insert_data;
155 DROP PROCEDURE update_data;
156 DROP PROCEDURE delete_data;
157 DROP TRIGGER insert_data;
158 DROP TRIGGER update_data;
159 DROP TRIGGER delete_data;
160 DROP TABLE trans;
161 DROP TABLE func;
162 DROP TABLE proc;
163 DROP TABLE trigg;
164 DROP TABLE t1;
165 DROP TABLE t2;
166 include/sync_slave_sql_with_master.inc
167 include/rpl_end.inc