Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5, 10.6, 10.4(EOL), 10.7(EOL), 10.8(EOL), 10.9(EOL)
-
None
-
None
Description
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.
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; |
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; |
Attachments
Issue Links
- relates to
-
MDEV-20501 Assertion `maybe_null || !null_value' failed in Item_func_round::date_op
- Stalled