raghavyadav01 commented on issue #26779:
URL: https://github.com/apache/datafusion/issues/26779#issuecomment-6427979009

   I cannot reproduce this on main at 833f499. Every shape in the report keeps 
the sort key:
   
   - `k / 10 = 5`
   - `k / 10 IN (5)`
   - `k / 10 BETWEEN 5 AND 5`
   - `k / 10 >= 5 AND k / 10 <= 5`
   - `CAST(ts AS DATE) = DATE '2024-01-06'` with `ORDER BY ts`
   
   The first four all plan as `SortExec: expr=[k@0 ASC NULLS LAST, id@1 ASC 
NULLS LAST]`, and the timestamp one keeps `ts`. Same in-memory single-partition 
table as your repro.
   
   So it looks fixed somewhere between 55.0.0 and main. I did not bisect to the 
commit.
   
   Worth adding the regression test anyway, since the related reports from the 
same constant handling are still open (#26623, #26624).
   


-- 
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]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to