Hi,
This is presumably a one line fix in the install script for the two day
old upgrade bug:
nstall -m 644 db/mysql-mods-1.4b5.sql \
debian/$@/usr/share/dbconfig-common/data/ndoutils-mysql/upgrade/mysql/1.4b5
+ install -m 644 db/mysql-mods-1.4b8.sql \
+ debian/$@/usr/share/dbconfig-common/data/ndoutils-mysql/upgrade/mysql/1.4b9
mysql-mods-1.4b8.sql contains the needed changes. I notice version 1.4b8
doesn't appear in the changelog so presumably it was never packaged. I
suspect the Debian patch should also name the file mysql-mods-1.4b9.sql.
Testing this could break my install in other ways so I'm reluctant to tag
this bug +patch without having tested my patch.
Further less relevant discussion
--------------------------------
I also wonder why the changes in 1.4b6 aren't in the list of upgrades
(though it doesn't add new or remove columns so it's compatible).
A tool for mysql to check the structure differences between two versions
of a table and create an alter table statement would be nice. The closest
to that is:
* dummy name for new table
* get column name list for columns with the same name
* write lock old table;insert into new_table select old_table
* drop old table;unlock old table (not there, I'm not sure what happens)
* rename new dummy table to be the same as the old name
This would reclaim freed space when using innodb_file_per_table.
Thanks,
Drew Daniels
Resume: http://www.boxheap.net/ddaniels/resume.html
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
