#34 Foo.selectBy(column=None) should issue '... column IS NULL'

closed
Oleg Broytman
General (125)
5
2005-03-01
2004-08-19
Andrew Bennetts
No

Many places in SQLObject allow use of None for NULL.
When selectBy is given None as a value to match for a
column, it does "column = NULL" in the query, but NULL
is never equal to another value, so this never matches.
It would be more useful for the query to be "column IS
NULL" in this case.

Discussion

  • Oleg Broytman
    Oleg Broytman
    2005-03-01

    • assigned_to: nobody --> phd
    • status: open --> closed
     
  • Oleg Broytman
    Oleg Broytman
    2005-03-01

    Logged In: YES
    user_id=4799

    Fixed at revision 658.