You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
Commit 35440ba
Browse filesBrowse the repository at this point in the historyBrowse files
revert: drop the array_union NULL guard in favor of #6716
The CASE WHEN <left> IS NOT NULL guard serialized the left operand twice,
in the IS NOT NULL test and in the call, so nested unions grew
exponentially: twelve nested array_union calls became 4,095 union nodes,
and each level evaluated its left operand twice.
#6716 adds a native NullShortCircuit that evaluates the left operand once
and the right operand only on the rows where the left is not NULL. It
covers array_union for every element type, so it fixes the eager
evaluation this guard was for without the duplication.
This reverts commit 88ec629.
0 commit comments