[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