From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
Cc: | Jason Turim <jason(at)signalvine(dot)com>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #14250: Error in subquery fails silently and parent query continues to execute |
Date: | 2016-07-14 23:42:48 |
Message-ID: | CAKFQuwZoOC2mvrJwPtw1DkRORUhzcE2qzoAiOPxhdanNp3XwbA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Thu, Jul 14, 2016 at 6:57 PM, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
wrote:
> David G. Johnston wrote:
> > On Thu, Jul 14, 2016 at 6:40 PM, Jason Turim <jason(at)signalvine(dot)com>
> wrote:
> >
> > > I see, thanks. Have you all considered making it an error to execute
> > > correlated queries without table qualifying the column names?
> > >
> > Will never happen. I'm not even sure it would be desirable in a
> > greenfield situation let alone in an established product.
>
> The problem is that this is defined by the SQL standard, so we're not at
> liberty to change it.
We as a product are at liberty to make the change.
> The opinion of several people is that it would be
> safer to require the qualification. If this were a green field I'm sure
> we'd do it differently.
>
>
The fact that it is standard is my point. A brand new database product
today would likely choose to adhere to the standard and/or prevailing
convention on this topic instead of going it alone and requiring the
qualification.
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2016-07-15 00:00:40 | Re: BUG #14246: Postgres crashing frequently |
Previous Message | Jason Turim | 2016-07-14 23:35:55 | Re: BUG #14250: Error in subquery fails silently and parent query continues to execute |