aws / aws/amazon-redshift-odbc-driver
Fix for TIMESTAMPTZ problem in 2.1.3 not quite complete.
- Dominant language
- C
- Stars
- 25
- Forks
- 17
- PR merge metrics
- No merged PRs in 30d
Description
## Driver version
2.1.3.0
## Redshift version
PostgreSQL 8.0.2 on i686-pc-linux-gnu, co\
mpiled by GCC gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3), Redshift 1.0.74754
## Client Operating System
Linux
## Table schema
## Problem description
ODBC version 2.1.3.0 attempted to fix an issue where the type reported for a TIMESTAMPTZ column was reported incorrectly. SQLDescribeCol() was properly fixed and now returns SQL_TYPE_TIMESTAMP instead of CHARACTER VARYING. However, SQLColAttribute() when called with SQL_DESC_TYPE_NAME was changed to return TIMESTAMP instead of CHARACTER VARYING. This is incorrect -- it should return TIMESTAMPTZ. Please fix SQLColAttribute(). It would be nice to fix that in a patch to 2.1.3.0 if at all possible, but certainly it should be fixed in 2.1.4.
1. Expected behaviour:
2. Actual behaviour:
3. Error message/stack trace:
4. Any other details that can be helpful:
## ODBC trace logs
## Reproduction code
Contributor guide
Research direction
Search the driver for SQLColAttribute handling of SQL_DESC_TYPE_NAME and compare it with the existing SQLDescribeCol behavior. Reproduce the metadata lookup using a TIMESTAMPTZ column on the reported Redshift environment; done means SQLColAttribute reports TIMESTAMPTZ while SQLDescribeCol continues to return SQL_TYPE_TIMESTAMP.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- c, postgresql, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 42/100