DDtKey opened a new issue, #8374:
URL: https://github.com/apache/arrow-datafusion/issues/8374
### 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:
```sql
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 second ordering it works:
```sql
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_
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
