manual_news.html

关于mysql学习的 中文教程

<ul>
  <li>Fixed problem in the C API when you called <code>mysql_close()</code> directly after <code>mysql_init()</code>. 
  </li>
  <li>Better client error message when you can't open socket. </li>
  <li>Fixed <code>delayed_insert_thread</code> counting when you couldn't create a new 
    delayed_insert thread. </li>
  <li>Fixed bug in <code>CONCAT()</code> with many arguments. </li>
  <li>Added patches for DEC 3.2 and SCO. </li>
  <li>Fixed path-bug when installing <strong>MySQL</strong> as a service on NT. </li>
  <li>The <strong>MySQL</strong>-Win32 version is now compiled with VC++ 6.0 instead of with 
    VC++ 5.0. </li>
  <li>New installation setup for <strong>MySQL</strong>-Win32. </li>
</ul>

<h3><a href="manual_toc.html#News-3.22.21" name="News-3.22.21">D.2.8 Changes in release 
3.22.21</a></h3>

<ul>
  <li>Fixed problem with <code>DELETE FROM TABLE</code> when table was locked by another 
    thread. </li>
  <li>Fixed bug in <code>LEFT JOIN</code> involving empty tables. </li>
  <li>Changed the <code>mysql.db</code> column from <code>char(32)</code> to <code>char(60)</code>. 
  </li>
  <li><code>MODIFY</code> and <code>DELAYED</code> are not reserved words anymore. </li>
  <li>Fixed a bug when storing days in a <code>TIME</code> column. </li>
  <li>Fixed a problem with <code>Host '..' is not allowed to connect to this MySQL server</code> 
    after one had inserted a new <strong>MySQL</strong> user with a <code>GRANT</code> 
    command. </li>
  <li>Changed to use <code>TCP_NODELAY</code> also on Linux (Should give faster TCP/IP 
    connections). </li>
</ul>

<h3><a href="manual_toc.html#News-3.22.20" name="News-3.22.20">D.2.9 Changes in release 
3.22.20</a></h3>

<ul>
  <li>Fixed <code>STD()</code> for big tables when result should be 0. </li>
  <li>The update log didn't have newlines on some operating systems. </li>
  <li><code>INSERT DELAYED</code> had some garbage at end in the update log. </li>
</ul>

<h3><a href="manual_toc.html#News-3.22.19" name="News-3.22.19">D.2.10 Changes in release 
3.22.19</a></h3>

<ul>
  <li>Fixed bug in <code>mysql_install_db</code> (from 3.22.17). </li>
  <li>Changed default key cache size to 8M. </li>
  <li>Fixed problem with queries that needed temporary tables with <code>BLOB</code> columns. </li>
</ul>

<h3><a href="manual_toc.html#News-3.22.18" name="News-3.22.18">D.2.11 Changes in release 
3.22.18</a></h3>

<ul>
  <li>Fixes a fatal problem in 3.22.17 on Linux; After <code>shutdown</code> all threads 
    didn't die properly. </li>
  <li>Added option <code>-O flush-time=#</code> to <code>mysqld</code>. This is mostly useful 
    on Win32 and tells how often <strong>MySQL</strong> should close all unused tables and 
    flush all updated tables to disk. </li>
  <li>Fixed problem that a <code>VARCHAR</code> column compared with <code>CHAR</code> column 
    didn't use keys efficiently. </li>
</ul>

<h3><a href="manual_toc.html#News-3.22.17" name="News-3.22.17">D.2.12 Changes in release 
3.22.17</a></h3>

<ul>
  <li>Fixed a core dump problem when using <code>--log-update</code> and connecting without a 
    default database. </li>
  <li>Fixed some <code>configure</code> and portability problems. </li>
  <li>Using <code>LEFT JOIN</code> on tables that had circular dependencies caused <code>mysqld</code> 
    to hang forever. </li>
</ul>

<h3><a href="manual_toc.html#News-3.22.16" name="News-3.22.16">D.2.13 Changes in release 
3.22.16</a></h3>

