Bug #66910 JDBC getTypeInfo does not show JDBC etc canonical literals for temporal types

• Submitted: 21 Sep 2012 15:17
• Modified: 18 Jan 2013 16:50
• Reporter: the 6campbells
• Status: No Feedback
• Category: Connector / J
• Severity: S3 (Non-critical)
• Version: 5.1.12
• OS: Any
• CPU Architecture: Any

[21 Sep 2012 15:17] the 6campbells

Description:
While MySQL documents temporal literals http://dev.mysql.com/doc/refman/5.5/en/date-and-time-literals.html

the literal prefix value returned via JDBC DatabaseMetadata.getTypeInfo is only showing the literal for DATE as '. one would think it should be showing the JDBC canonical literal prefix as opposed to single quote.

How to repeat:
Using a customer JDBC program or open source tool like SQLSquirrel, connect and dump the results of DatabaseMetadata.getTypeInfo.

Suggested fix:
Support the JDBC canonical or report the equivalent MySQL valid prefixes for the temporal types.

[18 Dec 2012 16:50] Sveta Smirnova

Thank you for the report.

I can not repeat described behavior: getColumnTypeName returns DATE for date column. I will attach test case shortly.

Additionally version 5.1.12 is old. Try with current version 5.1.22 and, if problem still exists, provide repeatable test case.

[18 Dec 2012 16:51] Sveta Smirnova

test case for c/J testsuite

Attachment: bug66910.java (text/x-java), 1.38 KiB.

[19 Jan 2013 1:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".