Pre discussion see in
https://issues.apache.org/jira/browse/CALCITE-2798
https://issues.apache.org/jira/browse/CALCITE-3664
IMO, we should at least provide a configuration about this. People use Calcite most for its optimizer, and this info users may care, How it executed is by the engine, but users should know this in the plan.
- is caused by
-
CALCITE-2798 Optimizer should remove ORDER BY in sub-query, provided it has no LIMIT or OFFSET
-
- Closed
-
- is duplicated by
-
CALCITE-3664 Sort in subquery is lost when converting SqlNode to Relnode
-
- Closed
-
- links to