mahara-contributors team mailing list archive

[Mahara Bot <1353069@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://reviews.mahara.org/3974
Committed: http://gitorious.org/mahara/mahara/commit/6e0d6e9404f4067693bd0cd6481930598300dedf
Submitter: Aaron Wells (aaronw@xxxxxxxxxxxxxxx)
Branch:    1.8_STABLE

commit 6e0d6e9404f4067693bd0cd6481930598300dedf
Author: Yuliya Bozhko <yuliya.bozhko@xxxxxxxxxxxxx>
Date:   Wed Aug 6 07:47:36 2014 +1200

Fix db_format_tsfield() returning value with offset on Postgres 9.2 and
later (Bug #1353069)

Change-Id: I827851a16eba74d474234c21dd6b6afc2d06470c
Signed-off-by: Yuliya Bozhko <yuliya.bozhko@xxxxxxxxxxxxx>

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1353069

Title:
  db_format_tsfield() returning time value with offset on POstgres

Status in Mahara ePortfolio:
  Fix Committed
Status in Mahara 1.10 series:
  Fix Committed
Status in Mahara 1.8 series:
  Fix Committed
Status in Mahara 1.9 series:
  Fix Committed
Status in Mahara 15.04 series:
  Fix Committed

Bug description:
  On postgres db_format_tsfield() calculates time by doing
  FLOOR(EXTRACT(EPOCH FROM {$field})) which apparently doesn't make
  sense if we are using fields without timezone (by reading this
  http://postgresql.1045698.n5.nabble.com/Possible-problem-with-EXTRACT-
  EPOCH-FROM-TIMESTAMP-td2125933.html).

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1353069/+subscriptions