Skip to content

TPC-H queries used in DataFusion are missing limit clause #16229

@0ax1

Description

@0ax1

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 is not part of ANSI SQL.

https://www.tpc.org/tpc_documents_current_versions/pdf/tpc-h_v2.17.1.pdf

E.g. query 2:

Image

To Reproduce

./bench.sh data tpch
./bench.sh run tpch 2

returns 460 rows instead of 100 rows.

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions