[SPARK-16994] Filter and limit are illegally permuted.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.0
• Fix Version/s: 2.0.1, 2.1.0
• Component/s: SQL
• Labels: correctness
• Assignee: Reynold Xin
• Reporter: TobiasP
• Created: 10/Aug/16 09:51
• Updated: 31/Aug/16 21:36
• Resolved: 19/Aug/16 13:12

Description

scala> spark.createDataset(1 to 100).limit(10).filter($"value" % 10 === 0).explain
== Physical Plan ==
CollectLimit 10
+- *Filter ((value#875 % 10) = 0)
   +- LocalTableScan [value#875]

scala> spark.createDataset(1 to 100).limit(10).filter($"value" % 10 === 0).collect
res23: Array[Int] = Array(10, 20, 30, 40, 50, 60, 70, 80, 90, 100)

Issue Links

• links to: [Github] Pull Request #14583 (dongjoon-hyun)
• links to: [Github] Pull Request #14713 (rxin)