Hi,
I'd like to know more information on this issue where is this testcase located? thanks 
The problem is very simple. Look at it, you cannot create a table shown by 'show create table':
mysql> create table t1(a int, b timestamp as (a=1) virtual)engine=innodb;
|
Query OK, 0 rows affected (0.39 sec)
|
|
|
mysql> show create table t1;
|
+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| t1 | CREATE TABLE `t1` (
|
`a` int(11) DEFAULT NULL,
|
`b` timestamp AS (a=1) VIRTUAL NULL ON UPDATE CURRENT_TIMESTAMP
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.04 sec)
|
|
|
mysql> drop table if exists `t1`;
|
Query OK, 0 rows affected (0.19 sec)
|
|
|
mysql>
|
mysql> CREATE TABLE `t1` (
|
-> `a` int(11) DEFAULT NULL,
|
-> `b` timestamp AS (a=1) VIRTUAL NULL ON UPDATE CURRENT_TIMESTAMP
|
-> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'NULL ON UPDATE CURRENT_TIMESTAMP
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1' at line 3
|
mysql>
|
works in 10.1 - was fixed in MDEV-8441
MariaDB [test]> select @@version;
|
+--------------------+
|
| @@version |
|
+--------------------+
|
| 10.1.8-MariaDB-log |
|
+--------------------+
|
1 row in set (0.00 sec)
|
|
|
MariaDB [test]> create table t1(a int, b timestamp as (a=1) virtual)engine=innodb;
|
Query OK, 0 rows affected (0.00 sec)
|
|
|
MariaDB [test]> show create table t1;
|
+-------+-------------------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+-------------------------------------------------------------------------------------------------------------------------+
|
| t1 | CREATE TABLE `t1` (
|
`a` int(11) DEFAULT NULL,
|
`b` timestamp AS (a=1) VIRTUAL
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
+-------+-------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.00 sec)
|
|
|
MariaDB [test]> drop table t1;CREATE TABLE `t1` (
|
Query OK, 0 rows affected (0.01 sec)
|
|
|
-> `a` int(11) DEFAULT NULL,
|
-> `b` timestamp AS (a=1) VIRTUAL
|
-> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
Query OK, 0 rows affected (0.00 sec)
|
MariaDB [test]> select @@version
|
-> ;
|
+---------------------+
|
| @@version |
|
+---------------------+
|
| 10.0.22-MariaDB-log |
|
+---------------------+
|
1 row in set (0.00 sec)
|
|
|
MariaDB [test]> create table t1(a int, b timestamp as (a=1) virtual)engine=innodb;
|
Query OK, 0 rows affected (0.00 sec)
|
|
|
MariaDB [test]> show create table t1;
|
+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| t1 | CREATE TABLE `t1` (
|
`a` int(11) DEFAULT NULL,
|
`b` timestamp AS (a=1) VIRTUAL NULL ON UPDATE CURRENT_TIMESTAMP
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.00 sec)
|