|
If you were logged in you would be able to see more operations.
|
|
|
|
Environment:
|
Apperars on Windows and Linux operating system, affects Fb 2.5.0. Other operating system and I haven't tried
|
|
| Planning Status: |
Unspecified
|
|
alter procedure allows to add input or output parameter with the same name. Selecting from procedure with such parameters crushes the server.
create or alter procedure Double_Params
returns
(ValueInt Integer)
as
begin
ValueInt = 1;
Suspend;
end;
Commit;
create or alter procedure Double_Params
returns
(ValueInt Integer,
ValueInt Integer)
as
begin
ValueInt = 1;
Suspend;
end;
Commit;
select * from Double_Params
|
|
Description
|
alter procedure allows to add input or output parameter with the same name. Selecting from procedure with such parameters crushes the server.
create or alter procedure Double_Params
returns
(ValueInt Integer)
as
begin
ValueInt = 1;
Suspend;
end;
Commit;
create or alter procedure Double_Params
returns
(ValueInt Integer,
ValueInt Integer)
as
begin
ValueInt = 1;
Suspend;
end;
Commit;
select * from Double_Params |
Show » |
|
Bug
Resolved
Major
Alter procedure allows to add the parameter with the same name.
Both 2.1 and 3.0 throws
violation of PRIMARY or UNIQUE KEY constraint "RDB$INDEX_51" on table "RDB$PROCEDURE_PARAMETERS".
error (2.1 have another constraint name).