Hello
If table xyz is a symbolic link (recommended in the manual for very big files
that do not fit on a single partition) then "ALTER TABLE xyz TYPE=ISAM;"
ignores this, removes the link and recreate the table on the data directory.
I consider it a bug, as it is
a) not what the user expects, even repair, optimise and other alter table
functions do not work like this
b) a user that has no shell account has no other way to alter the table type
c) this can be used as a denial of service attack as mysql hangs when
getting a "no space left" error message and this is a way to more around
the system administrators disk-quota settings!
This was tested with the latest MySQL-3.23.35 on linux (ext2 & reiserfs,
although this shouldn't matter in for the symlink handling)
bye,
-christian-
--
Christian Hammers WESTEND GmbH - Aachen und Dueren Tel 0241/701333-0
[EMAIL PROTECTED] Internet & Security for Professionals Fax 0241/911879
WESTEND ist CISCO Systems Partner - Premium Certified
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
