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

databaseName null in messages emited to database.history.kafka.topic when DDL statement uses databaseName.tablename

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 0.2
    • 0.1
    • mysql-connector
    • None
    • Hide

      CREATE TABLE inventory.customers2
      (
      id INT(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
      first_name VARCHAR(255) NOT NULL,
      last_name VARCHAR(255) NOT NULL,
      email VARCHAR(255) NOT NULL
      );

      Show
      CREATE TABLE inventory.customers2 ( id INT(11) PRIMARY KEY NOT NULL AUTO_INCREMENT, first_name VARCHAR(255) NOT NULL, last_name VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL );

      databaseName null in messages emited to database.history.kafka.topic when DDL statement uses databaseName.tablename

      null	{
  "source" : {
    "server" : "mysql-server-1"
  },
  "position" : {
    "file" : "mysql-bin.000003",
    "pos" : 1873,
    "row" : 0
  },
  "databaseName" : "",
  "ddl" : "CREATE TABLE inventory.customers1\n(\n  id INT(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,\n  first_name VARCHAR(255) NOT NULL,\n  last_name VARCHAR(255) NOT NULL,\n  email VARCHAR(255) NOT NULL\n)"
}

      Debezium should be able to extract databaseName from DDL statement.

            rhauch Randall Hauch (Inactive)
            xmlking5 Sumanth Chinthagunta (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: