berkaysynnada commented on issue #5200:
URL: https://github.com/apache/arrow-rs/issues/5200#issuecomment-1850254018

   AFAIK Postgre defines a month as exactly 30 days. While this simplification 
facilitates certain implementations, it can potentially introduce silent bugs. 
In our DataFusion fork, we have implemented a PartialOrd with semantics as 
described in [this 
comment](https://github.com/apache/arrow-rs/pull/5180#issuecomment-1845348496). 
In short, our implementation treats '1 month < 30 days' as false and '1 month 
>= 30 days' as false. However, '1 month + 1 day > 1 month' is true, and '1 
month > 27 days' is also true. The fix also addresses problematic cases 
involving negative-signed LSD blocks.
   
   If you're interested in how such an implementation could be integrated into 
DataFusion, we can help with the process.


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

Reply via email to