Issue Details (XML | Word | Printable)

Key: CORE-5274
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Unassigned
Reporter: Pavel Zotov
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Command 'SHOW PROCEDURE' leads ISQL to crash

Created: 13/Jun/16 08:34 AM   Updated: 13/Jun/16 08:43 AM
Component/s: ISQL
Affects Version/s: 4.0 Initial
Fix Version/s: None

File Attachments: 1. File isql-crash-on-show-procedure-command.7z (14 kB)

Image Attachments:

1. c1356-show-proc-in-40-broken-stdout.PNG
(6 kB)

QA Status: No test


 Description  « Hide
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 person.id,
  name type of column person.name
) as
    declare variable new_id type of column 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.




 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Pavel Zotov added a comment - 13/Jun/16 08:35 AM
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.

Pavel Zotov added a comment - 13/Jun/16 08:43 AM
PPS. Output of 'SHOW PROCEDURE' statement is broken - see attached screen.