MySQL Manual | D.6.7 Changes in release 3.21.27

Added user level lock functions GET_LOCK(string,timeout), RELEASE_LOCK(string).
Added Opened_tables to show status.
Changed connect timeout to 3 seconds to make it somewhat harder for crackers to kill mysqld through telnet + TCP/IP.
Fixed bug in range optimiser when using WHERE key_part_1 >= something AND key_part_2 <= something_else.
Changed configure for detection of FreeBSD 3.0 9803xx and above
WHERE with string_col_key = constant_string didn't always find all rows if the column had many values differing only with characters of the same sort value (like e and e with an accent).
Strings keys looked up with 'ref' were not compared in case-sensitive fashion.
Added umask() to make log files non-readable for normal users.
Ignore users with old (8-byte) password on startup if not using --old-protocol option to mysqld.
SELECT which matched all key fields returned the values in the case of the matched values, not of the found values. (Minor problem.)

User Comments