diff options
author | Georgi Kodinov <Georgi.Kodinov@Oracle.com> | 2010-08-20 14:22:46 +0300 |
---|---|---|
committer | Georgi Kodinov <Georgi.Kodinov@Oracle.com> | 2010-08-20 14:22:46 +0300 |
commit | a54c3dd5c0080bd6d2834478f5f5b4fc637fcc99 (patch) | |
tree | abdc965c92ac02057c93a78984ba3e9958312d87 /mysql-test/r/func_misc.result | |
parent | 3166b9153a4b879446de8bc34802a1c1ab9345ad (diff) | |
parent | bbaad8880e4329d8e01c359051fc39eb3192dda0 (diff) | |
download | mariadb-git-a54c3dd5c0080bd6d2834478f5f5b4fc637fcc99.tar.gz |
merge
Diffstat (limited to 'mysql-test/r/func_misc.result')
-rw-r--r-- | mysql-test/r/func_misc.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/func_misc.result b/mysql-test/r/func_misc.result index e21e7903459..1eb4153eb8b 100644 --- a/mysql-test/r/func_misc.result +++ b/mysql-test/r/func_misc.result @@ -337,6 +337,21 @@ select connection_id() > 0; connection_id() > 0 1 # +# 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; +# # Bug #52165: Assertion failed: file .\dtoa.c, line 465 # CREATE TABLE t1 (a SET('a'), b INT); |