Create database Table "ACT_RU_AUTHORIZATION" fails with "ALWAYS GENERATED AS""


i try to create the camunda tables in a mariaDB v. 10.1.13.
When i execute the SQL create file for camunda 7.5 db2_engine_7.5.0.sql
I get the error:

Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘generated always as (case when “USER_ID_” is null then “ID_” else “USER_ID_” end’ at line 11

When i look at Generated (Virtual and Persistent/Stored) Columns - MariaDB Knowledge Base it sems correct. any ideas?



Hi Hans,

You seem to use the create scripts for DB2 instead of MariaDB.


what a horrible mistake…
thank you!