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.
asked 01 Oct '12, 16:25
This problem has been fixed. See engineering case 723443, in the next EBF (build 22.214.171.12415 or greater). Thank you for the report.
answered 06 Nov '12, 11:12