let $MYSQLD_DATADIR= `select @@datadir`;

--copy_file std_data/old_decimal/t1dec102.frm $MYSQLD_DATADIR/test/t1dec102.frm

--copy_file std_data/old_decimal/t1dec102.MYD $MYSQLD_DATADIR/test/t1dec102.MYD

--copy_file std_data/old_decimal/t1dec102.MYI $MYSQLD_DATADIR/test/t1dec102.MYI

CREATE TABLE t1 AS SELECT MAX(a) FROM t1dec102;

SHOW CREATE TABLE t1;

DROP TABLE t1;

CREATE TABLE t1 AS SELECT MAX(a) FROM t1dec102;

SHOW CREATE TABLE t1;

Table	Create Table

t1	CREATE TABLE `t1` (

  `MAX(a)` decimal(10,2)/*old*/ DEFAULT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1

DROP TABLE t1;