Issue Details (XML | Word | Printable)

Key: CORE-2424
Type: Improvement Improvement
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Adriano dos Santos Fernandes
Reporter: Cosmin Apreutesei
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

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

Created: 13/Apr/09 12:39 PM   Updated: 23/Jun/11 02:54 PM
Component/s: Engine
Affects Version/s: 2.5 Beta 1
Fix Version/s: 2.5 Beta 2

Time Tracking:
Not Specified

Issue Links:
Relate
 

Planning Status: Unspecified


 Description  « Hide
Currently, CREATE VIEW forces me to specify column names when I select grouped fields. I see the field names are inferred correctly for subselects though.



 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Sean Leyne added a comment - 13/Apr/09 01:45 PM
Please provide an example.

Cosmin Apreutesei added a comment - 15/Apr/09 04:30 AM
create view V as select d.rdb$relation_id from rdb$database d group by d.rdb$relation_id

Invalid command.
must specify column name for view select expression.

Adriano dos Santos Fernandes added a comment - 22/Apr/09 07:20 AM
Another case:
recreate view V as select a from (select 1 a from rdb$database);