Confirming fix works on Lucid
mysql> ALTER TABLE `grtdiff_alter_test`.`t1` DROP COLUMN `t` , ADD COLUMN `t2` TEXT NULL FIRST; Query OK, 0 rows affected (0.13 sec) Records: 0 Duplicates: 0 Warnings: 0
mysql> \q Bye root@utest-lls32:~# apt-cache policy mysql-server mysql-server: Installed: 5.1.41-3ubuntu12.9 Candidate: 5.1.41-3ubuntu12.9 Version table: *** 5.1.41-3ubuntu12.9 0 500 http://ro.archive.ubuntu.com/ubuntu/ lucid-proposed/main Packages 100 /var/lib/dpkg/status 5.1.41-3ubuntu12.8 0 500 http://ro.archive.ubuntu.com/ubuntu/ lucid-updates/main Packages 5.1.41-3ubuntu12.7 0 500 http://security.ubuntu.com/ubuntu/ lucid-security/main Packages 5.1.41-3ubuntu12 0 500 http://ro.archive.ubuntu.com/ubuntu/ lucid/main Packages
root@utest-lls32:~# lsb_release -rd Description: Ubuntu 10.04.1 LTS Release: 10.04
Confirming fix works on Lucid
mysql> ALTER TABLE `grtdiff_ alter_test` .`t1` DROP COLUMN `t` , ADD COLUMN `t2` TEXT NULL FIRST;
Query OK, 0 rows affected (0.13 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> \q ro.archive. ubuntu. com/ubuntu/ lucid-proposed/main Packages dpkg/status 1.41-3ubuntu12. 8 0 ro.archive. ubuntu. com/ubuntu/ lucid-updates/main Packages 1.41-3ubuntu12. 7 0 security. ubuntu. com/ubuntu/ lucid-security/main Packages 1.41-3ubuntu12 0 ro.archive. ubuntu. com/ubuntu/ lucid/main Packages
Bye
root@utest-lls32:~# apt-cache policy mysql-server
mysql-server:
Installed: 5.1.41-3ubuntu12.9
Candidate: 5.1.41-3ubuntu12.9
Version table:
*** 5.1.41-3ubuntu12.9 0
500 http://
100 /var/lib/
5.
500 http://
5.
500 http://
5.
500 http://
root@utest-lls32:~# lsb_release -rd
Description: Ubuntu 10.04.1 LTS
Release: 10.04