Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Alter procedure allows to add the parameter with the same name. [CORE3509] #3867

Closed
firebird-automations opened this issue Jun 3, 2011 · 7 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Petr Gurin (gurin)

Is related to QA485

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

Commits: 37c6106 FirebirdSQL/fbt-repository@1e1cc0a

@firebird-automations
Copy link
Collaborator Author

Modified by: Petr Gurin (gurin)

Version: 2.5.1 [ 10333 ]

Version: 3.0 Alpha 1 [ 10331 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Looks like regression in v2.5.

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).

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

Version: 2.5.1 [ 10333 ] =>

Version: 3.0 Alpha 1 [ 10331 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.5.1 [ 10333 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to QA485 [ QA485 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pmakowski

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: Done successfully

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants