EXECUTE STATEMENT with "?" as arguments for "UPDATE <TABLE> SET <FIELD> ="
produces "-Data type unknown" exception
------------------------------------------------------------------------------------------------------------------
Key: CORE-4773
URL: http://tracker.firebirdsql.org/browse/CORE-4773
Project: Firebird Core
Issue Type: Bug
Reporter: Pavel Zotov
execute block as
declare v_stt varchar(255);
declare v_blob_a blob = 'qwertyuioplkjhgfdsazxcvbnm';
declare v_blob_b blob = '1234567890asdfghjklmnbvcxz';
begin
v_stt = 'update tb set b1 = case when id in (1,2) then ? else ? end';
execute statement ( v_stt ) ( v_blob_a, v_blob_b );
end
-- on WI-V2.5.5.26865 produres error:
Statement failed, SQLSTATE = HY004
Dynamic SQL Error
-SQL error code = -804
-Data type unknown
No such error on WI-T3.0.0.31805.
PS. 2 admin(s): please remove my post with timestamp 22/Apr/15 06:45 AM from
CORE-4752 because it is irrelevant to that.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
