Comments - is this a bug using TRIM using a space character before the open parenthesis ?
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
By default spaces are not permitted after the function name, but this can be changed by setting IGNORE_SPACE SQL_MODE.
thank you - it seemed strange that REGEXP_REPLACE and CONCAT allowed for the extra space, but not trim.