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>

Daniel Black added a comment - 2015-11-03 09:12 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)