on 2012 Oct 01 5:25 PM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
79 | |
11 | |
10 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.