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

Command 'SHOW PROCEDURE' leads ISQL to crash [CORE5274] #5552

Open
firebird-issue-importer opened this issue Jun 13, 2016 · 4 comments
Open

Command 'SHOW PROCEDURE' leads ISQL to crash [CORE5274] #5552

firebird-issue-importer opened this issue Jun 13, 2016 · 4 comments

Comments

@firebird-issue-importer

Submitted by: @pavel-zotov

Attachments:
isql-crash-on-show-procedure-command.7z
c1356-show-proc-in-40-broken-stdout.PNG

Run:

create or alter procedure sp_ins_person as begin end;
commit;
recreate table person (
id integer,
name varchar(40)
);
commit;

set term ^;
create or alter procedure sp_ins_person (
id type of column http://person.id,
name type of column http://person.name
) as
declare variable new_id type of column http://person.id;
begin
insert into person (id, name) values (:id, :name) returning id into :new_id;
end^
set term ;^
commit;
show procedure sp_ins_person; --- [ A ]

Standard window about process crash will appear if statement "show procedure ..." is NOT commented.
Dump and error signature see in attached file.

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 13, 2016

Modified by: @pavel-zotov

Attachment: isql-crash-on-show-procedure-command.7z [ 12971 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 13, 2016

Commented by: @pavel-zotov

PS. Found while analyzing failed results of test for core-1356 but it seems to me that this case is not related to that core.

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 13, 2016

Commented by: @pavel-zotov

PPS. Output of 'SHOW PROCEDURE' statement is broken - see attached screen.

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 13, 2016

Modified by: @pavel-zotov

Attachment: c1356-show-proc-in-40-broken-stdout.PNG [ 12972 ]

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
1 participant