opensearch-project / opensearch-project/sql-odbc
Power BI is getting an unexpected data type for date columns from the ODBC driver[BUG]
Nobody has claimed this yet.
- Dominant language
- C++
- Stars
- 10
- Forks
- 25
- PR merge metrics
- No merged PRs in 30d
Description
Describe the bug
Power BI is getting an unexpected data type for date columns from the ODBC driver. The driver should return type 93 which is SQL_TYPE_TIMESTAMP. These columns do not show up on Power BI as there is a data type mismatch.
To Reproduce
- Install the ODBC driver from https://github.com/opensearch-project/sql/actions/runs/1555197058
- Open ODBCTest
- Click on the
Catalogbutton - Select
SQLColumns - See data type for date columns is not 93
Expected behavior
Data type in ODBC test should have data type 93 for date columns
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
Reproduce the issue with the linked ODBC driver, ODBCTest, and the Catalog > SQLColumns flow. Inspect how the driver reports date columns and compare the result with the expected SQL type 93. Done means ODBCTest reports type 93 for date columns and the columns are recognized by Power BI.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 38/100