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

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

am 30.09.2011 00:20:19 von noreply

Bugs item #1011099, was opened at 2011-09-29 18:20
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=10110 99&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Farid Zidan (faridz)
Assigned to: Nobody (None)
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

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

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

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc