Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6, 10.11, 11.4, 11.8, 12.1.2
-
None
Description
after changing YEAR function the value unexpectedly change
the problem is the same as MDEV-38577 and MDEV-38576,but the function is different
mysql> SELECT YEAR(dkw78.c5) AS col_1 FROM t3 AS dkw78;
|
+-------+
|
| col_1 |
|
+-------+
|
| 2026 | |
+-------+
|
1 row in set (0.00 sec) |
|
|
mysql> SELECT YEAR(dkw78.c5 + INTERVAL '1' YEAR) - 1 AS col_1 FROM t3 AS dkw78; |
+-------+
|
| col_1 |
|
+-------+
|
| NULL |
|
+-------+
|
1 row in set, 1 warning (0.00 sec) |
How to repeat
DROP DATABASE IF EXISTS test; |
CREATE DATABASE IF NOT EXISTS test; |
USE test; |
|
|
CREATE TABLE t3 ( |
c5 TIME NULL |
);
|
|
|
INSERT INTO t3 (c5) VALUES ( '2023-01-01 22:44:35'); |
|
|
SELECT YEAR(dkw78.c5) AS col_1 FROM t3 AS dkw78; |
SELECT YEAR(dkw78.c5 + INTERVAL '1' YEAR) - 1 AS col_1 FROM t3 AS dkw78; |
|
Version
mysql> select version();
|
+------------------------+
|
| version() |
|
+------------------------+
|
| 12.1.2-MariaDB-ubu2404 | |
+------------------------+
|
1 row in set (0.00 sec) |
Attachments
Issue Links
- is duplicated by
-
MDEV-38576 after change MONTH function ,the value unexpectedly change
-
- Closed
-
-
MDEV-38577 after changing day function,the value unexpectedly change to null
-
- Closed
-