mahara-contributors team mailing list archive

[Mahara Bot <1691329@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://reviews.mahara.org/7765
Committed: https://git.mahara.org/mahara/mahara/commit/1f3927b3526c46a1123ad513dff0be618769feef
Submitter: Robert Lyon (robertl@xxxxxxxxxxxxxxx)
Branch:    master

commit 1f3927b3526c46a1123ad513dff0be618769feef
Author: Robert Lyon <robertl@xxxxxxxxxxxxxxx>
Date:   Wed May 17 11:14:45 2017 +1200

Bug 1691329: Fixing folder size call for mysql

We need to actually define an alias for the column to return

behatnotneeded

Change-Id: I6eec34389a24c1eef647963348ae8bcb60d716f5
Signed-off-by: Robert Lyon <robertl@xxxxxxxxxxxxxxx>

-- 
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/1691329

Title:
  Fetching folder size value not working for Mysql

Status in Mahara:
  Fix Committed

Bug description:
  We have a bit of code to estimate the size of a folder to display it
  in the files content list.

  This works on postgres but fails on mysql

  The issue is when we call SUM(aff.size) in postgres it sets the column
  title to sum for the results  but with mysql it returns SUM(aff.size)
  as the column title.

  The fix https://reviews.mahara.org/#/c/7765/

  sorts this out as we give it a column alias

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