[LRUG] Baffled by inconsistent behaviour of Rails find_by_* method

Sam Oliver sam at samoliver.com
Wed Aug 24 04:55:03 PDT 2011


On Wed, Aug 24, 2011 at 12:43 PM, Mark Woods <mwoods at online.ie> wrote:

> > In MySQL's world "4400/3H" == 4400
> > Yet another reason to ditch mysql.
>
> I can't reproduce this with mysql 5.0
>
>
I tried the following on mysql 5.1.37

SELECT "4400/3H" = 4400; # => 1 (MySQL 5.1.37)

I also tried selecting rows - I'm seeing multiple rows returned when the
numeric prefix of the varchar matches the integer in the where clause.

Sam
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lrug.org/pipermail/chat-lrug.org/attachments/20110824/3c70b12a/attachment-0003.html>


More information about the Chat mailing list