Referencing a column from select and order by clauses triggers duplicate expression error

[kawadakk]

Describe the bug

Referencing a column from a certain form of select and order by clauses causes an error saying "projections require unique expression names".

To Reproduce

> create table foo as values (1, 2), (3, 4), (5, 6);
0 row(s) fetched.
Elapsed 0.002 seconds.

> select cast(column1 as text) from foo order by column1;
Error during planning: Projections require unique expression names but the expression "CAST(foo.column1 AS Utf8)" at position 0 and "foo.column1" at position 1 have the same name. Consider aliasing ("AS") one of them.

Expected behavior

Successful query execution

Additional context

DataFusion v43.0.0

[jatin510]

take

[findepi]

@jatin510 what's your idea for the fix?
fwiw i tried to fix this for select clauses (#13489), but run into some fundamental issues with my approach

[jatin510]

I was trying to modify the project function in the logical plan, builder.rs.
To give define manual cast to the projection, in which cast is not defined explicitly.

you think its good approach ? @findepi

[findepi]

You mean cast or alias?