fix(jans-linux-setup): MariaDB json index creation

[devrimyatar]

Consequence of GluuFederation/community-edition-setup#1020

18:15:19 12/01/23 ERROR executing query ('(pymysql.err.ProgrammingError) (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 \'(CAST(jansClntId->\'$.v\' AS CHAR(128) ARRAY)))\' at line 1")',)
18:15:19 12/01/23 Executing mysql Query: ALTER TABLE jansdb.jansClntAuthz ADD INDEX `jansClntId_json_2`((CAST(jansClntId->'$.v[0]' AS CHAR(128))));
18:15:19 12/01/23 ERROR executing query ('(pymysql.err.ProgrammingError) (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 \'(CAST(jansClntId->\'$.v[0]\' AS CHAR(128))))\' at line 1")',)
18:15:19 12/01/23 Executing mysql Query: ALTER TABLE jansdb.jansClntAuthz ADD INDEX `jansClntId_json_3`((CAST(jansClntId->'$.v[1]' AS CHAR(128))));
18:15:19 12/01/23 ERROR executing query ('(pymysql.err.ProgrammingError) (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 \'(CAST(jansClntId->\'$.v[1]\' AS CHAR(128))))\' at line 1")',)
18:15:19 12/01/23 Executing mysql Query: ALTER TABLE jansdb.jansClntAuthz ADD INDEX `jansClntId_json_4`((CAST(jansClntId->'$.v[2]' AS CHAR(128))));
18:15:19 12/01/23 ERROR executing query ('(pymysql.err.ProgrammingError) (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 \'(CAST(jansClntId->\'$.v[2]\' AS CHAR(128))))\' at line 1")',)

[yurem]

According to my research I think Maria DB still no support JSON indexes. There are few workarounds like virtual columns, full text search. But these are not real working solutions for us. We need to turn off indexes creation for JSON columns if DB is MariaDB. Instead of this we can use child tables.

[devrimyatar]

MairaDB support removed: #7218