Thread

Re: BUG #19350: Short circuit optimization missed when running sql scriptes in JDBC

David G. Johnston <david.g.johnston@gmail.com> — 2025-12-10T13:46:51Z

On Wednesday, December 10, 2025, ZhangChi <798604270@qq.com> wrote:

> Hi David J.
>
> Thanks for your reply. I wonder why this query triggers an error under
> JDBC but not in the CLI.
>

Because the planner can simplify the expression if it sees a constant null
value but cannot when everything is injected via parameter.

David J.