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 liquibase.properties file and the CLI command (with all parameters) that you used?
I’m seeing this as well,
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,