Submitted by: Claudio Valderrama C. (robocop)

Assigned to: Claudio Valderrama C. (robocop)

When a parameters depends on a table field, the syntax is TYPE OF COLUMN. This was done in the SHOW PROCEDURE code but not when extracting a full script:

F:\fb2dev\fbbuild\firebird25\temp\Win32\Debug\firebird\bin>isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database 'badproc.fdb';
SQL> create table t(a int);
SQL> create procedure p(p_a type of column t.a) as begin end;
SQL> ^Z

F:\fb2dev\fbbuild\firebird25\temp\Win32\Debug\firebird\bin>isql -x BADPROC.FDB
Database: BADPROC.FDB

SET SQL DIALECT 3;

/* CREATE DATABASE 'BADPROC.FDB' PAGE_SIZE 4096 DEFAULT CHARACTER SET NONE */

/* Table: T, Owner: ATENEA\CLAUDIO */
CREATE TABLE T (A INTEGER);
COMMIT WORK;
SET AUTODDL OFF;
SET TERM ^ ;

/* Stored procedures */
CREATE PROCEDURE P (P_A TYPE OF T.A)
AS
BEGIN EXIT; END ^

ALTER PROCEDURE P (P_A TYPE OF T.A)
AS
begin end ^
SET TERM ; ^
COMMIT WORK ;
SET AUTODDL ON;

Should be TYPE OF COLUMN T.A instead.

Commits: d2013e6 50f7202

====== Test Details ======

Test not needed here: see test for CORE5089 instead.