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

Reply via email to