Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
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.
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Recommended Content
Product(s):
Benchmark Factory for Database
8.0, 7.6.1, 7.6, 7.5, 7.4, 7.3
Topic(s):
Troubleshooting
Article History:
Created on: 2/9/2016 Last Update on: 2/9/2016
Author:
Jon Lin
Thank you for your feedback for Topic Request
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Welcome to Quest Support
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.