1077
--echo # Test for bug #12652385 - "61493: REORDERING COLUMNS TO POSITION
1078
--echo # FIRST CAN CAUSE DATA TO BE CORRUPTED".
1081
drop table if exists t1;
1083
--echo # Use MyISAM engine as the fact that InnoDB doesn't support
1084
--echo # in-place ALTER TABLE in cases when columns are being renamed
1085
--echo # hides some bugs.
1086
create table t1 (i int, j int) engine=myisam;
1087
insert into t1 value (1, 2);
1088
--echo # First, test for original problem described in the bug report.
1090
--echo # Change of column order by the below ALTER TABLE statement should
1091
--echo # affect both column names and column contents.
1092
alter table t1 modify column j int first;
1094
--echo # Now test for similar problem with the same root.
1095
--echo # The below ALTER TABLE should change not only the name but
1096
--echo # also the value for the last column of the table.
1097
alter table t1 drop column i, add column k int default 0;
1076
1103
--echo End of 5.1 tests