aws / aws/amazon-redshift-odbc-driver

Fix for TIMESTAMPTZ problem in 2.1.3 not quite complete.

Open
#30 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.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

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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.