pypika
pypika copied to clipboard
Bug in filtering None values
When a filter value is None, pypika should generate query as WHERE name is NULL
instead of WHERE "name"=NULL
.
![Screenshot 2022-02-25 at 13 46 30](https://user-images.githubusercontent.com/4463796/155679949-40449e4f-8ba4-4ad1-9886-dc41c1d7724d.png)
WHERE "name"=NULL
is always going to be Falsy since NULL = NULL will always be falsy (why? best put by Matt as "I don't have a sister, and nor does my friend. If "NULL = NULL" then we have a common sister, and are therefore related!" here). Also, for reference this Wiki page on NULL -> https://en.wikipedia.org/wiki/Null_%28SQL%29#Controversy