Issue Details (XML | Word | Printable)

Key: CORE-2729
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Vlad Khorsun
Reporter: Vlad Khorsun
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Current connection may be used by EXECUTE STATEMENT instead of creation of new attachment

Created: 03/Nov/09 06:23 PM   Updated: 05/Nov/09 12:00 AM
Return to search
Issue 67 of 81 issue(s)
<< Previous | CORE-2729 | Next >>
Component/s: Engine
Affects Version/s: 2.5 Alpha 1, 2.5 Beta 1, 2.5 Beta 2
Fix Version/s: 2.5 RC1, 3.0 Alpha 1

Time Tracking:
Not Specified

Planning Status: Unspecified


 Description  « Hide
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.


 All   Comments   Work Log   Change History   Version Control      Sort Order: Ascending order - Click to sort in descending order
Vlad Khorsun made changes - 03/Nov/09 06:28 PM
Field Original Value New Value
Assignee Vlad Khorsun [ hvlad ]
Vlad Khorsun made changes - 03/Nov/09 09:04 PM
Fix Version/s 2.5 RC1 [ 10362 ]
Fix Version/s 3.0 Alpha 1 [ 10331 ]
Resolution Fixed [ 1 ]
Status Open [ 1 ] Resolved [ 5 ]
Dmitry Yemanov made changes - 03/Nov/09 11:53 PM
Fix Version/s 2.5 RC2 [ 10372 ]
Fix Version/s 2.5 RC1 [ 10362 ]
Dmitry Yemanov made changes - 05/Nov/09 12:00 AM
Fix Version/s 2.5 RC1 [ 10362 ]
Fix Version/s 2.5 RC2 [ 10372 ]