What is the problem the feature request solves?
Follow up to #5323
Today, if a sort column isn't in the query's projection, we skip the merge and read the files unordered. We should read the sort columns anyway (even when not selected), merge on them, and drop them before returning the rows.
A sorted table should be able to report its ordering and merge when the query doesn't select the sort key.
Describe the potential solution
No response
Additional context
No response
What is the problem the feature request solves?
Follow up to #5323
Today, if a sort column isn't in the query's projection, we skip the merge and read the files unordered. We should read the sort columns anyway (even when not selected), merge on them, and drop them before returning the rows.
A sorted table should be able to report its ordering and merge when the query doesn't select the sort key.
Describe the potential solution
No response
Additional context
No response