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

Support UNION for ALTER TABLE

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 0.5.2
    • Fix Version/s: 0.6
    • Component/s: mysql-connector
    • Labels:
      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

            Assignee:
            jpechanec Jiri Pechanec
            Reporter:
            jpechanec Jiri Pechanec
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: