Regression: Ordering by joined column doesn't return results #8374
Description
Describe the bug
After update to datafusion: 33 I've noticed wrong behavior for our internal test with sorting by multiple columns.
It used to work in datafusion: 31
To Reproduce
MRE with datafusion-cli:
CREATE TABLE users AS VALUES('Alice',50),('Bob',100);
CREATE TABLE employees AS VALUES('Alice','Finance'),('Bob','Marketing');
SELECT u.* FROM users u JOIN employees e ON u."column1" = e."column1" ORDER BY u."column1", e."column2";
0 rows in set. Query took 0.002 seconds.But at the same time, without ordering by joined column it works:
SELECT u.* FROM users u JOIN employees e ON u."column1" = e."column1" ORDER BY u."column1";
+---------+---------+
| column1 | column2 |
+---------+---------+
| Alice | 50 |
| Bob | 100 |
+---------+---------+
2 rows in set. Query took 0.002 seconds.Expected behavior
It should work as before
Additional context
No response