I wouldn't mind automatic naming (e.g. by automatically assigning AVG_X, AVG_X1, AVG_X2 as the field names in your example), but I would get annoyed if Firebird implemented it the same way as you demonstrate with MySQL and made the automatically named columns case sensitive requiring the new field name to be double quoted.

Is this a feature worth having? I don't know, I've never missed it. Though there's of course no reason to complicate moving from other databases to Firebird.

Set

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Bill Oliver
Sent: 28. mai 2008 14:34
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Column name for view select expression?

Thanks guys, I appreciate the help.

I can enter a tracker if you think this is a feature we want to add
to Firebird in the future. I asked my co-worker about this, and he
put it in the category of "midly annoying". I guess you get used to a
certain database, and its sql dialect, and then when something is
missing it bugs you.

If you get used to something else to start with, you never notice the
missing feature. ;-)

-bill

--- In firebird-support@yahoogroups.com, "Sandor Tamas" wrote:
>
> Yes, it is...It is so intelligent, you don't have to be... It does
> the work you should do. It creates names automatically.
>
> And then, you can have a bunch of "SHOW CREATE TABLE", and other
> tools to find out the names of those auto-created columns....
>
> SanTa
>
> --- In firebird-support@yahoogroups.com, "Bill Oliver" wrote:
> >
> > With MySQL, at least, they auto name the columns...
> >
> > mysql> CREATE VIEW V3 AS SELECT AVG(X), avg(x), avg(x) FROM T1;
> > Query OK, 0 rows affected (0.00 sec)
> >
> >
> > mysql> select * from v3;
> > +--------+---------------+-----------------+
> > | AVG(X) | My_exp_avg(x) | My_exp_1_avg(x) |
> > +--------+---------------+-----------------+
> > | NULL | NULL | NULL |
> > +--------+---------------+-----------------+
> > 1 row in set (0.00 sec)
> >
> >
> > --- In firebird-support@yahoogroups.com, Dmitry Yemanov wrote:
> > >
> > > Bill Oliver wrote:
> > >
> > > > My co-worker wonders why we check this case? It seems that MySQL and
> > > > Oracle let you create the view fine.
> > >
> > > I'm wondering what name do they assign to the view column? X? AVG?
> > > Something auto-generated? What if the sample would be a bit more
> > > complicated, containing duplicated fields/expressions?
> > >
> > >
> > > Dmitry