Index: driver/info.c =================================================================== --- driver/info.c (revision 775) +++ driver/info.c (working copy) @@ -992,7 +992,7 @@ {"date",sql_date,"10","'","'",NULL,sql_nullable,"0",sql_searchable,"0","0","0","date",NULL,NULL,sql_datetime,sql_date,NULL,NULL}, /* SQL_TYPE_TIME= 92 */ - {"time",sql_time,"6","'","'",NULL,sql_nullable,"0",sql_searchable,"0","0","0","time",NULL,NULL,sql_datetime,sql_time,NULL,NULL}, + {"time",sql_time,"8","'","'",NULL,sql_nullable,"0",sql_searchable,"0","0","0","time",NULL,NULL,sql_datetime,sql_time,NULL,NULL}, /* YEAR - SQL_SMALLINT */ {"year",sql_smallint,"4",NULL,NULL,NULL,sql_nullable,"0",sql_searchable,"0","0","0","year",NULL,NULL,sql_smallint,NULL,"10",NULL}, Index: test/my_datetime.c =================================================================== --- test/my_datetime.c (revision 775) +++ test/my_datetime.c (working copy) @@ -853,6 +853,24 @@ } +/** + Bug #30939: SQLGetTypeInfo returns 6 instead of 8 for COLUMN_SIZE for + SQL_TYPE_TIME +*/ +DECLARE_TEST(t_bug30939) +{ + ok_stmt(hstmt, SQLGetTypeInfo(hstmt, SQL_TYPE_TIME)); + + ok_stmt(hstmt, SQLFetch(hstmt)); + + is_num(my_fetch_int(hstmt, 3), 8); + + expect_stmt(hstmt, SQLFetch(hstmt), SQL_NO_DATA); + + return OK; +} + + BEGIN_TESTS ADD_TEST(my_ts) ADD_TEST(t_tstotime) @@ -866,6 +884,7 @@ ADD_TODO(t_bug30081) ADD_TEST(t_datecolumns) ADD_TEST(t_bug14414) + ADD_TEST(t_bug30939) END_TESTS Index: ChangeLog =================================================================== --- ChangeLog (revision 777) +++ ChangeLog (working copy) @@ -3,6 +3,8 @@ Functionality added or changed: Bugs fixed: + * SQLGetTypeInfo() reported the wrong column size for the SQL_TYPE_TIME + type. (Bug #30939) * Empty selection for database and character set comboboxes in setup were set to " " instead of an empty string. (Bug #30568)