Command 'SHOW PROCEDURE'  leads ISQL to crash
---------------------------------------------

                 Key: CORE-5274
                 URL: http://tracker.firebirdsql.org/browse/CORE-5274
             Project: Firebird Core
          Issue Type: Bug
          Components: ISQL
    Affects Versions: 4.0 Initial
            Reporter: Pavel Zotov
         Attachments: isql-crash-on-show-procedure-command.7z

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.




-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are 
consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
J-Flow, sFlow and other flows. Make informed decisions using capacity 
planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to