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

Reply via email to