Return
-
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.