SQLite Forum

select match though row does not exists
Login
please show the SQL you are executing and its results. It is not clear what you mean by "check".

Changing the declared type of y is unlikely to make a difference, especially as all your attempts are interpreted exactly the same way.