Skip to content

Power BI is getting an unexpected data type for date columns from the ODBC driver[BUG] #18

@ghost

Description

@ghost

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

  1. Install the ODBC driver from https://github.com/opensearch-project/sql/actions/runs/1555197058
  2. Open ODBCTest
  3. Click on the Catalog button
  4. Select SQLColumns
  5. See data type for date columns is not 93

Expected behavior
Data type in ODBC test should have data type 93 for date columns

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions