[MDEV-2740] LP:740173 - 5.1-micro reports incorrect Length metadata for TIME expressions Created: 2011-03-22  Updated: 2015-02-02  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: Philip Stoev (Inactive) Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug740173.xml    

 Description   

Not repeatable with mysql-5.1 . 5.1-micro reports that the Length of a TIME column is 16 characters:

$ mysql --column-t -e "SELECT CAST('01:01:01' AS TIME)" -uroot --protocol=tcp --port=3306
Field 1: `CAST('01:01:01' AS TIME)`
Catalog: `def`
Database: ``
Table: ``
Org_table: ``
Type: TIME
Collation: binary (63)
Length: 16
Max_length: 8
Decimals: 0
Flags: BINARY

--------------------------

CAST('01:01:01' AS TIME)

--------------------------

01:01:01

--------------------------

 Comments   
Comment by Rasmus Johansson (Inactive) [ 2011-10-28 ]

Launchpad bug id: 740173

Generated at Thu Feb 08 06:43:53 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.