Affects Version/s: None
Fix Version/s: 0.4.0
There are two issues in several Drill Logical Rule.
1. When we call convert() to convert the child node from 'None' to 'Logical', we pass in the parent's trait. This may not be right.
In DrillFilterRule, we will pass filter's trait when convert sort. Since filter originally has empty RelCollation, this convert will produce a trivial sort, thus may get a logical plan with incorrect order.
2. The logical rule does not propagate the trait from child to parent, whenever possible. For instance, for the prior example, because filter's child is sort, after sort is converted into logical, the filter also has the same RelCollation as its child. We should propagate such RelCollation to Filter.