Page 1 of 1

Nullable fields strange behaviour

Posted: Wed 14 Dec 2011 09:53
by listonic
I found a strange behaviour :

I have a nullable bit field in MS SQL.

The value is null.
If i have a query :

(from i in Table
orderby i.Marketid
where i.nullablefield != true)

it does not return any records.
I have to do
(from i in Table
orderby i.Marketid
where i.nullablefield == false || i.nullablefield == null)

It seems like a bug for me.

Posted: Thu 15 Dec 2011 16:17
by StanislavK
Thank you for the report, we have reproduced the issue. We will analyze it and inform you about the results as soon as possible.