List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:August 8 1999 3:07pm
Subject:Re: Optimiser bug in 3.22.20a?
View as plain text  
>>>>> "Benjamin" == Benjamin Pflugmann <philemon@stripped> writes:

Benjamin> Hi.
Benjamin> When comparing a varchar with an integer, MySQL compares them as
Benjamin> integers, wich means that it has to convert your varchar to integer,
Benjamin> which - of course - prevents the use of any index on that varchar
Benjamin> column.

Right! This is however fixed in MySQL 3.23.2.

Benjamin> On Sun, Aug 08, 1999 at 03:35:47PM +0200, tony@stripped wrote:
Benjamin> [...]
>> The IDs are all 13 digit numbers, starting 7x000000 ... where x differentiates
> the 
>> type of item. Does this mean that MySQL isn't very good at dealing with this if
>> it's referred to in numeric context, but is fine when treated as a string?
Benjamin> [...]

Regards,
Monty
Thread
Optimiser bug in 3.22.20a?tony7 Aug
  • Optimiser bug in 3.22.20a?Michael Widenius8 Aug
    • Re: Optimiser bug in 3.22.20a?tony8 Aug
      • Re: Optimiser bug in 3.22.20a?Benjamin Pflugmann8 Aug
        • Re: Optimiser bug in 3.22.20a?Michael Widenius8 Aug