Re: A SQL bug/feature? Non-existent column in select of in-list subquery returns rows instead of ORA-
Date: Tue, 29 Mar 2011 10:00:41 -0700
Message-ID: <AANLkTinRJmczhDktVKSFWzk7xm403jMRNKcE-k00=++J_at_mail.gmail.com>
Yes, indeed, when the developer uses a table alias, the query does return the error as expected. Still...doesn't seem right to me. Surprised I never saw this before. I go back to early Oracle v6.
Mark
On Tue, Mar 29, 2011 at 9:51 AM, <Dominic.Brooks_at_barclayscapital.com> wrote:
> Standard name resolution behaviour going to 10, 9 and beyond.
>
> Moral of the story - always use a table alias.
>
>
>
> Cheers,
>
> Dominic
>
>
>
> _______________________________________________
>
>
>
> This e-mail may contain information that is confidential, privileged or
> otherwise protected from disclosure. If you are not an intended recipient of
> this e-mail, do not duplicate or redistribute it by any means. Please delete
> it and any attachments and notify the sender that you have received it in
> error. Unless specifically indicated, this e-mail is not an offer to buy or
> sell or a solicitation to buy or sell any securities, investment products or
> other financial product or service, an official confirmation of any
> transaction, or an official statement of Barclays. Any views or opinions
> presented are solely those of the author and do not necessarily represent
> those of Barclays. This e-mail is subject to terms available at the
> following link: www.barcap.com/emaildisclaimer. By messaging with Barclays
> you consent to the foregoing. Barclays Capital is the investment banking
> division of Barclays Bank PLC, a company registered in England (number
> 1026167) with its registered office at 1 Churchill Place, London, E14 5HP.
> This email may relate to or be sent from other members of the Barclays
> Group.**
>
> _______________________________________________
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 29 2011 - 12:00:41 CDT