terrymanu commented on issue #36047:
URL:
https://github.com/apache/shardingsphere/issues/36047#issuecomment-3677675743
Root Cause: Same class as #29672: PostgreSQL parse layer recursion on
extremely large inputs exhausts resources. #29672 hits stack overflow from
IN-list left recursion plus recursive visitors; this case hits heap OOM from
recursive decomposition and node duplication of
large boolean chains. Both fail during SQL parsing.
Analysis:
- Trigger stage: parsing/condition extraction, not routing or execution.
- Path difference: IN-list vs AND/OR chains; shared root cause is
recursive/expansive parsing without flattening or limiting, causing linear or
worse growth in stack/memory.
- Version: 5.1.2 lacks optimizations for large boolean expressions;
comments already note further optimization is needed.
Conclusion: This is the same class of issue as #29672. Mark as duplicate
and consolidate follow-up and details (stack trace, SQL scale) in #29672.
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
