[#MXS-1621] ALTER TABLE with AFTER keyword doesn't work

[MXS-1621] ALTER TABLE with AFTER keyword doesn't work Created: 2018-01-21 Updated: 2018-02-01 Resolved: 2018-02-01
Status:	Closed
Project:	MariaDB MaxScale
Component/s:	avrorouter
Affects Version/s:	2.1.13
Fix Version/s:	2.1.14

Type:

Bug

Priority:

Major

Reporter:

markus makela

Assignee:

markus makela

Resolution:

Fixed

Votes:

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());

Generated at Thu Feb 08 04:08:10 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.