diff options
| author | sergefp@mysql.com <> | 2005-07-12 16:31:04 +0000 |
|---|---|---|
| committer | sergefp@mysql.com <> | 2005-07-12 16:31:04 +0000 |
| commit | 670428f6e63b0e3b32f0b006a27648da8260162c (patch) | |
| tree | 33c96af5bf7b24068362913a303185aef8dfc303 /mysql-test/t | |
| parent | d71548c873e69c0a58a99e9822b6c78fe709988e (diff) | |
| parent | 55e70fd1f66cfd259d382e422c60d01cd914e05a (diff) | |
| download | mariadb-git-670428f6e63b0e3b32f0b006a27648da8260162c.tar.gz | |
Merge spetrunia@bk-internal.mysql.com:/home/bk/mysql-4.1
into mysql.com:/home/psergey/mysql-4.1-bug11821
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/subselect.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index e585022563f..12593438805 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -1746,3 +1746,11 @@ CREATE TABLE `t2` ( INSERT INTO `t2` VALUES (1, 1, 1, '10.10.10.1'); SELECT s.ip, count( e.itemid ) FROM `t1` e JOIN t2 s ON s.sessionid = e.sessionid WHERE e.sessionid = ( SELECT sessionid FROM t2 ORDER BY sessionid DESC LIMIT 1 ) GROUP BY s.ip HAVING count( e.itemid ) >0 LIMIT 0 , 30; drop tables t1,t2; + +# BUG#11821 : Select from subselect using aggregate function on an enum +# segfaults: +create table t1 (fld enum('0','1')); +insert into t1 values ('1'); +select * from (select max(fld) from t1) as foo; +drop table t1; + |