
|
If you were logged in you would be able to see more operations.
|
|
|
| Planning Status: |
Unspecified
|
|
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.
|
|
Description
|
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.
|
Show » |
made changes - 03/Nov/09 06:28 PM
| Field |
Original Value |
New Value |
|
Assignee
|
|
Vlad Khorsun
[ hvlad
]
|
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
]
|
made changes - 03/Nov/09 11:53 PM
|
Fix Version/s
|
|
2.5 RC2
[ 10372
]
|
|
Fix Version/s
|
2.5 RC1
[ 10362
]
|
|
made changes - 05/Nov/09 12:00 AM
|
Fix Version/s
|
|
2.5 RC1
[ 10362
]
|
|
Fix Version/s
|
2.5 RC2
[ 10372
]
|
|
|