EMS logo

Products Navigation

choose your database tool

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

SQL Industry News

MySQL News

08/26/2005
MySQL 4.1.14 released.

MySQL 4.1.14, a new version of the popular Open Source/Free Software Database Management System has been released. It is now available in source and binary form for a number of platforms from our download pages at http://dev.mysql.com/downloads/ and mirror sites.

This is a bug fix release for the current production series.

Changes in release 4.1.14:

  • SHOW CHARACTER SET and INFORMATION_SCHEMA now properly report the Latin1 character set as cp1252.
  • Added support of where clause for queries with FROM DUAL.
  • Added an optimization that avoids key access with NULL keys for the ref method when used in   outer joins.
  • Query cache is switched off if a thread (connection) has tables locked. This prevents invalid results where the locking thread inserts values between a second thread connecting and selecting from the table.
  • Some subqueries of the form SELECT ... WHERE ROW(...) IN (subquery) were being handled incorrectly.
  • User variables were not automatically cast for comparisons, causing queries to fail if the column and connection character sets differed. Now when mixing strings with different character sets but the same coercibility, allow conversion if one character set is a superset of the other.

Source: dev.mysql.com

twitterfacebook