Bug #67793 MySQL ODBC drivers incorrectly returns TIME columns, where value > '99:59:59'

Description:
When you read column data using SQLGetData into SQL_C_TYPE_TIME then:

- if TIME column contains value <= '99:59:59' then data are correctly filled into SQL_TIME_STRUCT: hour=99, minute=59, second=59.

- but if TIME column contains value > '99:59:59' f.e. '120:34:56' (more than 6 digits) then data are filled : hour=12, minute=03, second=45
(values are taken from left by 2 digits: 12 03 45 6, instead of 120 34 56)

How to repeat:
Use f.e. in Pascal: SQLGetData(, , SQL_C_TYPE_TIME, @ODBCTimeStruct, SizeOf(SQL_TIME_STRUCT), @StrLenOrInd);
And read any TIME column with TIME value >= '100:00:00'

Problem may be in utility.c in function str_to_time_st:
    ts->hour=   digit(buff[0])*10+digit(buff[1]);
    ts->minute= digit(buff[2])*10+digit(buff[3]);
    ts->second= digit(buff[4])*10+digit(buff[5]); 

here is hard coded, that hours are 2 digits only, but it is not ok.

Verified using 5.2.3

Patch and test case

Attachment: bug67793.patch (application/octet-stream, text), 2.40 KiB.

Pushed to the revision 1149 of Connector/ODBC 5.2.

Added an entry to the Connector/ODBC 5.2.6 changelog:

When reading TIME column data using the SQLGetData method into the SQL_C_TYPE_TIME datatype, errors occured when the time string contained more than 6-digits (e.g., 120:53:44).