Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
plan for this query is as follows: It adds a column of in clause to the result of the left subtree, which may be true, false, or null. In a distributed environment, repartitioning and writing this operator to disk will easily cause errors in the calculations related to null values. For example, if