Problem of using Concat_WS method

[marc-antoine yonga]

Hello,

For my project, I want to implement a field with the CONCAT_WS method.

When I'm trying this function insert a query, the result is good :

UPDATE mydb_jobersplace.t_jp_comande SET T_JP_Commande_NumCleT = CONCAT_WS('_', T_JP_Commande_BaseNumCle, CONVERT(T_JP_Commande_NumCle, char(7))); // good result.

When I'm inserting the method into the generate expression I have the error message number 1064 :

(CONCAT_WS('_', `T_JP_Commande_BaseNumCle`, Convert(`T_JP_Commande_NumCle`, CHAR(7)))); // error message.

Thanks you for your help !