|
I'm filing here extra testcases that were posted as comments for MDEV-20501 but represent a different problem and are not fixed by the fix for MDEV-20501.
https://jira.mariadb.org/browse/MDEV-20501?focusedCommentId=153956&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-153956
USE test;
|
CREATE TABLE t (a TIMESTAMP,b TIMESTAMP); # (ENGINE=InnoDB)
|
INSERT INTO t VALUES (0,0);
|
SET SQL_MODE='TRADITIONAL';
|
SELECT TRUNCATE(a,b) AS c FROM t;
|
https://jira.mariadb.org/browse/MDEV-20501?focusedCommentId=188708&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-188708
SET sql_mode='';
|
CREATE TABLE t5 (c TIMESTAMP KEY,c2 INT NOT NULL,c3 CHAR(1) NOT NULL);
|
INSERT INTO t5 (c) VALUES (1);
|
SET sql_mode=traditional;
|
SELECT ROUND (c,c2),TRUNCATE (c,c2) FROM t5;
|
|