Skip site navigation (1) Skip section navigation (2)

[ psqlodbc-Bugs-1011099 ] SQLStatistics returns A instead of D for descending index column

From: <noreply(at)pgfoundry(dot)org>
To: noreply(at)pgfoundry(dot)org
Subject: [ psqlodbc-Bugs-1011099 ] SQLStatistics returns A instead of D for descending index column
Date: 2011-11-02 00:02:16
Message-ID: 20111102000216.6F203532D888@pgfoundry.org (view raw or flat)
Thread:
Lists: pgsql-odbc
Bugs item #1011099, was opened at 2011-09-29 22:20
You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1011099&group_id=1000125

Category: None
Group: None
>Status: Closed
Resolution: None
Priority: 3
Submitted By: Farid Zidan (faridz)
Assigned to: Hiroshi Inoue (hinoue)
Summary: SQLStatistics returns A instead of D for descending index column

Initial Comment:
PostgreSQL ANSI(x64) 9.00.03.10 on Windows 7 x64
postgresql-x64-9.0 - PostgreSQL Server 9.0 on Windows 7 x64

Example,

create table test_index (
  ds_oid serial not null,
  logid varchar(128) null
);

create index IX_DESC on test_index (
  ds_oid,
  logid desc
);

I get 'A' instead of 'D' for ASC_OR_DESC column of row for 'logid' column of the index on executing SQLStatistics

----------------------------------------------------------------------

Comment By: Farid Zidan (faridz)
Date: 2011-10-05 00:18

Message:
64-bit driver fix passes my testing.

regards,
Farid

----------------------------------------------------------------------

Comment By: Hiroshi Inoue (hinoue)
Date: 2011-10-04 23:52

Message:
I applied the fix to 64-bit drivers also though 
I can't test it by myself.

regards,
Hiroshi Inoue

----------------------------------------------------------------------

Comment By: Farid Zidan (faridz)
Date: 2011-10-04 22:06

Message:
I am using the 64-bit driver. Is the fix to test included in 
the 64-bit driver (says on 311 page that 64-bit driver is 
really experimental?)

regards,
Farid

----------------------------------------------------------------------

Comment By: Hiroshi Inoue (hinoue)
Date: 2011-10-04 12:26

Message:
Hi Farid,

Could you please try the drivers on tesing for 9.0.0311
at
 http://www.ne.jp/asahi/inocchichichi/entrance/psqlodbc/index.html ?

regards,
Hiroshi Inoue

----------------------------------------------------------------------

You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1011099&group_id=1000125

pgsql-odbc by date

Next:From: noreplyDate: 2011-11-02 00:05:30
Subject: [ psqlodbc-Bugs-1001827 ] Error when updating a TIMESTAMP column with NULL using ADODB
Previous:From: noreplyDate: 2011-11-02 00:01:37
Subject: [ psqlodbc-Bugs-1010376 ] GUID code missing in convert.c ("Unrecognized C_parameter ..") and fix

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group