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 _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
