[PR] fix: fdw/external support filter pushdown for numeric columns with integer constants [cloudberry-pxf]

["MisterRaindrop (via GitHub)" <gi...@apache.org>]

MisterRaindrop opened a new pull request, #103:
URL: https://github.com/apache/cloudberry-pxf/pull/103

   <!--Thank you for contributing! -->
   
   <!--In case of an existing issue or discussions, please reference it-->
   
   <!--Remove this section if no corresponding issue.-->
   
   ---
   
   ## Change logs
   
   When a numeric column is compared with an integer constant (e.g.,
       biz_dt = 20260331), PostgreSQL wraps the constant in an implicit
       type cast FuncExpr (int4 -> numeric). The filter extraction code
       only recognized plain Const nodes, causing these filters to be
       dropped and resulting in full table scans on the source.
   
   ## Contributor's checklist
   
   Here are some reminders before you submit your pull request:
   
   * Make sure that your Pull Request has a clear title and commit message. You can take the [Git commit template](https://github.com/apache/cloudberry/blob/main/.gitmessage) as a reference.
   * Learn the [code contribution](https://cloudberry.apache.org/contribute/code) and [doc contribution](https://cloudberry.apache.org/contribute/doc) guides for better collaboration.
   * Make sure that CICD workflow is successful.
   * List your communications in the [GitHub Issues](https://github.com/apache/cloudberry-pxf/issues) or [Discussions](https://github.com/apache/cloudberry/discussions) (if has or needed).
   * Feel free to ask for the [cloudberry committers](https://github.com/orgs/apache/teams/cloudberry-committers) or other people to help review and approve.


-- 
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

Re: [PR] fix: fdw/external support filter pushdown for numeric columns with integer constants [cloudberry-pxf]

["MisterRaindrop (via GitHub)" <gi...@apache.org>]

MisterRaindrop merged PR #103:
URL: https://github.com/apache/cloudberry-pxf/pull/103


-- 
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