[
http://tracker.firebirdsql.org/browse/CORE-5089?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pavel Zotov reopened CORE-5089:
-------------------------------
> Metadata extration (ISQL -X): "CREATE PROCEDURE/FUNCTION" statement contains
> reference to column of table(s) that not yet exists if this procedure had
> parameter of such type when it was created
> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: CORE-5089
> URL: http://tracker.firebirdsql.org/browse/CORE-5089
> Project: Firebird Core
> Issue Type: Bug
> Components: ISQL
> Affects Versions: 3.0 RC1
> Reporter: Pavel Zotov
> Assignee: Adriano dos Santos Fernandes
> Fix For: 3.0 RC2
>
> Attachments: test-metadata-extraction-core-5089.zip
>
>
> Create new database and apply this script:
> ===
> create or alter procedure sp_test (ix int) returns(ox int) as begin end;
> commit;
> recreate table test(
> x int
> );
> commit;
> set term ^;
>
> alter procedure sp_test(
> ix type of column test.x
> )
> returns(
> ox type of column test.x
> ) as
> begin
> /* foo */
> end
> ^
> set term ;^
> commit;
> ===
> Then run: ISQL -X this_database.fdb 1>metadata.log
> File "metadata.log" will contain following rows:
> ===
> SET SQL DIALECT 3;
> /* CREATE DATABASE '/3333:e30' PAGE_SIZE 8192 DEFAULT CHARACTER SET NONE; */
> COMMIT WORK;
> COMMIT WORK;
> SET AUTODDL OFF;
> SET TERM ^ ;
> /* Stored procedures headers */
> CREATE OR ALTER PROCEDURE SP_TEST (IX TYPE OF COLUMN TEST.X)
> ------------------------------------------ [ 1 ]
> RETURNS (OX TYPE OF COLUMN TEST.X)
> ---------------------------------------------------------------------------------------
> [ 2 ]
> AS
> BEGIN EXIT; END ^
> SET TERM ; ^
> COMMIT WORK;
> SET AUTODDL ON;
> /* Table: TEST, Owner: SYSDBA */
> CREATE TABLE TEST (X INTEGER);
> COMMIT WORK;
> SET AUTODDL OFF;
> SET TERM ^ ;
> /* Stored procedures bodies */
> ALTER PROCEDURE SP_TEST (IX TYPE OF COLUMN TEST.X)
> RETURNS (OX TYPE OF COLUMN TEST.X)
> AS
> begin
> /* foo */
> end ^
> SET TERM ; ^
> COMMIT WORK;
> SET AUTODDL ON;
> ===
> This script will not be compiled because of invalid references marked as [ 1
> ] and [ 2 ].
> PS. Found while preparing test for CORE-2792; I'm not sure that this issue
> should be added there thus created new ticket.
--
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
------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
