Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-1470

CREATE DATABASE and TABLE statements do not support DEFAULT charset

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Critical Critical
    • 0.10.0.CR2
    • 0.10.0.Beta4
    • mysql-connector
    • None

      See https://gitter.im/debezium/user?at=5d77a487d5c7bd57946a253f

      org.apache.kafka.connect.errors.ConnectException: no viable alternative at input 'CREATE DATABASE example CHARACTER SET = DEFAULT;' with DBZ 0.9.5 Final. The same query fails to parse when I extend some test case on master. However, MySQL 5.5 and 5.7 (both Percona) and MariaDB 10.3 agree that this is valid. As far as I can tell DBZ struggles with the charset being set to DEFAULT, not because of the odd =. It works with or without = if I specify an actual charset like latin1.
      it's Syntax Error in Percona 8.0+, though

      It is necessary to check if the same proble is for CREATE TABLE and column definitions.

              ccranfor@redhat.com Chris Cranford
              jpechane Jiri Pechanec
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: