Metadata extration (ISQL -X): "CREATE VIEW" statement contains reference to
column of another view that not yet exists
-----------------------------------------------------------------------------------------------------------------------
Key: CORE-5094
URL: http://tracker.firebirdsql.org/browse/CORE-5094
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.5, 3.0 RC1
Reporter: Pavel Zotov
Run on empty database (it will be compiled without exceptions):
===
set bail on;
set echo on;
create view v1 as select 'foo' as foo, current_timestamp as bar from
rdb$database;
create view v2 as select 'bar' as foo, current_timestamp as bar from v1;
alter view v1 as
select
(select foo from v2 rows 1) as foo,
(select bar from v2 rows 1) as bar
from rdb$database;
commit;
===
Then:
1) echo set echo on; set bail on; > test_meta.sql & isql /:e30 -x
>>test_meta.sql
2) restore (or create again) empty database
3) isql /:e30 -i test_meta.sql
Output will be:
===
C:\MIX\firebird\QA\fbt-repo\tmp>isql /:e30 -i test_meta.sql
SET SQL DIALECT 3;
/* CREATE DATABASE '/:e30' PAGE_SIZE 8192 DEFAULT CHARACTER SET NONE; */
COMMIT WORK;
/* View: V1, Owner: SYSDBA */
CREATE VIEW V1 (FOO, BAR) AS
select
(select foo from v2 rows 1) as foo,
(select bar from v2 rows 1) as bar
from rdb$database;
Statement failed, SQLSTATE = 42S02
unsuccessful metadata update
-CREATE VIEW V1 failed
-Dynamic SQL Error
-SQL error code = -204
-Table unknown
-V2
-At line 3, column 29
After line 8 in file test_meta.sql
===
Checked on: WI-V2.5.6.26965; WI-V3.0.0.32300.
--
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
