Comment 4 for bug 1845228

Revision history for this message
Mahara Bot (dev-mahara) wrote : A change has been merged

Reviewed: https://reviews.mahara.org/10380
Committed: https://git.mahara.org/mahara/mahara/commit/e48f88ced5feae30aebedaa8301682ab5f73f457
Submitter: Robert Lyon (<email address hidden>)
Branch: master

commit e48f88ced5feae30aebedaa8301682ab5f73f457
Author: Rebecca Blundell <email address hidden>
Date: Thu Sep 26 13:49:07 2019 +1200

Bug 1845228: Make Mahara work with mysql 8.0.17

-Add mysql reserved words 'array' and 'member'
-Remove deprecated ||, &&, ! and replace with OR, AND, NOT
Note: Use of || is deprecated unless the PIPES_AS_CONCAT SQL mode is
enabled. In that case, || signifies the SQL-standard string
concatenation operator
-Quote uses of member in SQL queries
Note: when passed in as a variable it is quoted on query construction

behatnotneeded

Change-Id: I860bac5c44dab206b70a78215a5784e6f1fe3928