aws / aws/amazon-redshift-odbc-driver
SQLColumnsW will sometimes return "smallint out of range" error
- Dominant language
- C
- Stars
- 25
- Forks
- 17
- PR merge metrics
- No merged PRs in 30d
Description
## Driver version
2.1.2
## Redshift version
1.0.71629
## Client Operating System
RHEL 9
## Table schema
Can't share that here, I can share through direct channel.
## Problem description
1. Expected behaviour: SQLColumnsW returns column metadata without an error
2. Actual behaviour: SQLColumnsW returns and error
3. Error message/stack trace: "smallint out of range"
4. Any other details that can be helpful:
This occurs for a customer of ours, and I don't have an internal repro for this issue yet They are connecting to a complex view. I have the DDL, but don't have the base tables to setup a repro.
sqlstate: 22003
native error: 0
## ODBC trace logs
Will send via other channel.
## Reproduction code
I don't have a repro yet. Will try to get one.
Contributor guide
Research direction
Start with the SQLColumnsW entry point and obtain the promised ODBC trace logs, view DDL, and a reproducible case. Compare the failing metadata path with the expected behavior: SQLColumnsW should return column metadata without the “smallint out of range” error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- c, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100