Debian Codegraph @

mysql-test/suite/innodb/r/instant_add_column_autoinc.result

raw
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;