Bugs fixed:
Process escape tokens in
Connection.prepareStatement(...)
. You can disable this behavior by setting the JDBC URL configuration propertyprocessEscapeCodesForPrepStmts
tofalse
. (Bug#15141)Usage advisor complains about unreferenced columns, even though they've been referenced. (Bug#15065)
Driver incorrectly closes streams passed as arguments to
PreparedStatements
. Reverts to legacy behavior by setting the JDBC configuration propertyautoClosePStmtStreams
totrue
(also included in the 3-0-Compat configuration “bundle”). (Bug#15024)Deadlock while closing server-side prepared statements from multiple threads sharing one connection. (Bug#14972)
Unable to initialize character set mapping tables (due to J2EE classloader differences). (Bug#14938)
Escape processor replaces quote character in quoted string with string delimiter. (Bug#14909)
DatabaseMetaData.getColumns()
doesn't returnTABLE_NAME
correctly. (Bug#14815)storesMixedCaseIdentifiers()
returnsfalse
(Bug#14562)storesLowerCaseIdentifiers()
returnstrue
(Bug#14562)storesMixedCaseQuotedIdentifiers()
returnsfalse
(Bug#14562)storesMixedCaseQuotedIdentifiers()
returnstrue
(Bug#14562)If
lower_case_table_names=0
(on server):storesLowerCaseIdentifiers()
returnsfalse
storesLowerCaseQuotedIdentifiers()
returnsfalse
storesMixedCaseIdentifiers()
returnstrue
storesMixedCaseQuotedIdentifiers()
returnstrue
storesUpperCaseIdentifiers()
returnsfalse
storesUpperCaseQuotedIdentifiers()
returnstrue
storesUpperCaseIdentifiers()
returnsfalse
(Bug#14562)storesUpperCaseQuotedIdentifiers()
returnstrue
(Bug#14562)If
lower_case_table_names=1
(on server):storesLowerCaseIdentifiers()
returnstrue
storesLowerCaseQuotedIdentifiers()
returnstrue
storesMixedCaseIdentifiers()
returnsfalse
storesMixedCaseQuotedIdentifiers()
returnsfalse
storesUpperCaseIdentifiers()
returnsfalse
storesUpperCaseQuotedIdentifiers()
returnstrue
storesLowerCaseQuotedIdentifiers()
returnstrue
(Bug#14562)Fixed
DatabaseMetaData.stores*Identifiers()
:If
lower_case_table_names=0
(on server):storesLowerCaseIdentifiers()
returnsfalse
storesLowerCaseQuotedIdentifiers()
returnsfalse
storesMixedCaseIdentifiers()
returnstrue
storesMixedCaseQuotedIdentifiers()
returnstrue
storesUpperCaseIdentifiers()
returnsfalse
storesUpperCaseQuotedIdentifiers()
returnstrue
If
lower_case_table_names=1
(on server):storesLowerCaseIdentifiers()
returnstrue
storesLowerCaseQuotedIdentifiers()
returnstrue
storesMixedCaseIdentifiers()
returnsfalse
storesMixedCaseQuotedIdentifiers()
returnsfalse
storesUpperCaseIdentifiers()
returnsfalse
storesUpperCaseQuotedIdentifiers()
returnstrue
storesMixedCaseIdentifiers()
returnstrue
(Bug#14562)storesLowerCaseQuotedIdentifiers()
returnsfalse
(Bug#14562)Java type conversion may be incorrect for
MEDIUMINT
. (Bug#14562)storesLowerCaseIdentifiers()
returnsfalse
(Bug#14562)Added configuration property
useGmtMillisForDatetimes
which when set totrue
causesResultSet.getDate()
,.getTimestamp()
to return correct millis-since GMT when.getTime()
is called on the return value (currently default isfalse
for legacy behavior). (Bug#14562)Extraneous sleep on
autoReconnect
. (Bug#13775)Reconnect during middle of
executeBatch()
should not occur ifautoReconnect
is enabled. (Bug#13255)maxQuerySizeToLog
is not respected. Added logging of bound values forexecute()
phase of server-side prepared statements whenprofileSQL=true
as well. (Bug#13048)OpenOffice expects
DBMD.supportsIntegrityEnhancementFacility()
to returntrue
if foreign keys are supported by the datasource, even though this method also covers support for check constraints, which MySQL doesn't have. Setting the configuration propertyoverrideSupportsIntegrityEnhancementFacility
totrue
causes the driver to returntrue
for this method. (Bug#12975)Added
com.mysql.jdbc.testsuite.url.default
system property to set default JDBC url for testsuite (to speed up bug resolution when I'm working in Eclipse). (Bug#12975)logSlowQueries
should give better info. (Bug#12230)Don't increase timeout for failover/reconnect. (Bug#6577)
Fixed client-side prepared statement bug with embedded
?
characters inside quoted identifiers (it was recognized as a placeholder, when it was not).Do not permit
executeBatch()
forCallableStatements
with registeredOUT
/INOUT
parameters (JDBC compliance).Fall back to platform-encoding for
URLDecoder.decode()
when parsing driver URL properties if the platform doesn't have a two-argument version of this method.