[MDEV-12574] MAX(old_decimal) produces a column of the old DECIMAL type - Jira

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.

blocks

MDEV-4912 Data type plugin API version 1

relates to

MDEV-16542 Fix ALTER TABLE FORCE to upgrade temporal types

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server