I found that for some reason when I try to create a stored generated column that concatenate a "char" column the following error is raised by MariaDB:
I cannot reproduce this bug with MariaDB 10.3.36 in Debian 10. so maybe is only an issue with the new versions of MariaDB.
Steps to reproduce:
1. Create the following table:
2. Add one record to the table:
3. Try to add the following stored generated column:
The following error code is received:
MariaDB should allow to create the stored generated column in the same way that is possible to do using Maria 10.3.36 or using a virtual generated column like the following example:
It also works when use "CONCAT" with a "varchar" column, like the following example:
I can also reproduce this issue with a different collation (utf8mb4_general_ci) and charset (utf8mb4).