Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
5.5, 10.0, 10.1, 10.2, 10.3, 10.4
-
None
-
None
Description
EXTRACT(WEEK) returns strange values for dates with zero components :
SET sql_mode=''; -- Allow zeros in dates |
DROP TABLE IF EXISTS t1; |
CREATE TABLE t1 (a DATE); |
INSERT INTO t1 VALUES ('0000-00-00'),('0000-00-01'),('0000-01-00'),('0000-01-01'),('0001-00-00'),('0001-00-01'),('0001-01-00'),('0001-01-01'); |
SELECT a, EXTRACT(WEEK FROM a) FROM t1; |
returns
+------------+----------------------+
|
| a | EXTRACT(WEEK FROM a) |
|
+------------+----------------------+
|
| 0000-00-00 | 613566757 |
|
| 0000-00-01 | 613566757 |
|
| 0000-01-00 | 52 |
|
| 0000-01-01 | 1 |
|
| 0001-00-00 | 613566752 |
|
| 0001-00-01 | 613566752 |
|
| 0001-01-00 | 0 |
|
| 0001-01-01 | 0 |
|
+------------+----------------------+
|
EXTRACT(WEEK FROM time_expr) also returns a strange result:
SELECT EXTRACT(WEEK FROM TIME'10:20:30'); |
+-----------------------------------+
|
| EXTRACT(WEEK FROM TIME'10:20:30') |
|
+-----------------------------------+
|
| 613566757 |
|
+-----------------------------------+
|