-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
Reviewed: https:/ /reviews. mahara. org/10380 /git.mahara. org/mahara/ mahara/ commit/ e48f88ced5feae3 0aebedaa8301682 ab5f73f457
Committed: https:/
Submitter: Robert Lyon (<email address hidden>)
Branch: master
commit e48f88ced5feae3 0aebedaa8301682 ab5f73f457
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: I860bac5c44dab2 06b70a78215a578 4e6f1fe3928