Selectable store procedure return inserted values - join not working in FB3 ---------------------------------------------------------------------------
Key: CORE-6449 URL: http://tracker.firebirdsql.org/browse/CORE-6449 Project: Firebird Core Issue Type: Bug Affects Versions: 3.0.6 Reporter: Tomas Beran I have stored procedure where I insert data to table and returning primary key of inserted data. When I write select * from PROCEDURE P left outer join TABLE T on T.PK = P.PK then in Firebird 3.0.6 T is null, but in 2.5 T containg inserted data When I create sql query in the same transaction to TABLE T - data is returned example: set term ^; create table TEST_TABLE ( PKID integer, TEXT varchar(10), constraint TEST_TABLE_PKID primary key (PKID))^ create or alter procedure TEST_PROCEDURE (text varchar(10)) returns (PKID integer) as begin select coalesce (max(PKID), 0) + 1 from TEST_TABLE into :pkid; insert into TEST_TABLE (PKID, TEXT) values (:pkid, :text); suspend; end ^ set term ;^ this query in FB 3.0.6 return null but in 2.5.9 return Hi select T.TEXT from TEST_PROCEDURE('Hi') P left outer join TEST_TABLE T on T.PKID = P.PKID; -- 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 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel