Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2.2, 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL)
-
None
Description
MariaDB [test]> set sql_mode='STRICT_TRANS_TABLES,NO_ZERO_DATE';
|
Query OK, 0 rows affected (0.00 sec)
|
 |
MariaDB [test]> CREATE TABLE t1 (
|
-> ts TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
-> tsv TIMESTAMP AS (ADDDATE(ts, INTERVAL 1 DAY)) VIRTUAL
|
-> ) ENGINE=MyISAM;
|
ERROR 1067 (42000): Invalid default value for 'tsv'
|
Attachments
Issue Links
- relates to
-
MDEV-7635 update defaults and simplify mysqld config parameters
- Closed
- links to