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

Support UNION for ALTER TABLE

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 0.6
    • 0.5.2
    • mysql-connector
    • None

    Description

      ALTER TABLE with UNION is not parseable - see https://dev.mysql.com/doc/refman/5.7/en/alter-table.html

      Test SQL

      CREATE DATABASE IF NOT EXISTS `test_schema`;
      
      USE `test_schema`;
      
      CREATE TABLE `merge_table` (
        `id` int(11) NOT NULL,
        `name` varchar(45) DEFAULT NULL,
        PRIMARY KEY (`id`)
      ) ENGINE=MRG_MyISAM DEFAULT CHARSET=latin1;
      
      CREATE TABLE IF NOT EXISTS `table1` (
        `id` int(11) NOT NULL,
        `name` varchar(45) DEFAULT NULL,
        PRIMARY KEY (`id`)
      ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
      
      
      CREATE TABLE  IF NOT EXISTS`table2` (
        `id` int(11) NOT NULL,
        `name` varchar(45) DEFAULT NULL,
        PRIMARY KEY (`id`)
      ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
      
      ALTER TABLE `merge_table` UNION = (`table1`,`table2`);
      

      Communication context - https://gitter.im/debezium/user?at=59aae737ba0f0f6e380d7cbb

      Attachments

        Activity

          People

            jpechane Jiri Pechanec
            jpechane Jiri Pechanec
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: