| 1 |
--echo # |
| 2 |
--echo # Bug #28560650 SERVER CRASH ON EXECUTING UPDATE QUERY USING |
| 3 |
--echo # REPEAT FUNC(SIGSEGV VIOLATION) |
| 4 |
--echo # |
| 5 |
|
| 6 |
CREATE TABLE t1 |
| 7 |
( a INT PRIMARY KEY, |
| 8 |
d INT NOT NULL, |
| 9 |
b VARCHAR(5000) NOT NULL, |
| 10 |
c VARCHAR(5000), |
| 11 |
vcol1 INT AS (a + 3) VIRTUAL, |
| 12 |
vcol2 INT AS (a + 5) VIRTUAL, |
| 13 |
vcol3 INT AS (a + 7) VIRTUAL, |
| 14 |
vcol4 INT AS (a + 7) VIRTUAL, |
| 15 |
vadcol INT AS (a + LENGTH(d)) STORED, |
| 16 |
vbcol CHAR(2) AS (SUBSTR(b,2,2)) VIRTUAL, |
| 17 |
vbidxcol CHAR(3) AS (SUBSTR(b,1,3)) VIRTUAL, |
| 18 |
INDEX(vcol1), |
| 19 |
INDEX(vcol2), |
| 20 |
INDEX(vcol3), |
| 21 |
INDEX(vcol4), |
| 22 |
INDEX(vbidxcol)); |
| 23 |
|
| 24 |
INSERT INTO t1 (a, d, b, c) |
| 25 |
VALUES (1, 1, REPEAT('x', 4000), REPEAT('y', 4000)); |
| 26 |
INSERT INTO t1 (a, d, b, c) |
| 27 |
VALUES (2, 1, REPEAT('i', 100), REPEAT('z', 5000)); |
| 28 |
|
| 29 |
SELECT a, d, LEFT(b, 10), LEFT(c, 10), vcol1, vcol2, vcol3, vcol4, |
| 30 |
vadcol, vbcol, vbidxcol FROM t1; |
| 31 |
|
| 32 |
UPDATE t1 |
| 33 |
SET b = REPEAT('a', 4000), |
| 34 |
vbidxcol = DEFAULT |
| 35 |
WHERE a = 2; |
| 36 |
|
| 37 |
SELECT a, d, LEFT(b, 10), LEFT(c, 10), vcol1, vcol2, vcol3, vcol4, |
| 38 |
vadcol, vbcol, vbidxcol FROM t1; |
| 39 |
|
| 40 |
DROP TABLE t1; |