[MDEV-5827] CAST(field_bit AS TIME) does not work well Created: 2014-03-11  Updated: 2023-11-28

Status: Confirmed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.1.67, 5.2.14, 5.3.12, 5.5.36, 10.0.10
Fix Version/s: 10.4, 10.5, 10.6

Type: Bug Priority: Minor
Reporter: Alexander Barkov Assignee: Alexander Barkov
Resolution: Unresolved Votes: 0
Labels: upstream


 Description   

The BIT field works well as a number in most cases,
but not when casting it to temporal data types:

DROP TABLE IF EXISTS t1;
 
CREATE TABLE t1 (a BIT(8));
 
INSERT INTO t1 VALUES (0xFF);
 
SELECT a+0,CAST(255 AS TIME), CAST(a AS TIME) FROM t1;
 
SHOW WARNINGS;

returns

+------+-------------------+-----------------+
 
| a+0  | CAST(255 AS TIME) | CAST(a AS TIME) |
 
+------+-------------------+-----------------+
 
|  255 | 00:02:55          | 00:00:00        |
 
+------+-------------------+-----------------+
 
1 row in set, 1 warning (0.00 sec)
 
 
 
+---------+------+----------------------------------------+
 
| Level   | Code | Message                                |
 
+---------+------+----------------------------------------+
 
| Warning | 1292 | Truncated incorrect time value: '\xFF' |
 
+---------+------+----------------------------------------+

The expected result for CAST(a AS TIME) is '00:02:55'
without warnings.

 Comments   
Comment by Sergei Golubchik [ 2014-03-11 ]

what versions are affected?

Comment by Elena Stepanova [ 2014-04-11 ]

MySQL 5.5/5.6/5.7 are also affected (I don't know if there is a bug report about it).

Generated at Thu Feb 08 07:07:20 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.