You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudberry.apache.org by "hiSandog (via GitHub)" <gi...@apache.org> on 2026/07/10 02:55:34 UTC

Re: [I] [Bug] ORCA misses direct dispatch for multi-value predicates (IN / OR of equalities) on the distribution key [cloudberry]

hiSandog commented on issue #1839:
URL: https://github.com/apache/cloudberry/issues/1839#issuecomment-4931546165

   When translating the DXL dispatch values, the target content IDs should be unioned and deduplicated rather than requiring every constant to hash to one segment. The regression matrix should include values on one, several, and all segments, duplicate constants, explicit `OR`, `IN`, and a null-containing predicate, then compare ORCA with the Postgres planner's dispatch set. It is also worth preserving the all-segments fallback for non-constant or parameterized values whose segment cannot be known safely at plan time.
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@cloudberry.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cloudberry.apache.org
For additional commands, e-mail: commits-help@cloudberry.apache.org