Details
Description
The logical NOT operator produces inconsistent and incorrect results when applied to the DATE_FORMAT function if the function is given invalid (non-date/string) arguments.
CREATE TABLE t80 (c2 DECIMAL(10,10)); |
INSERT INTO t80 (c2) VALUES (0.1); |
 |
select not DATE_FORMAT(c2, c2) FROM t80; |
-- return 0.1
|
select not DATE_FORMAT(c2, c2) FROM t80; |
-- return 0
|
select not(not DATE_FORMAT(c2, c2)) FROM t80; |
-- return 0 ,expected 1 |
Attachments
Issue Links
- relates to
-
MDEV-36440 Double negation is treated as original value in WHERE clause
-
- Confirmed
-