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

CREATE DATABASE and TABLE statements do not support DEFAULT charset

    XMLWordPrintable

Details

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

    Description

      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.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: