Revisit required_child_distribution(), output_partitioning(), output_ordering() implementations in ExecutionPlan's implementations

[mingmwang]

Describe the bug
A clear and concise description of what the bug is.

Looks like couple of physical plan implementations do not implement those methods correctly.

To Reproduce
Steps to reproduce the behavior:

Expected behavior
A clear and concise description of what you expected to happen.

Additional context
Add any other context about the problem here.