Debian Codegraph @

mysql-test/suite/innodb/t/instant_add_column_autoinc.test

raw
1 --source include/count_sessions.inc
2
3 delimiter |;
4 #Procedure for alter(DDL)
5 CREATE PROCEDURE test.sp2 (IN start BIGINT)
6 BEGIN
7 SET @idx =start;
8 WHILE (@idx > 0) DO
9 ALTER TABLE test.t1 ADD n2 BIGINT;
10 ALTER TABLE test.t1 DROP COLUMN n2;
11 SET @idx = @idx - 1;
12 END WHILE;
13 END|
14
15 #Procedure for INSERT
16 CREATE PROCEDURE test.sp1 (IN start BIGINT)
17 BEGIN
18 SET @idx =start;
19 WHILE (@idx > 0) DO
20 INSERT INTO test.t1 (c2,c3) VALUES(repeat('q',10),@idx);
21 SET @idx = @idx - 1;
22 END WHILE;
23 END|
24
25 delimiter ;|
26
27
28 connect (con1,localhost,root,,);
29
30 connection default;
31 CREATE TABLE t1 (c1 INT AUTO_INCREMENT PRIMARY KEY, c2 TEXT(1024), c3 INT);
32 --send call test.sp2(30);
33
34 connection con1;
35 --send call test.sp1(300);
36 --reap
37
38 connection default;
39 --reap
40
41 CHECK TABLE t1;
42 DROP TABLE t1;
43
44 CREATE TABLE t1 (c1 INT AUTO_INCREMENT PRIMARY KEY, c2 TEXT(1024), c3 INT) PARTITION BY HASH (c1) PARTITIONS 2;
45 --send call test.sp2(30);
46
47 connection con1;
48 --send call test.sp1(300);
49 --reap
50
51 connection default;
52 --reap
53
54 CHECK TABLE t1;
55
56 disconnect con1;
57
58 DROP PROCEDURE IF EXISTS test.sp1;
59 DROP PROCEDURE IF EXISTS test.sp2;
60
61 DROP TABLE t1;
62
63 --source include/wait_until_count_sessions.inc