#
# Start of 10.4 tests
#
#
#  MDEV-16542 Fix ALTER TABLE FORCE to upgrade temporal types
#
CREATE PROCEDURE mdev16542_create_select()
BEGIN
SELECT '# CREATE..SELECT and SHOW' AS ``;
CREATE TABLE t2 AS SELECT
a0, a1, a2, a3, a4, a5, a6,
COALESCE(a0),
COALESCE(a1),
COALESCE(a2),
COALESCE(a3),
COALESCE(a4),
COALESCE(a5),
COALESCE(a6)
FROM t1;
SHOW CREATE TABLE t2;
DROP TABLE t2;
END;
$$
CREATE PROCEDURE mdev16542_alter_force_and_show()
BEGIN
SELECT '# ALTER..FORCE and SHOW' AS ``;
ALTER TABLE t1 FORCE;
SHOW CREATE TABLE t1;
END;
$$
CREATE PROCEDURE mdev16542()
BEGIN
SET SESSION debug_dbug="+d,sql_type";
SELECT '# Original table' AS ``;
SHOW CREATE TABLE t1;
CALL mdev16542_create_select();
CALL mdev16542_alter_force_and_show();
SELECT '# Setting @@global.mysql56_temporal_format=false' AS ``;
SET @@global.mysql56_temporal_format=false;
CALL mdev16542_create_select();
CALL mdev16542_alter_force_and_show();
SELECT '# Setting @@global.mysql56_temporal_format=true' AS ``;
SET @@global.mysql56_temporal_format=true;
CALL mdev16542_create_select();
CALL mdev16542_alter_force_and_show();
SET SESSION debug_dbug="-d,sql_type";
END;
$$
SET @@global.mysql56_temporal_format=true;
CREATE TABLE t1 (
a0 TIME,
a1 TIME(1),
a2 TIME(2),
a3 TIME(3),
a4 TIME(4),
a5 TIME(5),
a6 TIME(6)
);
CALL mdev16542;

