MySQL query error (3.2.9p1 -> 3.2.12p1, Ubuntu 24.04)

Hello!

I found a problem after upgrade.
mysql> SELECT GROUP_CONCAT(groupid) AS groups FROM `sys_group` WHERE client_id IN (SELECT client_id FROM `client` WHERE client_id=48 OR parent_client_id=48);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups FROM `sys_group` WHERE client_id IN (SELECT client_id FROM `client` WHERE' at line 1

Please check this.
Mysql server version is 8.0.40

Regards Attila

 

thank you, patch working