Sudheera Palihakkara added a comment - 2014-02-05 06:26 Hi, I'd like to know more information on this issue where is this testcase located? thanks

sbester1 added a comment - 2014-02-05 06:59 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>