From: Tor Didriksen
Date: October 18 2010 3:56pm
Subject: Re: bzr commit into mysql-5.5-bugteam branch (tor.didriksen:3247)
 Bug#57203
List-Archive: http://lists.mysql.com/commits/121038
Message-Id: <4CBC6E30.40008@oracle.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 2010-10-18 17:41, Alexey Kopytov wrote:
> On 18.10.10 19:32, Tor Didriksen wrote:
>> On 2010-10-18 17:28, Alexey Kopytov wrote:
>>> On 18.10.10 17:13, Tor Didriksen wrote:
>>>> === modified file 'mysql-test/t/select.test'
>>>> --- a/mysql-test/t/select.test 2010-09-09 15:00:33 +0000
>>>> +++ b/mysql-test/t/select.test 2010-10-18 13:13:09 +0000
>>>> @@ -4147,3 +4147,18 @@ DROP VIEW view_t1;
>>>> DROP TABLE t1;
>>>>
>>>> --echo # End of test BUG#54515
>>>> +
>>>> +--echo #
>>>> +--echo # Bug #57203 Assertion `field_length<= 255' failed.
>>>> +--echo #
>>>> +
>>>> +SELECT avg(distinct(-31872)) as foo;
>>>> +
>>>
>>> Why have you added the above line?
>> an even simpler test case, from Shane Bester today.
>>
>
> It does not lead to a failed assertion on my 5.5 build w/o your fix. 
> It does not even seem to invoke Field_{float,double}::val_str().
Sorry, wrong query simplification, this one crashes

select coalesce((avg(distinct (geomfromtext("point(25379 -22010)")))))
union all
select coalesce((avg(distinct (geomfromtext("point(25379 -22010)")))))
;