| 1 |
CREATE PROCEDURE test.sp2 (IN start BIGINT) |
| 2 |
BEGIN |
| 3 |
SET @idx =start; |
| 4 |
WHILE (@idx > 0) DO |
| 5 |
ALTER TABLE test.t1 ADD n2 BIGINT; |
| 6 |
ALTER TABLE test.t1 DROP COLUMN n2; |
| 7 |
SET @idx = @idx - 1; |
| 8 |
END WHILE; |
| 9 |
END| |
| 10 |
CREATE PROCEDURE test.sp1 (IN start BIGINT) |
| 11 |
BEGIN |
| 12 |
SET @idx =start; |
| 13 |
WHILE (@idx > 0) DO |
| 14 |
INSERT INTO test.t1 (c2,c3) VALUES(repeat('q',10),@idx); |
| 15 |
SET @idx = @idx - 1; |
| 16 |
END WHILE; |
| 17 |
END| |
| 18 |
CREATE TABLE t1 (c1 INT AUTO_INCREMENT PRIMARY KEY, c2 TEXT(1024), c3 INT); |
| 19 |
call test.sp2(30);; |
| 20 |
call test.sp1(300);; |
| 21 |
CHECK TABLE t1; |
| 22 |
Table Op Msg_type Msg_text |
| 23 |
test.t1 check status OK |
| 24 |
DROP TABLE t1; |
| 25 |
CREATE TABLE t1 (c1 INT AUTO_INCREMENT PRIMARY KEY, c2 TEXT(1024), c3 INT) PARTITION BY HASH (c1) PARTITIONS 2; |
| 26 |
call test.sp2(30);; |
| 27 |
call test.sp1(300);; |
| 28 |
CHECK TABLE t1; |
| 29 |
Table Op Msg_type Msg_text |
| 30 |
test.t1 check status OK |
| 31 |
DROP PROCEDURE IF EXISTS test.sp1; |
| 32 |
DROP PROCEDURE IF EXISTS test.sp2; |
| 33 |
DROP TABLE t1; |