COALESCE with bind variables [CORE582] #938
Comments
Modified by: @pcisarVersion: 1.5.2 [ 10027 ] Component: API / Client Library [ 10040 ] assignee: Dmitry Yemanov [ dimitr ] SF_ID: 1258287 => |
Modified by: @pcisarassignee: Dmitry Yemanov [ dimitr ] => |
Modified by: @pcisarWorkflow: jira [ 10606 ] => Firebird [ 14943 ] |
|
Commented by: @dyemanov Provided that "? IS NULL" works in v2.5 (while requiring some support from the client side), I close this ticket as resolved. |
Modified by: @dyemanovstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 2.5 Beta 2 [ 10300 ] |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Modified by: @pavel-zotovQA Status: No test |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Submitted by: ovaron2k3 (ovaron2k3)
SFID: 1258287#
Submitted By: ovaron2k3
i'm using FB 1.5.2 on windows xp.
the bind variable is 1 char, the following gives a
string truncation exception
WHERE COALESCE(?,'') = ''
while this works
WHERE COALESCE(?,CAST('' AS VARCHAR(1))) = ''
but the best would be, if
WHERE ? IS NULL
work
The text was updated successfully, but these errors were encountered: