2010YOUY01 commented on PR #13028: URL: https://github.com/apache/datafusion/pull/13028#issuecomment-2429157042
> @2010YOUY01 good point! do you maybe know what is the use-case for allowing fractional values for LIMIT or OFFSET? Not really, allowing fractional values looks quite bizarre to me, however, nowadays many SQL are auto-generated so we can't make too many assumptions > 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 way it requires lots of effort to match PostgreSQL's behavior 🤔 Maybe it should be left to a later task -- 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]
