On Wednesday, December 10, 2025, ZhangChi <798604270(at)qq(dot)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.