Re: ResultSetMetaData.getColumnTypeName bug for fieldtype YEAR - Mark Matthews - com.mysql.lists.bugs

3 messages in com.mysql.lists.bugsRe: ResultSetMetaData.getColumnTypeNa...

From	Sent On	Attachments
John Zoetebier	09 Mar 2003 22:03
Mark Matthews	10 Mar 2003 05:04
John Zoetebier	11 Mar 2003 13:21

Subject:	Re: ResultSetMetaData.getColumnTypeName bug for fieldtype YEAR
From:	Mark Matthews (ma...@mysql.com)
Date:	03/10/2003 05:04:21 AM
List:	com.mysql.lists.bugs

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1

John Zoetebier wrote:

SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `<' and `>'). SEND-PR: From: john...@transparent.co.nz To: mys...@lists.mysql.com Subject: [50 character or so descriptive subject here (for reference)]

Description:

I created a table with all fields to see what the column type name is. All field types showed a correct column type, except field type YEAR. The column type for YEAR = "UNKNOWN"

I use mysql-connector-java-3.0.6-stable-bin.jar The command to get column typeinfo is instance method: ResultSetMetaData.getColumnTypeName()

This looks a bug to me in the JDBC connector to me.

How-To-Repeat:

<code/input/activities to reproduce the problem (multiple lines)> Create table with field with field type YEAR. Run Java program to extract column type using ResultSetMetaData.getColumnTypeName

[snip]

Thanks for your bug report!

This is now fixed in the 3.0 and 3.1 branches, and will be released as 3.0.7 or 3.1.1 (respectively). If you need to test the fix before these versions are released, please download a nightly snapshot from http://mmmysql.sourceforge.net/snapshots/

-Mark - -- MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/

For technical support contracts, visit https://order.mysql.com/?ref=mmma

iD8DBQE+bI1utvXNTca6JD8RAkBaAJwO/bOKVldDAfOsvqITvyl6DZmuuwCdEQww jbLKCqLZFB6FtEVITfkUN9Q= =a7DF -----END PGP SIGNATURE-----