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