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

        Gliffy Diagrams

          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: