1
--source include/have_falcon.inc
2
--source include/big_test.inc
4
# Record cache memory leak test second version. Inspired by Kevin.
6
# Note: This is a bigger version of the original test to be
7
# used with --big-test option.
10
# ----------------------------------------------------- #
11
# --- Initialisation --- #
12
# ----------------------------------------------------- #
13
let $engine = 'Falcon';
14
eval SET @@storage_engine = $engine;
17
DROP TABLE IF EXISTS t1;
20
CREATE TABLE t1 (c1 varchar(100));
21
INSERT INTO t1 VALUES (repeat('A', 100));
22
INSERT INTO t1 VALUES (repeat('B', 100));
23
INSERT INTO t1 VALUES (repeat('C', 100));
26
# ----------------------------------------------------- #
28
# ----------------------------------------------------- #
34
UPDATE t1 SET c1 = lower(c1);
35
UPDATE t1 SET c1 = upper(c1);
36
UPDATE t1 SET c1 = lower(c1);
37
UPDATE t1 SET c1 = upper(c1);
38
UPDATE t1 SET c1 = lower(c1);
39
UPDATE t1 SET c1 = upper(c1);
40
UPDATE t1 SET c1 = lower(c1);
41
UPDATE t1 SET c1 = upper(c1);
48
# ----------------------------------------------------- #
50
# ----------------------------------------------------- #
51
SELECT count(*) FROM t1;
53
# ----------------------------------------------------- #
54
# --- Final cleanup --- #
55
# ----------------------------------------------------- #