[BUG, Ivan] Searching for an empty/non-empty field

jda jda at his.com
Thu Nov 11 14:47:12 CST 2004


>
>Jon,
>
>Actually correct syntax is
>     SELECT * from thereferences WHERE title IS NULL
>
>
>Ivan, please add to our VSQL_Test_User_Errors group this query
>     SELECT * from thereferences WHERE title = NULL
>
>Make sure it not crashes but return error.

Thanks for the correction.

One more little problem, then.

I tried

SELECT hit from thereferences WHERE title IS NULL

on an empty db and got no match...

Jon


More information about the Valentina-beta mailing list