Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1(EOL), 10.2(EOL), 10.3(EOL)
Description
I add this code into type_decimal.test.
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; |
It adds the following output to the test result:
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;
|
Notice, a field of the "old" decimal type was created. It should create the new decimal variant.
Attachments
Issue Links
- blocks
-
MDEV-4912 Data type plugin API version 1
- Closed
- relates to
-
MDEV-16542 Fix ALTER TABLE FORCE to upgrade temporal types
- Closed