From: Ann W. Harrison
Date: February 18 2009 10:08pm
Subject: Re: Patch for bug#42208
List-Archive: http://lists.mysql.com/falcon/562
Message-Id: <499C86C1.6040102@mysql.com>
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset=ISO-8859-1
Content-Transfer-Encoding: 7BIT

Vlad,
> 
>> The double precision representation of 10 is precise, so there's
>> no problem with that query.
>>
> 
> Ok, I had to formulate the query a la Philip into
> select name order by  name, age where name like 'A%' and age > 10 and age  <
> 9007199254740993 

OK, but you don't have to go to disk until you find the first A% who is
over 999,999,999,999,999 years old.

Cheers,

Ann