Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-1621

ALTER TABLE with AFTER keyword doesn't work

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.1.13
    • Fix Version/s: 2.1.14
    • Component/s: avrorouter
    • Labels:
      None

      Description

      The following SQL will corrupt the conversion process.

      CREATE TABLE test.t1(a int, b datetime(3));
      INSERT INTO test.t1 VALUES(1, NOW());
      ALTER TABLE test.t1 ADD COLUMN c INT AFTER a;
      INSERT INTO test.t1 VALUES(2, 2, NOW());
      

        Attachments

          Activity

            People

            Assignee:
            markus makela markus makela
            Reporter:
            markus makela markus makela
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration