TPC-E queries lack LIMIT clause (186830)

Chat now with support

Return

Feedback Submitted

Was this article helpful?

Select Rating

Title

TPC-E queries lack LIMIT clause
Description

TPC-E query belonging to transaction "CUSTOMER-POSITION_Frame 2" and "TRADE-STATUS_Frame 1" does not contain the required LIMIT clause, resulting in these queries returning tens of thousands of rows, instead of 30 or 50.
Cause

Benchmark Factory employs as generic a SQL as possible to apply to all databases and there is just no generic limit clause. It may even be possible that not all ODBC databases that are support have a limit clause.
Resolution

WORKAROUND: None
STATUS: Waiting for fix in a future release of Benchmark Factory for Databases.

Feedback Submitted

Was this article helpful?

Select Rating

Title