0ax1 opened a new issue, #16229: URL: https://github.com/apache/datafusion/issues/16229
### Describe the bug TPC-H queries used in context of DataFusion benchmarks are missing the `limit` clause. Limits are defined separately in full-text but not part of the reference query definition. Most likely because the `limit` clause it not part of ANSI SQL. https://www.tpc.org/tpc_documents_current_versions/pdf/tpc-h_v2.17.1.pdf E.g. query 2: <img width="768" alt="Image" src="https://github.com/user-attachments/assets/facddee8-d266-4a47-91ee-ac9d7ff65ddb" /> ### To Reproduce ``` ./bench.sh data tpch ./bench.sh run tpch 2 ``` returns 460 rows instead of 100 rows. ### Expected behavior _No response_ ### Additional context _No response_ -- 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: github-unsubscr...@datafusion.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org For additional commands, e-mail: github-h...@datafusion.apache.org