aws / aws/amazon-redshift-odbc-driver

SQLColumnsW will sometimes return "smallint out of range" error

Open
#25 2 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.