Mysql JSON Type is failed with syntax error

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.

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

I’m seeing this as well,


classpath=<path to>\\mysql-connector-java-8.0.25\\mysql-connector-java-8.0.25.jar

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,