maria-discuss team mailing list archive

[Federico Razzoli <federico_raz@xxxxxxxx>]

Hi! MySQL 5.6 returns a warning for wrong datatypes, with any SQL_MODE:


mysql> CREATE TABLE t (c TIMESTAMP) ENGINE=InnoDB;
Query OK, 0 rows affected (0,31 sec)

mysql> SELECT c FROM t WHERE c = 1;
Empty set, 1 warning (0,00 sec)

Warning (Code 1292): Incorrect datetime value: '1' for column 'c' at row 1


Will this be done in MariaDB 10 too? Currently, no warning is issued.

Federico