Comment 11 for bug 552420
Revision history for this message
| Jay Pipes (jaypipes) wrote Re: [Bug 552420] Re: implicit startTransaction in ALTER TABLE calling rnd_init to do data copy | #11 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
1b1ed1a
(Get the code!)
On Wed, Apr 28, 2010 at 1:00 PM, Brian Aker <email address hidden> wrote:
> BTW just as useful (or possibly useful) info, these tables are very
> special.
>
> If you are coming from a temporary table we just create another
> temporary table and switch the names at the end (and there is no
> recovery).
>
> >From a normal table, you create an INTERNAL_TABLE which half exists in
> the system. It is for all purposes a normal table except that it
> bypasses a number of systems along the way (like locking). During an
> alter table this table can become lost during a crash.
>
> Unfortunately the code paths for TEMP tables and normal tables if
> different still.
Thanks, Brian. Yeah, some of that code is indeed ugly :) But, I think
I've figured out a way to fix this bug at least ;)
-jay