Error creating index on MySQL 5.7

[iromli]

Describe the bug

When using MySQL 5.7 (and its derivative distribution, i.e. AWS Aurora MySQL 5.7), creating index with CAST query triggers SQL syntax error, for example:

sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(CAST(clnId->'$.v' AS CHAR(128) ARRAY)))' at line 1")
[SQL: ALTER TABLE `jansCibaReq` ADD INDEX `jansCibaReq_json_1` ((CAST(clnId->'$.v' AS CHAR(128) ARRAY)))]

To Reproduce
Steps to reproduce the behavior:

1. Deploy MySQL 5.7 container
2. Set CN_PERSISTENCE_TYPE environment variable to sql
3. Deploy janssenproject/persistence-loader container
4. See error (as mentioned above) on container's logs

Expected behavior

Error should not be thrown.

Additional context

The error only occurs in MySQL 5.7.x