1
--source include/have_falcon.inc
2
--source include/big_test.inc
4
# Bug #22154: Crash after 500 alters, 500 inserts, and a few updates
6
--echo *** Bug #22154 ***
8
# ----------------------------------------------------- #
9
# --- Initialisation --- #
10
# ----------------------------------------------------- #
11
let $engine = 'Falcon';
12
eval SET @@storage_engine = $engine;
15
DROP TABLE IF EXISTS tj9;
16
DROP PROCEDURE IF EXISTS pj9;
19
CREATE TABLE tj9 (s0 int);
22
create procedure pj9 ()
24
declare v int default 1;
27
set @v = concat('alter table tj9 add column s',v,' char(64) default ''Hello World''');
28
prepare stmt1 from @v;
35
insert into tj9 (s1) values (v);
41
set @v = concat('update tj9 set s',v,'=concat(s2,s1)');
42
prepare stmt1 from @v;
49
# ----------------------------------------------------- #
51
# ----------------------------------------------------- #
54
# ----------------------------------------------------- #
56
# ----------------------------------------------------- #
57
SELECT count(*) FROM tj9;
59
# ----------------------------------------------------- #
60
# --- Final cleanup --- #
61
# ----------------------------------------------------- #