[Firebird-devel] [ firebird-Bugs-1258287 ] COALESCE with bind variables

[SourceForge.net <no...@so...>]

Bugs item #1258287, was opened at 2005-08-13 11:19
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=109028&aid=1258287&group_id=9028

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: André Meyer (ovaron2k3)
Assigned to: Nobody/Anonymous (nobody)
Summary: COALESCE with bind variables

Initial Comment:
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

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=109028&aid=1258287&group_id=9028