Timestamp key column data needed _binary
stripped for
UpdatableResultSet.refreshRow()
. (Bug#7686)
Timestamps converted incorrectly to strings with server-side prepared statements and updatable result sets. (Bug#7715)
Detect new sql_mode
variable in string form
(it used to be integer) and adjust quoting method for strings
appropriately.
Added holdResultsOpenOverStatementClose
property (default is false
), that keeps
result sets open over statement.close() or new execution on
same statement (suggested by Kevin Burton).
Infinite recursion when „falling back“ to master in failover configuration. (Bug#7952)
Disable multi-statements (if enabled) for MySQL-4.1 versions prior to version 4.1.10 if the query cache is enabled, as the server returns wrong results in this configuration.
Fixed duplicated code in
configureClientCharset()
that prevented
useOldUTF8Behavior=true
from working
properly.
Removed dontUnpackBinaryResults
functionality, the driver now always stores results from
server-side prepared statements as is from the server and
unpacks them on demand.
Emulated locators corrupt binary data when using server-side prepared statements. (Bug#8096)
Fixed synchronization issue with
ServerPreparedStatement.serverPrepare()
that could cause deadlocks/crashes if connection was shared
between threads.
By default, the driver now scans SQL you are preparing via all
variants of Connection.prepareStatement()
to determine if it is a supported type of statement to prepare
on the server side, and if it is not supported by the server,
it instead prepares it as a client-side emulated prepared
statement. You can disable this by passing
emulateUnsupportedPstmts=false
in your JDBC
URL. (Bug#4718)
Remove _binary
introducer from parameters
used as in/out parameters in
CallableStatement
.
Always return byte[]
s for output parameters
registered as *BINARY
.
Send correct value for „boolean“
true
to server for
PreparedStatement.setObject(n, "true",
Types.BIT)
.
Fixed bug with Connection not caching statements from
prepareStatement()
when the statement
wasn't a server-side prepared statement.
Choose correct „direction“ to apply time
adjustments when both client and server are in GMT time zone
when using ResultSet.get(..., cal)
and
PreparedStatement.set(...., cal)
.
Added dontTrackOpenResources
option
(default is false
, to be JDBC compliant),
which helps with memory use for non-well-behaved apps (that
is, applications that don't close Statement
objects when they should).
ResultSet.getString()
doesn't maintain
format stored on server, bug fix only enabled when
noDatetimeStringSync
property is set to
true
(the default is
false
). (Bug#8428)
Fixed NPE in ResultSet.realClose()
when
using usage advisor and result set was already closed.
PreparedStatements
not creating streaming
result sets. (Bug#8487)
Don't pass NULL
to
String.valueOf()
in
ResultSet.getNativeConvertToString()
, as it
stringifies it (that is, returns null
),
which is not correct for the method in question.
ResultSet.getBigDecimal()
throws exception
when rounding would need to occur to set scale. The driver now
chooses a rounding mode of „half up“ if
non-rounding BigDecimal.setScale()
fails.
(Bug#8424)
Added useLocalSessionState
configuration
property, when set to true
the JDBC driver
trusts that the application is well-behaved and only sets
autocommit and transaction isolation levels using the methods
provided on java.sql.Connection
, and
therefore can manipulate these values in many cases without
incurring round-trips to the database server.
Added enableStreamingResults()
to
Statement
for connection pool
implementations that check
Statement.setFetchSize()
for
specification-compliant values. Call
Statement.setFetchSize(>=0)
to disable
the streaming results for that statement.
Added support for BIT
type in MySQL-5.0.3.
The driver will treat BIT(1-8)
as the JDBC
standard BIT
type (which maps to
java.lang.Boolean
), as the server does not
currently send enough information to determine the size of a
bitfield when < 9 bits are declared.
BIT(>9)
will be treated as
VARBINARY
, and will return
byte[]
when getObject()
is called.
Dies ist eine Übersetzung des MySQL-Referenzhandbuchs, das sich auf dev.mysql.com befindet. Das ursprüngliche Referenzhandbuch ist auf Englisch, und diese Übersetzung ist nicht notwendigerweise so aktuell wie die englische Ausgabe. Das vorliegende deutschsprachige Handbuch behandelt MySQL bis zur Version 5.1.