Re: [sqlite] incorrect where clause does not throw error

On 10/05/2009 6:53 AM, Stefan Finzel wrote: > Porting an application to sqlite3.6.13 on Linux i made a mistake > creating a illegal query on a character field: > > select * from Test where Remark = NULL > > select * from Test where Remark <> NULL > > I was confused as there were neither data

[sqlite] incorrect where clause does not throw error

Porting an application to sqlite3.6.13 on Linux i made a mistake creating a illegal query on a character field: select * from Test where Remark = NULL select * from Test where Remark <> NULL I was confused as there were neither data nor an error. Shouldn't this cause at least an error