We're updating the issue view to help you get more done. 

FROM_DAYS(<timestamp column>) returns different result in MariaDB comparing to MySQL: NULL vs 0000-00-00

Description

It's rather a cosmetic difference, but I want to fix our failures on MySQL engines suite (again), and this is one of them. So, if it's intended behavior, please reassign the bug back to me so I update the result file for engines/funcs/r/date_function.

MariaDB 5.3, 5.5, 10.0:

1 2 3 4 5 CREATE TABLE t1(c1 TIMESTAMP NOT NULL) ENGINE=MyISAM; INSERT INTO t1 VALUES('2008-02-29'); SELECT FROM_DAYS(c1) FROM t1; # FROM_DAYS(c1) # NULL

MySQL 5.1, 5.5, 5.6, MariaDB 5.2:

1 2 3 4 5 CREATE TABLE t1(c1 TIMESTAMP NOT NULL) ENGINE=MyISAM; INSERT INTO t1 VALUES('2008-02-29'); SELECT FROM_DAYS(c1) FROM t1; # FROM_DAYS(c1) # 0000-00-00

No warnings on either version.

Environment

None

Status

Assignee

Sergei Golubchik

Reporter

Elena Stepanova

Fix versions

Affects versions

10.0.0
5.5.28a
5.3.11

Priority

Trivial