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

CREATE DATABASE and TABLE statements do not support DEFAULT charset

    Details

      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.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                ccranfor Chris Cranford
                Reporter:
                jpechanec Jiri Pechanec
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: