diff options
| author | Jonathan Perkin <jonathan.perkin@oracle.com> | 2010-12-16 11:13:58 +0100 |
|---|---|---|
| committer | Jonathan Perkin <jonathan.perkin@oracle.com> | 2010-12-16 11:13:58 +0100 |
| commit | 33827e7dbfc177ef52718f63eaf87e005ab3e8b5 (patch) | |
| tree | 83c2beab0fb52424ab77dcb1449a3f394f0d0fe1 /mysql-test/t/select.test | |
| parent | dec388d5beac2e9d0d32ce1610b871c3d1042544 (diff) | |
| parent | cf175bf4b8fef9c054fa4779fbea011ad43432a0 (diff) | |
| download | mariadb-git-33827e7dbfc177ef52718f63eaf87e005ab3e8b5.tar.gz | |
Merge from mysql-5.5.8-release
Diffstat (limited to 'mysql-test/t/select.test')
| -rw-r--r-- | mysql-test/t/select.test | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/t/select.test b/mysql-test/t/select.test index 87f36c452f2..3ed7213e8d7 100644 --- a/mysql-test/t/select.test +++ b/mysql-test/t/select.test @@ -4147,3 +4147,22 @@ DROP VIEW view_t1; DROP TABLE t1; --echo # End of test BUG#54515 + +--echo # +--echo # Bug #57203 Assertion `field_length <= 255' failed. +--echo # + +SELECT coalesce((avg(distinct (geomfromtext("point(25379 -22010)"))))) +UNION ALL +SELECT coalesce((avg(distinct (geomfromtext("point(25379 -22010)"))))) +AS foo +; + +CREATE table t1(a text); +INSERT INTO t1 VALUES (''), (''); +SELECT avg(distinct(t1.a)) FROM t1, t1 t2 +GROUP BY t2.a ORDER BY t1.a; + +DROP TABLE t1; + +--echo # End of test BUG#57203 |