Constant columns getting empty value with subselect from procedure in procedure
or execute block
------------------------------------------------------------------------------------------------
Key: CORE-4073
URL: http://tracker.firebirdsql.org/browse/CORE-4073
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 Alpha 1
Environment: Win7/64, version "WI-T3.0.0.30317 Firebird 3.0 Unstable"
Reporter: Thomas Beckmann
Priority: Critical
Hard to describe, see this example:
set term ^ ;
create or alter procedure P_TEST returns (TEXT D_VC10) as
begin
TEXT = '12345'; suspend;
end^
set term ; ^
select A, TEXT from (select 2 as A, TEXT from P_TEST);
returns
A TEXT
============ ==========
0 12345
and
select A, TEXT from (select '2' as A, TEXT from P_TEST);
returns
A TEXT
====== ==========
12345
If the procedure is replaced like this
select A, TEXT from (select '2' as A, '12345' as TEXT from RDB$DATABASE);
everything works fine.
(Of course the above stuff is a simplified test case)
--
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
------------------------------------------------------------------------------
Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire
the most talented Cisco Certified professionals. Visit the
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
