Hi All, Is there a way to push Sort RelNode collation trait down to its children? Let say I have the following rel tree
LogicalSort LogicalProject LogicalFilter LogicalScan and the goal is to push the collation trait all the way to the Scan node to transform it to something like that PhysicalProject PhysicalFilter PhysicalScan with CollationTrait or PhysicalProject PhysicalFilter PhysicalSort PhysicalScan I have a rule that matches the sort node and transforms it to a result of its input convert call where the collation trait together with the physical convention trait is added to the child's trait set. The rule seems to be firing but the collation trait is not propagated down - the result of the Logical to Physical Scan conversion rule does not have it. If this approach is not possible what could be an alternative? Have various transpose rules to position the sort rel just above the scan? Thanks, Mike