Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.13
-
None
Description
This script:
SET @@old_mode=zero_date_time_cast; |
DROP TABLE IF EXISTS t1; |
CREATE TABLE t1 (a TIME,b TIME(1)); |
INSERT INTO t1 VALUES (TIME'830:20:30',TIME'830:20:30'); |
SELECT TO_DAYS(a), TO_DAYS(b) FROM t1; |
SHOW WARNINGS;
|
produces the following output:
...
|
MariaDB [test]> SELECT TO_DAYS(a), TO_DAYS(b) FROM t1;
|
+------------+------------+
|
| TO_DAYS(a) | TO_DAYS(b) |
|
+------------+------------+
|
| NULL | NULL |
|
+------------+------------+
|
1 row in set, 1 warning (0.00 sec)
|
|
MariaDB [test]> SHOW WARNINGS;
|
+---------+------+--------------------------------------------+
|
| Level | Code | Message |
|
+---------+------+--------------------------------------------+
|
| Warning | 1264 | Out of range value for column 'a' at row 1 |
|
+---------+------+--------------------------------------------+
|
1 row in set (0.00 sec)
|
Notice, the warning was correctly displayed for the column 'a',
but was not displayed for the column 'b'.
Attachments
Activity
Field | Original Value | New Value |
---|---|---|
Fix Version/s | 10.0 [ 16000 ] |
Component/s | OTHER [ 10125 ] | |
Fix Version/s | 10.0.15 [ 17300 ] | |
Fix Version/s | 10.0 [ 16000 ] | |
Resolution | Fixed [ 1 ] | |
Status | Open [ 1 ] | Closed [ 6 ] |
Component/s | Temporal Types [ 11000 ] | |
Component/s | OTHER [ 10125 ] |
Workflow | MariaDB v2 [ 53216 ] | MariaDB v3 [ 66254 ] |
Workflow | MariaDB v3 [ 66254 ] | MariaDB v4 [ 148164 ] |