MMBase

sorting on NULL is ambiguous

Details

  • Type: Bug Bug
  • Status: Open Open
  • Priority: Major Major
  • Resolution: Unresolved
  • Affects Version/s: 1.7.0
  • Fix Version/s: 2.0.0
  • Component/s: Database Layer
  • Description:
    Hide
    original bugid: #6877
    If you have NULL values in your database, sorting may give odd results.
    An ORDERBY query in MYSQL sorts NULL values FIRST.
    An ORDERBY query in PostgresSQL sorts NULL values LAST.
    This can give odd results when listing data (specifically some fiels, such as dates, where NULL is rendered as 1/1/1970).
    Show
    original bugid: #6877 If you have NULL values in your database, sorting may give odd results. An ORDERBY query in MYSQL sorts NULL values FIRST. An ORDERBY query in PostgresSQL sorts NULL values LAST. This can give odd results when listing data (specifically some fiels, such as dates, where NULL is rendered as 1/1/1970).

Activity

Hide
Henk Hangyi added a comment - 2007-02-25 13:22
IMO these could best be part of the transaction improvement project for the 2.0 release
Show
Henk Hangyi added a comment - 2007-02-25 13:22 IMO these could best be part of the transaction improvement project for the 2.0 release
Hide
Michiel Meeuwissen added a comment - 2007-02-25 17:28
I don't quite see the relation with transactions.
Show
Michiel Meeuwissen added a comment - 2007-02-25 17:28 I don't quite see the relation with transactions.

People

Dates

  • Created:
    2006-08-17 17:48
    Updated:
    2007-02-25 17:28