MMBase

Postgresql and case insensitive ordering.Needless use of UPPER.

Details

  • Type: Bug Bug
  • Status: Open Open
  • Priority: Major Major
  • Resolution: Unresolved
  • Affects Version/s: 1.8.0
  • Fix Version/s: 2.0.0
  • Component/s: Database Layer
  • Description:
    Hide
    original bugid: #6845
    Depedning of the Locale used during initdb, order by is always case insensitive in postgresql. There is no need for specifying order by UPPER(title).

    On the other hand, perhaps warning must be logged if you want to order by case sensitively. This is probably only possible if the locale was C or POSSIX. The inverse is true if the locale was something like a real language.
    Show
    original bugid: #6845 Depedning of the Locale used during initdb, order by is always case insensitive in postgresql. There is no need for specifying order by UPPER(title). On the other hand, perhaps warning must be logged if you want to order by case sensitively. This is probably only possible if the locale was C or POSSIX. The inverse is true if the locale was something like a real language.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Michiel Meeuwissen added a comment - 2007-02-02 21:56
I thought I fixed this already. Verify.
Show
Michiel Meeuwissen added a comment - 2007-02-02 21:56 I thought I fixed this already. Verify.
Hide
Permalink
Michiel Meeuwissen added a comment - 2008-07-15 22:19
Not fixed. Code is present in PostgresqlSqlSqlHandler, but commented out.
Probably not correctly working yet.
Show
Michiel Meeuwissen added a comment - 2008-07-15 22:19 Not fixed. Code is present in PostgresqlSqlSqlHandler, but commented out. Probably not correctly working yet.
Hide
Permalink
Michiel Meeuwissen added a comment - 2009-07-07 06:20
I propose that as long as Posgresql does not decently support collators (as e.g. Mysql does). we won't loose time with this issue.

(See http://wiki.postgresql.org/wiki/Todo:Collate)

In the mean time, if you have a performance problem because of 'lowers' in the queries, please manually add an index on the lowered field too.
Show
Michiel Meeuwissen added a comment - 2009-07-07 06:20 I propose that as long as Posgresql does not decently support collators (as e.g. Mysql does). we won't loose time with this issue. (See http://wiki.postgresql.org/wiki/Todo:Collate) In the mean time, if you have a performance problem because of 'lowers' in the queries, please manually add an index on the lowered field too.

People

Dates

  • Created:
    2006-07-05 22:08
    Updated:
    2009-07-31 16:05
Atlassian JIRA (v4.1#519) | Report a problem | Request a feature | Contact administrators
Powered by a free Atlassian JIRA open source license for MMBase Foundation. Try JIRA - bug tracking software for your team.