diff options
| author | Martin Hansson <martin.hansson@sun.com> | 2009-11-20 13:29:43 +0100 |
|---|---|---|
| committer | Martin Hansson <martin.hansson@sun.com> | 2009-11-20 13:29:43 +0100 |
| commit | ca595821498d6a547fa1780df86cdf127b0019b3 (patch) | |
| tree | fabb9c5fa11cdf96ecdc1297561875b1a58090ed /mysql-test/t/subselect.test | |
| parent | b4a3083dc8b8049e64692ffc8e6e527914fb93da (diff) | |
| parent | 4205c622e1a741bae1b2d8d213342f8e0bdd936a (diff) | |
| download | mariadb-git-ca595821498d6a547fa1780df86cdf127b0019b3.tar.gz | |
merge of Bug#33204 (backport)
Diffstat (limited to 'mysql-test/t/subselect.test')
| -rw-r--r-- | mysql-test/t/subselect.test | 16 |
1 files changed, 15 insertions, 1 deletions
diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index d25aab68b5e..98c4a75c426 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -30,7 +30,7 @@ SELECT 1 IN (SELECT 1); SELECT 1 FROM (SELECT 1 as a) b WHERE 1 IN (SELECT (SELECT a)); -- error ER_WRONG_USAGE select (SELECT 1 FROM (SELECT 1) a PROCEDURE ANALYSE(1)); --- error ER_WRONG_USAGE +-- error ER_WRONG_PARAMETERS_TO_PROCEDURE SELECT 1 FROM (SELECT 1) a PROCEDURE ANALYSE((SELECT 1)); -- error ER_BAD_FIELD_ERROR SELECT (SELECT 1) as a FROM (SELECT 1) b WHERE (SELECT a) IS NULL; @@ -3764,5 +3764,19 @@ SELECT * FROM t1 WHERE EXISTS ( SELECT 1 INTO @v ); SELECT * FROM t1 WHERE a IN ( SELECT 1 INTO @v ); DROP TABLE t1, t2; +# +# Bug #31157: Crash when select+order by the avg of some field within the +# group by +# +CREATE TABLE t1 (a ENUM('rainbow')); +INSERT INTO t1 VALUES (),(),(),(),(); +SELECT 1 FROM t1 GROUP BY (SELECT 1 FROM t1 ORDER BY AVG(LAST_INSERT_ID())); +DROP TABLE t1; +CREATE TABLE t1 (a LONGBLOB); +INSERT INTO t1 SET a = 'aaaa'; +INSERT INTO t1 SET a = 'aaaa'; +SELECT 1 FROM t1 GROUP BY + (SELECT LAST_INSERT_ID() FROM t1 ORDER BY MIN(a) ASC LIMIT 1); +DROP TABLE t1; --echo End of 5.1 tests. |