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

Hey,

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 https://mariadb.com/kb/en/mariadb/virtual-computed-columns/ it sems correct. any ideas?

Thx

Hans

Hi Hans,

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

Cheers,
Thorben

what a horrible mistake…
thank you!