Hi David and Stephen,

On 2018/03/14 12:59, David G. Johnston wrote:
On Tuesday, March 13, 2018, Tatsuro Yamada <yamada.tats...@lab.ntt.co.jp 
<mailto:yamada.tats...@lab.ntt.co.jp>> wrote:

    Hi Hackers,

    I found a bug, maybe.
    If it is able to get an explain command result from below query 
    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 

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. :)

Tatsuro Yamada

Reply via email to