[ODBC-290] Cursor type defaults to SQL_CURSOR_STATIC Created: 2020-07-08 Updated: 2023-04-13 Resolved: 2023-04-13 |
|
| Status: | Closed |
| Project: | MariaDB Connector/ODBC |
| Component/s: | General |
| Affects Version/s: | 3.1.7 |
| Fix Version/s: | 3.2.0 |
| Type: | Bug | Priority: | Major |
| Reporter: | Tom Hughes | Assignee: | Lawrin Novitsky |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Environment: |
Fedora 32 |
||
| Description |
|
The Microsoft ODBC specification says that the default cursor type is SQL_CURSOR_FORWARD_ONLY but the MariaDB driver sets it to SQL_CURSOR_STATIC and it has to be explicitly changed to get a forward only cursor. |
| Comments |
| Comment by Lawrin Novitsky [ 2020-10-16 ] |
|
Well, this is a bug, and it is fairly easy to fix, but fixing it can break existing applications. Thus I better leave it for the next minor version. |
| Comment by Lawrin Novitsky [ 2020-10-18 ] |
|
I've made "Force Forward Only Cursor" option to make SQL_CURSOR_FORWARD_ONLY a default cursor type. That was missing. Also added that option to the setup dialog and "FORWARDONLY" option name along with OPTION's bit |
| Comment by Lawrin Novitsky [ 2023-04-13 ] |
|
3.2.0 contains this change |