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

[Dmitry A. <fd...@ua...>]

Hello Carlos,

Thursday, March 25, 2004, 2:41:01 PM, you wrote:

CGÁ> I think i can do a change do the generation of the where clausule using
CGÁ> coalesce ( have you reviewed how the use of coalesce affects the query
CGÁ> plan ?? maybe it have no effect ... i will try to check it ) for 1.5+
CGÁ> and using Pk fields only on all other versions ( 1.0.x and Interbase 6 )
     Hummmmmm... I think that this will render the negative influence
     upon building plan, but as it were there was not -- must work
     pravilino. better NATURAL plan, than incorrect result.

     And i'm don't know true... COALESCE its unsupported 1.0.x and
     Interbase 6? Or supported?!?! If not supported -- it's may be
     realised as feature for Firebird 1.5!
     
CGÁ> Opinions ?????
     Is it my opinion! ;)


-- 
Best regards,
 Dmitry                            mailto:fd...@ua...