Is NULL not allowed is SQL delete statement (for Derby)?

Posted by leftbrainlogic on Stack Overflow See other posts from Stack Overflow or by leftbrainlogic
Published on 2010-03-21T09:04:15Z Indexed on 2010/03/21 9:11 UTC
Read the original article Hit count: 430

delete from MyTable
where
((null = null) or (col1 = null)) OR
((102 = null) or (col2 = 102)))

Error: Syntax error: Encountered "null" at line 3, column 3.
SQLState:  42X01
ErrorCode: -1

© Stack Overflow or respective owner