Current connection may be used by EXECUTE STATEMENT instead of creation of new attachment
-----------------------------------------------------------------------------------------
Key: CORE-2729
URL:
http://tracker.firebirdsql.org/browse/CORE-2729 Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5 Beta 2, 2.5 Beta 1, 2.5 Alpha 1
Reporter: Vlad Khorsun
create user test password 'test';
commit;
execute block
returns (o_att_id int, o_user varchar(32))
as
begin
o_att_id = CURRENT_CONNECTION;
o_user = CURRENT_USER;
suspend;
-- should use current connection
execute statement 'select CURRENT_CONNECTION, CURRENT_USER from rdb$database'
into :o_att_id, :o_user;
suspend;
-- should use distinct connection
execute statement 'select CURRENT_CONNECTION, CURRENT_USER from rdb$database'
as user 'test' password 'test'
into :o_att_id, :o_user;
suspend;
end
All 3 rows returns the same values while 3rd row must not return the same values as 1st and 2nd.
--
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
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.
http://p.sf.net/sfu/bobj-julyFirebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
