diff options
| author | Georgi Kodinov <Georgi.Kodinov@Oracle.com> | 2010-08-02 11:17:47 +0300 |
|---|---|---|
| committer | Georgi Kodinov <Georgi.Kodinov@Oracle.com> | 2010-08-02 11:17:47 +0300 |
| commit | 05e88a5bbf19d89a9c76318f31c4731d42c63b05 (patch) | |
| tree | 83ab28bc55d6e43bd4b888c039e628587c586802 /mysql-test/r/func_misc.result | |
| parent | 06469e2323c8671da7ade7816457e98ecb76e371 (diff) | |
| parent | b7e8fd0863697836af80807c82e6383ab646853e (diff) | |
| download | mariadb-git-05e88a5bbf19d89a9c76318f31c4731d42c63b05.tar.gz | |
merge
Diffstat (limited to 'mysql-test/r/func_misc.result')
| -rw-r--r-- | mysql-test/r/func_misc.result | 17 |
1 files changed, 16 insertions, 1 deletions
diff --git a/mysql-test/r/func_misc.result b/mysql-test/r/func_misc.result index e21e7903459..a95308b0e66 100644 --- a/mysql-test/r/func_misc.result +++ b/mysql-test/r/func_misc.result @@ -345,4 +345,19 @@ SELECT COALESCE(a) = COALESCE(b) FROM t1; COALESCE(a) = COALESCE(b) 1 DROP TABLE t1; -End of tests +# +# Bug #54461: crash with longblob and union or update with subquery +# +CREATE TABLE t1 (a INT, b LONGBLOB); +INSERT INTO t1 VALUES (1, '2'), (2, '3'), (3, '2'); +SELECT DISTINCT LEAST(a, (SELECT b FROM t1 LIMIT 1)) FROM t1 UNION SELECT 1; +LEAST(a, (SELECT b FROM t1 LIMIT 1)) +1 +2 +SELECT DISTINCT GREATEST(a, (SELECT b FROM t1 LIMIT 1)) FROM t1 UNION SELECT 1; +GREATEST(a, (SELECT b FROM t1 LIMIT 1)) +2 +3 +1 +DROP TABLE t1; +End of 5.1 tests |