alamb commented on issue #19654: URL: https://github.com/apache/datafusion/issues/19654#issuecomment-3751672375
FWIW SQL doesn't constraint the ordering of a query, so a query like `SELECT * FROM t LIMIT 10` is not well specified in the sense the database is free to return any arbitrary rows. For example it is free to return different rows the next time `SELECT * FROM t LIMIT 10` is run, even if no data changes in between Similarly, it would be correct (though probably not what the user wants) for these queries to return the same results * `SELECT * FROM t LIMIT 10` * `SELECT * FROM t LIMIT 10 OFFSET 10` * `SELECT * FROM t LIMIT 10 OFFSET 10000` So the point being that offset and limit only really make sense when there is an ORDER BY clause attached too -- 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]
