ODBC Statements do not respect the driver SQL_ATTR_MAX_ROWS setting. [ODBC74]

[firebird-automations]

Submitted by: Clinton L. Warren (justdoro)

The driver does not respect the SQL_ATTR_MAX_ROWS setting.

Select a table with n rows (say, 100).

Create a select statement that has its SQL_ATTR_MAX_ROWS setting set to 10 rows.

Executing the select will return all 100 rows.

Similar tests against the SQL Server ODBC driver and the MySQL ODBC driver return 10 rows.

[firebird-automations]

Commented by: Clinton L. Warren (justdoro)

This was tested with Delphi using the ADO components by setting the ADOQuery.MaxRecords property to 10. Using ODBCTrace showed that ADO is setting SQL_ATTR_MAX_ROWS on the ODBC sql statement.

[firebird-automations]

Modified by: @alexpotapchenko

assignee: Alexander Potapchenko [ lightfore ]

[firebird-automations]

Modified by: @alexpotapchenko

Fix Version: 2.1 Beta [ 10410 ]

[firebird-automations]

Modified by: @alexpotapchenko

Version: 2.0 RC2 [ 10320 ]

Fix Version: 2.1 Beta [ 10410 ] =>

[firebird-automations]

Modified by: @alexpotapchenko

Version: 2.0 [ 10044 ]

Version: 2.0 RC2 [ 10320 ] =>

[firebird-automations]

Commented by: Julien Nabet (julien2412)

I submitted a patch to review here: https://github.com/FirebirdSQL/firebird-odbc-driver/pull/1

[irodushka]

The patch is fine, merged, thank you!