Github user mgaido91 commented on a diff in the pull request:
https://github.com/apache/spark/pull/19522#discussion_r145269515
--- Diff:
sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/optimizer/expressions.scala
---
@@ -176,6 +176,8 @@ object ReorderAssociativeOperator extends
Rule[LogicalPlan] {
object OptimizeIn extends Rule[LogicalPlan] {
def apply(plan: LogicalPlan): LogicalPlan = plan transform {
case q: LogicalPlan => q transformExpressionsDown {
+ case expr @ In(v, _) if expr.isListEmpty =>
+ If(IsNull(v), Literal.create(null, BooleanType), FalseLiteral)
--- End diff --
sorry, but I can't understand your suggestion: `Coalesce` returns the first
non-null value. Here we should return `Null` when the value is null, `false`
otherwise. I can't think of a function doing this.
---
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
