Storm should use "IS NULL" when comparing against a Variable with a None value

Bug #588815 reported by Marc Tardif
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Storm
Invalid
Undecided
Unassigned

Bug Description

When Storm compares against a Variable with a None value, like IntVariable(None), this results in the SQL query: = NULL. Instead, this should result in: IS NULL. The same applies when comparing for equality and non-equality.

Revision history for this message
Gustavo Niemeyer (niemeyer) wrote :

I don't think this is true:

>>> from storm.locals import *
>>> from storm.expr import compile
>>> class C(object):
... __storm_table__ = "C"
... column = Int(primary=True)
...
>>> compile(C.column == None)
'C."column" IS NULL'

Can you please provide another example where this is the case?

Changed in storm:
status: New → Invalid
Revision history for this message
Marc Tardif (cr3) wrote :

I've been unable to reproduce the context in which I was comparing a column to a Variable type with a None value, as opposed to comparing a column to None directly which worked fine. So, I'll also consider this bug as invalid.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.