Unnecessary LOWER?

[Attila-SWE]

joomla-cms/libraries/src/Table/User.php

Line 277 in 689c33f

->where('LOWER(' . $this->_db->quoteName('email') . ') = LOWER(:mail)')

Since collation for #__users is case insensitive i guess the LOWER( here is unnecessary and just decreases performance? Found it in my slow_log.

[richard67]

You seem to forget that Joomla supports also PostgreSQL, so the PHP code has to cover not only MySQL or MariaDB.

[Attila-SWE]

Ok! That explains the reason for LOWER(). Thanks.