diff options
| author | Jonathan Perkin <jonathan.perkin@oracle.com> | 2011-02-08 14:43:27 +0100 |
|---|---|---|
| committer | Jonathan Perkin <jonathan.perkin@oracle.com> | 2011-02-08 14:43:27 +0100 |
| commit | d2495d17961995cf661ff7e1e89738b922fefe93 (patch) | |
| tree | b84e667b7060882e689e2c7e28066b7f09723869 /mysql-test/t/func_misc.test | |
| parent | 0a8419dfdd6d80b6029c354fb0a82683b2fef617 (diff) | |
| parent | b831c6dbbb29a9dc7dd3e3b7910f5b39e96fe2af (diff) | |
| download | mariadb-git-d2495d17961995cf661ff7e1e89738b922fefe93.tar.gz | |
Merge from mysql-5.0.92-release
Diffstat (limited to 'mysql-test/t/func_misc.test')
| -rw-r--r-- | mysql-test/t/func_misc.test | 13 |
1 files changed, 12 insertions, 1 deletions
diff --git a/mysql-test/t/func_misc.test b/mysql-test/t/func_misc.test index 01c508c9b58..89359fab0ca 100644 --- a/mysql-test/t/func_misc.test +++ b/mysql-test/t/func_misc.test @@ -450,5 +450,16 @@ DROP TABLE t1; # select NAME_CONST('_id',1234) as id; ---echo End of 5.0 tests +--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 End of 5.0 tests |