Mysql JSON Type is failed with syntax error

Liquibase Development
1

When I use liquibase diff 2 mysql 8.x database to generate changelog.xml with mysql connector 8.0.15 version. The JSON type is mapped to JSON(1073741824). When I try to apply this changelog.xml to mysql and got syntax error since JSON(1073741824) is not valid syntax.

2

Can you provide your liquibase.properties file and the CLI command (with all parameters) that you used?

3

I’m seeing this as well,

Properties

driver=com.mysql.cj.jdbc.Driver
classpath=<path to>\\mysql-connector-java-8.0.25\\mysql-connector-java-8.0.25.jar
url=jdbc:mysql://<db-host>:<db-port>/<schema>?useSSL=true
includeSchema=true

xml generated from generateChangeLog produces this node for the JSON field

<column name="field" type="JSON(1073741824)"/>

Which then makes SQL statement as

field JSON(1073741824) NULL,

If you manually edit to the below it works

field JSON NULL,