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

CREATE DATABASE and TABLE statements do not support DEFAULT charset

    XMLWordPrintable

    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.

        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: