[ https://issues.apache.org/jira/browse/SPARK-40099?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17686249#comment-17686249 ]
daile commented on SPARK-40099: ------------------------------- [~yumwang] can you help review it again ? > Merge adjacent CaseWhen branches if their values are the same > ------------------------------------------------------------- > > Key: SPARK-40099 > URL: https://issues.apache.org/jira/browse/SPARK-40099 > Project: Spark > Issue Type: Improvement > Components: SQL > Affects Versions: 3.4.0 > Reporter: Yuming Wang > Priority: Major > > For example: > {code:sql} > CASE > WHEN f1.buyer_id IS NOT NULL THEN 1 > WHEN f2.buyer_id IS NOT NULL THEN 1 > ELSE 0 > END > {code} > The excepted result: > {code:sql} > CASE > WHEN f1.buyer_id IS NOT NULL or f2.buyer_id IS NOT NULL > THEN 1 > ELSE 0 > END > {code} -- This message was sent by Atlassian Jira (v8.20.10#820010) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org