[
https://issues.apache.org/jira/browse/SPARK-60575?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hyukjin Kwon updated SPARK-60575:
---------------------------------
Affects Version/s: 4.4.0
> Preserve compound operand grouping in connector IN expressions
> --------------------------------------------------------------
>
> Key: SPARK-60575
> URL: https://issues.apache.org/jira/browse/SPARK-60575
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 5.0.0, 4.4.0
> Reporter: Linhong Liu
> Assignee: Linhong Liu
> Priority: Major
> Labels: pull-request-available
>
> V2ExpressionSQLBuilder does not group the left operand of IN. For an operand
> containing NOT, OR or another predicate, the generated SQL can parse
> differently from the original expression.
> For example, (NOT a) IN (true, false) is rendered as NOT (a) IN (true,
> false). With a=true, the original expression evaluates to true but the
> generated SQL evaluates to false.
> Reuse the existing operand-grouping helper so compound expressions are
> parenthesized. Simple references and self-delimiting expressions should
> retain their current SQL. Also cover the CASE expression generated for an
> empty IN list and TRUE/FALSE/NULL evaluation.
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
