diff options
| author | Georgi Kodinov <Georgi.Kodinov@Oracle.com> | 2010-08-20 16:10:49 +0300 |
|---|---|---|
| committer | Georgi Kodinov <Georgi.Kodinov@Oracle.com> | 2010-08-20 16:10:49 +0300 |
| commit | bd62942ec1c074aaa554007feb9d8c64a061732c (patch) | |
| tree | 131ffa70b19236e991dc12e5bdbbe8e4fb548d7c /mysql-test/t/func_misc.test | |
| parent | 352f2ada7bbe084a03f8c186e90e70873ee14f84 (diff) | |
| parent | a54c3dd5c0080bd6d2834478f5f5b4fc637fcc99 (diff) | |
| download | mariadb-git-bd62942ec1c074aaa554007feb9d8c64a061732c.tar.gz | |
merge
Diffstat (limited to 'mysql-test/t/func_misc.test')
| -rw-r--r-- | mysql-test/t/func_misc.test | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/func_misc.test b/mysql-test/t/func_misc.test index 5d93813a9ff..ec71e950ca7 100644 --- a/mysql-test/t/func_misc.test +++ b/mysql-test/t/func_misc.test @@ -468,6 +468,19 @@ select NAME_CONST('_id',1234) as id; select connection_id() > 0; --echo # +--echo # Bug #54461: crash with longblob and union or update with subquery +--echo # + +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; +SELECT DISTINCT GREATEST(a, (SELECT b FROM t1 LIMIT 1)) FROM t1 UNION SELECT 1; + +DROP TABLE t1; + + +--echo # --echo # Bug #52165: Assertion failed: file .\dtoa.c, line 465 --echo # |