End of Product Lifecycle. Active development and support for MySQL Database Server versions 3.23, 4.0, and 4.1 has ended. For details, see http://www.mysql.com/about/legal/lifecycle/#calendar. Please consider upgrading to a recent version. Further updates to the content of this manual will be minimal. All formats of this manual will continue to be available until 31 Dec 2010.
Inserting a DATETIME
into a
TIME
column no longer try to
store 'days' in it.
Fixed problem with storage of float/double on little endian
machines. (This affected
SUM()
.)
Added connect timeout on TCP/IP connections.
Fixed problem with LIKE
"%"
on an index that may have
NULL
values.
REVOKE ALL
PRIVILEGES
didn't revoke all privileges.
Allow creation of temporary tables with same name as the original table.
When granting an account a
GRANT
option for a database,
the account couldn't grant privileges to other users.
New statement: SHOW GRANTS FOR user
(by
Sinisa).
New date_add
syntax: date/datetime
+ INTERVAL # interval_type
. By Joshua Chamas.
Fixed privilege check for LOAD DATA
REPLACE
.
Automatic fixing of broken include files on Solaris 2.7
Some configure issues to fix problems with big file system detection.
REGEXP
is now case-insensitive if you use
nonbinary strings.
User Comments
Add your own comment.