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 | 9fc04b9fb858243c1c2f3945404d9aeae8d228e2 (patch) | |
| tree | 83ab28bc55d6e43bd4b888c039e628587c586802 /mysql-test/t/func_misc.test | |
| parent | d03f0eecfdedb28158f6159721fe3a610df4efe4 (diff) | |
| parent | c65e99e00c93d662223601a3b38ef8df55009df7 (diff) | |
| download | mariadb-git-9fc04b9fb858243c1c2f3945404d9aeae8d228e2.tar.gz | |
merge
Diffstat (limited to 'mysql-test/t/func_misc.test')
| -rw-r--r-- | mysql-test/t/func_misc.test | 15 |
1 files changed, 14 insertions, 1 deletions
diff --git a/mysql-test/t/func_misc.test b/mysql-test/t/func_misc.test index a60eb9cf845..5d93813a9ff 100644 --- a/mysql-test/t/func_misc.test +++ b/mysql-test/t/func_misc.test @@ -478,4 +478,17 @@ SELECT COALESCE(a) = COALESCE(b) FROM t1; DROP TABLE t1; ---echo End of 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.1 tests |