Problem with upgrading to 15.04 - postgres and upgrade/limit

Bug #1483084 reported by Robert Lyon on 2015-08-10
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Mahara
High
Robert Lyon
1.10
High
Unassigned
15.04
High
Unassigned
15.10
Undecided
Unassigned

Bug Description

Postgres can only do an upgrade / limit via subquery and Mysql can only do it without subquery

so we need to have seperate sql commands for both

Reviewed: https://reviews.mahara.org/5073
Committed: https://git.nzoss.org.nz/mahara/mahara/commit/22842bdfbaad207388c1a00130c53d6d0c356bbe
Submitter: Son Nguyen (<email address hidden>)
Branch: master

commit 22842bdfbaad207388c1a00130c53d6d0c356bbe
Author: Robert Lyon <email address hidden>
Date: Mon Aug 10 13:19:04 2015 +1200

Bug 1483084: Upgrade problem with assigning artefact path

Postgres works slightly differently to mysql with the
update .. limit command

behatnotneeded: as this is an upgrde problem

Change-Id: I6ae18e545d9e3ba56ca3a258b02038b3759ea178
Signed-off-by: Robert Lyon <email address hidden>

Changed in mahara:
status: In Progress → Fix Committed
Changed in mahara:
milestone: none → 15.10.0
Mahara Bot (dev-mahara) wrote :

Patch for "1.10_STABLE" branch: https://reviews.mahara.org/5101

Reviewed: https://reviews.mahara.org/5101
Committed: https://git.nzoss.org.nz/mahara/mahara/commit/242b84a23fc5c83178c43ed20147739d19728957
Submitter: Robert Lyon (<email address hidden>)
Branch: 1.10_STABLE

commit 242b84a23fc5c83178c43ed20147739d19728957
Author: Robert Lyon <email address hidden>
Date: Mon Aug 10 13:19:04 2015 +1200

Bug 1483084: Upgrade problem with assigning artefact path

Postgres works slightly differently to mysql with the
update .. limit command

behatnotneeded: as this is an upgrde problem

Change-Id: I6ae18e545d9e3ba56ca3a258b02038b3759ea178
Signed-off-by: Robert Lyon <email address hidden>

Mahara Bot (dev-mahara) wrote :

Reviewed: https://reviews.mahara.org/5099
Committed: https://git.nzoss.org.nz/mahara/mahara/commit/1426aea6fcb2d1a39a2fbaf832e9bbef1c3ed89b
Submitter: Robert Lyon (<email address hidden>)
Branch: 15.04_STABLE

commit 1426aea6fcb2d1a39a2fbaf832e9bbef1c3ed89b
Author: Robert Lyon <email address hidden>
Date: Mon Aug 10 13:19:04 2015 +1200

Bug 1483084: Upgrade problem with assigning artefact path

Postgres works slightly differently to mysql with the
update .. limit command

behatnotneeded: as this is an upgrde problem

Change-Id: I6ae18e545d9e3ba56ca3a258b02038b3759ea178
Signed-off-by: Robert Lyon <email address hidden>

Robert Lyon (robertl-9) on 2016-11-06
Changed in mahara:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers