| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Tatsuro Yamada <yamada(dot)tatsuro(at)lab(dot)ntt(dot)co(dot)jp> |
| Cc: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: planner bug regarding lateral and subquery? |
| Date: | 2018-03-14 03:59:34 |
| Message-ID: | CAKFQuwadB8zo453WtCjS+GTzH=rJMPPNf8AmKY6Peg7HgMn6bA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tuesday, March 13, 2018, Tatsuro Yamada <yamada(dot)tatsuro(at)lab(dot)ntt(dot)co(dot)jp>
wrote:
> Hi Hackers,
>
> I found a bug, maybe.
> If it is able to get an explain command result from below query
> successfully,
> I think that it means the query is executable.
>
There is a difference between executable, compilable, and able to execute
to completion, runtime, on specific data. You've proven the former but as
the error indicates specific data causes the complete execution of the
query to fail.
I can write "select cola / colb from tbl" and as long as there are no zeros
in colb the query will complete, but if there is you get a divide by zero
runtime error. This is similar.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavan Deolasee | 2018-03-14 04:36:07 | Re: Faster inserts with mostly-monotonically increasing values |
| Previous Message | Stephen Frost | 2018-03-14 03:36:22 | Re: planner bug regarding lateral and subquery? |