<ul>
  <li><code>mysqladmin processlist</code> could kill the server if a new user logged in. </li>
  <li><code>DELETE FROM tbl_name WHERE key_column=col_name</code> didn't find any matching 
    rows. Fixed. </li>
  <li><code>DATE_ADD(column,...)</code> didn't work. </li>
  <li><code>INSERT DELAYED</code> could deadlock with status 'upgrading lock' </li>
  <li>Extended <code>ENCRYPT()</code> to take longer salt strings than 2 characters. </li>
  <li><code>longlong2str</code> is now much faster than before. For <code>Intel x86</code> 
    platforms, this function is written in optimized assembler. </li>
  <li>Added the <code>MODIFY</code> keyword to <code>ALTER TABLE</code>. </li>
</ul>

<h3><a href="manual_toc.html#News-3.22.15" name="News-3.22.15">D.2.14 Changes in release 
3.22.15</a></h3>

<ul>
  <li><code>GRANT</code> used with <code>IDENTIFIED BY</code> didn't take effect until 
    privileges were flushed. </li>
  <li>Name change of some variables in <code>SHOW STATUS</code>. </li>
  <li>Fixed problem with <code>ORDER BY</code> with 'only index' optimzation when there were 
    multiple key definitions for a used column. </li>
  <li><code>DATE</code> and <code>DATETIME</code> columns are now up to 5 times faster than 
    before. </li>
  <li><code>INSERT DELAYED</code> can be used to let the client do other things while the 
    server inserts rows into a table. </li>
  <li><code>LEFT JOIN USING (col1,col2)</code> didn't work if one used it with tables from 2 
    different databases. </li>
  <li><code>LOAD DATA LOCAL INFILE</code> didn't work in the Unix version because of a missing 
    file. </li>
  <li>Fixed problems with <code>VARCHAR</code>/<code>BLOB</code> on very short rows (&lt; 4 
    bytes); error 127 could occur when deleting rows. </li>
  <li>Updating <code>BLOB/TEXT</code> through formulas didn't work for short (&lt; 256 char) 
    strings. </li>
  <li>When you did a <code>GRANT</code> on a new host, <code>mysqld</code> could die on the 
    first connect from this host. </li>
  <li>Fixed bug when one used <code>ORDER BY</code> on column name that was the same name as 
    an alias. </li>
  <li>Added <code>BENCHMARK(loop_count,expression)</code> function to time expressions. </li>
</ul>

<h3><a href="manual_toc.html#News-3.22.14" name="News-3.22.14">D.2.15 Changes in release 
3.22.14</a></h3>

<ul>
  <li>Allow empty arguments to <code>mysqld</code> to make it easier to start from shell 
    scripts. </li>
  <li>Setting a <code>TIMESTAMP</code> column to <code>NULL</code> didn't record the timestamp 
    value in the update log. </li>
  <li>Fixed lock handler bug when one did <code>INSERT INTO TABLE ... SELECT ... GROUP BY</code>. 
  </li>
  <li>Added a patch for <code>localtime_r()</code> on Win32 so that it will not crash anymore 
    if your date is &gt; 2039, but instead will return a time of all zero. </li>
  <li>Names for user-defined functions are no longer case sensitive. </li>
  <li>Added escape of <code>^Z</code> (ASCII 26) to <code>\Z</code> as <code>^Z</code> doesn't 
    work with pipes on Win32. </li>
  <li><code>mysql_fix_privileges</code> adds a new column to the <code>mysql.func</code> to 
    support aggregate UDF functions in future <strong>MySQL</strong> releases. </li>
</ul>

<h3><a href="manual_toc.html#News-3.22.13" name="News-3.22.13">D.2.16 Changes in release 
3.22.13</a></h3>

