I know there was a lot of talk about columns names a while back and i
don't want to start it all up again, but i have noticed some things in
the 3.2.2 release that seem a little odd to me.
if i write a query as follows:
select a.id, b.stuff
from a inner join b on a.id=b.id;
The column names come back as i expected they would: id, stuff.
If however, i create the following view:
create view aview as
select a.id, b.stuff
from a inner join b on a.id=b.id;
The column names don't come back as i expected they would instead they
are: a.id, b.stuff. I would have expected that to return the same
thing as the query. Obviously not a big deal to work around.. but
thought it was odd.
The same sort of thing happens on an in-line view or subselect. Take
the fictitious example below:
select a.id, tmpb.stuff
from a inner join
(
select b.id, b.stuff
from b
) as tmpb
on tmpb.id=a.id;
The work-around for this is of course to explicitly alias your columns
to the names you were expecting, but it is probably worth changeing if
only to make it more intuitive and consistent.
thanks
--preston