# Original table
Table	Create Table
t1	CREATE TABLE `t1` (
  `a0` time /* mysql-5.6 */ DEFAULT NULL,
  `a1` time(1) /* mysql-5.6 */ DEFAULT NULL,
  `a2` time(2) /* mysql-5.6 */ DEFAULT NULL,
  `a3` time(3) /* mysql-5.6 */ DEFAULT NULL,
  `a4` time(4) /* mysql-5.6 */ DEFAULT NULL,
  `a5` time(5) /* mysql-5.6 */ DEFAULT NULL,
  `a6` time(6) /* mysql-5.6 */ DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1

# CREATE..SELECT and SHOW
Table	Create Table
t2	CREATE TABLE `t2` (
  `a0` time /* mysql-5.6 */ DEFAULT NULL,
  `a1` time(1) /* mysql-5.6 */ DEFAULT NULL,
  `a2` time(2) /* mysql-5.6 */ DEFAULT NULL,
  `a3` time(3) /* mysql-5.6 */ DEFAULT NULL,
  `a4` time(4) /* mysql-5.6 */ DEFAULT NULL,
  `a5` time(5) /* mysql-5.6 */ DEFAULT NULL,
  `a6` time(6) /* mysql-5.6 */ DEFAULT NULL,
  `COALESCE(a0)` time /* mysql-5.6 */ DEFAULT NULL,
  `COALESCE(a1)` time(1) /* mysql-5.6 */ DEFAULT NULL,
  `COALESCE(a2)` time(2) /* mysql-5.6 */ DEFAULT NULL,
  `COALESCE(a3)` time(3) /* mysql-5.6 */ DEFAULT NULL,
  `COALESCE(a4)` time(4) /* mysql-5.6 */ DEFAULT NULL,
  `COALESCE(a5)` time(5) /* mysql-5.6 */ DEFAULT NULL,
  `COALESCE(a6)` time(6) /* mysql-5.6 */ DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1

# ALTER..FORCE and SHOW
Table	Create Table
t1	CREATE TABLE `t1` (
  `a0` time /* mysql-5.6 */ DEFAULT NULL,
  `a1` time(1) /* mysql-5.6 */ DEFAULT NULL,
  `a2` time(2) /* mysql-5.6 */ DEFAULT NULL,
  `a3` time(3) /* mysql-5.6 */ DEFAULT NULL,
  `a4` time(4) /* mysql-5.6 */ DEFAULT NULL,
  `a5` time(5) /* mysql-5.6 */ DEFAULT NULL,
  `a6` time(6) /* mysql-5.6 */ DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1

# Setting @@global.mysql56_temporal_format=false

# CREATE..SELECT and SHOW
Table	Create Table
t2	CREATE TABLE `t2` (
  `a0` time /* mariadb-5.3 */ DEFAULT NULL,
  `a1` time(1) /* mariadb-5.3 */ DEFAULT NULL,
  `a2` time(2) /* mariadb-5.3 */ DEFAULT NULL,
  `a3` time(3) /* mariadb-5.3 */ DEFAULT NULL,
  `a4` time(4) /* mariadb-5.3 */ DEFAULT NULL,
  `a5` time(5) /* mariadb-5.3 */ DEFAULT NULL,
  `a6` time(6) /* mariadb-5.3 */ DEFAULT NULL,
  `COALESCE(a0)` time /* mariadb-5.3 */ DEFAULT NULL,
  `COALESCE(a1)` time(1) /* mariadb-5.3 */ DEFAULT NULL,
  `COALESCE(a2)` time(2) /* mariadb-5.3 */ DEFAULT NULL,
  `COALESCE(a3)` time(3) /* mariadb-5.3 */ DEFAULT NULL,
  `COALESCE(a4)` time(4) /* mariadb-5.3 */ DEFAULT NULL,
  `COALESCE(a5)` time(5) /* mariadb-5.3 */ DEFAULT NULL,
  `COALESCE(a6)` time(6) /* mariadb-5.3 */ DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1

# ALTER..FORCE and SHOW
Table	Create Table
t1	CREATE TABLE `t1` (
  `a0` time /* mariadb-5.3 */ DEFAULT NULL,
  `a1` time(1) /* mariadb-5.3 */ DEFAULT NULL,
  `a2` time(2) /* mariadb-5.3 */ DEFAULT NULL,
  `a3` time(3) /* mariadb-5.3 */ DEFAULT NULL,
  `a4` time(4) /* mariadb-5.3 */ DEFAULT NULL,
  `a5` time(5) /* mariadb-5.3 */ DEFAULT NULL,
  `a6` time(6) /* mariadb-5.3 */ DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1

# Setting @@global.mysql56_temporal_format=true

# CREATE..SELECT and SHOW
Table	Create Table
t2	CREATE TABLE `t2` (
  `a0` time /* mysql-5.6 */ DEFAULT NULL,
  `a1` time(1) /* mysql-5.6 */ DEFAULT NULL,
  `a2` time(2) /* mysql-5.6 */ DEFAULT NULL,
  `a3` time(3) /* mysql-5.6 */ DEFAULT NULL,
  `a4` time(4) /* mysql-5.6 */ DEFAULT NULL,
  `a5` time(5) /* mysql-5.6 */ DEFAULT NULL,
  `a6` time(6) /* mysql-5.6 */ DEFAULT NULL,
  `COALESCE(a0)` time /* mysql-5.6 */ DEFAULT NULL,
  `COALESCE(a1)` time(1) /* mysql-5.6 */ DEFAULT NULL,
  `COALESCE(a2)` time(2) /* mysql-5.6 */ DEFAULT NULL,
  `COALESCE(a3)` time(3) /* mysql-5.6 */ DEFAULT NULL,
  `COALESCE(a4)` time(4) /* mysql-5.6 */ DEFAULT NULL,
  `COALESCE(a5)` time(5) /* mysql-5.6 */ DEFAULT NULL,
  `COALESCE(a6)` time(6) /* mysql-5.6 */ DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1

# ALTER..FORCE and SHOW
Table	Create Table
t1	CREATE TABLE `t1` (
  `a0` time /* mysql-5.6 */ DEFAULT NULL,
  `a1` time(1) /* mysql-5.6 */ DEFAULT NULL,
  `a2` time(2) /* mysql-5.6 */ DEFAULT NULL,
  `a3` time(3) /* mysql-5.6 */ DEFAULT NULL,
  `a4` time(4) /* mysql-5.6 */ DEFAULT NULL,
  `a5` time(5) /* mysql-5.6 */ DEFAULT NULL,
  `a6` time(6) /* mysql-5.6 */ DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
DROP TABLE t1;
CREATE TABLE t1 (
a0 DATETIME,
a1 DATETIME(1),
a2 DATETIME(2),
a3 DATETIME(3),
a4 DATETIME(4),
a5 DATETIME(5),
a6 DATETIME(6)
);
CALL mdev16542;

# Original table
Table	Create Table
t1	CREATE TABLE `t1` (
  `a0` datetime /* mysql-5.6 */ DEFAULT NULL,
  `a1` datetime(1) /* mysql-5.6 */ DEFAULT NULL,
  `a2` datetime(2) /* mysql-5.6 */ DEFAULT NULL,
  `a3` datetime(3) /* mysql-5.6 */ DEFAULT NULL,
  `a4` datetime(4) /* mysql-5.6 */ DEFAULT NULL,
  `a5` datetime(5) /* mysql-5.6 */ DEFAULT NULL,
  `a6` datetime(6) /* mysql-5.6 */ DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1

# CREATE..SELECT and SHOW
Table	Create Table
t2	CREATE TABLE `t2` (
  `a0` datetime /* mysql-5.6 */ DEFAULT NULL,
  `a1` datetime(1) /* mysql-5.6 */ DEFAULT NULL,
  `a2` datetime(2) /* mysql-5.6 */ DEFAULT NULL,
  `a3` datetime(3) /* mysql-5.6 */ DEFAULT NULL,
  `a4` datetime(4) /* mysql-5.6 */ DEFAULT NULL,
  `a5` datetime(5) /* mysql-5.6 */ DEFAULT NULL,
  `a6` datetime(6) /* mysql-5.6 */ DEFAULT NULL,
  `COALESCE(a0)` datetime /* mysql-5.6 */ DEFAULT NULL,
  `COALESCE(a1)` datetime(1) /* mysql-5.6 */ DEFAULT NULL,
  `COALESCE(a2)` datetime(2) /* mysql-5.6 */ DEFAULT NULL,
  `COALESCE(a3)` datetime(3) /* mysql-5.6 */ DEFAULT NULL,
  `COALESCE(a4)` datetime(4) /* mysql-5.6 */ DEFAULT NULL,
  `COALESCE(a5)` datetime(5) /* mysql-5.6 */ DEFAULT NULL,
  `COALESCE(a6)` datetime(6) /* mysql-5.6 */ DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1

# ALTER..FORCE and SHOW
Table	Create Table
t1	CREATE TABLE `t1` (
  `a0` datetime /* mysql-5.6 */ DEFAULT NULL,
  `a1` datetime(1) /* mysql-5.6 */ DEFAULT NULL,
  `a2` datetime(2) /* mysql-5.6 */ DEFAULT NULL,
  `a3` datetime(3) /* mysql-5.6 */ DEFAULT NULL,
  `a4` datetime(4) /* mysql-5.6 */ DEFAULT NULL,
  `a5` datetime(5) /* mysql-5.6 */ DEFAULT NULL,
  `a6` datetime(6) /* mysql-5.6 */ DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1

# Setting @@global.mysql56_temporal_format=false

# CREATE..SELECT and SHOW
Table	Create Table
t2	CREATE TABLE `t2` (
  `a0` datetime /* mariadb-5.3 */ DEFAULT NULL,
  `a1` datetime(1) /* mariadb-5.3 */ DEFAULT NULL,
  `a2` datetime(2) /* mariadb-5.3 */ DEFAULT NULL,
  `a3` datetime(3) /* mariadb-5.3 */ DEFAULT NULL,
  `a4` datetime(4) /* mariadb-5.3 */ DEFAULT NULL,
  `a5` datetime(5) /* mariadb-5.3 */ DEFAULT NULL,
  `a6` datetime(6) /* mariadb-5.3 */ DEFAULT NULL,
  `COALESCE(a0)` datetime /* mariadb-5.3 */ DEFAULT NULL,
  `COALESCE(a1)` datetime(1) /* mariadb-5.3 */ DEFAULT NULL,
  `COALESCE(a2)` datetime(2) /* mariadb-5.3 */ DEFAULT NULL,
  `COALESCE(a3)` datetime(3) /* mariadb-5.3 */ DEFAULT NULL,
  `COALESCE(a4)` datetime(4) /* mariadb-5.3 */ DEFAULT NULL,
  `COALESCE(a5)` datetime(5) /* mariadb-5.3 */ DEFAULT NULL,
  `COALESCE(a6)` datetime(6) /* mariadb-5.3 */ DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1

# ALTER..FORCE and SHOW
Table	Create Table
t1	CREATE TABLE `t1` (
  `a0` datetime /* mariadb-5.3 */ DEFAULT NULL,
  `a1` datetime(1) /* mariadb-5.3 */ DEFAULT NULL,
  `a2` datetime(2) /* mariadb-5.3 */ DEFAULT NULL,
  `a3` datetime(3) /* mariadb-5.3 */ DEFAULT NULL,
  `a4` datetime(4) /* mariadb-5.3 */ DEFAULT NULL,
  `a5` datetime(5) /* mariadb-5.3 */ DEFAULT NULL,
  `a6` datetime(6) /* mariadb-5.3 */ DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1

# Setting @@global.mysql56_temporal_format=true

# CREATE..SELECT and SHOW
Table	Create Table
t2	CREATE TABLE `t2` (
  `a0` datetime /* mysql-5.6 */ DEFAULT NULL,
  `a1` datetime(1) /* mysql-5.6 */ DEFAULT NULL,
  `a2` datetime(2) /* mysql-5.6 */ DEFAULT NULL,
  `a3` datetime(3) /* mysql-5.6 */ DEFAULT NULL,
  `a4` datetime(4) /* mysql-5.6 */ DEFAULT NULL,
  `a5` datetime(5) /* mysql-5.6 */ DEFAULT NULL,
  `a6` datetime(6) /* mysql-5.6 */ DEFAULT NULL,
  `COALESCE(a0)` datetime /* mysql-5.6 */ DEFAULT NULL,
  `COALESCE(a1)` datetime(1) /* mysql-5.6 */ DEFAULT NULL,
  `COALESCE(a2)` datetime(2) /* mysql-5.6 */ DEFAULT NULL,
  `COALESCE(a3)` datetime(3) /* mysql-5.6 */ DEFAULT NULL,
  `COALESCE(a4)` datetime(4) /* mysql-5.6 */ DEFAULT NULL,
  `COALESCE(a5)` datetime(5) /* mysql-5.6 */ DEFAULT NULL,
  `COALESCE(a6)` datetime(6) /* mysql-5.6 */ DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1

# ALTER..FORCE and SHOW
Table	Create Table
t1	CREATE TABLE `t1` (
  `a0` datetime /* mysql-5.6 */ DEFAULT NULL,
  `a1` datetime(1) /* mysql-5.6 */ DEFAULT NULL,
  `a2` datetime(2) /* mysql-5.6 */ DEFAULT NULL,
  `a3` datetime(3) /* mysql-5.6 */ DEFAULT NULL,
  `a4` datetime(4) /* mysql-5.6 */ DEFAULT NULL,
  `a5` datetime(5) /* mysql-5.6 */ DEFAULT NULL,
  `a6` datetime(6) /* mysql-5.6 */ DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
DROP TABLE t1;
CREATE TABLE t1 (
a0 TIMESTAMP,
a1 TIMESTAMP(1),
a2 TIMESTAMP(2),
a3 TIMESTAMP(3),
a4 TIMESTAMP(4),
a5 TIMESTAMP(5),
a6 TIMESTAMP(6)
);
CALL mdev16542;

# Original table
Table	Create Table
t1	CREATE TABLE `t1` (
  `a0` timestamp /* mysql-5.6 */ NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `a1` timestamp(1) /* mysql-5.6 */ NOT NULL DEFAULT '0000-00-00 00:00:00.0',
  `a2` timestamp(2) /* mysql-5.6 */ NOT NULL DEFAULT '0000-00-00 00:00:00.00',
  `a3` timestamp(3) /* mysql-5.6 */ NOT NULL DEFAULT '0000-00-00 00:00:00.000',
  `a4` timestamp(4) /* mysql-5.6 */ NOT NULL DEFAULT '0000-00-00 00:00:00.0000',
  `a5` timestamp(5) /* mysql-5.6 */ NOT NULL DEFAULT '0000-00-00 00:00:00.00000',
  `a6` timestamp(6) /* mysql-5.6 */ NOT NULL DEFAULT '0000-00-00 00:00:00.000000'
) ENGINE=MyISAM DEFAULT CHARSET=latin1

# CREATE..SELECT and SHOW
Table	Create Table
t2	CREATE TABLE `t2` (
  `a0` timestamp /* mysql-5.6 */ NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `a1` timestamp(1) /* mysql-5.6 */ NOT NULL DEFAULT '0000-00-00 00:00:00.0',
  `a2` timestamp(2) /* mysql-5.6 */ NOT NULL DEFAULT '0000-00-00 00:00:00.00',
  `a3` timestamp(3) /* mysql-5.6 */ NOT NULL DEFAULT '0000-00-00 00:00:00.000',
  `a4` timestamp(4) /* mysql-5.6 */ NOT NULL DEFAULT '0000-00-00 00:00:00.0000',
  `a5` timestamp(5) /* mysql-5.6 */ NOT NULL DEFAULT '0000-00-00 00:00:00.00000',
  `a6` timestamp(6) /* mysql-5.6 */ NOT NULL DEFAULT '0000-00-00 00:00:00.000000',
  `COALESCE(a0)` timestamp /* mysql-5.6 */ NULL DEFAULT NULL,
  `COALESCE(a1)` timestamp(1) /* mysql-5.6 */ NULL DEFAULT NULL,
  `COALESCE(a2)` timestamp(2) /* mysql-5.6 */ NULL DEFAULT NULL,
  `COALESCE(a3)` timestamp(3) /* mysql-5.6 */ NULL DEFAULT NULL,
  `COALESCE(a4)` timestamp(4) /* mysql-5.6 */ NULL DEFAULT NULL,
  `COALESCE(a5)` timestamp(5) /* mysql-5.6 */ NULL DEFAULT NULL,
  `COALESCE(a6)` timestamp(6) /* mysql-5.6 */ NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1

# ALTER..FORCE and SHOW
Table	Create Table
t1	CREATE TABLE `t1` (
  `a0` timestamp /* mysql-5.6 */ NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `a1` timestamp(1) /* mysql-5.6 */ NOT NULL DEFAULT '0000-00-00 00:00:00.0',
  `a2` timestamp(2) /* mysql-5.6 */ NOT NULL DEFAULT '0000-00-00 00:00:00.00',
  `a3` timestamp(3) /* mysql-5.6 */ NOT NULL DEFAULT '0000-00-00 00:00:00.000',
  `a4` timestamp(4) /* mysql-5.6 */ NOT NULL DEFAULT '0000-00-00 00:00:00.0000',
  `a5` timestamp(5) /* mysql-5.6 */ NOT NULL DEFAULT '0000-00-00 00:00:00.00000',
  `a6` timestamp(6) /* mysql-5.6 */ NOT NULL DEFAULT '0000-00-00 00:00:00.000000'
) ENGINE=MyISAM DEFAULT CHARSET=latin1

# Setting @@global.mysql56_temporal_format=false

# CREATE..SELECT and SHOW
Table	Create Table
t2	CREATE TABLE `t2` (
  `a0` timestamp /* mariadb-5.3 */ NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `a1` timestamp(1) /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00.0',
  `a2` timestamp(2) /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00.00',
  `a3` timestamp(3) /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00.000',
  `a4` timestamp(4) /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00.0000',
  `a5` timestamp(5) /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00.00000',
  `a6` timestamp(6) /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00.000000',
  `COALESCE(a0)` timestamp /* mariadb-5.3 */ NULL DEFAULT NULL,
  `COALESCE(a1)` timestamp(1) /* mariadb-5.3 */ NULL DEFAULT NULL,
  `COALESCE(a2)` timestamp(2) /* mariadb-5.3 */ NULL DEFAULT NULL,
  `COALESCE(a3)` timestamp(3) /* mariadb-5.3 */ NULL DEFAULT NULL,
  `COALESCE(a4)` timestamp(4) /* mariadb-5.3 */ NULL DEFAULT NULL,
  `COALESCE(a5)` timestamp(5) /* mariadb-5.3 */ NULL DEFAULT NULL,
  `COALESCE(a6)` timestamp(6) /* mariadb-5.3 */ NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1

# ALTER..FORCE and SHOW
Table	Create Table
t1	CREATE TABLE `t1` (
  `a0` timestamp /* mariadb-5.3 */ NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `a1` timestamp(1) /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00.0',
  `a2` timestamp(2) /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00.00',
  `a3` timestamp(3) /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00.000',
  `a4` timestamp(4) /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00.0000',
  `a5` timestamp(5) /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00.00000',
  `a6` timestamp(6) /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00.000000'
) ENGINE=MyISAM DEFAULT CHARSET=latin1

# Setting @@global.mysql56_temporal_format=true

# CREATE..SELECT and SHOW
Table	Create Table
t2	CREATE TABLE `t2` (
  `a0` timestamp /* mysql-5.6 */ NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `a1` timestamp(1) /* mysql-5.6 */ NOT NULL DEFAULT '0000-00-00 00:00:00.0',
  `a2` timestamp(2) /* mysql-5.6 */ NOT NULL DEFAULT '0000-00-00 00:00:00.00',
  `a3` timestamp(3) /* mysql-5.6 */ NOT NULL DEFAULT '0000-00-00 00:00:00.000',
  `a4` timestamp(4) /* mysql-5.6 */ NOT NULL DEFAULT '0000-00-00 00:00:00.0000',
  `a5` timestamp(5) /* mysql-5.6 */ NOT NULL DEFAULT '0000-00-00 00:00:00.00000',
  `a6` timestamp(6) /* mysql-5.6 */ NOT NULL DEFAULT '0000-00-00 00:00:00.000000',
  `COALESCE(a0)` timestamp /* mysql-5.6 */ NULL DEFAULT NULL,
  `COALESCE(a1)` timestamp(1) /* mysql-5.6 */ NULL DEFAULT NULL,
  `COALESCE(a2)` timestamp(2) /* mysql-5.6 */ NULL DEFAULT NULL,
  `COALESCE(a3)` timestamp(3) /* mysql-5.6 */ NULL DEFAULT NULL,
  `COALESCE(a4)` timestamp(4) /* mysql-5.6 */ NULL DEFAULT NULL,
  `COALESCE(a5)` timestamp(5) /* mysql-5.6 */ NULL DEFAULT NULL,
  `COALESCE(a6)` timestamp(6) /* mysql-5.6 */ NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1

# ALTER..FORCE and SHOW
Table	Create Table
t1	CREATE TABLE `t1` (
  `a0` timestamp /* mysql-5.6 */ NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `a1` timestamp(1) /* mysql-5.6 */ NOT NULL DEFAULT '0000-00-00 00:00:00.0',
  `a2` timestamp(2) /* mysql-5.6 */ NOT NULL DEFAULT '0000-00-00 00:00:00.00',
  `a3` timestamp(3) /* mysql-5.6 */ NOT NULL DEFAULT '0000-00-00 00:00:00.000',
  `a4` timestamp(4) /* mysql-5.6 */ NOT NULL DEFAULT '0000-00-00 00:00:00.0000',
  `a5` timestamp(5) /* mysql-5.6 */ NOT NULL DEFAULT '0000-00-00 00:00:00.00000',
  `a6` timestamp(6) /* mysql-5.6 */ NOT NULL DEFAULT '0000-00-00 00:00:00.000000'
) ENGINE=MyISAM DEFAULT CHARSET=latin1
DROP TABLE t1;
SET @@global.mysql56_temporal_format=DEFAULT;
DROP PROCEDURE mdev16542;
DROP PROCEDURE mdev16542_create_select;
DROP PROCEDURE mdev16542_alter_force_and_show;
#
# End of 10.4 tests
#