MySQL 5.7 Reference Manual
MySQL 5.7 Release Notes
The COLLATE clause has high precedence
(higher than ||), so
the following two expressions are equivalent:
Press CTRL+C to copyx || y COLLATE z x || (y COLLATE z)