Alterações na distribuição 3.20.6

Portable to more systems because of MIT-pthreads, which will be used automatically if configure cannot find a -lpthreads library.

• Added GNU-style long options to almost all programs. Test with program --help.
• Some shared library support for Linux.
• The FAQ is now in .texi format and is available in .html, .txt and .ps formats.
• Added new SQL function RAND([init]).
• Changed sql_lex to handle \0 unquoted, but the client can't send the query through the C API, because it takes a str pointer. You must use mysql_real_query() to send the query.
• Added API function mysql_get_client_info().
• mysqld now uses the N_MAX_KEY_LENGTH from nisam.h as the maximum allowable key length.
• The following now works:

  mysql> SELECT filter_nr,filter_nr FROM filter ORDER BY filter_nr;
  

  Previously, this resulted in the error: Column: 'filter_nr' in order clause is ambiguous.

• MariaDB now outputs '\0', '\t', '\n' and '\\' when encountering ASCII 0, tab, newline or '\' while writing tab-separated output. This is to allow printing of binary data in a portable format. To get the old behaviour, use -r (or --raw).
• Added german error messages (60 of 80 error messages translated).
• Added new API function mysql_fetch_lengths(MYSQL_RES *), which returns an array of column lengths (of type uint).
• Fixed bug with IS NULL in WHERE clause.
• Changed the optimiser a little to get better results when searching on a key part.
• Added SELECT option STRAIGHT_JOIN to tell the optimiser that it should join tables in the given order.
• Added support for comments starting with '--' in mysql.cc (Postgres syntax).
• You can have SELECT expressions and table columns in a SELECT which are not used in the group part. This makes it efficient to implement lookups. The column that is used should be a constant for each group because the value is calculated only once for the first row that is found for a group.

  mysql> SELECT id,lookup.text,SUM(*) FROM test,lookup
   -> WHERE test.id=lookup.id GROUP BY id;
  

• Fixed bug in SUM(function) (could cause a core dump).
• Changed AUTO_INCREMENT placement in the SQL query:

  INSERT INTO table (auto_field) VALUES (0);
  

  inserted 0, but it should insert an AUTO_INCREMENT value.

• mysqlshow.c: Added number of records in table. Had to change the client code a little to fix this.
• MariaDB now allows doubled '' or '' within strings for embedded ' or '.
• New math functions: EXP(), LOG(), SQRT(), ROUND(), CEILING().

Retornar