Weird ISNULL behavior in Ultralite

[Former Member]

Hi again.

I have found a strange behavior when placing two ISNULL functions together, like in the following example:

SELECT ISNULL('a','') + ISNULL(NULL, '') + 'b'

I suppose the correct result is 'ab', however Ultralite returns only 'b'. Note that I left both isnulls with an empty string in the second parameter. If I replace it with a space or any other character:

SELECT ISNULL('a','x') + ISNULL(NULL, 'x') + 'b'

Then it returns 'axb' correctly.

[chris_keating]

I have reproduced this and will investigate.

[Former Member · Accepted solution]

This problem has been fixed. See engineering case 723443, in the next EBF (build 12.0.1.3815 or greater). Thank you for the report.

[Former Member · Accepted solution]

Thanks Andy, much appreciated!