stevomitric opened a new pull request, #58810: URL: https://github.com/apache/spark/pull/58810
### What changes were proposed in this pull request? Replace multi-value UNPIVOT’s COALESCE null filter with independent IS NOT NULL checks joined by OR. Add parser and mixed-type regression tests. ### Why are the changes needed? COALESCE requires a common type, causing valid UNPIVOT queries with unrelated value types, such as DATE and INT, to fail analysis. ### Does this PR introduce _any_ user-facing change? Yes. Multi-value UNPIVOT EXCLUDE NULLS now supports mixed types and removes only rows where every value is null. ### How was this patch tested? New test in the PR. ### Was this patch authored or co-authored using generative AI tooling? Co-Authored-by: OpenAI Codex (GPT-5) -- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
