yeah you'd have to search around MySQL's bugtracker for that one, I've seen it before, the only record I can find at the moment is #4 here:
http://sql-info.de/mysql/gotchas.html#1_1 On Oct 26, 2010, at 11:16 PM, Diana Clarke wrote: > Any ideas why I'm getting one row back with an id of 5 when I filtered > by id IS NULL? > > [SQLAlchemy-0.6.4, MySQL 5, MyISAM] > > sqlalchemy.engine.base.Engine.0x...eb2c: INFO: SELECT user.id AS > user_id, user.username AS user_username, user.level AS user_level > FROM user > WHERE user.level = %s AND user.id IS NULL > > sqlalchemy.engine.base.Engine.0x...eb2c: INFO: (1,) > > sqlalchemy.engine.base.Engine.0x...eb2c: DEBUG: Col ('user_id', > 'user_username', 'user_level') > > sqlalchemy.engine.base.Engine.0x...eb2c: DEBUG: Row (5L, u'jane', 1) > > Thanks, > > --diana > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
