Storm should use "IS NULL" when comparing against a Variable with a None value
Bug #588815 reported by
Marc Tardif
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.
To post a comment you must log in.
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?