lovasoa opened a new pull request, #1733:
URL: https://github.com/apache/datafusion-sqlparser-rs/pull/1733

   The primary motivation for this change is to fix the visitor traversal order 
for CASE expressions. In SQL, CASE expressions follow a specific syntactic 
order (e.g., `CASE a WHEN 1 THEN 2 WHEN 3 THEN 4 ELSE 5`), AST visitors now 
process nodes in the same order as they appear in the source code. The previous 
implementation, using separate `conditions` and `results` vectors, would visit 
all conditions first and then all results, which didn't match the source order. 
The new `CaseWhen` structure ensures visitors process expressions in the 
correct order: `a,1,2,3,4,5`.
   
   A secondary benefit is making invalid states unrepresentable in the type 
system. The previous implementation using parallel vectors (`conditions` and 
`results`) made it possible to create invalid CASE expressions where the number 
of conditions didn't match the number of results. When this happened, the 
`Display` implementation would silently drop elements from the longer list, 
potentially masking bugs. The new `CaseWhen` struct couples each condition with 
its result, making it impossible to create such mismatched states.
   
   While this is a breaking change to the AST structure, sqlparser has a 
history of making such changes when they improve correctness. I don't expect 
significant downstream breakages, and the benefits of correct visitor ordering 
and type safety are significant, so I think the trade-off is worthwhile.
   


-- 
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: github-unsubscr...@datafusion.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For additional commands, e-mail: github-h...@datafusion.apache.org

Reply via email to