opensearch-project / opensearch-project/sql-odbc
[BUG] Tableau is incorrectly receiving non-null values as null from the ODBC driver
Nobody has claimed this yet.
- Dominant language
- C++
- Stars
- 10
- Forks
- 25
- PR merge metrics
- No merged PRs in 30d
Description
Describe the bug
The TDVT smoke tests are failing due to all values of a query being null when the expected are not null. The issue has been isolated to the ODBC driver as a query to the OpenSearch sql plugin returns accurate non-null values.
To Reproduce
Steps to reproduce the behavior using ODBCTest:
- Execute SELECT
staples.DiscountFROMstaplesGROUP BY 1 - SQLSetStmtAttr
- Attribute SQL_ATTR_ROW_ARRAY_SIZE
- ValuePtr: 100
- SQLBindCol
- Column Number: 21
- Target Type: SQL_C_Double
- SQL fetch
- Actual Result: SQLDescribeCol returned: SQL_ERROR=-1
Screenshots
Actual results:
Expected results:
Host/Environment (please complete the following information):
- OS: Windows 10
- Version 21H1
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
Start by reproducing the failure with ODBCTest on Windows 10 using the provided SELECT, SQL_ATTR_ROW_ARRAY_SIZE, SQLBindCol, and fetch steps. Compare the ODBC driver's result with the OpenSearch SQL plugin and the expected non-null values; done means the Tableau/ODBC path returns the correct values and SQLDescribeCol no longer reports SQL_ERROR.
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