Re: Schema inconsistency after inplace alter table in MySQL 5.6.6-m9

Hello Rich!

* Rich Prohaska <[email protected]> [12/09/09 00:48]:
> The problem with inplace alter table operations isthat  the rename of
> the FRM schema is not transactional.  Are there any plans to address
> this?

This not only problem with in-place operations in 5.6, it is
also present in 5.1/5.5 and also exists in some form for ALTER TABLE
executed through creation and copying data to temporary table.

So the problem is not really something new and was there almost
forever.

We have already bugs reported about this and similar issues
(for example, see http://bugs.mysql.com/bug.php?id=25922).
But since this is pre-existing problem, which doesn't happen often,
and fixing it requires fairly big changes to ALTER TABLE/other DDL
it is unlikely that this will happen in 5.6 timeframe.

Best regards,
Dmitry

-- 
Dmitry Lenev, Software Developer
Oracle Development SPB/MySQL, www.mysql.com

Are you MySQL certified?  http://www.mysql.com/certification

-- 
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe:    http://lists.mysql.com/internals