findepi commented on PR #13028: URL: https://github.com/apache/datafusion/pull/13028#issuecomment-2429111288
> Postgres's behavior is: if `OFFSET` is not integer for example 0.5, 0th row won't be included, if `LIMIT` is 0.5, then 0th row would be included: @2010YOUY01 good point! do you maybe know what is the use-case for allowing fractional values for LIMIT or OFFSET? this looks like a pandora box. strictly speaking, casting them to integral values isn't exactly what we can do: `OFFSET 1.5 LIMIT 1.5` should return 3rd row, but not the 4th row. -- 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]
