[#CORE-1402] CREATE VIEW without column list when UNION is used

Firebird Core

CREATE VIEW without column list when UNION is used

Created: 03/Aug/07 03:04 AM Updated: 23/Jun/11 10:03 AM

Component/s:

Engine

Affects Version/s:

2.1 Beta 1

Fix Version/s:

2.5 Beta 2

Time Tracking:

Not Specified

Issue Links:

Relate

This issue relate to:

~~CORE-2424~~ Make CREATE VIEW infer column names for views involving a GROUP BY clause or derived table

This issue is related to:

~~QA-301~~ Test for CORE-1402

Description

« Hide

Column list should not be required when creating views based on UNION statements.
Column names should be the same as when the SELECT query is run outside the view.

"The column identifiers of the output set are those specified in the first SELECT specification.
If you would like to use alternative column names, column aliasing can be used in the
output list of the first SELECT specification"

All

Comments

Work Log

Change History

Version Control

Subversion Commits

Sort Order:

[ Permalink | « Hide ]

Dmitry Yemanov added a comment - 27/Apr/09 11:38 PM

Test cases:

recreate view V1 as
select d.rdb$relation_id from rdb$database d
union all
select d.rdb$relation_id from rdb$database d

recreate view V2 as
select d.rdb$relation_id as q from rdb$database d
union all
select d.rdb$relation_id as w from rdb$database d

recreate view V3 as
select a from (select 1 a from rdb$database)
union all
select b from (select 1 b from rdb$database)

recreate view V4 as
select a as a1 from (select 1 a from rdb$database)
union all
select b as b1 from (select 1 b from rdb$database)