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-issue-importer opened this issue Jun 3, 2011 · 7 comments

Comments

@firebird-issue-importer
Copy link

@firebird-issue-importer firebird-issue-importer commented Jun 3, 2011

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 22, 2011

Modified by: Petr Gurin (gurin)

Version: 2.5.1 [ 10333 ]

Version: 3.0 Alpha 1 [ 10331 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 27, 2011

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 27, 2011

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

Version: 2.5.1 [ 10333 ] =>

Version: 3.0 Alpha 1 [ 10331 ] =>

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 27, 2011

Modified by: @hvlad

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

resolution: Fixed [ 1 ]

Fix Version: 2.5.1 [ 10333 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Mar 27, 2014

Modified by: @pcisar

Link: This issue is related to QA485 [ QA485 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 8, 2014

Modified by: @pmakowski

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented May 29, 2015

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
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants