From: Heikki Tuuri Date: May 21 2005 3:12pm Subject: bk commit into 5.0 tree (heikki:1.1898) List-Archive: http://lists.mysql.com/internals/25160 Message-Id: <200505211512.j4LFCvOX020235@hundin.mysql.fi> Below is the list of changes that have just been committed into a local 5.0 repository of heikki. When heikki does a push these changes will be propagated to the main repository and, within 24 hours after the push, to the public repository. For information on how to access the public repository see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html ChangeSet 1.1898 05/05/21 18:12:45 heikki@stripped +1 -0 ha_innodb.cc: The natural InnoDB type for NEWDECIMAL is FIXBINARY, not BINARY, since there probably is no benefit from stripping trailing bytes 0x20; note that tables created with 5.0.6 and containing DECIMAL do not need to be rebuilt, as BINARY works as well; note that because of Jani's fix to bug 10465, tables created with 5.0.? - 5.0.5 DO NEED TO BE REBUILT if they contain DECIMAL sql/ha_innodb.cc 1.210 05/05/21 18:12:28 heikki@stripped +1 -1 The natural InnoDB type for NEWDECIMAL is FIXBINARY, not BINARY, since there probably is no benefit from stripping trailing bytes 0x20; note that tables created with 5.0.6 and containing DECIMAL do not need to be rebuilt, as BINARY works as well; note that because of Jani's fix to bug 10465, tables created with 5.0.? - 5.0.5 DO NEED TO BE REBUILT if they contain DECIMAL # This is a BitKeeper patch. What follows are the unified diffs for the # set of deltas contained in the patch. The rest of the patch, the part # that BitKeeper cares about, is below these diffs. # User: heikki # Host: hundin.mysql.fi # Root: /home/heikki/mysql-5.0 --- 1.209/sql/ha_innodb.cc Tue May 17 21:47:10 2005 +++ 1.210/sql/ha_innodb.cc Sat May 21 18:12:28 2005 @@ -2606,7 +2606,7 @@ return(DATA_MYSQL); } case FIELD_TYPE_NEWDECIMAL: - return(DATA_BINARY); + return(DATA_FIXBINARY); case FIELD_TYPE_LONG: case FIELD_TYPE_LONGLONG: case FIELD_TYPE_TINY: