What is the bug?

JDBC driver reports the precision of TIMESTAMP columns as 24 - which is incorrect

How can one reproduce the bug?

ResultSetMetaData::getPrecision
https://docs.oracle.com/javase/8/docs/api/java/sql/ResultSetMetaData.html#getPrecision-int-

What is the expected behavior?

For datetime datatypes, this is the length in characters of the String representation

For TIMESTAMP and DATETIME it should be 19 for 0 FSP and up to 29 for 9 FSP (fractional second digits).

What is your host/environment?

JDBC: 1.1.0.1

Do you have any additional context?

Opened on behalf of @kylepbit