There seems to be an issue with selecting rows when a field is null, even though I'm not mentioning the field in the query at all.
Here's an example:
SELECT * FROM accounts WHERE username='JohnDoe'
This won't return any rows if the field verified on the table (or any other) is set to null, if I set it to any other value apart from null, it returns the row normally.
There seems to be an issue with selecting rows when a field is null, even though I'm not mentioning the field in the query at all.
Here's an example:
SELECT * FROM accounts WHERE username='JohnDoe'
This won't return any rows if the field
verifiedon the table (or any other) is set to null, if I set it to any other value apart from null, it returns the row normally.