JDBC Request: Allow to only fetch a certain number of rows

[asfimport]

Franz Schwab (Bug 63561):
How about enhancing the JDBC sampler to only fetch a certain number of rows from the database (the result set of a select query)?

My use case is database load testing. In 99% of the cases I use the JDBC sampler for, I am only interested in the time it took the database to run the query.
I am not interested in the time it took the client (JMeter in that case) to fetch the result set.
A BI client for example might run a query with a big result set, but maybe only fetch the first 100 rows and not the whole result set.
Currently, there is no option in JMeter to do so.
Even when you set the "Count Records" option in JMeter, the whole result set is fetched (in order to count the rows). There is no option to get the result set size without fetching it (this is JDBC standard).
It is not an option to add a LIMIT clause at the end of the query, as databases might have an optimization for that.
For the same reason, it is also not an option to use the JDBC parameter ResultSet.setMaxRows(int).
I am only interested in knowing that the query has been processed successfully (= didn't throw an error).

This is a new bug/feature request, I accidentally hijacked the following bug initially:
#1896

OS: All

[asfimport]

Franz Schwab (migrated from Bugzilla):
Some discussion already took place here:
frschwab@102f0ac

[asfimport]

Franz Schwab (migrated from Bugzilla):
Pull request: #476

[asfimport]

UbikLoadPack support (migrated from Bugzilla):
Merged in trunk:
ab9770b

[asfimport]

光年 (migrated from Bugzilla):
没有中文汉化