Debian Codegraph @

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

raw
1 BEGIN;
2 INSERT INTO t0 VALUES(
3 repeat('a',10000),repeat('b',10000),repeat('c',10000),
4 repeat('d',10000),repeat('e',10000),repeat('f',10000));
5 UPDATE t0 SET a=substr(a,9999),b=substr(b,9999),c=substr(c,9999),
6 d=substr(d,9999),e=substr(e,9999),f=substr(f,9999);
7 ERROR HY000: Undo log record is too big.
8 UPDATE t0 SET a=substr(a,9999);
9 SELECT LENGTH(a) FROM t0;
10 LENGTH(a)
11 2
12 ROLLBACK;
13 SELECT * FROM t0;
14 a b c d e f
15 DROP TABLE t0;
16 BEGIN;
17 INSERT INTO t0 VALUES(
18 repeat('a',10000),repeat('b',10000),repeat('c',10000),
19 repeat('d',10000),repeat('e',10000),repeat('f',10000));
20 UPDATE t0 SET a=substr(a,9999),b=substr(b,9999),c=substr(c,9999),
21 d=substr(d,9999),e=substr(e,9999),f=substr(f,9999);
22 ERROR HY000: Undo log record is too big.
23 UPDATE t0 SET a=substr(a,9999);
24 SELECT LENGTH(a) FROM t0;
25 LENGTH(a)
26 2
27 ROLLBACK;
28 SELECT * FROM t0;
29 a b c d e f
30 DROP TABLE t0;