Change output ordering display of sources

[mustafasrepo]

Is your feature request related to a problem or challenge?

Current source executors(CsvExec, etc.) contains outpout_ordering inside display. For the following table

CREATE EXTERNAL TABLE multiple_ordered_table (
  a0 INTEGER,
  a INTEGER,
  b INTEGER,
  c INTEGER,
  d INTEGER
)
STORED AS CSV
WITH HEADER ROW
WITH ORDER (a ASC, b ASC)
WITH ORDER (c ASC)
LOCATION '../core/tests/data/window_2.csv';

display would be

----CsvExec: file_groups={1 group: [[path]]}, projection=[a, b], output_ordering=[a@0 ASC NULLS LAST, b@1 ASC NULLS LAST], has_header=true

It would be nice, if output ordering would contain all of the valid orderings at the source such as following

----CsvExec: file_groups={1 group: [[path]]}, projection=[a, b], output_orderings=[[a@0 ASC NULLS LAST, b@1 ASC NULLS LAST], [c@2 ASC NULLS LAST]], has_header=true

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response

[alamb]

I agree this would be a great first issue

I think the relevant code is https://github.com/apache/arrow-datafusion/blob/b46b7c0ea27e7c5ec63f5367ed04c9612a32d717/datafusion/core/src/datasource/physical_plan/mod.rs#L138-L142

[QuenKar]

hi, I am new here and curious about this.

[mustafasrepo]

Thanks @QuenKar!