Hi, i've tried Firebird 2 new feature to try out the improvement. It
is a great improvement i'd said, Congratulation to all the developer
team.

But i've found some feature missing and actually don't know if someone
else agree with me.

I've tried to create a view from a select query with union, it works
greater than before since it support union selection to create view.
But FB2 still need to define the column name for the view if the
select query did not select all field.

What i want is:

CREATE VIEW UJIVIEW2 AS
SELECT ID,19 KODE FROM UJI
UNION
SELECT ID, KODE FROM UJI2;

and will show view with columns:
ID, KODE

Thanks
--
Iwan Cahyadi Sugeng