• SQLkiwi (3/3/2011)


    Just to be clear, Bart's example is compiled as:

    SELECT CASE WHEN 0 <= 0 THEN 0 ELSE LOG10(0) END;

    ..which also gives the error (when it should not). Reproduces on 2005 (build 0.05254) and 2008 (build 10.0.4272) for me.

    And reproduced on 2005 SP3 (9.00.4035.00 X64) and 2008 R2 RTM (10.50.1734.0 Intel X86) for me.

    -- Gianluca Sartori