ALTER and CREATE with default partitioning differently react to SQL_MODE => unusable SHOW CREATE

--source include/have_partition.inc

create table t (a int) with system versioning;

alter table t partition by system_time partitions 3;

show create table t;

--let $show= query_get_value(show create table t, 'Create Table', 1)

drop table t;

--eval $show

# Cleanup

drop table if exists t;

MariaDB [test]> create table t (a int) with system versioning;

Query OK, 0 rows affected (0.033 sec)

MariaDB [test]> alter table t partition by system_time partitions 3;

Query OK, 0 rows affected, 1 warning (0.084 sec)   

Records: 0  Duplicates: 0  Warnings: 1

MariaDB [test]> show warnings;

+---------+------+----------------------------------------------------------------------------------+

| Level   | Code | Message                                                                          |

+---------+------+----------------------------------------------------------------------------------+

| Warning | 4115 | Maybe missing parameters: no rotation condition for multiple HISTORY partitions. |

+---------+------+----------------------------------------------------------------------------------+

1 row in set (0.000 sec)

MariaDB [test]> show create table t;

+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------+

| Table | Create Table                                                                                                                                        |

+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------+

| t     | CREATE TABLE `t` (

  `a` int(11) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1 WITH SYSTEM VERSIONING

 PARTITION BY SYSTEM_TIME 

PARTITIONS 3 |

+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------+

1 row in set (0.023 sec)

MariaDB [test]> drop table t;

Query OK, 0 rows affected (0.040 sec)

MariaDB [test]> CREATE TABLE `t` (

    ->   `a` int(11) DEFAULT NULL

    -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1 WITH SYSTEM VERSIONING

    ->  PARTITION BY SYSTEM_TIME 

    -> PARTITIONS 3;

ERROR 4115 (HY000): Maybe missing parameters: no rotation condition for multiple HISTORY partitions.