Thread: [ psqlodbc-Bugs-1000759 ] SQLGetInfo(SQL_NULL_COLLATION) returns SQL_NC_END instead of SQL_NC_HIGH
[ psqlodbc-Bugs-1000759 ] SQLGetInfo(SQL_NULL_COLLATION) returns SQL_NC_END instead of SQL_NC_HIGH
From
Date:
Bugs item #1000759, was opened at 2006-10-19 05:53 You can respond by visiting: http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000759&group_id=1000125 Category: None Group: None >Status: Closed Resolution: None Priority: 3 Submitted By: Dmitriy Ivanov (divanov) Assigned to: Hiroshi Inoue (hinoue) Summary: SQLGetInfo(SQL_NULL_COLLATION) returns SQL_NC_END instead of SQL_NC_HIGH Initial Comment: With the ANSI dirver 08.02.0103, I get SQLGetInfo(SQL_NULL_COLLATION) => 4, i.e. SQL_NC_END. This obviously contradicts toactual results and PG documentation Part VI. Reference > SQL Commands > SELECT: The null value sorts higher than any other value. In other words, with ascending sort order, null values sort at the end, and with descending sort order, null values sort at the beginning. ---------------------------------------------------------------------- Comment By: Dmitriy Ivanov (divanov) Date: 2006-10-20 10:25 Message: Both works now. Thanks a lot! ---------------------------------------------------------------------- Comment By: Hiroshi Inoue (hinoue) Date: 2006-10-20 06:47 Message: Oops sorry, I uploaded the wrong version of dll. Please try the attached dll. regards, Hiroshi Inoue ---------------------------------------------------------------------- Comment By: Dmitriy Ivanov (divanov) Date: 2006-10-20 05:43 Message: I have tried the attached ANSI driver dlls (version 08.02.0104) and neiter can see any difference in SQLGetInfo (SQL_NULL_COLLATION) nor in SQLStatistics. ---------------------------------------------------------------------- Comment By: Hiroshi Inoue (hinoue) Date: 2006-10-20 02:04 Message: SQL_NC_END had been right until 7.2 came. OK please try the attached dll. regards, Hiroshi Inoue ---------------------------------------------------------------------- You can respond by visiting: http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000759&group_id=1000125