Re: planner bug regarding lateral and subquery?

Hi David and Stephen,

On 2018/03/14 12:59, David G. Johnston wrote:
> On Tuesday, March 13, 2018, Tatsuro Yamada <yamada(dot)tatsuro(at)lab(dot)ntt(dot)co(dot)jp <mailto: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.

Thank you for the explanation.
I understand that it's a runtime error and not able to avoid in parser and planner. :)

Thanks,
Tatsuro Yamada