Bug #31097 ALTER ONLINE of a data type with implicit default value leaves tmp frm
Submitted: 19 Sep 2007 15:46 Modified: 10 Oct 2007 11:49
Reporter: Jonathan Miller
Status: Closed
Category:Server: Cluster Severity:S2 (Serious)
Version:5.1-mysql-6.2 OS:Linux (64)
Assigned to: Martin Skold Target Version:

[19 Sep 2007 15:46] Jonathan Miller 
Description:
Doing and ALTER ONLINE ADD COLUMN using a data type is implicit default values will fail
w1th:

Alter Table Add Column TIMESTAMP
DBD::mysql::st execute failed: This version of MySQL doesn't yet support 'ALTER ONLINE
TABLE TABLE_ALTER.t1 ADD COLUMN c3 TIMESTAMP' 

which is okay, but it leaves a temp frm file in the database directory that will cause
DROP DATABASE to fail

How to repeat:
see above
[19 Sep 2007 17:54] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/34411

ChangeSet@1.2636, 2007-09-19 17:53:18+02:00, mskold@mysql.com +6 -0
  Bug #31097  ALTER ONLINE of a data type with implicit default value leaves tmp frm: only
remove frm file if file type is TMP_TABLE_FRM_FILE_ONLY
[20 Sep 2007 9:17] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/34414

ChangeSet@1.2637, 2007-09-20 09:14:25+02:00, mskold@mysql.com +2 -0
  Bug #31097  ALTER ONLINE of a data type with implicit default value leaves tmp frm:
fixed testcase so result is time independent
[10 Oct 2007 11:49] Jon Stephens 
Thank you for your bug report. This issue has been committed to our source repository of
that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version,
including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html

Documented in mysql-5.1.22-ndb-6.2.7 changelog as follows:

            Online <literal>ALTER</literal> operations involving a
            column whose data type has an implicit default value left
            behind temporary <filename>.FRM</filename> files, causing
            subsequent <literal>DROP DATABASE</literal> statements to
            fail.
[15 Oct 2007 19:56] Jon Stephens 
Also documented in mysql-5.1.22-ndb-6.3.4 changelog (already closed).