Fix for TIMESTAMPTZ problem in 2.1.3 not quite complete.

[Shermont]

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

[Shermont]

There is some ODBC code in issue #21 which may help in reproducing the problem.

[vahid110]

Hi @Shermont
Thank you for bringing this issue to our attention. We appreciate your diligence in reporting it.

I'm pleased to inform you that our development team has already addressed this issue. The fix has been implemented will be included in our next release.