opensearch-project / opensearch-project/sql-odbc
[BUG] `fetch_size` is not supported in PBI connector
Open
Nobody has claimed this yet.
bug
- Dominant language
- C++
- Stars
- 10
- Forks
- 25
- PR merge metrics
- No merged PRs in 30d
Description
What is the bug?
Currently, fetch_size can be configured in ODBC by adding ;fetchSize=x block in the connection string.
PowerBI connector has no option to set this.
What is the expected behavior?
One of:
- Update PBI connector: allow user to optionally set
fetch_sizeand use it in connection string if set - Update ODBC driver to properly comply with ODBC API. For example, if
SQLSetStmtAttrcalled withSQL_ATTR_MAX_ROWS, driver doesn't setfetch_sizeparameter. Maybe PBI connector update is also required.
What is your host/environment?
main @ 1f0620fb1
Do you have any additional context?
Inspired by #16
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
No files or tests are named. Start by tracing the PBI connector's connection-string configuration and the ODBC driver's handling of SQLSetStmtAttr with SQL_ATTR_MAX_ROWS; compare both paths against the existing fetchSize connection-string behavior. Done means the chosen path supports configuring fetch_size as described and its behavior is covered by the relevant validation.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- cpp, sql
- Domain
- database
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100