Re: [Firebird-net-provider] FbCommandBuilder incorrect behaivor in where clause generation on nullable fields!

[<car...@te...>]

Hello:

>    In SqlClient use template ({0}=? OR ({0} IS NULL AND ? IS NULL)),
>    but it's not work on fbserver. But if we work on firebird 1.5 we
>    can release correct work thru, for example COALESCE keyword. When
>    all be works fine! (May be CASE works too, but need 3 params, but
>    not 2).
> 
>    I think that in server this feature will else long, but we already
>    can get correct work, if using coalesce keyword, on FB1.5 at least
>    once! 

Hummmmmmmm ... not sure about what to do !! :)

I think i can do a change do the generation of the where clausule using 
coalesce ( have you reviewed how the use of coalesce affects the query 
plan ?? maybe it have no effect ... i will try to check it ) for 1.5+ 
and using Pk fields only on all other versions ( 1.0.x and Interbase 6 )



Opinions ?????



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain