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, 5:06:59 PM, you wrote:

CGÁ> Hello:

>> Carlos: you to do work for this feature? :)
CGÁ> Yes i only need to decide how i'm going to fix it :)

CGÁ> Huumm what about this?? :

CGÁ> SELECT EMP_NO FROM EMPLOYEE WHERE (HIRE_DATE=@B1 OR (HIRE_DATE IS NULL
CGÁ> AND @B2 = CAST(NULL AS DATE)))
    Hmmmm... no, it's don't work, because
       @B2 = CAST(NULL AS DATE)))
       NULL = NULL --> NULL (false), no match comparison
           ^^^ binary operator for NULL arguments result always NULL.
       in this may use only IS NULL check, but in this construction
       parameter can't be used... :) COALESCE... ;)))))))
       
-- 
Best regards,
 Dmitry                            mailto:fd...@ua...