<ul>
  <li>Saving <code>NOW()</code>, <code>CURDATE()</code> or <code>CURTIME()</code> directly in 
    a column didn't work. </li>
  <li><code>SELECT COUNT(*) ... LEFT JOIN ...</code> didn't work with no <code>WHERE</code> 
    part. </li>
  <li>Updated <tt>`config.guess'</tt> to allow <strong>MySQL</strong> to configure on UnixWare 
    7.0.x. </li>
  <li>Changed the implementation of <code>pthread_cond()</code> on the Win32 version. <code>get_lock()</code> 
    now correctly times out on Win32! </li>
</ul>

<h3><a href="manual_toc.html#News-3.22.12" name="News-3.22.12">D.2.17 Changes in release 
3.22.12</a></h3>

<ul>
  <li>Fixed problem when using <code>DATE_ADD()</code> and <code>DATE_SUB()</code> in a <code>WHERE</code> 
    clause. </li>
  <li>You can now set the password for a user with the <code>GRANT ... TO user IDENTIFIED BY 
    'password'</code> syntax. </li>
  <li>Fixed bug in <code>GRANT</code> checking with <code>SELECT</code> on many tables. </li>
  <li>Added missing file <code>mysql_fix_privilege_tables</code> to the RPM distribution. This 
    is not run by default since it relies on the client package. </li>
  <li>Added option <code>SQL_SMALL_RESULT</code> to <code>SELECT</code> to force use of fast 
    temporary tables when you know that the result set will be small. </li>
  <li>Allow use of negative real numbers without a decimal point. </li>
  <li>Day number is now adjusted to maximum days in month if the resulting month after <code>DATE_ADD</code>/<code>DATE_SUB()</code> 
    doesn't have enough days. </li>
  <li>Fix that <code>GRANT</code> compares columns in case-insensitive fashion. </li>
  <li>Fixed a bug in <tt>`sql_list.h'</tt> that made <code>ALTER TABLE</code> dump core in 
    some contexts. </li>
  <li>The hostname in <code>user@hostname</code> can now include <samp>`.'</samp> and <samp>`-'</samp> 
    without quotes in the context of the <code>GRANT</code>, <code>REVOKE</code> and <code>SET 
    PASSWORD FOR ...</code> statements. </li>
  <li>Fix for <code>isamchk</code> for tables which need big temporary files. </li>
</ul>

<h3><a href="manual_toc.html#News-3.22.11" name="News-3.22.11">D.2.18 Changes in release 
3.22.11</a></h3>

<ul>
  <li><strong>IMPORTANT</strong>: You must run the <code>mysql_fix_privilege_tables</code> 
    script when you upgrade to this version! This is needed because of the new <code>GRANT</code> 
    system. If you don't do this, you will get <code>Access denied</code> when you try to use <code>ALTER 
    TABLE</code>, <code>CREATE INDEX</code> or <code>DROP INDEX</code>. </li>
  <li><code>GRANT</code> to allow/deny users table and column access. </li>
  <li>Changed <code>USER()</code> to return <code>user@host</code> </li>
  <li>Changed the syntax for how to set <code>PASSWORD</code> for another user. </li>
  <li>New command <code>FLUSH STATUS</code> that sets most status variables to zero. </li>
  <li>New status variables: <code>aborted_threads</code>, <code>aborted_connects</code>. </li>
  <li>New option variable: <code>connection_timeout</code>. </li>
  <li>Added support for Thai sorting (by Pruet Boonma </li>
  <li>Slovak and japanese error messages. </li>
  <li>Configuration and portability fixes. </li>
  <li>Added option <code>SET SQL_WARNINGS=1</code> to get a warning count also for simple 
    inserts. </li>
  <li><strong>MySQL</strong> now uses <code>SIGTERM</code> instead of <code>SIGQUIT</code> 
    with shutdown to work better on FreeBSD. </li>
  <li>Added option <code>\G</code> (print vertically) to <code>mysql</code>. </li>
  <li><code>SELECT HIGH_PRIORITY</code> ... killed <code>mysqld</code>. </li>
  <li><code>IS NULL</code> on a <code>AUTO_INCREMENT</code> column in a <code>LEFT JOIN</code> 
    didn't work as expected. </li>
  <li>New function <code>MAKE_SET()</code>. </li>
</ul>

<h3><a href="manual_toc.html#News-3.22.10" name="News-3.22.10">D.2.19 Changes in release 
3.22.10</a></h3>

<ul>
  <li><code>mysql_install_db</code> no longer starts the <strong>MySQL</strong> server! You 
    should start <code>mysqld</code> with <code>safe_mysqld</code> after installing it! The <strong>MySQL</strong> 
    RPM will however start the server as before. </li>
  <li>Added <code>--bootstrap</code> option to <code>mysqld</code> and recoded <code>mysql_install_db</code> 
    to use it. This will make it easier to install <strong>MySQL</strong> with RPMs. </li>
  <li>Changed <code>+</code>, <code>-</code> (sign and minus), <code>*</code>, <code>/</code>, 
    <code>%</code>, <code>ABS()</code> and <code>MOD()</code> to be <code>BIGINT</code> aware 
    (64-bit safe). </li>
  <li>Fixed a bug in <code>ALTER TABLE</code> that caused <code>mysqld</code> to crash. </li>