Ticket #158 (closed defect: fixed)

Opened 3 years ago

Last modified 2 years ago

Postgres-backed trac installations fail due to IFNULL not existing

Reported by: brian Assigned to: jornh
Priority: normal Component: PlannedMilestonesMacro
Severity: blocker Keywords:
Cc: Trac Release: 0.8

Description

Postgres Trac installations do not have an IFNULL function which is used in the SQL query. Instead, you must change it to COALESCE() which will have the same effect in this instance: 

"ORDER BY (coalesce(due, 0) = 0) ASC, due ASC, name" % time()

Attachments

Change History

05/29/06 16:48:09 changed by cadiolis@gmail.com

  • release set to 0.8.

Postgresql syntax is NULLIF (versus IFNULL) 

"ORDER BY (NULLIF(due, 0) = 0) ASC, due ASC, name" % time()

05/30/06 23:24:54 changed by mgood

  • status changed from new to closed.
  • resolution set to fixed.

(In [796]) * use the Milestone model API to be cross-DB compatible and preserve proper sorting (fixes #158, #213, #235, #398)

  • use Markup to make sure HTML is properly escaped for output

Add/Change #158 (Postgres-backed trac installations fail due to IFNULL not existing)




Change Properties
Action