XOOPS Brasil

 

Apêndice D. Histórico de Alterações do MySQL

Índice

D.1. Alterações na distribuição 5.0.0 (Development)
D.2. Alterações na distribuição 4.1.x (Alpha)
D.2.1. Alterações na distribuição 4.1.2 (not released yet)
D.2.2. Alterações na distribuição 4.1.1 (01 de Dez de 2003)
D.2.3. Alterações na distribuição 4.1.0 (03 Apr 2003: Alpha)
D.3. Alterações na distribuição 4.0.x (Production)
D.3.1. Alterações na distribuição 4.0.17 (not released yet)
D.3.2. Alterações na distribuição 4.0.16 (17 Out 2003)
D.3.3. Alterações na distribuição 4.0.15 (03 Sep 2003)
D.3.4. Alterações na distribuição 4.0.14 (18 Jul 2003)
D.3.5. Alterações na distribuição 4.0.13 (16 May 2003)
D.3.6. Alterações na distribuição 4.0.12 (15 Mar 2003: Production)
D.3.7. Alterações na distribuição 4.0.11 (20 Feb 2003)
D.3.8. Alterações na distribuição 4.0.10 (29 Jan 2003)
D.3.9. Alterações na distribuição 4.0.9 (09 Jan 2003)
D.3.10. Alterações na distribuição 4.0.8 (07 Jan 2003)
D.3.11. Alterações na distribuição 4.0.7 (20 Dec 2002)
D.3.12. Alterações na distribuição 4.0.6 (14 Dec 2002: Gamma)
D.3.13. Alterações na distribuição 4.0.5 (13 Nov 2002)
D.3.14. Alterações na distribuição 4.0.4 (29 Sep 2002)
D.3.15. Alterações na distribuição 4.0.3 (26 Aug 2002: Beta)
D.3.16. Alterações na distribuição 4.0.2 (01 Jul 2002)
D.3.17. Alterações na distribuição 4.0.1 (23 Dec 2001)
D.3.18. Alterações na distribuição 4.0.0 (Oct 2001: Alpha)
D.4. Alterações na distribuição 3.23.x (Recent; still supported)
D.4.1. Alterações na distribuição 3.23.59 (not released yet)
D.4.2. Alterações na distribuição 3.23.58 (11 Sep 2003)
D.4.3. Alterações na distribuição 3.23.57 (06 Jun 2003)
D.4.4. Alterações na distribuição 3.23.56 (13 Mar 2003)
D.4.5. Alterações na distribuição 3.23.55 (23 Jan 2003)
D.4.6. Alterações na distribuição 3.23.54 (05 Dec 2002)
D.4.7. Alterações na distribuição 3.23.53 (09 Oct 2002)
D.4.8. Alterações na distribuição 3.23.52 (14 Aug 2002)
D.4.9. Alterações na distribuição 3.23.51 (31 May 2002)
D.4.10. Alterações na distribuição 3.23.50 (21 Apr 2002)
D.4.11. Alterações na distribuição 3.23.49
D.4.12. Alterações na distribuição 3.23.48 (07 Feb 2002)
D.4.13. Alterações na distribuição 3.23.47 (27 Dec 2001)
D.4.14. Alterações na distribuição 3.23.46 (29 Nov 2001)
D.4.15. Alterações na distribuição 3.23.45 (22 Nov 2001)
D.4.16. Alterações na distribuição 3.23.44 (31 Oct 2001)
D.4.17. Alterações na distribuição 3.23.43 (04 Oct 2001)
D.4.18. Alterações na distribuição 3.23.42 (08 Sep 2001)
D.4.19. Alterações na distribuição 3.23.41 (11 Aug 2001)
D.4.20. Alterações na distribuição 3.23.40
D.4.21. Alterações na distribuição 3.23.39 (12 Jun 2001)
D.4.22. Alterações na distribuição 3.23.38 (09 May 2001)
D.4.23. Alterações na distribuição 3.23.37 (17 Apr 2001)
D.4.24. Alterações na distribuição 3.23.36 (27 Mar 2001)
D.4.25. Alterações na distribuição 3.23.35 (15 Mar 2001)
D.4.26. Alterações na distribuição 3.23.34a
D.4.27. Alterações na distribuição 3.23.34 (10 Mar 2001)
D.4.28. Alterações na distribuição 3.23.33 (09 Feb 2001)
D.4.29. Alterações na distribuição 3.23.32 (22 Jan 2001: Production)
D.4.30. Alterações na distribuição 3.23.31 (17 Jan 2001)
D.4.31. Alterações na distribuição 3.23.30 (04 Jan 2001)
D.4.32. Alterações na distribuição 3.23.29 (16 Dec 2000)
D.4.33. Alterações na distribuição 3.23.28 (22 Nov 2000: Gamma)
D.4.34. Alterações na distribuição 3.23.27 (24 Oct 2000)
D.4.35. Alterações na distribuição 3.23.26 (18 Oct 2000)
D.4.36. Alterações na distribuição 3.23.25 (29 Sep 2000)
D.4.37. Alterações na distribuição 3.23.24 (08 Sep 2000)
D.4.38. Alterações na distribuição 3.23.23 (01 Sep 2000)
D.4.39. Alterações na distribuição 3.23.22 (31 Jul 2000)
D.4.40. Alterações na distribuição 3.23.21
D.4.41. Alterações na distribuição 3.23.20
D.4.42. Alterações na distribuição 3.23.19
D.4.43. Alterações na distribuição 3.23.18
D.4.44. Alterações na distribuição 3.23.17
D.4.45. Alterações na distribuição 3.23.16
D.4.46. Alterações na distribuição 3.23.15 (May 2000: Beta)
D.4.47. Alterações na distribuição 3.23.14
D.4.48. Alterações na distribuição 3.23.13
D.4.49. Alterações na distribuição 3.23.12 (07 Mar 2000)
D.4.50. Alterações na distribuição 3.23.11
D.4.51. Alterações na distribuição 3.23.10
D.4.52. Alterações na distribuição 3.23.9
D.4.53. Alterações na distribuição 3.23.8 (02 Jan 2000)
D.4.54. Alterações na distribuição 3.23.7 (10 Dec 1999)
D.4.55. Alterações na distribuição 3.23.6
D.4.56. Alterações na distribuição 3.23.5 (20 Oct 1999)
D.4.57. Alterações na distribuição 3.23.4 (28 Sep 1999)
D.4.58. Alterações na distribuição 3.23.3
D.4.59. Alterações na distribuição 3.23.2 (09 Aug 1999)
D.4.60. Alterações na distribuição 3.23.1
D.4.61. Alterações na distribuição 3.23.0 (05 Aug 1999: Alpha)
D.5. Alterações na distribuição 3.22.x (Old; discontinued)
D.5.1. Alterações na distribuição 3.22.35
D.5.2. Alterações na distribuição 3.22.34
D.5.3. Alterações na distribuição 3.22.33
D.5.4. Alterações na distribuição 3.22.32 (14 Feb 2000)
D.5.5. Alterações na distribuição 3.22.31
D.5.6. Alterações na distribuição 3.22.30
D.5.7. Alterações na distribuição 3.22.29 (02 Jan 2000)
D.5.8. Alterações na distribuição 3.22.28 (20 Oct 1999)
D.5.9. Alterações na distribuição 3.22.27
D.5.10. Alterações na distribuição 3.22.26 (16 Sep 1999)
D.5.11. Alterações na distribuição 3.22.25
D.5.12. Alterações na distribuição 3.22.24 (05 Jul 1999)
D.5.13. Alterações na distribuição 3.22.23 (08 Jun 1999)
D.5.14. Alterações na distribuição 3.22.22 (30 Apr 1999)
D.5.15. Alterações na distribuição 3.22.21
D.5.16. Alterações na distribuição 3.22.20 (18 Mar 1999)
D.5.17. Alterações na distribuição 3.22.19 (Mar 1999: Production)
D.5.18. Alterações na distribuição 3.22.18
D.5.19. Alterações na distribuição 3.22.17
D.5.20. Alterações na distribuição 3.22.16 (Feb 1999: Gamma)
D.5.21. Alterações na distribuição 3.22.15
D.5.22. Alterações na distribuição 3.22.14
D.5.23. Alterações na distribuição 3.22.13
D.5.24. Alterações na distribuição 3.22.12
D.5.25. Alterações na distribuição 3.22.11
D.5.26. Alterações na distribuição 3.22.10
D.5.27. Alterações na distribuição 3.22.9
D.5.28. Alterações na distribuição 3.22.8
D.5.29. Alterações na distribuição 3.22.7 (Sep 1998: Beta)
D.5.30. Alterações na distribuição 3.22.6
D.5.31. Alterações na distribuição 3.22.5
D.5.32. Alterações na distribuição 3.22.4
D.5.33. Alterações na distribuição 3.22.3
D.5.34. Alterações na distribuição 3.22.2
D.5.35. Alterações na distribuição 3.22.1 (Jun 1998: Alpha)
D.5.36. Alterações na distribuição 3.22.0
D.6. Alterações na distribuição 3.21.x
D.6.1. Alterações na distribuição 3.21.33
D.6.2. Alterações na distribuição 3.21.32
D.6.3. Alterações na distribuição 3.21.31
D.6.4. Alterações na distribuição 3.21.30
D.6.5. Alterações na distribuição 3.21.29
D.6.6. Alterações na distribuição 3.21.28
D.6.7. Alterações na distribuição 3.21.27
D.6.8. Alterações na distribuição 3.21.26
D.6.9. Alterações na distribuição 3.21.25
D.6.10. Alterações na distribuição 3.21.24
D.6.11. Alterações na distribuição 3.21.23
D.6.12. Alterações na distribuição 3.21.22
D.6.13. Alterações na distribuição 3.21.21a
D.6.14. Alterações na distribuição 3.21.21
D.6.15. Alterações na distribuição 3.21.20
D.6.16. Alterações na distribuição 3.21.19
D.6.17. Alterações na distribuição 3.21.18
D.6.18. Alterações na distribuição 3.21.17
D.6.19. Alterações na distribuição 3.21.16
D.6.20. Alterações na distribuição 3.21.15
D.6.21. Alterações na distribuição 3.21.14b
D.6.22. Alterações na distribuição 3.21.14a
D.6.23. Alterações na distribuição 3.21.13
D.6.24. Alterações na distribuição 3.21.12
D.6.25. Alterações na distribuição 3.21.11
D.6.26. Alterações na distribuição 3.21.10
D.6.27. Alterações na distribuição 3.21.9
D.6.28. Alterações na distribuição 3.21.8
D.6.29. Alterações na distribuição 3.21.7
D.6.30. Alterações na distribuição 3.21.6
D.6.31. Alterações na distribuição 3.21.5
D.6.32. Alterações na distribuição 3.21.4
D.6.33. Alterações na distribuição 3.21.3
D.6.34. Alterações na distribuição 3.21.2
D.6.35. Alterações na distribuição 3.21.0
D.7. Alterações na distribuição 3.20.x
D.7.1. Alterações na distribuição 3.20.18
D.7.2. Alterações na distribuição 3.20.17
D.7.3. Alterações na distribuição 3.20.16
D.7.4. Alterações na distribuição 3.20.15
D.7.5. Alterações na distribuição 3.20.14
D.7.6. Alterações na distribuição 3.20.13
D.7.7. Alterações na distribuição 3.20.11
D.7.8. Alterações na distribuição 3.20.10
D.7.9. Alterações na distribuição 3.20.9
D.7.10. Alterações na distribuição 3.20.8
D.7.11. Alterações na distribuição 3.20.7
D.7.12. Alterações na distribuição 3.20.6
D.7.13. Alterações na distribuição 3.20.3
D.7.14. Alterações na distribuição 3.20.0
D.8. Alterações na distribuição 3.19.x
D.8.1. Alterações na distribuição 3.19.5
D.8.2. Alterações na distribuição 3.19.4
D.8.3. Alterações na distribuição 3.19.3

Este apêndice lista as alterações de versão para versão no código fonte do MySQL.

Estamos agora trabalhando ativamente no MySQL 4.1 & 5.0 e só forneceremos correções de erros críticos para o MySQL 4.0 e MySQL 3.23. Atualizamos esta seção a medida que adicionamos novos recursos, para que assim todos possam acompanhar o desenvolvimento.

Nossa seção de TODO contém os planos adicionais que temos para as versões 4.1 e 5.0. Veja mais informações sobre isto na Seção 1.6, “MySQL e o Futuro (o TODO)”.

Note que tendemos a atualizar o manual ao mesmo tempo em que fazemos as alterações no MySQL. Se você encontrar um versão listada aqui que você não pode encontrar na página de download do MySQL (http://www.mysql.com/downloads/), significa que a versão ainda não foi liberada!

A data mencionada com uma versão liberada é a data do último BitKeeper ChangeSet na qual esta distribuição particular foi baseada, e não a data em que os pacotes estavam disponíveis. Os binários estão disponíveis normalmente alguns dias após a data indicada do ChangeSet - contruir e testar todos os pacotes levam algum tempo.

D.1. Alterações na distribuição 5.0.0 (Development)

No momento, a versão 5.0 só está disponível em seu código fonte. Veja mais informações sobre isto na Seção 2.3.4, “Instalando pela árvore de fontes do desenvolvimento”.

O seguinte log de alterações mostra o que já foi feito na árvore 5.0:

  • Suporte básico a stored procedures (estilo SQL-99).

  • Adicionado SELECT INTO lista_de_vars, que pode ser misturados, p.ex.: tipos locais e globais.

  • O log de atualização está obsoleto (não é mais suportado). Ele está totlalmente substituído pelo log binário.

  • Nomes de variáveis de usuários agora estão em caso insensitivo: se você fizer SET @a=10; então SELECT @A; retornará 10. É claro que o conteúdo da variável ainda é caso sensitivo, apenas o seu nome é caso insensitivo.

D.2. Alterações na distribuição 4.1.x (Alpha)

A versão 4.1 do servidor MySQL inclui muitos melhoramentos e novos recursos. Os binários desta versão estão disponíveis para download em http://www.mysql.com/downloads/mysql-4.1.html.

  • Subqueries:

    SELECT * FROM t1 WHERE t1.a=(SELECT t2.b FROM t2);
    
    SELECT * FROM t1 WHERE (1,2,3) IN (SELECT a,b,c FROM t2);
    

  • Tabelas derivadas:

    SELECT t1.a FROM t1, (SELECT * FROM t2) t3 WHERE t1.a=t3.a;
    

  • Sintaxe INSERT ... ON DUPLICATE KEY UPDATE .... Ela lhe permite fazer um UPDATE de um registro existente se a inserção criasse um valor duplicado em uma chave PRIMARY ou UNIQUE. (REPLACE lhe permite sobrescrever um registro existente, o que é totalmente diferente). See Seção 6.4.3, “Sintaxe INSERT.

  • Uma nova função de agrupamento GROUP_CONCAT(). See Seção 6.3.7, “Funções e Modificadores para Usar com Cláusulas GROUP BY.

  • Suporte a Unicode Extensivo (UTF8).

  • Os conjuntos de caracteres podem ser definidos por colunas, tabelas e bancos de dados.

  • Nova cache de chaves para tabelas MyISAM com vários parâmetros de ajustes. Você pode tem multiplas caches de cahves, índices precarregados em caches para batches ...

  • Índices BTREE em tabelas HEAP.

  • Suporte a OpenGIS (Dados Geográficos). See Capítulo 10, Extensões Espacias em MySQL.

  • SHOW WARNINGS exibe avisos para o último comando. Veja mais informações sobre isto na Seção 4.6.8.9, “SHOW WARNINGS | ERRORS.

  • Protocolo binário mais rápido com instruções prepardas e ligação de parâmetros. See Seção 12.1.4, “Instruções Preparadas da API C”.

  • Agora você pode executar várias instruções com uma única chamada a API C e de uma vez e então ler o resultado See Seção 12.1.8, “Tratando a Execução de Múltiplas Consultas na API C”.

  • Create Table: CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tabela LIKE tabela.

  • Comando HELP baseado no servidor que pode ser usado no cliente mysql de linha de comando (e outros clientes) para obter ajuda para comandos SQL.

Para uma lista completa das atualizações, veja a seção de alterações para cada distribuição 4.1.x individual.

D.2.1. Alterações na distribuição 4.1.2 (not released yet)

Functionality added or changed:

  • ENGINE is now a synonym for the TYPE option for CREATE TABLE and ALTER TABLE.

  • Added init_connect and init_slave server variables. The values should be SQL statements to be executed when each client connects or each time a slave's SQL thread starts, respectively.

  • C API enhancement: SERVER_QUERY_NO_INDEX_USED and SERVER_QUERY_NO_GOOD_INDEX_USED flags are now set in server_status field of MYSQL structure. It is these flags that make the query to be logged as slow if mysqld was started with --log-slow-queries --log-queries-not-using-indexes.

Bugs fixed:

  • Fixed a bug with the INTERVAL() function when 8 or more comparison arguments are provided. (Bug#1561)

  • Packaging: Fixed a bug in the Mac OS PKG postinstall script (mysql_install_db was called with an obsolete argument).

  • Packaging: Added missing file mysql_create_system_tables to the server RPM package. This bug was fixed for the 4.1.1 RPMs by updating the MySQL-server RPM from MySQL-server-4.1.1-0 to MySQL-server-4.1.1-1. The other RPMs were not affected by this change.

  • Fixed a bug in myisamchk and CHECK TABLE that sometimes resulted in a spurious error Found key at page ..... that points to record outside datafile for a table with a FULLTEXT index. (Bug#1977)

  • Fixed a hang in full-text indexing of strings in multi-byte (all besides utf8) charsets. (Bug#2065)

  • Fixed a crash in full-text indexing of UTF-8 data. (Bug#2033)

  • Replication: a rare race condition in the slave SQL thread that could lead to an incorrect complaint that the relay log is corrupted. (Bug#2011)

  • Replication: if an administrative command on a table (OPTIMIZE TABLE, REPAIR TABLE etc) was run on the slave, this could sometimes stop the slave SQL thread (this did not lead to any corruption; one just had to type START SLAVE to get replication going again). (Bug#1858)

  • Replication: in the slave SQL thread, a multi-table UPDATE could produce an incorrect complaint that some record was not found in one table, if the UPDATE was preceded by a INSERT ... SELECT. (Bug#1701)

D.2.2. Alterações na distribuição 4.1.1 (01 de Dez de 2003)

Funcionalidades adicionadas ou alteradas:

  • Added IGNORE option for DELETE statement.

  • The MySQL source distribution now also includes the MySQL Internals Manual internals.texi.

  • Added mysql_set_server_option() C API client function to allow multiple statement handling in the server to be enabled or disabled.

  • The mysql_next_result() C API function now returns -1 if there are no more result sets.

  • Renamed CLIENT_MULTI_QUERIES connect option flag to CLIENT_MULTI_STATEMENTS. To allow for a transition period, the old option will continue to be recognized for a while.

  • Require DEFAULT before table and database default character set. This enables us to use ALTER TABLE table_name ... CHARACTER SET=... to change the character set for all CHAR, VARCHAR, and TEXT columns in a table.

  • Added MATCH ... AGAINST( ... WITH QUERY EXPANSION) and the ft_query_expansion_limit server variable.

  • Removed unused ft_max_word_len_for_sort server variable.

  • Full-text search now supports multi-byte character sets and the Unicode utf8 character set. (The Unicode ucs2 character set is not yet supported.)

  • Phrase search in MATCH ... AGAINST ( ... IN BOOLEAN MODE) no longer matches partial words.

  • Added aggregate function BIT_XOR() for bitwise XOR operations.

  • Replication over SSL now works.

  • The START SLAVE statement now supports an UNTIL clause for specifying that the slave SQL thread should be started but run only until it reaches a given position in the master's binary logs or in the slave's relay logs.

  • Produce warnings even for single-row INSERT statements, not just for multiple-row INSERT statements. Previously, it was necessary to set SQL_WARNINGS=1 to generate warnings for single-row statements.

  • Added delimiter (\d) command to the mysql command-line client for changing the statement delimiter (terminator). The default delimiter is semicolon.

  • CHAR, VARCHAR, and TEXT columns now have lengths measured in characters rather than in bytes. The character size depends on the column's character set. This means, for example, that a CHAR(n) column for a multi-byte character set will take more storage than before. Similarly, index values on such columns are measured in characters, not bytes.

  • LIMIT no longer accepts negative arguments (they used to be treated as very big positive numbers before).

  • The DATABASE() function now returns NULL rather than the empty string if there is no database selected.

  • Added --sql-mode=NO_AUTO_VALUE_ON_ZERO option to suppress the usual behaviour of generating the next sequence number when zero is stored in an AUTO_INCREMENT column. With this mode enabled, zero is stored as zero; only storing NULL generates a sequence number.

  • Warning: Incompatible change! Client authentication now is based on 41-byte passwords in the user table, not 45-byte passwords as in 4.1.0. Any 45-byte passwords created for 4.1.0 must be reset after running the mysql_fix_privilege_tables script.

  • Added MySQL Server option and global variable 'secure-auth' that disallows authentication for accounts that have old (pre-4.1.1) passwords.

  • Added MySQL command line client option 'secure-auth'. If this option is set, client will refuse to send password in old (pre-4.1.1) format.

  • Warning: Incompatible change! Renamed the C API mysql_prepare_result() function to mysql_get_metadata() as the old name was confusing.

  • Added DROP USER 'username'@'hostname' statement to drop an account that has no privileges.

  • The interface to aggregated UDF functions has changed a bit. You must now declare a xxx_clear() function for each aggregate function XXX().

  • The CONCAT_WS() function no longer skips empty strings.

  • Added new ADDTIME(), DATE(), DATEDIFF(), LAST_DAY(), MAKEDATE(), MAKETIME(), MICROSECOND(), SUBTIME(), TIME(), TIMEDIFF(), TIMESTAMP(), UTC_DATE(), UTC_TIME(), UTC_TIMESTAMP(), and WEEKOFYEAR() functions.

  • Added new syntax for ADDDATE() and SUBDATE(). The second argument now may be a number representing the number of days to be added to or subtracted from the first date argument.

  • Added new type values DAY_MICROSECOND, HOUR_MICROSECOND, MINUTE_MICROSECOND, SECOND_MICROSECOND, and MICROSECOND for DATE_ADD(), DATE_SUB(), and EXTRACT().

  • Added new %f microseconds format specifier for DATE_FORMAT() and TIME_FORMAT().

  • All queries in which at least one SELECT does not use indexes properly now are written to the slow query log when long log format is used.

  • It is now possible to create a MERGE table from MyISAM tables in different databases. Formerly, all the MyISAM tables had to be in the same database, and the MERGE table had to be created in that database as well.

  • Adicionada as novas funções COMPRESS(), UNCOMPRESS() e UNCOMPRESSED_LENGTH().

  • Ao fazer SQL SQL_MODE=#, para um modo complexo (como ANSI) agora atualizamos a variável SQL_MODE para incluir todas as opções que o modo exige.

  • Adicionada a função ROLLUP OLAP (Online Analytical Processing - Processamento Analítico Online), que lhe dá um resumo para cada nível GROUP BY.

  • Adicionado os códigos SQLSTATE para todos os erros do servidor.

  • Adicionado mysql_sqlstate() e mysql_stmt_sqlstate() que retornam o código de erro SQLSTATE para o último erro.

  • --lower-case-table-names=1 agora também faz a aliases caso insensitivo. (Bug#534)

  • Colunas TIME com valor de horas maior do que 24 eram retornadas incorretamente para o cliente.

  • As instruções ANALYZE, OPTIMIZE, REPAIR e FLUSH são agora armazenados no log binário e assim replicados para o slave. Este registro não ocorre se a palavra chave opcional NO_WRITE_TO_BINLOG (ou seu alias LOCAL) for usada. As exceções são que FLUSH LOGS, FLUSH MASTER, FLUSH SLAVE e FLUSH TABLES WITH READ LOCK, não são registrados no log em qualquer caso. Para uma sintaxe completa, veja Seção 4.6.4, “Sintaxe de FLUSH.

  • Nova variável global RELAY_LOG_PURGE para habilitar ou desabilitar automaticamente a remoção de relay logs.

  • LOAD DATA agora produz avisos que podem ser buscados com SHOW WARNINGS.

  • Adicionado o suporte a sintaxe CREATE TABLE nome_tabela (LIKE nome_tabela2).

  • CREATE TABLE nome_tabela (...) TYPE=storage_engine agora gera um aviso se o mecanismo de armazenamento não for respeitado. A tabela ainda é criada como MyISAM, como antes.

  • Muitas sub selectas são muito mais rápidas que antes.

  • Disabled the PURGE LOGS statement that was added in in version 4.1.0. The statement now should be issued as PURGE MASTER LOGS or PURGE BINARY LOGS.

  • Added SHOW BDB LOGS as an alias for SHOW LOGS.

  • Added SHOW MASTER LOGS (which had been deleted in version 4.1.0) as an alias for SHOW BINARY LOGS.

  • Added Slave_IO_State and Seconds_Behind_Master columns to the output of SHOW SLAVE STATUS. Slave_IO_State indicates the state of the slave I/O thread, and Seconds_Behind_Master indicates the number of seconds by which the slave is late compared to the master.

  • --lower-case-table-names=1 now also makes aliases case insensitive. (Bug#534)

Bugs corrigidos:

  • Fixed merging types and length of fields in UNION

  • Fixed a bug in privilege handling that caused connections from certain IP addresses to be assigned incorrect database-level privileges. A connection could be assigned the database privileges of the previous successful authentication from one of those IP addresses, even if the IP address username and database name were different. (Bug#1636)

  • Error-handling functions were not called properly when an error resulted from [CREATE | REPLACE| INSERT] ... SELECT statements.

  • HASH, BTREE, RTREE, ERRORS, and WARNINGS no longer are reserved words. (Bug#724)

  • Fix for bug in ROLLUP when all tables were const tables. (Bug#714)

  • Fixed a bug in UNION that prohibited NULL values from being inserted into result set columns where the first SELECT of the UNION retrieved NOT NULL columns.

  • Fixed name resolution of columns of reduced subqueries in unions. (Bug#745)

  • Fixed memory overrun in subqueries in select list with WHERE clause bigger than outer query WHERE clause. (Bug#726)

  • Fixed a bug that caused MyISAM tables with FULLTEXT indexes created in 4.0.x to be unreadable in 4.1.x.

  • Fixed a data loss bug in REPAIR TABLE ... USE_FRM when used with tables that contained TIMESTAMP columns and were created in 4.0.x.

  • Fixed reduced subquery processing in ORDER BY/GROUP BY clauses. (Bug#442)

  • Fixed name resolution of outer columns of subquery in INSERT/REPLACE statements. (Bug#446)

  • Fixed bug in marking columns of reduced subqueries. (Bug#679)

  • Fixed a bug that made CREATE FULLTEXT INDEX syntax illegal.

  • Fixed a crash when a SELECT that required a temporary table (marked by Using temporary in EXPLAIN output) was used as a derived table in EXPLAIN command. (Bug#251)

  • Fixed a rare table corruption bug in DELETE from a big table with a new (created by MySQL-4.1) fulltext index.

  • LAST_INSERT_ID() now returns 0 if the last INSERT statement didn't insert any rows.

  • Corrigido a perda dos últimos caracteres na saída da função (Bug#447)

  • Corrigido um erro de replicação raro quando um transação extendia em dois ou mais relay logs e o escravo era parada enquanto ele estava executando a parte da transação que estava no segundo relay log ou em um adicional. Então a replicação parava no inicio do segundo relay log ou adicional, o que estava incorreto. (ele deve parar no BEGIN, no primeiro relay log). (Bug#53)

  • Agora CONNECTION_ID() é replicado apropriadamente (Bug#177).

  • A nova função PASSWORD() na versão 4.1 é replicada apropriadamente (Bug#344).

  • Corrigida a dupla liberação de memória

  • Corrigido um erro em UNION envolvendo tabelas temporárias.

  • Corrigido um erro de falha em DERIVED TABLES quando EXPLAIN é usado em um DERIVED TABLES com um join

  • Corrigido um erro de falha no DELETE com ORDER BY e LIMIT causado pala inicialização do vetor do ponteiro de referências.

  • Corrigido um erro na função USER() causado pelo erro no tamanho da string alocada

  • Corrigido um erro de falha quando se tentava criar uma tabela com coluna do tipo GEOMETRY com um mecanismo de armazenamenti que não a suporta.

  • Corrigido um erro de falha no UNION causado pela lista de select vazia e um campo não existente sendo usado em algumas das instruções SELECTs individuais.

  • Corrigido um erro de replicação com um master na versão 3.23 e um slave na 4.0: o slave perdia a replicação de tabelas temporárias se FLUSH LOGS era executado no master (Bug#254).

  • Corrigido um bug de segurança: Um servidor compilado ser suporte a SSL ainda permitia conexões de usuários que possuiam a opção REQUIRE SSL especificado para as suas contas.

  • Quando um usuário indefinido era usado em uma atualização de consulta no master (como INSERT INTO t VALUES(@a) onde @a nunca havia sido definido por esta conexão), então o slave podia replicar a consulta de forma incorreta se uma transação anterior no master usava uma variável de usuário de mesmo nome. (Bug#1331)

  • Corrigido um erro com instruções preparadas: O uso do parâmetro ? de instruções preparadas como argumento de certas funções e cláusulas fazia com que o servidor falhasse durante chamadas mysql_prepare(). (Bug#1500)

  • Corrigido um erro com instruções preparadas: depois da chamada de mysql_stmt_prepare, colchetes são permitidos em todas as instruções consequentes, mesmo se eles não forem preparados (Bug#1946)

D.2.3. Alterações na distribuição 4.1.0 (03 Apr 2003: Alpha)

Funcionalidades adicionadas ou alteradas:

  • Nova autenticação do cliente, mais segura, baseada em senha de 45-byte na tabela user.

  • Nova função CRC32() para calcular valor de verificação de redundância cíclica.

  • No Windows, agora estamos usando memória compartilhada para comunicar entre servidor e cliente quando eles estão executando na mesma máquina e você está conectando a localhost.

  • REPAIR das tabelas MyISAM agora usam menos espaço temporário em disco ao ordenar as colunas de caracteres.

  • A verificação de DATE/DATETIME agora é um bit estritamente para suportar a habilidade de deitiguir automaticamente entre date, datetime e time com microsegundos. Por exemplo, tipos de dados YYYYMMDD HHMMDD não são mais suportados; deve-se também ter separadores entre as partes DATE/TIME ou não.

  • Ajuda do lado do servidor para todas as funções do MySQL. Pode-se agora digitar help week no cliente mysql e conseguir ajuda para a função week().

  • Adionada a nova função da API C mysql_get_server_version().

  • Corrigido um buh na libmysqlclient que buscava campos padrões.

  • Corrigido um bug no cliente mysql.cc ao ignorar comentários

  • Adicionado o método record_in_range() para tabelas MERGE poderem escolher o índice certo quando houverem muitos para serem escolhidos.

  • A replicação agora funciona com RAND() e variáveis de usuários @var.

  • Permite-se alterar o modo para ANSI_QUOTES com o servidor no ar.

  • Agora pode se matar EXPLAIN SELECT. See Seção 4.6.7, “Sintaxe de KILL.

  • Agora pode se matar REPAIR TABLE. See Seção 4.6.7, “Sintaxe de KILL.

  • Permiti-se especificar lista de chaves vazias para USE INDEX, IGNORE INDEX e FORCE INDEX.

  • Agora DROP TEMPORARY TABLE apenas apaga tabelas temporárias e não finaliza transações.

  • Adicionado suporte para UNION em tabelas derivadas.

  • Warning: Alteração imcompatível! TIMESTAMP agora é retornado comi uma string do tipo 'YYYY-MM-DD HH:MM:SS' e tamanhos de timestamp diferentes não são suportados.

    Esta alteração era necessária para compatibilidade com o padrão SQL. Em uma versão futura, uma alteração adicional será feita (compatível co esta alteração), permitindo que o tamanho do timestamp indique o número de dígitos desejado para a fração de segundos.

  • Novo protocolo cliente/servidor mais rápido que suporta instruções preparadas, limitar parâmetros e colunas de resultados, transferância binaria de dados, avisos.

  • Adicionado nome de banco de dados e de nomes reais de tabela (no caso de alias) à estrutura MYSQL_FIELD.

  • Consultas multi linhas: Agora você pode executar diversas consultas de uma vez e então ler o resultados.

  • Em CREATE TABLE foo (a INT not null primary key) a palavra PRIMARY agora é opcional.

  • Em CREATE TABLE o atributo SERIAL agora é um alias para BIGINT NOT NULL AUTO_INCREMENT UNIQUE.

  • SELECT ... FROM DUAL é um alias para SELECT .... (Para ser compatível com alguns outros bancos de dados).

  • Se é criado um CHAR/VARCHAR muito grande, ele á alterado automaticamente para TEXT ou BLOB; Será exibido um aviso neste caso.

  • POde-se especificar os tipos BLOB/TEXT diferentes com a sintaxe BLOB(tamanho) e TEXT(tamanho). O MySQL irá alterá-los automaticamente para um dos tipos internos BLOB/TEXT.

  • CHAR BYTE é um alias para CHAR BINARY.

  • VARCHARACTER é um alias para VARCHAR.

  • Novos operadores inteiro MOD inteiro e inteiro DIV inteiro.

  • Adicionado SERIAL DEFAULT VALUE como um alias para AUTO_INCREMENT.

  • Adicionado TRUE e FALSE como alias para 1 e 0, respectivamente.

  • Agora aliases são forçados em tabelas dferivadas, como no SQL-99.

  • orrigido SELECT .. LIMIT 0 para retornar a contagem aproriada de linhas para SQL_CALC_FOUND_ROWS.

  • Pode-se especificar muitos diretórios temporários para serem usados de modo round-robin com: --tmpdir=nomedir1:nomedir2:nomedir3.

  • Subqueries: SELECT * from t1 where t1.a=(SELECT t2.b FROM t2).

  • Tabelas derivadas:

    SELECT a.col1, b.col2
           FROM (SELECT MAX(col1) AS col1 FROM root_table) a,
           other_table b
           WHERE a.col1=b.col1;
    

  • Conjuntos de caracteres a serem definidos por colunas, tabelas e banco de dados.

  • Suporte a Unicode (UTF8).

  • Nova sintaxe CONVERT(... USING ...) para conversão de valores strings entre conjunto de caracteres.

  • Índices BTREE em tabelas HEAP.

  • Servidor embutido mais rápido (novo protocolo de comunicação interno).

  • Pode-se adicionar um comentário por coluna em CREATE TABLE.

  • SHOW FULL COLUMNS FROM nome_tabela exibe os comentários das colunas.

  • ALTER DATABASE.

  • Suporte a GIS (dados geometricos). See Capítulo 10, Extensões Espacias em MySQL.

  • SHOW [COUNT(*)] WARNINGS exibe avisos sobre o último comnado.

  • Pode se especificar um tipo de coluna para em um CREATE TABLE ... SELECT definindo a coluna na parte CREATE.

    CREATE TABLE foo (um tinyint não nulo) SELECT b+1 AS 'a' FROM bar;
    
  • expr SOUNDS LIKE expr é o mesmo que SOUNDEX(expr)=SOUNDEX(expr).

  • Adicionada nova função VARIANCE(expr) que retorna a variância de expr

  • Pode se criar um tabela a partir de uma existente usando CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tabela (LIKE tabela). A tabela também pode ser normal ou temporária.

  • Novas opções --reconnect e --disable-reconnect para o cliente mysql, para reconectar automaticamente ou não se a conexão for perdida.

  • START SLAVE (STOP SLAVE) não retorna mais um erro se o slave já está iniciado (parado); ele retorns um aviso.

  • SLAVE START e SLAVE STOP não é mais aceitada pelo analisador de consulta; use START SLAVE e STOP SLAVE em seu lugar.

D.3. Alterações na distribuição 4.0.x (Production)

A versão 4.0 do servidor MySQL inclui muitos aprimoramentos e novos recursos:

Para uma lista completa de alterações, visite a seção para cada distribuição 4.0.x individual.

D.3.1. Alterações na distribuição 4.0.17 (not released yet)

Functionality added or changed:

  • Allow spaces in windows service names.

  • Changed the default Windows service name for mysqld from MySql to MySQL. This should not affect usage, because service names are not case sensitive.

  • When you install mysqld as a service on Windows systems, mysqld will read startup options in option files from the option group with the same name as the service name. (Except when the service name is MySQL).

Bugs fixed:

  • Fixed Bug#1335 when filesort was never shown in EXPLAIN if query contained ORDER BY NULL clause.

  • Fixed invalidation of whole query cache on DROP DATABASE. (Bug#1898)

  • Fixed bug in range optimizer that caused wrong results for some not likely AND/OR queries. (Bug#1828)

  • Fixed a crash in ORDER BY when ordering by expression and identifier. (Bug#1945)

  • Fixed a crash in an open HANDLER when an ALTER TABLE was executed in a different connection. (Bug#1826)

  • Fixed a bug in trunc* operator of full-text search which sometimes caused MySQL not to find all matched rows.

  • Fixed bug in zero prepending to DECIMAL column type.

  • Fixed optimiser bug, introduced in 4.0.16, when REF access plan was preferred to more efficient RANGE on another column.

  • Fixed problem when installing a MySQL server as a Windows service using a command of the form mysqld --install mysql --defaults-file=path-to-file.

  • Fixed an incorrect result from a query that uses only const tables (such as one-row tables) and non-constant expression (such as RAND()). (Bug#1271)

  • Fixed bug when the optimiser did not take SQL_CALC_FOUND_ROWS into account if LIMIT clause was present. (Bug#1274)

  • mysqlbinlog now asks for a password at the console when the -p or --password option is used with no argument. This is consistent with the way that other clients such mysqladmin and mysqldump already behave. Note: A consequence of this change is that it is no longer possible to invoke mysqlbinlog as mysqlbinlog -p pass_val (with a space between the -p option and the following password value). (Bug#1595)

  • Bug accidentally introduced in 4.0.16 where the slave SQL thread deleted its replicated temporary tables when STOP SLAVE was issued.

  • In a ``chain'' replication setup A->B->C, if 2 sessions on A updated temporary tables of the same name at the same time, the binary log of B became incorrect, resulting in C becoming confused. (Bug#1686)

  • In a ``chain'' replication setup A->B->C, if STOP SLAVE was issued on B while it was replicating a temporary table from A, then when START SLAVE was issued on B, the binary log of B became incorrect, resulting in C becoming confused. (Bug#1240)

  • When MASTER_LOG_FILE and MASTER_LOG_POS were not specified, CHANGE MASTER used the coordinates of the slave I/O thread to set up replication, which broke replication if the slave SQL thread lagged behind the slave I/O thread. This caused the slave SQL thread to lose some events. The new behaviour is to use the coordinates of the slave SQL thread instead. See Seção 4.11.8.1, “CHANGE MASTER TO. (Bug#1870)

  • Now if integer is stored or converted to TIMESTAMP or DATETIME value checks of year, month, day, hour, minute and second ranges are performed and numbers representing illegal timestamps are converted to 0 value. This behaviour is consistent with manual and with behaviour of string to TIMESTAMP/DATETIME conversion. (Bug#1448)

  • Fixed bug when BIT_AND() and BIT_OR() group functions returned incorrect value if SELECT used a temporary table and no rows were found. (Bug#1790).

  • BIT_AND() is now unsigned in all contexts. This means that it will now return 18446744073709551615 (= 0xffffffffffffffff) instead of -1 if there were no rows in the result.

  • Fixed bug with BIT_AND() still returning signed value for an empty set in some cases. (Bug#1972)

  • Fixed bug with ^ (XOR) and >> (bit shift) still returning signed value in some cases. (Bug#1993)

  • Replication: a rare race condition in the slave SQL thread, which could lead to a wrong complain that the relay log is corrupted. (Bug#2011)

  • Replication: if an administrative command on a table (OPTIMIZE TABLE, REPAIR TABLE etc) was run on the slave, this could sometimes stop the slave SQL thread (this did not led to any corruption; one just had to type START SLAVE to get replication going again). (Bug#1858)

  • Replication: in the slave SQL thread, a multi-table UPDATE could produce a wrong complain that some record was not found in one table, if the UPDATE was preceded by a INSERT ... SELECT. (Bug#1701)

D.3.2. Alterações na distribuição 4.0.16 (17 Out 2003)

Funcionalidades adicionadas ou alteradas:

  • Write memory allocation information to error log when doing mysqladmin debug. This only works on system that support the mallinfo() call (like newer Linux systems).

  • Added the following new server variables to allow more precise memory allocation: range_alloc_block_size, query_alloc_block_size, query_prealloc_size, transaction_alloc_block_size, and transaction_prealloc_size.

  • mysqlbinlog now reads option files. To make this work one must now specify --read-from-remote-server when reading binary logs from a MySQL server. (Note that using a remote server is deprecated and may disappear in future mysqlbinlog versions).

  • Block SIGPIPE signals also for non-threaded programs. The blocking is moved from mysql_init() to mysql_server_init(), which is automatically called on the first call to mysql_init().

  • Added --libs_r and --include options to mysql_config.

  • New `> prompt for mysql. This prompt is similar to the '> and "> prompts, but indicates that an identifier quoted with backticks was begun on an earlier line and the closing backtick has not yet been seen.

  • Atualizado o mysql_install_db para poder usar o endereço de IP da máquina local em vez do nome da máquina ao criar as tabelas de permissões iniciais de skip-name-resolve foi especificado. Esta opção pode ser útil no FreeBSD para evitar problemas de segurança de threads com o resolver de bibliotecas do FreeBSD. (Obrigado a Jeremy Zawodny pelo patch)

  • A documentation change: Added a note that when backing up a slave, it is necessary also to back up the master.info and relay-log.info files, as well as any SQL_LOAD-* files located in the directory specified by the --slave-load-tmpdir option. All these files are needed when the slave resumes replication after you restore the slave's data.

Bugs corrigidos:

  • Fixed a spurious error ERROR 14: Can't change size of file (Errcode: 2) on Windows in DELETE FROM table_name without a WHERE clause or TRUNCATE TABLE table_name, when table_name is a MyISAM table. (Bug#1397)

  • Fixed a bug that resulted in thr_alarm queue is full warnings after increasing the max_connections variable with SET GLOBAL. (Bug#1435)

  • Made LOCK TABLES to work when Lock_tables_priv is granted on the database level and Select_priv is granted on the table level.

  • Fixed crash of FLUSH QUERY CACHE on queries that use same table several times (Bug#988).

  • Fixed core dump bug when setting an enum system variable (such as SQL_WARNINGS) to NULL.

  • Extended the default timeout value for Windows clients from 30 seconds to 1 year. (The timeout that was added in MySQL 4.0.15 was way too short). This fixes a bug that caused ERROR 2013: Lost connection to MySQL server during query for queries that lasted longer than 30 seconds, if the client didn't specify a limit with mysql_options(). Users of 4.0.15 on Windows should upgrade to avoid this problem.

  • More ``out of memory'' checking in range optimiser.

  • Fixed and documented a problem when setting and using a user variable within the same SELECT statement. (Bug#1194).

  • Fixed bug in overrun check for BLOB values with compressed tables. This was a bug introduced in 4.0.14. It caused MySQL to regard some correct tables containing BLOB values as corrupted. (Bug#770, Bug#1304, and maybe Bug#1295)

  • SHOW GRANTS showed USAGE instead of the real column-level privileges when no table-level privileges were given.

  • When copying a database from the master, LOAD DATA FROM MASTER dropped the corresponding database on the slave, thus erroneously dropping tables that had no counterpart on the master and tables that may have been excluded from replication using replicate-*-table rules. Now LOAD DATA FROM MASTER no longer drops the database. Instead, it drops only the tables that have a counterpart on the master and that match the replicate-*-table rules. replicate-*-db rules can still be used to include or exclude a database as a whole from LOAD DATA FROM MASTER. A database will also be included or excluded as a whole if there are some rules like replicate-wild-do-table=db1.% or replicate-wild-ignore-table=db1.%, as is already the case for CREATE DATABASE and DROP DATABASE in replication. (Bug#1248)

  • Fixed a bug where mysqlbinlog crashed with a segmentation fault when used with the -h or --host option. (Bug#1258)

  • Fixed a bug where mysqlbinlog crashed with a segmentation fault when used on a binary log containing only final events for LOAD DATA. (Bug#1340)

  • Fixed compilation problem when compiling with OpenSSL 0.9.7 with disabled old DES support (If OPENSSL_DISABLE_OLD_DES_SUPPORT option was enabled).

  • Fixed a bug when two (or more) MySQL servers were running on the same machine, and they were both slaves, and at least one of them was replicating some LOAD DATA INFILE command from its master. The bug was that one slave MySQL server sometimes deleted the SQL_LOAD-* files (used for replication of LOAD DATA INFILE and located in the slave-load-tmpdir directory, which defaults to tmpdir) belonging to the other slave MySQL server of this machine, if these slaves had the same slave-load-tmpdir directory. When that happened, the other slave could not replicate LOAD DATA INFILE and complained about not being able to open some SQL_LOAD-* file. (Bug#1357)

  • If LOAD DATA INFILE failed for a small file, the master forgot to write a marker (a Delete_file event) in its binary log, so the slave could not delete 2 files (SQL_LOAD-*.info and SQL_LOAD-*.data from its tmpdir. (Bug#1391)

  • On Windows, the slave forgot to delete a SQL_LOAD-*.info file from tmpdir after successfully replicating a LOAD DATA INFILE command. (Bug#1392)

  • When a connection terminates, MySQL writes DROP TEMPORARY TABLE statements to the binary log for all temporary tables which the connection had not explicitely dropped. MySQL forgot to backquote the database and table names in the statement. (Bug#1345)

  • On some 64-bit machines (some HP-UX and Solaris machines), a slave installed with the 64-bit MySQL binary could not connect to its master (it connected to itself instead). (Bug#1256, Bug#1381)

  • Code was introduced in MySQL 4.0.15 for the slave to detect that the master had died while writing a transaction to its binary log. This code reported an error in a legal situation: When the slave I/O thread was stopped while copying a transaction to the relay log, the slave SQL thread would later pretend that it found an unfinished transaction. (Bug#1475)

D.3.3. Alterações na distribuição 4.0.15 (03 Sep 2003)

IMPORTANT:

If you are using this release on Windows, you should upgrade at least your clients (any program that uses libmysql.lib) to 4.0.16 or above. This is because the 4.0.15 release had a bug in the Windows client library that causes Windows clients using the library to die with a Lost connection to MySQL server during query error for queries that take more than 30 seconds. This problem is specific to Windows; clients on other platforms are unaffected.

Funcionalidades adicionadas ou alteradas:

  • O mysqldump agora coloca todos os identificadores corretamente entre aspas ao conectar com o servidor. Isto assegura que durante o processo de dump, O mysqldump nunca enviará consultas ao servidor que resultam em um erro de sintaxe. Este problema não está relacionado a saída do programa mysqldump, que não foi alterado. (Bug#1148)

  • Altera a informação de metadados do resultado e assim MIN() e MAX() informamm que eles podem retornar NULL (isto é verdade porque um conjunto vazio retornará NULL). (Bug#324)

  • Produz uma mensagem de erro no Windows se um segundo servidor mysqld é iniciado na mesma porta TCP/IP que um servidor mysqld já em execução.

  • As variveis do servidor mysqld wait_timeout, net_read_timeout e net_write_timeout agora funcionam no Windows. Agora pode-se também definir o tempo limite de leitura e escrita em clientes Windows com a opção mysql_options()

  • Adicionada a opção --sql-mode=NO_DIR_IN_CREATE para tornar possível para os slaves ignorarem as opções INDEX DIRECTORY e DATA DIRECTORY dadas para CREATE TABLE. Quando ele está ligado, SHOW CREATE TABLE não exibirá os diretórios dados.

  • SHOW CREATE TABLE agora exibe as opções INDEX DIRECTORY e DATA DIRECTORY, se eles fossem especificados quando a tabela era criada.

  • A variável do servidor open_files_limit agora exibe o limite de arquivos abertos real.

  • MATCH ... AGAINST() em modo de linguagem natural agora tratam de palavra presentes em mais de 2,000,000 linhas como stopwords.

  • As imagens do disco de instalação do Mac OS X agora incluem um pacote MySQLStartupItem.pkg adicional que habilita a inicialização automática do MySQL no boot do sistema. See Seção 2.1.3, “Instalando o MySQL no Mac OS X”.

  • A maioria da documentação incluída na distribuição tar do binário (.tar.gz) foi movida para o subdiretório docs. See Seção 2.2.5, “Layouts de Instalação”.

  • O manual agora está incluído com um arquivo info tradicional na distribuição binária. (Bug#1019)

  • A distribuição binária agora incluem a biblioteca do servidor embutido (libmysqld) por padrão. Devido a problemas de ligação com compiladores diferentes do gcc, ele não estava incluído em todos os pacotes da distribuição inicial da versão 4.0.15. Os pacotes afetados forma reconstruidos e distribuidos como 4.0.15a. Veja mais informações sobre isto na Seção 1.5.1.2, “Servidor Embutido MySQL”.

  • O MySQL agora pode usar o otimizador de faixa para BETWEEN com limites não constantes. (Bug#991)

  • Mensagens de erro de replicação agora incluem o banco de dados padrão, assim os usuários podem verificar em qual banco de dados a consulta com erro está rodando.

  • Uma alteração da documentação: Adicionado um parágrafo sobre como as opções binlog-do-db e binlog-ignore-db são testadas em um banco de dados no master (see Seção 4.10.4, “O Log Binário”), e um parágrafo sobre como replicate-do-db, replicate-do-table e opções análogas são testadas em bancos de dados e tabelas no slave (see Seção 4.11.6, “Opções de Inicialização da Replicação”).

  • Agora o slave não replica SET PASSWORD se estiver configurado para excluir o banco de dados mysql da replicação (usando, por exemplo, replicate-wild-ignore-table=mysql.%). Este já era o caso para GRANT e REVOKE desde a versão 4.0.13 (embora houvesse o Bug#980 nas versões 4.0.13 & 4.0.14, que foi corrigido na versão 4.0.15).

  • Rewrote the information shown in the State column of SHOW PROCESSLIST for replication threads and for MASTER_POS_WAIT() and added the most common states for these threads to the documentation, see Seção 4.11.3, “Detalhes de Implementação da Replicação”.

  • Adiciona um teste na replicação para detectar o caso no qual o master morre no meio da gravação de uma transação no log binário; tal transação inacabada agora dispara uma mensagem de erro no slave.

  • Um comando GRANT que cria um usuário anônimo (isto é, uma conta com nome de usuário vazio) não exige mais FLUSH PRIVILEGES para a conta ser conhecida no servidor. (Bug#473)

  • CHANGE MASTER agora descarrega o relay-log.info. Anteriormente isto era feito na próxima execução de START SLAVE, assim se o mysqld fosse desligado no slave depois de CHANGE MASTER sem executar START SLAVE, o nome e posição do relay log eram perdidos. Na reinicialização eles eram carregados a partir do relay-log.info, revertendo-os para seus valores antigos (incorretos) de antes do CHANGE MASTER, exibindo mensagens de erro (já que o relay log antigo não existia mais) e as threads slaves se recusavam a iniciar. (Bug#858)

Bugs corrigidos:

  • Corrigido o overflow do buffer no tratamewnto de senhas, que podia potencialmente ser explorardo pelo usuário MySQL com privilégios na tabela mysql.user para executar código aleatórios para obter acessi com o UID do processo mysqld (obrgado a Jedi/Sector One por detectar e reportar este erro.)

  • Corrigido um falha do servidor com FORCE INDEX em uma consulta contendo "Range checked for each record" na saída do EXPLAIN. (Bug#1172)

  • Corrigido o tratamento de permissão de tabelas/colunas - a ordenação apropriada (do mais específico para o menos específico, see Seção 4.3.10, “Controle de Acesso, Estágio 2: Verificação da Requisição”) não era respeitada (Bug#928)

  • Corrigido um bug raro no MYISAM introduzido na versão 4.0.3 onde o handler do arquivo de índice não era diretamente atualizado depois de um UPDATE de registros dinamicos separados.

  • Corrigido o erro Can't unlock file ao executar myisamchk --sort-index no Windows. (Bug#1119)

  • Corrigido um possível deadlock ao alterar key_buffer_size enquanto a cache de chaves era ativamente usada. (Bug#1088)

  • Corrigido um bug de overflow em MyISAM e ISAM quando um registro era atualiado na tabela com um grande número de colunas e pelo meno uma coluna BLOB/TEXT.

  • Corrigido um resultado incorreto ao fazer UNION e LIMIT #,# quando não era usado parenteses na parte SELECT.

  • Corrigido um resultado incorreto ao fazer UNION e ORDER BY .. LIMIT # quando não usado parenteses na parte SELECT.

  • Corrigido um problema com SELECT SQL_CALC_FOUND_ROWS ... UNION ALL ... LIMIT # onde FOUND_ROWS() retornava o número incorreto de linhas.

  • Corrigidos um erro de pilha indesejado quando tinhamos uma grande expressão do tipo 1+1-1+1-1... de uma ceta combinação. (Bug#871)

  • Corrigido o erro que algumas vezes fazia uma tabela com um índice FULLTEXT estar marcada como "analyzed".

  • Corrigido o MySQL para que o tamanho do campo (na API C) para a segunda coluna em SHOW CREATE TABLE seja sempre maior que o tamanho do dado. A única aplicação conhecida que era afetada pelo comportamento anterior era o Borland dbExpress, que truncava a saída do comando. (Bug#1064)

  • Corrigida a falha na comparação de strings usando o conjunto de caracteres tis620. (Bug#1116)

  • Corrigido um bug do ISAM na otimização de MAX().

  • myisamchk --sort-records=N não marca mais a tabela como danificada se a ordenação falhar devido a uma chave inapropriada. (Bug#892)

  • Corrigido um erro no tratamento de tabelas MyISAM compactadas que algumas vezes torna impossível se reparar tabelas compactadas no modo "Repair by sort". "Repair with keycache" (myisamchk --safe-recover) funcionad. (Bug#1015)

  • Correção de um erro na propagação do número da versão do manual incluído no arquivo de distribuição. (Bug#1020)

  • Corrigida um problema de ordenacao da chave (uma chave primária - PRIMARY - declarada em uma coluna que não é explicitamente marcada como NOT NULL era ordenada depois de uma chave UNIQUE para uma coluna NOT NULL).

  • Corrigido o resultado de INTERVAL qaundo aplicado a um valor DATE. (Bug#792)

  • Corrida a compilação da biblioteca do servidor embutido da arquivo de especificação do RPM. (Bug#959)

  • Adicionado alguns arquivos que faltavam na arquivo de especificação do RPM e corrigido alguns erros de criação do RPM que ocorriam no Red Hat Linux 9. (Bug#998)

  • Corrigida a avaliação incorreta de XOR na cláusula WHERE. (Bug#992)

  • Corrigido um erro com processamento na cache de consultas com tabelas unidas a partir de mais de 255 tabelas. (Bug#930)

  • Correção dos resultados incorretos da consulta outer join (ex. LEFT JOIN) quando a condição ON é sempre falsa, e a faixa de busca é usada. (Bug#926)

  • Corrigido um erro causando resultados incorretos de MATCH ... AGAINST() em algumas joins. (Bug#942)

  • Tabelas MERGE não ignoram mais "Using index" (da saída de EXPLAIN).

  • Corrigido um erro que fazia uma tabela vazia ser marcada como "analyzed". (Bug#937)

  • Corrigida a falha em myisamchk --sort-records quando usada em tabelas compactadas.

  • Corrigido o ALTER TABLE lento (quando comparado a versão 3.23) e comandos relacionados tais como CREATE INDEX. (Bug#712)

  • Correção de segmentation fault resultante de LOAD DATA FROM MASTER quando o mestre estava executando sem a opção --log-bin. (Bug#934)

  • Corrigido um erro de segurança: Um servidor compilado com suporte a SSL ainda permitia conexões por usuários que tinham a opção REQUIRE SSL especificadas por suas contas.

  • Corrigido um erro aleatório: Algumas vezes o slave replicava consultas GRANT ou REVOKE mesmo se estivesse configurado para excluir o banco de dados mysql da replicação (por exemplo, usando replicate-wild-ignore-table=mysql.%). (Bug#980)

  • Os campos Last_Errno e Last_Error na saída de SHOW SLAVE STATUS agora são limpadas por CHANGE MASTER e quando a thread slave de SQL inicia. (Bug#986)

  • Um erro de documentação: ela dizia que RESET SLAVE não altera a informação de conexão (master host, port, user e password), embora ela o fizesse. A instrução retorna estes valores para a opção de inicialização (master-host etc) se houvesse alguma. (Bug#985)

  • SHOW SLAVE STATUS agora exibe a informação correta (master host, port, user e password) depois de RESET SLAVE (isto é, ela mostra os novos valores, que são copiados das opções de inicialização se houver alguma). (Bug#985)

  • Disabilitada a propagação da posição original do log do master para eventos porque isto gerava valores inesperados para Exec_Master_Log_Pos e problemas com MASTER_POS_WAIT() em configurações de replicação A->B->C. (Bug#1086)

  • Corrigido uma segmentation fault no mysqlbinlog quando --position=x era usado com x estando entre um evento Create_file e o evento Append_block, Exec_load ou Delete_file. (Bug#1091)

  • mysqlbinlog exibia avisos superfluos quando se usava --database, o que causava erro de sintaxe quando enviado para mysql. (Bug#1092)

  • O mysqlbinlog --database também filtra LOAD DATA INFILE (anteriormente, ele filtrava todas as consultas exceto LOAD DATA INFILE). (Bug#1093)

  • O mysqlbinlog em alguns casos esquece de colocar um '#' em frente do LOAD DATA INFILE original (este comando é exibido apenas para informação, não para ser executado; mais tarde ele funcionava como LOAD DATA LOCAL com um nome de arquivo diferente, para execução pelo mysql). (Bug#1096)

  • binlog-do-db e binlog-ignore-db filtravam LOAD DATA INFILE incorretamente (ele era escrito parcialmente para o log binário). Isto resultava em um corrompimento do log binário, que podia fazer o slave parar com um erro. (Bug#1100)

  • Quando, em uma transação, um tabela transacional (como uma tabela InnoDB) era atualizada, e posteriormente na mesma transação um tabela não transacional (como um tabela MyISAM) era atualizada usando o conteúdo atualizado da tabela transacional (com INSERT ... SELECT por exemplo), as consultas eram escritas no log binário em uma ordem incorreta. (Bug#873)

  • Quando em uma transação, INSERT ... SELECT atualizava uma tabela não transacional, e um ROLLBACK era executado, nenhum erro era atualizado para o cliente. Agora o cliente é avisado que não se pode fazer roll back de algumas alterações, como já era o caso para um INSERT normal. (Bug#1113)

  • Corrigido um erro portencial: Quando STOP SLAVE era executado enquanto a thread slave de SQL estava no meio de uma transação, e então CHANGE MASTER era usado para direcionar para o slave para alguma instrução não transacional, a thread slave de SQL ficava confusa (porque ela ainda podia achar que estava em uma transação).

D.3.4. Alterações na distribuição 4.0.14 (18 Jul 2003)

Funcionalidades adicionadas ou alteradas:

  • InnoDB agora suporta indexação pelo prefixo de um campo. Isto significa, em particularm que as colunas BLOB e TEXT pode ser indexadas em tabelas InnoDB, o que não era possível antes.

  • Uma alteração de documentação: Função INTERVAL(NULL, ...) retorna -1.

  • Habilitado o INSERT do SELECT quando a tabela na qual os registros são inseridos também é uma tabela listada no SELECT.

  • Permite CREATE TABLE e INSERT de qualquer UNION.

  • A opção SQL_CALC_FOUND_ROWS agora sempre retorna o número total de rgistro de qulquer UNION.

  • Removida a opção --table de mysqlbinlog para evitar repetir a funcionalidade mysqldump.

  • Alterado levemente o otimizador para preferir busca de índice sobre busca em toda a tabela em alguns casos limites.

  • Adicionado uma variável especifica da thread, max_seeks_for_key, que pode ser usada para forçar a otimização para usar chaves em vez de varrer a tabela, mesmo se a cardinalidade do índice for baixa.

  • Adicionada a otimização que converte LEFT JOIN para joins normais em alguns casos.

  • Uma alteração da documentação: adicionado um parágrafo sobre falhas em replicação (como usar um slave sobrevivente como um novo master, como resumir a configuração original). See Seção 4.11.9, “FAQ da Replicação”.

  • Uma alteração de documentação: adicionado avisos sobre uso seguro do comando CHANGE MASTER. See Seção 4.11.8.1, “CHANGE MASTER TO.

  • O MySQL agora envia um aviso (e não um erro, como na versão 4.0.13) quando ele abre uma tabela que foi criada com o MySQL 4.1.

  • Adicionada a opção --nice para mysqld_safe para permitir configurar a exatidão do processo mysqld. (Obrigado a Christian Hammers por fornecer o patch inicial.) (Bug#627)

  • Adicionada a opção --read-only para que o mysqld não permita atualizações, exceto da thread escrava ou de usuários com o privilégio SUPER. (Pacth original de Markus Benning).

  • SHOW BINLOG EVENTS FROM x onde x é menor que 4, agora converte silenciosamente x para 4 em vez de exibir um erro. A mesma alteração foi feita para CHANGE MASTER TO MASTER_LOG_POS=x e CHANGE MASTER TO RELAY_LOG_POS=x.

  • mysqld agora só adiciona um tratamento de interrupção para o sinal SIGINT se você começá-lo com a nova opção --gdb. Isto é porque alguns usuários MySQL encontraram alguns problemas estranhos quando acidentalmente enviavam SIGINT para a threads mysqld.

  • RESET SLAVE agora limpa os campos Last_Errno e Last_Error na saída de SHOW SLAVE STATUS.

  • Adicionada a variável max_relay_log_size; o relay log será rotacionado automaticamente quando seu tamanho exceder max_relay_log_size. Mas se max_relay_log_size for 0 (o padrão), max_binlog_size será usado (como em versões mais antigas). max_binlog_size ainda se aplica a logs binários em qualquer caso de uso.

  • FLUSH LOGS agora rotaciona os relay logs em adição aos outros tipos de logs que ele já rotacionava.

Bugs corrigidos:

  • Comparação/ordenação para o conjunto de caracteres latin1_de foi reescrita. O algoritmo antigo não podia tratar casos como "sä" > "ßa". Veja mais informações sobre isto na Seção 4.7.1.1, “German character set”. Em casos raros ela resultava em tabela corrompida.

  • Corrigido um problema com a prompt de senha no Windows. (Bug#683)

  • ALTER TABLE ... UNION=(...) para uma tabela MERGE agora é permitida mesmo que alguma tabela MyISAM seja somente leitura. (Bug#702)

  • Corrigido um problema com CREATE TABLE t1 SELECT x'41'. (Bug#801)

  • Removido alguns avisos de lock incorretos do log de erro.

  • Corrigida um estouro de memória ao se fazer REPAIR em uma tabela com uma chave auto incremento multi-partes onde uma parte era um pacote CHAR.

  • Corrigida uma provável condição de corrida no código da replicação que podia levar potencialmente a instruções INSERT não sendo replicadas no evento de um comando FLUSH LOGS ou quando o log binário excede max_binlog_size. (Bug#791)

  • Corrigido um bug que pode levar a falha em INTERVAL e GROUP BY ou DISTINCT. (Bug#807)

  • Corrigido um bug no mysqlhotcopy, assim ele agora aborta em operações de cópia de tabelas sem sucesso. Corrigido outro bug, assim ele obtem sucesso quando houver milhares de tabelas para copiar. (Bug#812)

  • Corrigido o problema com mysqlhotcopy que falhava ao ler opções do arquivo de opção. (Bug#808)

  • Corrigido um bug no otimizador que algumas vezes prevenia o MySQL de usar índices FULLTEXT mesmo se fosse possível (por exemplo, em SELECT * FROM t1 WHERE MATCH a,b AGAINST("index") > 0).

  • Corrigido um bug com ``table is full'' em operações UNION.

  • Corrigido um problema de segurança no qual usuários habilitados sem privilégios obtinham informações na lista de banco de dados existentes usando SHOW TABLES e comandos parecidos.

  • Corrigido um problema de pilha no UnixWare/OpenUnix.

  • Corrigido um problema de configuração UnixWare/OpenUNIX e OpenServer.

  • Corrigido um problema de pilha cheia na verificação da senha.

  • Corrigido um problema com max_user_connections.

  • HANDLER sem um índice agora funciona apropriadamente quando uma tabela tem registros deletados. (Bug#787)

  • Corrigido um erro com LOAD DATA em mysqlbinlog. (Bug#670)

  • Correção: SET CHARACTER SET DEFAULT fucniona. (Bug#462)

  • Corrigido o comportamento de tabelas MERGE em consultas ORDER BY ... DESC. (Bug#515)

  • Corrigida a falha do servidor em PURGE MASTER LOGS ou SHOW MASTER LOGS quando o log binário estava desligado. (Bug#733)

  • Corrigido o problema de verificação de senha no Windows. (Bug#464)

  • Corrigido um erro na comparação de uma coluna DATETIME e uma constante inteira. (Bug#504)

  • Corrigido o modo remoto de mysqlbinlog. (Bug#672)

  • Corrigido ERROR 1105: Unknown error que ocorria para algumas consultas SELECT, onde uma coluna declarada como NOT NULL era comparada com uma expressão que podia tomar o valor NULL.

  • Alterado o timeout em mysql_real_connect() para usar poll() em vez de select() para contornar problemas cmo muitos outros arquivos abertos no cliente.

  • Corrigido resultados incorretos de MATCH ... AGAINST usado com uma consulta LEFT JOIN.

  • Corrigido um bug que limitava o valor máximo para variáveis mysqld em 4294967295 quando eles eram especificados na linha de comando.

  • Corrigido um bug que algumas vezes causavam falsos erros de ``Access denied'' nas instruções HANDLER ... READ, quando uma tabela é referenciada via um alias.

  • Corrigido um problema de portabilidade com safe_malloc, o qual fazia com que o MySQL para enviar erros de "Freeing wrong aligned pointer" no SCO 3.2.

  • ALTER TABLE ... ENABLE/DISABLE KEYS podia causar um core dump quando feito depois de uma instrução INSERT DELAYED na mesma tabela.

  • Corrigido um problema com conversão da hora local para GMT onde algumas vezes resultava em diferentes (mas corretos) timestamps. Agora o MySQL deve usar o menor valor de possível neste caso. (Bug#316)

  • Uma cache de consultas muito pequena podia fazer o mysqld falhar. (Bug#549)

  • Corrigido um bug (acidentalemnte introduzida por nós mas presente apenas na versão 4.0.13) que faz INSERT ... SELECT em uma coluna AUTO_INCREMENT que não replica bem. Este bug está no master, não no slave. (Bug#490)

  • Corrigido um bug: Quando uma instrução INSERT ... SELECT inseria linhas em uma tabela não transacional, mas falhava no mesmo ponto (por exemplo, devido a erros de ``Duplicate key''), a consulta não era escrita no log binário. Agora ela é escrita no log binário, com seus códigos de erros, como todas as outras cosultas são. Sobre a opção slave-skip-errors para como tratar consultas completadas parcialmente no slave, veja Seção 4.11.6, “Opções de Inicialização da Replicação”. (Bug#491)

  • SET FOREIGN_KEY_CHECKS=0 não era replicado apropriadamente. A correção provavelmente não será feita para 3.23.

  • Em um slave, LOAD DATA INFILE sem cláusulas IGNORE ou REPLACE no master, era replicada com IGNORE. Enquanto isto não for um problemase os dados do master e slave são identicos (em LOAD que não produz conflitos de duplicação no master não produzirá nada no slave de qualquer forma), o que é verdade em operações normais, para depuração é melhor não adicionar silenciosamente o IGNORE. Deste modo, você pode obter uma mensagem de erro no slave e descobrir que por alguma razão, os dados no master e slave são diferentes e investigar o porque. (Bug#571)

  • Em um slave, LOAD DATA INFILE exibia uma mensagem incomplete ``Duplicate entry '%-.64s' for key %d''' (o nome e valor da chave não eram mencionados) no caso de conflito de duplicação (o que não acontece em operações normais). (Bug#573)

  • Quando usado um slave compilado com --debug, CHANGE MASTER TO RELAY_LOG_POS podia causar um falha de declaração da depuração. (Bug#576)

  • Ao fazer um LOCK TABLES WRITE em uma tabela InnoDB, o commit podia não acontecer, se a consulta não era escrita no log binário (por exemplo, se --log-bin não era usado, ou binlog-ignore-db era usado). (Bug#578)

  • Se um master na versão 3.23 tivesse aberto tabelas temporárias que tinham sido replicadas para um slave na versão 4.0, e o log binário rotacionado, estas tabelas temporárias eram automaticamente removidas pelo slave (o que causa problemas se o master os utiliza subsequecialmente). Este erro foi corrigido na versão 4.0.13, mas de um modo que cria um incoveniência indesejada: se o master na versão 3.23 morrer brutalmente. (queda de força), sem tempo suficiente para escrever automaticamente instruções DROP TABLE em seu log binário. então o slave na versão 4.0.13 não notificaria que as tabelas temporárias tinham sido removidas, até o servidor mysqld slave ter sido reiniciado. Este pequeno incoveniente está corrigido na versão 3.23.57 e 4.0.14 (significando que o master deve ser atualizado para a versão 3.23.57 e o slave para a 4.0.14 para remover o incoveniente). (Bug#254)

  • Se MASTER_POS_WAIT() estava espereando e o slave estava inativo, e thread slave de SQL terminada, MASTER_POS_WAIT() esperaria para sempre. Agora quando a thread slave de SQL termina, MASTER_POS_WAIT() retorna NULL imediatamente (``slave stopped''). (Bug#651)

  • Depois de RESET SLAVE; START SLAVE;, o valor de Relay_Log_Space exibido por SHOW SLAVE STATUS era muito grande para 4 bytes. (Bug#763)

  • Se uma consulta era ignorada no slave (devido a replicate-ignore-table e outras regras similares), o escravo ainda verifica se a consulta consegue o mesmo código de erro (0, sem erro) como no master. Assim se o master tiver um erro na consulta (por exemplo, ``Duplicate entry'' em uma inserção de múltiplas linhas), então o slave parava e avisava que código de erro não coincidia. (Bug#797)

D.3.5. Alterações na distribuição 4.0.13 (16 May 2003)

Funcionalidades adicionadas ou alteradas:

  • PRIMARY KEY agora implica NOT NULL. (Bug#390)

  • O pacote de binários do Windows agora está compilado com --enable-local-infile encontrar a configuraçào de construção do Unix.

  • Removida a medida do tempo de mysql-test-run. time não aceita todos os parâmetros exigidos em muitas aplicações (por exemplo, QNX) e a medida de tempo não é reamente necessária (isto não é um benchmark).

  • SHOW MASTER STATUS e SHOW SLAVE STATUS exigem o privilégio SUPER; agora eles aceitam REPLICATION CLIENT. (Bug#343)

  • Adicionada otimização de reparação do MyISAM em multi-threads e a variável myisam_repair_threads para habilitá-lo. Veja mais informações sobre isto na Seção 4.6.8.4, “SHOW VARIABLES.

  • Adicionada a variável innodb_max_dirty_pages_pct que controla a quantidade de páginas ``sujas'' permitidas na área de buffer do InnoDB.

  • As mensagens de erro CURRENT_USER() e Access denied agora relatam o nome de máquina exatamente como ele está especificado no comando GRANT.

  • Removido os resultados de benchmark das distribuições fonte e binárias. Eles ainda estão disponíveis na árvore fonte do BK.

  • Tabelas InnoDB agora suportam ANALYZE TABLE.

  • O MySQL agora envia um erro quando ele abre uma tabela que foi criada com o MySQL 4.1.

  • A opção --new agora altera altera os itens binários (0xFFDF) para serem tratados como strings binárias em vez de números por padrão. Isto corrige alguns problemas com conjunto de caracteres onde é conveniente colocar a string como um item binário. Depois destas alterações você deve converter a string binária para INTEGER com um CAST se você quiser comparar dois itens binários, um com o outro, e saber qual é maior. SELECT CAST(0xfeff AS UNSIGNED) < CAST(0xff AS UNSIGNED). Este será o comportamento padrão no MySQL 4.1. (Bug#152)

  • Habilitado delayed_insert_timeout no Linux (as bibliotecas glibc mais modernas tem um pthread_cond_timedwait corrigido). (Bug#211)

  • Não cria mais threads de insert delayed que o dado por max_insert_delayed_threads. (Bug#211)

  • Alterado o UPDATE ... LIMIT para aplicar o limite as linhas encontradas, independente de terem sido alteradas. Anteriormente o limite era aplicado como uma restrição no número de linhas alteradas.

  • Ajustado o otimizador para favorecer indíces em cluster em ver de busca na tabela.

  • BIT_AND() e BIT_OR() agora retornam um valor de 64 bits sem sinal.

  • Adicionado avisos ao log de erro do porquê de um falha em uma conexão segura (quando executando com --log-warnings).

  • As opções --skip-symlink e --use-symbolic-links estão obsoletas e forma substituídas com --symbolic-links.

  • A opção padrão para innodb_flush_log_at_trx_commit foi alterada de 0 para 1 para tornar tabelas InnoDB como ACID por padrão. See Seção 7.5.3, “Opções de Inicialização do InnoDB”.

  • Adicionado o recurso para SHOW KEYS para mostrar chaves que estão disabilitadas pelo comando ALTER TABLE DISABLE KEYS.

  • Ao usar um tipo de tabela não existente com CREATE TABLE, primeiro vê se o tipo de tabela padrão existe antes de utilizar MyISAM.

  • Adicionado MEMORY como um alias para HEAP.

  • Renomeada a função rnd para my_rnd já que o nome era muito genérico e é um símbolo exportado no libmysqlclient (obrigado a Dennis Haney pelo patch inicial).

  • Correção de portabilidade: renomeado include/dbug.h para include/my_debug.h.

  • mysqldump não deleta mais o log binário sem aviso quando chamado com --master-data ou --first-slave; enquanto este comportamento era conveniente para alguns usuários, outros podia sofrer com ele. Agora deve perguntar explicitamente pela sua deleção com a nova opção --delete-master-logs.

  • Se o slave é configurado (usando, por exemplo, replicate-wild-ignore-table=mysql.%) para ecluir mysql.user, mysql.host, mysql.db, mysql.tables_priv e mysql.columns_priv da replicação, então GRANT e REVOKE não serão replicados.

Bugs corrigidos:

  • A mensagem de erro Access denied ao logar tinha um valor Using password incorreto. (Bug#398)

  • Corrigido um bug com NATURAL LEFT JOIN, NATURAL RIGHT JOIN e RIGHT JOIN quando usadas muitas tabelas em joins. O problema era que o método JOIN não era sempre associoado com as tabelas envolvida no método JOIN. Se você tiver uma consulta que usa muitos RIGHT JOIN ou NATURAL ... JOINS você deve verificar se eles funcionam como você espera depois de atualizar o MySQL para esta versõa. (Bug#291)

  • O cliente de linha de comando mysql não olha mais os comnados \* dentro de stringd com aspas invertidas.

  • Corrigido Unknown error ao usar UPDATE ... LIMIT. (Bug#373)

  • Corrigido o problema com o modo ANSI e GROUP BY com constantes. (Bug#387)

  • Corrigido o erro com UNION e OUTER JOIN. (Bug#386)

  • Corrigido o erro se é usado um UPDATE multi-tabelas e a consulta exige um tabela temporária maior que tmp_table_size. (Bug#286)

  • Executa mysql_install_db com a opção -IN-RPM para a instalação do Mac OS X não falhar em sistemas com a configuração de nome de máquina feita de forma inapropriada.

  • LOAD DATA INFILE agora irá ler 000000 como uma data zerada em vez de "2000-00-00".

  • Corrigido um erro que fazia que DELETE FROM table WHERE const_expression sempre deletasse toda a tabela (mesmo se o resultado da expressão fosse falso). (Bug#355)

  • Corrigido um bug de core dump ao usar FORMAT('nan',#). (Bug#284)

  • Corrigido um erro na resolução do nome com HAVING ... COUNT(DISTINCT ...).

  • Corrigido resultados incorretos da operação de truncamento (*) em MATCH ... AGAINST() em alguns joins complexos.

  • Fixed a crash in REPAIR ... USE_FRM command, when used on read-only, nonexisting table or a table with a crashed index file.

  • Fixed a crashing bug in mysql monitor program. It occurred if program was started with --no-defaults, with a prompt that contained hostname and connection to non-existing db was requested

  • Fixed problem when comparing a key for a multi-byte-character set. (Bug#152)

  • Fixed bug in LEFT, RIGHT and MID when used with multi-byte character sets and some GROUP BY queries. (Bug#314)

  • Fix problem with ORDER BY being discarded for some DISTINCT queries. (Bug#275)

  • Fixed that SET SQL_BIG_SELECTS=1 works as documented (This corrects a new bug introduced in 4.0)

  • Fixed some serious bugs in UPDATE ... ORDER BY. (Bug#241)

  • Fixed unlikely problem in optimising WHERE clause with constant expression like in WHERE 1 AND (a=1 AND b=1).

  • Fixed that SET SQL_BIG_SELECTS=1 works again.

  • Introduced proper backtick quoting for db.table in SHOW GRANTS.

  • FULLTEXT index stopped working after ALTER TABLE that converts TEXT column to CHAR. (Bug#283)

  • Fixed a security problem with SELECT and wildcarded select list, when user only had partial column SELECT privileges on the table.

  • Mark a MyISAM table as "analyzed" only when all the keys are indeed analyzed.

  • Only ignore world-writeable my.cnf files that are regular files (and not, for example, named pipes or character devices).

  • Fixed few smaller issues with SET PASSWORD.

  • Fixed error message which contained deprecated text.

  • Fixed a bug with two NATURAL JOINs in the query.

  • SUM() didn't return NULL when there was no rows in result or when all values was NULL.

  • On Unix symbolic links handling was not enabled by default and there was no way to turn this on.

  • Added missing dashes to parameter --open-files-limit in mysqld_safe. (Bug#264)

  • Fixed incorrect hostname for TCP/IP connections displayed in SHOW PROCESSLIST.

  • Fixed a bug with NAN in FORMAT(...) function ...

  • Fixed a bug with improperly cached database privileges.

  • Fixed a bug in ALTER TABLE ENABLE / DISABLE KEYS which failed to force a refresh of table data in the cache.

  • Fixed bugs in replication of LOAD DATA INFILE for custom parameters (ENCLOSED, TERMINATED and so on) and temporary tables. (Bug#183, Bug#222)

  • Fixed a replication bug when the master is 3.23 and the slave 4.0: the slave lost the replicated temporary tables if FLUSH LOGS was issued on the master. (Bug#254)

  • Fixed a bug when doing LOAD DATA INFILE IGNORE: When reading the binary log, mysqlbinlog and the replication code read REPLACE instead of IGNORE. This could make the slave's table become different from the master's table. (Bug#218)

  • Fixed a deadlock when relay_log_space_limit was set to a too small value. (Bug#79)

  • Fixed a bug in HAVING clause when an alias is used from the select list.

  • Fixed overflow bug in MyISAM when a row is inserted into a table with a large number of columns and at least one BLOB/TEXT column. Bug was caused by incorrect calculation of the needed buffer to pack data.

  • Fixed a bug when SELECT @nonexistent_variable caused the error in client - server protocol due to net_printf() being sent to the client twice.

  • Fixed a bug in setting SQL_BIG_SELECTS option.

  • Fixed a bug in SHOW PROCESSLIST which only displayed a localhost in the "Host" column. This was caused by a glitch that only used current thread information instead of information from the linked list of threads.

  • Removed unnecessary Mac OS X helper files from server RPM. (Bug#144)

  • Allow optimization of multiple-table update for InnoDB tables as well.

  • Fixed a bug in multiple-table updates that caused some rows to be updated several times.

  • Fixed a bug in mysqldump when it was called with --master-data: the CHANGE MASTER TO commands appended to the SQL dump had incorrect coordinates. (Bug#159)

  • Fixed a bug when an updating query using USER() was replicated on the slave; this caused segfault on the slave. (Bug#178). USER() is still badly replicated on the slave (it is replicated to "").

D.3.6. Alterações na distribuição 4.0.12 (15 Mar 2003: Production)

Functionality added or changed:

  • mysqld no longer reads options from world-writeable config files.

  • Integer values between 9223372036854775807 and 9999999999999999999 are now regarded as unsigned longlongs, not as floats. This makes these values work similar to values between 10000000000000000000 and 18446744073709551615.

  • SHOW PROCESSLIST will now include the client TCP port after the hostname to make it easier to know from which client the request originated.

Bugs fixed:

  • Fixed mysqld crash on extremely small values of sort_buffer variable.

  • INSERT INTO u SELECT ... FROM t was written too late to the binary log if t was very frequently updated during the execution of this query. This could cause a problem with mysqlbinlog or replication. The master must be upgraded, not the slave. (Bug#136)

  • Fixed checking of random part of WHERE clause. (Bug#142)

  • Fixed a bug with multiple-table updates with InnoDB tables. This bug occurred as, in many cases, InnoDB tables cannot be updated ``on the fly,'' but offsets to the records have to be stored in a temporary table.

  • Added missing file mysql_secure_installation to the server RPM subpackage. (Bug#141)

  • Fixed MySQL (and myisamchk) crash on artificially corrupted .MYI files.

  • Don't allow BACKUP TABLE to overwrite existing files.

  • Fixed a bug with multi-table UPDATE statements when user had all privileges on the database where tables are located and there were any entries in tables_priv table, that is, grant_option was true.

  • Fixed a bug that allowed a user with table or column grants on some table, TRUNCATE any table in the same database.

  • Fixed deadlock when doing LOCK TABLE followed by DROP TABLE in the same thread. In this case one could still kill the thread with KILL.

  • LOAD DATA LOCAL INFILE was not properly written to the binary log (hence not properly replicated). (Bug#82)

  • RAND() entries were not read correctly by mysqlbinlog from the binary log which caused problems when restoring a table that was inserted with RAND(). INSERT INTO t1 VALUES(RAND()). In replication this worked ok.

  • SET SQL_LOG_BIN=0 was ignored for INSERT DELAYED queries. (Bug#104)

  • SHOW SLAVE STATUS reported too old positions (columns Relay_Master_Log_File and Exec_Master_Log_Pos) for the last executed statement from the master, if this statement was the COMMIT of a transaction. The master must be upgraded for that, not the slave. (Bug#52)

  • LOAD DATA INFILE was not replicated by the slave if replicate_*_table was set on the slave. (Bug#86)

  • After RESET SLAVE, the coordinates displayed by SHOW SLAVE STATUS looked un-reset (though they were, but only internally). (Bug#70)

  • Fixed query cache invalidation on LOAD DATA.

  • Fixed memory leak on ANALYZE procedure with error.

  • Fixed a bug in handling CHAR(0) columns that could cause incorrect results from the query.

  • Fixed rare bug with incorrect initialisation of AUTO_INCREMENT column, as a secondary column in a multi-column key (see Seção 3.6.9, “Usando AUTO_INCREMENT), when data was inserted with INSERT ... SELECT or LOAD DATA into an empty table.

  • On Windows, STOP SLAVE didn't stop the slave until the slave got one new command from the master (this bug has been fixed for MySQL 4.0.11 by releasing updated 4.0.11a Windows packages, which include this individual fix on top of the 4.0.11 sources). (Bug#69)

  • Fixed a crash when no database was selected and LOAD DATA command was issued with full table name specified, including database prefix.

  • Fixed a crash when shutting down replication on some platforms (for example, Mac OS X).

  • Fixed a portability bug with pthread_attr_getstacksize on HP-UX 10.20 (Patch was also included in 4.0.11a sources).

  • Fixed the bigint test to not fail on some platforms (for example, HP-UX and Tru64) due to different return values of the atof() function.

  • Fixed the rpl_rotate_logs test to not fail on certain platforms (e.g. Mac OS X) due to a too long file name (changed slave-master-info.opt to .slave-mi).

D.3.7. Alterações na distribuição 4.0.11 (20 Feb 2003)

Functionality added or changed:

  • NULL is now sorted LAST if you use ORDER BY ... DESC (as it was before MySQL 4.0.2). This change was required to comply with the SQL-99 standard. (The original change was made because we thought that SQL-99 required NULL to be always sorted at the same position, but this was incorrect).

  • Added START TRANSACTION (SQL-99 syntax) as alias for BEGIN. This is recommended to use instead of BEGIN to start a transaction.

  • Added OLD_PASSWORD() as a synonym for PASSWORD().

  • Allow keyword ALL in group functions.

  • Added support for some new INNER JOIN and JOIN syntaxes. For example, SELECT * FROM t1 INNER JOIN t2 didn't work before.

  • Novell NetWare 6.0 porting effort completed, Novell patches merged into the main source tree.

Bugs fixed:

  • Fixed problem with multiple-table delete and InnoDB tables.

  • Fixed a problem with BLOB NOT NULL columns used with IS NULL.

  • Re-added missing pre- and post(un)install scripts to the Linux RPM packages (they were missing after the renaming of the server subpackage).

  • Fixed that table locks are not released with multi-table updates and deletes with InnoDB storage engine.

  • Fixed bug in updating BLOB columns with long strings.

  • Fixed integer-wraparound when giving big integer (>= 10 digits) to function that requires an unsigned argument, like CREATE TABLE (...) AUTO_INCREMENT=#.

  • MIN(key_column) could in some cases return NULL on a column with NULL and other values.

  • MIN(key_column) and MAX(key_column) could in some cases return incorrect values when used in OUTER JOIN.

  • MIN(key_column) and MAX(key_column) could return incorrect values if one of the tables was empty.

  • Fixed rare crash in compressed MyISAM tables with blobs.

  • Fixed bug in using aggregate functions as argument for INTERVAL, CASE, FIELD, CONCAT_WS, ELT and MAKE_SET functions.

  • When running with --lower-case-table-names (default on Windows) and you had tables or databases with mixed case on disk, then executing SHOW TABLE STATUS followed with DROP DATABASE or DROP TABLE could fail with Errcode 13.

D.3.8. Alterações na distribuição 4.0.10 (29 Jan 2003)

Functionality added or changed:

  • Added option --log-error[=file_name] to mysqld_safe and mysqld. This option will force all error messages to be put in a log file if the option --console is not given. On Windows --log-error is enabled as default, with a default name of host_name.err if the name is not specified.

  • Changed some things from Warning: to Note: in the log files.

  • The mysqld server should now compile on NetWare.

  • Added optimization that if one does GROUP BY ... ORDER BY NULL then result is not sorted.

  • New --ft-stopword-file command-line option for mysqld to replace/disable the built-in stopword list that is used in full-text searches. Veja mais informações sobre isto na Seção 4.6.8.4, “SHOW VARIABLES.

  • Changed default stack size from 64K to 192K; This fixes a core dump problem on Red Hat 8.0 and other systems with a glibc that requires a stack size larger than 128K for gethostbyaddr() to resolve a hostname. You can fix this for earlier MySQL versions by starting mysqld with --thread-stack=192K.

  • Added mysql_waitpid to the binary distribution and the MySQL-client RPM subpackage (required for mysql-test-run).

  • Renamed the main MySQL RPM package to MySQL-server. When updating from an older version, MySQL-server.rpm will simply replace MySQL.rpm.

  • If a slave is configured with replicate_wild_do_table=db.% or replicate_wild_ignore_table=db.%, these rules will be applied to CREATE/DROP DATABASE too.

  • Added timeout value for MASTER_POS_WAIT().

Bugs fixed:

  • Fixed initialisation of the random seed for newly created threads to give a better rand() distribution from the first call.

  • Fixed a bug that caused mysqld to hang when a table was opened with the HANDLER command and then dropped without being closed.

  • Fixed bug in logging to binary log (which affects replication) a query that inserts a NULL in an AUTO_INCREMENT column and also uses LAST_INSERT_ID().

  • Fixed an unlikely bug that could cause a memory overrun when using ORDER BY constant_expression.

  • Fixed a table corruption in myisamchk's parallel repair mode.

  • Fixed bug in query cache invalidation on simple table renaming.

  • Fixed bug in mysqladmin --relative.

  • On some 64 bit systems, show status reported a strange number for Open_files and Open_streams.

  • Fixed incorrect number of columns in EXPLAIN on empty table.

  • Fixed bug in LEFT JOIN that caused zero rows to be returned in the case the WHERE condition was evaluated as FALSE after reading const tables. (Unlikely condition).

  • FLUSH PRIVILEGES didn't correctly flush table/column privileges when mysql.tables_priv is empty.

  • Fixed bug in replication when using LOAD DATA INFILE one a file that updated an AUTO_INCREMENT column with NULL or 0. This bug only affected MySQL 4.0 masters (not slaves or MySQL 3.23 masters). Note: If you have a slave that has replicated a file with generated AUTO_INCREMENT columns then the slave data is corrupted and you should reinitialise the affected tables from the master.

  • Fixed possible memory overrun when sending a BLOB value larger than 16M to the client.

  • Fixed incorrect error message when setting a NOT NULL column to an expression that returned NULL.

  • Fixed core dump bug in str LIKE "%other_str%" where str or other_str contained characters >= 128.

  • Fixed bug: When executing on master LOAD DATA and InnoDB failed with table full error the binary log was corrupted.

D.3.9. Alterações na distribuição 4.0.9 (09 Jan 2003)

Functionality added or changed:

  • OPTIMIZE TABLE will for MyISAM tables treat all NULL values as different when calculating cardinality. This helps in optimising joins between tables where one of the tables has a lot of NULL values in a indexed column:

    SELECT * from t1,t2 where t1.a=t2.key_with_a_lot_of_null;
    

  • Added join operator FORCE INDEX (key_list). This acts likes USE INDEX (key_list) but with the addition that a table scan is assumed to be VERY expensive. One bad thing with this is that it makes FORCE a reserved word.

  • Reset internal row buffer in MyISAM after each query. This will reduce memory in the case you have a lot of big blobs in a table.

Bugs fixed:

  • A security patch in 4.0.8 causes the mysqld server to die if the remote hostname can't be resolved. This is now fixed.

  • Fixed crash when replication big LOAD DATA INFILE statement that caused log rotation.

D.3.10. Alterações na distribuição 4.0.8 (07 Jan 2003)

Functionality added or changed:

  • Default max_packet_length for libmysqld.c is now 1024*1024*1024.

  • One can now specify max_allowed_packet in a file ready by mysql_options(MYSQL_READ_DEFAULT_FILE). for clients.

  • When sending a too big packet to the server with the not compressed protocol, the client now gets an error message instead of a lost connection.

  • We now send big queries/result rows in bigger hunks, which should give a small speed improvement.

  • Fixed some bugs with the compressed protocol for rows > 16M.

  • InnoDB tables now also support ON UPDATE CASCADE in FOREIGN KEY constraints. See the InnoDB section in the manual for the InnoDB changelog.

Bugs fixed:

  • Fixed bug in ALTER TABLE with BDB tables.

  • Fixed core dump bug in QUOTE() function.

  • Fixed a bug in handling communication packets bigger than 16M. Unfortunately this required a protocol change; If you upgrade the server to 4.0.8 and above and have clients that uses packets >= 255*255*255 bytes (=16581375) you must also upgrade your clients to at least 4.0.8. If you don't upgrade, the clients will hang when sending a big packet.

  • Fixed bug when sending blobs longer than 16M to client.

  • Fixed bug in GROUP BY when used on BLOB column with NULL values.

  • Fixed a bug in handling NULL values in CASE ... WHEN ...

D.3.11. Alterações na distribuição 4.0.7 (20 Dec 2002)

Functionality added or changed:

  • mysqlbug now also reports the compiler version used for building the binaries (if the compiler supports the option --version).

Bugs fixed:

  • Fixed compilation problems on OpenUnix and HPUX 10.20.

  • Fixed some optimization problems when compiling MySQL with -DBIG_TABLES on a 32 bit system.

  • mysql_drop_db() didn't check permissions properly so anyone could drop another users database. DROP DATABASE is checked properly.

D.3.12. Alterações na distribuição 4.0.6 (14 Dec 2002: Gamma)

Functionality added or changed:

  • Added syntax support for CHARACTER SET xxx and CHARSET=xxx table options (to be able to read table dumps from 4.1).

  • Fixed replication bug that caused the slave to loose its position in some cases when the replication log was rotated.

  • Fixed that a slave will restart from the start of a transaction if it's killed in the middle of one.

  • Moved the manual pages from man to man/man1 in the binary distributions.

  • The default type returned by IFNULL(A,B) is now set to be the more 'general' of the types of A and B. (The order is STRING, REAL or INTEGER).

  • Moved the mysql.server startup script in the RPM packages from /etc/rc.d/init.d/mysql to /etc/init.d/mysql (which almost all current Linux distributions support for LSB compliance).

  • Added Qcache_lowmem_prunes status variable (number of queries that were deleted from cache because of low memory).

  • Fixed mysqlcheck so it can deal with table names containing dashes.

  • Bulk insert optimization (see Seção 4.6.8.4, “SHOW VARIABLES) is no longer used when inserting small (less than 100) number of rows.

  • Optimization added for queries like SELECT ... FROM merge_table WHERE indexed_column=constant_expr.

  • Added functions LOCALTIME and LOCALTIMESTAMP as synonyms for NOW().

  • CEIL is now an alias for CEILING.

  • The CURRENT_USER() function can be used to get a user@host value as it was matched in the GRANT system. See Seção 6.3.6.2, “Funções Diversas”.

  • Fixed CHECK constraints to be compatible with SQL-99. This made CHECK a reserved word. (Checking of CHECK constraints is still not implemented).

  • Added CAST(... as CHAR).

  • Added PostgreSQL compatible LIMIT syntax: SELECT ... LIMIT row_count OFFSET offset

  • mysql_change_user() will now reset the connection to the state of a fresh connect (Ie, ROLLBACK any active transaction, close all temporary tables, reset all user variables etc..)

  • CHANGE MASTER and RESET SLAVE now require that slave threads be both already stopped; these commands will return an error if at least one of these two threads is running.

Bugs fixed:

  • Fixed number of found rows returned in multi table updates

  • Make --lower-case-table-names default on Mac OS X as the default file system (HFS+) is case insensitive. Veja mais informações sobre isto na Seção 6.1.3, “Caso Sensitivo nos Nomes”.

  • Transactions in AUTOCOMMIT=0 mode didn't rotate binary log.

  • A fix for the bug in a SELECT with joined tables with ORDER BY and LIMIT clause when filesort had to be used. In that case LIMIT was applied to filesort of one of the tables, although it could not be. This fix also solved problems with LEFT JOIN.

  • mysql_server_init() now makes a copy of all arguments. This fixes a problem when using the embedded server in C# program.

  • Fixed buffer overrun in libmysqlclient library that allowed a malicious MySQL server to crash the client application.

  • Fixed security-related bug in mysql_change_user() handling. All users are strongly recommended to upgrade to version 4.0.6.

  • Fixed bug that prevented --chroot command-line option of mysqld from working.

  • Fixed bug in phrase operator "..." in boolean full-text search.

  • Fixed bug that caused OPTIMIZE TABLE to corrupt the table under some rare circumstances.

  • Part rewrite of multi-table-update to optimise it, make it safer and more bug free.

  • LOCK TABLES now works together with multi-table-update and multi-table-delete.

  • --replicate-do=xxx didn't work for UPDATE commands. (Bug introduced in 4.0.0)

  • Fixed shutdown problem on Mac OS X.

  • Major InnoDB bugs in REPLACE, AUTO_INCREMENT, INSERT INTO ... SELECT ... were fixed. See the InnoDB changelog in the InnoDB section of the manual.

  • RESET SLAVE caused a crash if the slave threads were running.

D.3.13. Alterações na distribuição 4.0.5 (13 Nov 2002)

Functionality added or changed:

  • Port number was added to host name (if it is known) in SHOW PROCESSLIST command

  • Changed handling of last argument in WEEK() so that one can get week number according to the ISO 8601 specification. (Old code should still work).

  • Fixed that INSERT DELAYED threads doesn't hang on Waiting for INSERT when one sends a SIGHUP to mysqld.

  • Change that AND works according to SQL-99 when it comes to NULL handling. In practice, this only affects queries where you do something like WHERE ... NOT (NULL AND 0).

  • mysqld will now resolve basedir to its full path (with realpath()). This enables one to use relative symlinks to the MySQL installation directory. This will however cause show variables to report different directories on systems where there is a symbolic link in the path.

  • Fixed that MySQL will not use index scan on index disabled with IGNORE INDEX or USE INDEX. to be ignored.

  • Added --use-frm option to mysqlcheck. When used with REPAIR, it gets the table structure from the .frm file, so the table can be repaired even if the .MYI header is corrupted.

  • Fixed bug in MAX() optimization when used with JOIN and ON expressions.

  • Added support for reading of MySQL 4.1 table definition files.

  • BETWEEN behaviour changed (see Seção 6.3.1.2, “Operadores de Comparação”). Now datetime_col BETWEEN timestamp AND timestamp should work as expected.

  • One can create TEMPORARY MERGE tables now.

  • DELETE FROM myisam_table now shrinks not only the .MYD file but also the .MYI file.

  • When one uses the --open-files-limit=# option to mysqld_safe it's now passed on to mysqld.

  • Changed output from EXPLAIN from 'where used' to 'Using where' to make it more in line with other output.

  • Removed variable safe_show_database as it was no longer used.

  • Updated source tree to be built using automake 1.5 and libtool 1.4.

  • Fixed an inadvertently changed option (--ignore-space) back to the original --ignore-spaces in mysqlclient. (Both syntaxes will work).

  • Don't require UPDATE privilege when using REPLACE.

  • Added support for DROP TEMPORARY TABLE ..., to be used to make replication safer.

  • When transactions are enabled, all commands that update temporary tables inside a BEGIN/COMMIT are now stored in the binary log on COMMIT and not stored if one does ROLLBACK. This fixes some problems with non-transactional temporary tables used inside transactions.

  • Allow braces in joins in all positions. Formerly, things like SELECT * FROM (t2 LEFT JOIN t3 USING (a)), t1 worked, but not SELECT * FROM t1, (t2 LEFT JOIN t3 USING (a)). Note that braces are simply removed, they do not change the way the join is executed.

  • InnoDB now supports also isolation levels READ UNCOMMITTED and READ COMMITTED. For a detailed InnoDB changelog, see Seção 7.5.16, “Histórico de Alterações do InnoDB” in this manual.

Bugs fixed:

  • Fixed bug in MAX() optimization when used with JOIN and ON expressions.

  • Fixed that INSERT DELAY threads don't hang on Waiting for INSERT when one sends a SIGHUP to mysqld.

  • Fixed that MySQL will not use an index scan on an index that has been disabled with IGNORE INDEX or USE INDEX.

  • Corrected test for root user in mysqld_safe.

  • Fixed error message issued when storage engine cannot do CHECK or REPAIR.

  • Fixed rare core dump problem in complicated GROUP BY queries that didn't return any result.

  • Fixed mysqlshow to work properly with wildcarded database names and with database names that contain underscores.

  • Portability fixes to get MySQL to compile cleanly with Sun Forte 5.0.

  • Fixed MyISAM crash when using dynamic-row tables with huge numbers of packed fields.

  • Fixed query cache behaviour with BDB transactions.

  • Fixed possible floating point exception in MATCH relevance calculations.

  • Fixed bug in full-text search IN BOOLEAN MODE that made MATCH to return incorrect relevance value in some complex joins.

  • Fixed a bug that limited MyISAM key length to a value slightly less that 500. It is exactly 500 now.

  • Fixed that GROUP BY on columns that may have a NULL value doesn't always use disk based temporary tables.

  • The filename argument for the --des-key-file argument to mysqld is interpreted relative to the data directory if given as a relative pathname.

  • Removed a condition that temp table with index on column that can be NULL has to be MyISAM. This was okay for 3.23, but not needed in 4.*. This resulted in slowdown in many queries since 4.0.2.

  • Small code improvement in multi-table updates.

  • Fixed a newly introduced bug that caused ORDER BY ... LIMIT row_count to not return all rows.

  • Fixed a bug in multi-table deletes when outer join is used on an empty table, which gets first to be deleted.

  • Fixed a bug in multi-table updates when a single table is updated.

  • Fixed bug that caused REPAIR TABLE and myisamchk to corrupt FULLTEXT indexes.

  • Fixed bug with caching the mysql grant table database. Now queries in this database are not cached in the query cache.

  • Small fix in mysqld_safe for some shells.

  • Give error if a MyISAM MERGE table has more than 2 ^ 32 rows and MySQL was not compiled with -DBIG_TABLES.

  • Fixed some ORDER BY ... DESC problems with InnoDB tables.

D.3.14. Alterações na distribuição 4.0.4 (29 Sep 2002)

  • Fixed bug where GRANT/REVOKE failed if hostname was given in non-matching case.

  • Don't give warning in LOAD DATA INFILE when setting a timestamp to a string value of '0'.

  • Fixed bug in myisamchk -R mode.

  • Fixed bug that caused mysqld to crash on REVOKE.

  • Fixed bug in ORDER BY when there is a constant in the SELECT statement.

  • One didn't get an error message if mysqld couldn't open the privilege tables.

  • SET PASSWORD FOR ... closed the connection in case of errors (bug from 4.0.3).

  • Increased max possible max_allowed_packet in mysqld to 1 GB.

  • Fixed bug when doing a multi-line INSERT on a table with an AUTO_INCREMENT key which was not in the first part of the key.

  • Changed LOAD DATA INFILE to not recreate index if the table had rows from before.

  • Fixed overrun bug when calling AES_DECRYPT() with incorrect arguments.

  • --skip-ssl can now be used to disable SSL in the MySQL clients, even if one is using other SSL options in an option file or previously on the command line.

  • Fixed bug in MATCH ... AGAINST( ... IN BOOLEAN MODE) used with ORDER BY.

  • Added LOCK TABLES and CREATE TEMPORARY TABLES privilege on the database level. One must run the mysql_fix_privilege_tables script on old installations to activate these.

  • In SHOW TABLE ... STATUS, compressed tables sometimes showed up as dynamic.

  • SELECT @@[global|session].var_name didn't report global | session in the result column name.

  • Fixed problem in replication that FLUSH LOGS in a circular replication setup created an infinite number of binary log files. Now a rotate-binary-log command in the binary log will not cause slaves to rotate logs.

  • Removed STOP EVENT from binary log when doing FLUSH LOGS.

  • Disable the use of SHOW NEW MASTER FOR SLAVE as this needs to be completely reworked in a future release.

  • Fixed a bug with constant expression (for example, field of a one-row table, or field from a table, referenced by a UNIQUE key) appeared in ORDER BY part of SELECT DISTINCT.

  • --log-binary=a.b.c now properly strips off .b.c.

  • FLUSH LOGS removed numerical extension for all future update logs.

  • GRANT ... REQUIRE didn't store the SSL information in the mysql.user table if SSL was not enabled in the server.

  • GRANT ... REQUIRE NONE can now be used to remove SSL information.

  • AND is now optional between REQUIRE options.

  • REQUIRE option was not properly saved, which could cause strange output in SHOW GRANTS.

  • Fixed that mysqld --help reports correct values for --datadir and --bind-address.

  • Fixed that one can drop UDFs that didn't exist when mysqld was started.

  • Fixed core dump problem with SHOW VARIABLES on some 64 bit systems (like Solaris sparc).

  • Fixed a bug in my_getopt(); --set-variable syntax didn't work for those options that didn't have a valid variable in the my_option struct. This affected at least the default-table-type option.

  • Fixed a bug from 4.0.2 that caused REPAIR TABLE and myisamchk --recover to fail on tables with duplicates in a unique key.

  • Fixed a bug from 4.0.3 in calculating the default datatype for some functions. This affected queries of type CREATE TABLE table_name SELECT expression(),...

  • Fixed bug in queries of type SELECT * FROM table-list GROUP BY ... and SELECT DISTINCT * FROM ....

  • Fixed bug with the --slow-log when logging an administrator command (like FLUSH TABLES).

  • Fixed a bug that OPTIMIZE of locked and modified table, reported table corruption.

  • Fixed a bug in my_getopt() in handling of special prefixes (--skip-, --enable-). --skip-external-locking didn't work and the bug may have affected other similar options.

  • Fixed bug in checking for output file name of the tee option.

  • Added some more optimization to use index for SELECT ... FROM many_tables .. ORDER BY key limit #

  • Fixed problem in SHOW OPEN TABLES when a user didn't have access permissions to one of the opened tables.

D.3.15. Alterações na distribuição 4.0.3 (26 Aug 2002: Beta)

  • Fixed problem with types of user variables. (Bug#551)

  • Fixed problem with configure ... --localstatedir=....

  • Cleaned up mysql.server script.

  • Fixed a bug in mysqladmin shutdown when pid file was modified while mysqladmin was still waiting for the previous one to disappear. This could happen during a very quick restart and caused mysqladmin to hang until shutdown_timeout seconds had passed.

  • Don't increment warnings when setting AUTO_INCREMENT columns to NULL in LOAD DATA INFILE.

  • Fixed all boolean type variables/options to work with the old syntax, for example, all of these work: --lower-case-table-names, --lower-case-table-names=1, -O lower-case-table-names=1, --set-variable=lower-case-table-names=1

  • Fixed shutdown problem (SIGTERM signal handling) on Solaris. (Bug from 4.0.2).

  • SHOW MASTER STATUS now returns an empty set if binary log is not enabled.

  • SHOW SLAVE STATUS now returns an empty set if slave is not initialised.

  • Don't update MyISAM index file on update if not strictly necessary.

  • Fixed bug in SELECT DISTINCT ... FROM many_tables ORDER BY not-used-column.

  • Fixed a bug with BIGINT values and quoted strings.

  • Added QUOTE() function that performs SQL quoting to produce values that can be used as data values in queries.

  • Changed variable DELAY_KEY_WRITE to an enum to allow one set DELAY_KEY_WRITE for all tables without taking down the server.

  • Changed behaviour of IF(condition,column,NULL) so that it returns the value of the column type.

  • Made safe_mysqld a symlink to mysqld_safe in binary distribution.

  • Fixed security bug when having an empty database name in the user.db table.

  • Fixed some problems with CREATE TABLE ... SELECT function().

  • mysqld now has the option --temp-pool enabled by default as this gives better performance with some operating systems.

  • Fixed problem with too many allocated alarms on slave when connecting to master many times (normally not a very critical error).

  • Fixed hang in CHANGE MASTER TO if the slave thread died very quickly.

  • Big cleanup in replication code (less logging, better error messages, etc..)

  • If the --code-file option is specified, the server calls setrlimit() to set the maximum allowed core file size to unlimited, so core files can be generated.

  • Fixed bug in query cache after temporary table creation.

  • Added --count=N (-c) option to mysqladmin, to make the program do only N iterations. To be used with --sleep (-i). Useful in scripts.

  • Fixed bug in multi-table UPDATE: when updating a table, do_select() became confused about reading records from a cache.

  • Fixed bug in multi-table UPDATE when several fields were referenced from a single table

  • Fixed bug in truncating nonexisting table.

  • Fixed bug in REVOKE that caused user resources to be randomly set.

  • Fixed bug in GRANT for the new CREATE TEMPORARY TABLE privilege.

  • Fixed bug in multi-table DELETE when tables are re-ordered in the table initialisation method and ref_lengths are of different sizes.

  • Fixed two bugs in SELECT DISTINCT with large tables.

  • Fixed bug in query cache initialisation with very small query cache size.

  • Allow DEFAULT with INSERT statement.

  • The startup parameters myisam_max_sort_file_size and myisam_max_extra_sort_file_size are now given in bytes, not megabytes.

  • External system locking of MyISAM/ISAM files is now turned off by default. One can turn this on with --external-locking. (For most users this is never needed).

  • Fixed core dump bug with INSERT ... SET db_name.table_name.colname=''.

  • Fixed client hangup bug when using some SQL commands with incorrect syntax.

  • Fixed a timing bug in DROP DATABASE

  • New SET [GLOBAL | SESSION] syntax to change thread-specific and global server variables at runtime.

  • Added variable slave_compressed_protocol.

  • Renamed variable query_cache_startup_type to query_cache_type, myisam_bulk_insert_tree_size to bulk_insert_buffer_size, record_buffer to read_buffer_size and record_rnd_buffer to read_rnd_buffer_size.

  • Renamed some SQL variables, but old names will still work until 5.0. Veja mais informações sobre isto na Seção 2.5.2, “Atualizando da Versão 3.23 para 4.0”.

  • Renamed --skip-locking to --skip-external-locking.

  • Removed unused variable query_buffer_size.

  • Fixed a bug that made the pager option in the mysql client non-functional.

  • Added full AUTO_INCREMENT support to MERGE tables.

  • Extended LOG() function to accept an optional arbitrary base parameter. See Seção 6.3.3.2, “Funções Matematicas”.

  • Added LOG2() function (useful for finding out how many bits a number would require for storage).

  • Added LN() natural logarithm function for compatibility with other databases. It is synonymous with LOG(X).

D.3.16. Alterações na distribuição 4.0.2 (01 Jul 2002)

  • Cleaned up NULL handling for default values in DESCRIBE table_name.

  • Fixed truncate() to round up negative values to the nearest integer.

  • Changed --chroot=path option to execute chroot() immediately after all options have been parsed.

  • Don't allow database names that contain ‘\’.

  • lower_case_table_names now also affects database names.

  • Added XOR operator (logical and bitwise XOR) with ^ as a synonym for bitwise XOR.

  • Added function IS_FREE_LOCK("lock_name"). Based on code contributed by Hartmut Holzgraefe .

  • Removed mysql_ssl_clear() from C API, as it was not needed.

  • DECIMAL and NUMERIC types can now read exponential numbers.

  • Added SHA1() function to calculate 160 bit hash value as described in RFC 3174 (Secure Hash Algorithm). This function can be considered a cryptographically more secure equivalent of MD5(). See Seção 6.3.6.2, “Funções Diversas”.

  • Added AES_ENCRYPT() and AES_DECRYPT() functions to perform encryption according to AES standard (Rijndael). See Seção 6.3.6.2, “Funções Diversas”.

  • Added --single-transaction option to mysqldump, allowing a consistent dump of InnoDB tables. See Seção 4.9.7, “mysqldump, Descarregando a Estrutura de Tabelas e Dados”.

  • Fixed bug in innodb_log_group_home_dir in SHOW VARIABLES.

  • Fixed a bug in optimiser with merge tables when non-unique values are used in summing up (causing crashes).

  • Fixed a bug in optimiser when a range specified makes index grouping impossible (causing crashes).

  • Fixed a rare bug when FULLTEXT index is present and no tables are used.

  • Added privileges CREATE TEMPORARY TABLES, EXECUTE, LOCK TABLES, REPLICATION CLIENT, REPLICATION SLAVE, SHOW DATABASES and SUPER. To use these, you must have run the mysql_fix_privilege_tables script after upgrading.

  • Fixed query cache align data bug.

  • Fixed mutex bug in replication when reading from master fails.

  • Added missing mutex in TRUNCATE TABLE; This fixes some core dump/hangup problems when using TRUNCATE TABLE.

  • Fixed bug in multiple-table DELETE when optimiser uses only indexes.

  • Fixed that ALTER TABLE table_name RENAME new_table_name is as fast as RENAME TABLE.

  • Fixed bug in GROUP BY with two or more fields, where at least one field can contain NULL values.

  • Use Turbo Boyer-Moore algorithm to speed up LIKE "%keyword%" searches.

  • Fixed bug in DROP DATABASE with symlink.

  • Fixed crash in REPAIR ... USE_FRM.

  • Fixed bug in EXPLAIN with LIMIT offset != 0.

  • Fixed bug in phrase operator "..." in boolean full-text search.

  • Fixed bug that caused duplicated rows when using truncation operator * in boolean full-text search.

  • Fixed bug in truncation operator of boolean full-text search (incorrect results when there are only +word*s in the query).

  • Fixed bug in boolean full-text search that caused a crash when an identical MATCH expression that did not use an index appeared twice.

  • Query cache is now automatically disabled in mysqldump.

  • Fixed problem on Windows 98 that made sending of results very slow.

  • Boolean full-text search weighting scheme changed to something more reasonable.

  • Fixed bug in boolean full-text search that caused MySQL to ignore queries of ft_min_word_len characters.

  • Boolean full-text search now supports ``phrase searches''.

  • New configure option --without-query-cache.

  • Memory allocation strategy for ``root memory'' changed. Block size now grows with number of allocated blocks.

  • INET_NTOA() now returns NULL if you give it an argument that is too large (greater than the value corresponding to 255.255.255.255).

  • Fix SQL_CALC_FOUND_ROWS to work with UNIONs. It will work only if the first SELECT has this option and if there is global LIMIT for the entire statement. For the moment, this requires using parentheses for individual SELECT queries within the statement.

  • Fixed bug in SQL_CALC_FOUND_ROWS and LIMIT.

  • Don't give an error for CREATE TABLE ...(... VARCHAR(0)).

  • Fixed SIGINT and SIGQUIT problems in mysql.cc on Linux with some glibc versions.

  • Fixed bug in convert.cc, which is caused by having an incorrect net_store_length() linked in the CONVERT::store() method.

  • DOUBLE and FLOAT columns now honor the UNSIGNED flag on storage.

  • InnoDB now retains foreign key constraints through ALTER TABLE and CREATE/DROP INDEX.

  • InnoDB now allows foreign key constraints to be added through the ALTER TABLE syntax.

  • InnoDB tables can now be set to automatically grow in size (autoextend).

  • Added --ignore-lines=n option to mysqlimport. This has the same effect as the IGNORE n LINES clause for LOAD DATA.

  • Fixed bug in UNION with last offset being transposed to total result set.

  • REPAIR ... USE_FRM added.

  • Fixed that DEFAULT_SELECT_LIMIT is always imposed on UNION result set.

  • Fixed that some SELECT options can appear only in the first SELECT.

  • Fixed bug with LIMIT with UNION, where last select is in the braces.

  • Fixed that full-text works fine with UNION operations.

  • Fixed bug with indexless boolean full-text search.

  • Fixed bug that sometimes appeared when full-text search was used with const tables.

  • Fixed incorrect error value when doing a SELECT with an empty HEAP table.

  • Use ORDER BY column DESC now sorts NULL values first. (In other words, NULL values sort first in all cases, whether or not DESC is specified.) This is changed back in 4.0.10.

  • Fixed bug in WHERE key_name='constant' ORDER BY key_name DESC.

  • Fixed bug in SELECT DISTINCT ... ORDER BY DESC optimization.

  • Fixed bug in ... HAVING 'GROUP_FUNCTION'(xxx) IS [NOT] NULL.

  • Fixed bug in truncation operator for boolean full-text search.

  • Allow value of --user=# option for mysqld to be specified as a numeric user ID.

  • Fixed a bug where SQL_CALC_ROWS returned an incorrect value when used with one table and ORDER BY and with InnoDB tables.

  • Fixed that SELECT 0 LIMIT 0 doesn't hang thread.

  • Fixed some problems with USE/IGNORE INDEX when using many keys with the same start column.

  • Don't use table scan with BerkeleyDB and InnoDB tables when we can use an index that covers the whole row.

  • Optimized InnoDB sort-buffer handling to take less memory.

  • Fixed bug in multi-table DELETE and InnoDB tables.

  • Fixed problem with TRUNCATE and InnoDB tables that produced the error Can't execute the given command because you have active locked tables or an active transaction.

  • Added NO_UNSIGNED_SUBTRACTION to the set of flags that may be specified with the --sql-mode option for mysqld. It disables unsigned arithmetic rules when it comes to subtraction. (This will make MySQL 4.0 behave more like 3.23 with UNSIGNED columns).

  • The result returned for all bit functions (|, <<, ...) is now of type unsigned integer.

  • Added detection of nan values in MyISAM to make it possible to repair tables with nan in float or double columns.

  • Fixed new bug in myisamchk where it didn't correctly update number of ``parts'' in the MyISAM index file.

  • Changed to use autoconf 2.52 (from autoconf 2.13).

  • Fixed optimization problem where the MySQL Server was in ``preparing'' state for a long time when selecting from an empty table which had contained a lot of rows.

  • Fixed bug in complicated join with const tables. This fix also improves performance a bit when referring to another table from a const table.

  • First pre-version of multi-table UPDATE statement.

  • Fixed bug in multi-table DELETE.

  • Fixed bug in SELECT CONCAT(argument_list) ... GROUP BY 1.

  • INSERT ... SELECT did a full rollback in case of an error. Fixed so that we only roll back the last statement in the current transaction.

  • Fixed bug with empty expression for boolean full-text search.

  • Fixed core dump bug in updating full-text key from/to NULL.

  • ODBC compatibility: Added BIT_LENGTH() function.

  • Fixed core dump bug in GROUP BY BINARY column.

  • Added support for NULL keys in HEAP tables.

  • Use index for ORDER BY in queries of type: SELECT * FROM t WHERE key_part1=1 ORDER BY key_part1 DESC,key_part2 DESC

  • Fixed bug in FLUSH QUERY CACHE.

  • Added CAST() and CONVERT() functions. The CAST and CONVERT functions are nearly identical and mainly useful when you want to create a column with a specific type in a CREATE ... SELECT statement. For more information, read Seção 6.3.5, “Funções de Conversão”.

  • CREATE ... SELECT on DATE and TIME functions now create columns of the expected type.

  • Changed order in which keys are created in tables.

  • Added new columns Null and Index_type to SHOW INDEX output.

  • Added --no-beep and --prompt options to mysql command-line client.

  • New feature: management of user resources.

    GRANT ... WITH MAX_QUERIES_PER_HOUR N1
                   MAX_UPDATES_PER_HOUR N2
                   MAX_CONNECTIONS_PER_HOUR N3;
    

    Veja mais informações sobre isto na Seção 4.4.7, “Limitando os Recursos dos Usuários”.

  • Added mysql_secure_installation to the scripts/ directory.

D.3.17. Alterações na distribuição 4.0.1 (23 Dec 2001)

  • Added system command to mysql.

  • Fixed bug when HANDLER was used with some unsupported table type.

  • mysqldump now puts ALTER TABLE tbl_name DISABLE KEYS and ALTER TABLE tbl_name ENABLE KEYS in the sql dump.

  • Added mysql_fix_extensions script.

  • Fixed stack overrun problem with LOAD DATA FROM MASTER on OSF/1.

  • Fixed shutdown problem on HP-UX.

  • Added DES_ENCRYPT() and DES_DECRYPT() functions.

  • Added FLUSH DES_KEY_FILE statement.

  • Added --des-key-file option to mysqld.

  • HEX(string) now returns the characters in string converted to hexadecimal.

  • Fixed problem with GRANT when using lower_case_table_names=1.

  • Changed SELECT ... IN SHARE MODE to SELECT ... LOCK IN SHARE MODE (as in MySQL 3.23).

  • A new query cache to cache results from identical SELECT queries.

  • Fixed core dump bug on 64-bit machines when it got an incorrect communication packet.

  • MATCH ... AGAINST(... IN BOOLEAN MODE) can now work without FULLTEXT index.

  • Fixed slave to replicate from 3.23 master.

  • Miscellaneous replication fixes/cleanup.

  • Got shutdown to work on Mac OS X.

  • Added myisam/ft_dump utility for low-level inspection of FULLTEXT indexes.

  • Fixed bug in DELETE ... WHERE ... MATCH ....

  • Added support for MATCH ... AGAINST(... IN BOOLEAN MODE). Note: you must rebuild your tables with ALTER TABLE tablename TYPE=MyISAM to be able to use boolean full-text search.

  • LOCATE() and INSTR() are now case-sensitive if either argument is a binary string.

  • Changed RAND() initialisation so that RAND(N) and RAND(N+1) are more distinct.

  • Fixed core dump bug in UPDATE ... ORDER BY.

  • In 3.23, INSERT INTO ... SELECT always had IGNORE enabled. Now MySQL will stop (and possibly roll back) by default in case of an error unless you specify IGNORE.

  • Ignore DATA DIRECTORY and INDEX DIRECTORY directives on Windows.

  • Added boolean full-text search code. It should be considered early alpha.

  • Extended MODIFY and CHANGE in ALTER TABLE to accept the FIRST and AFTER keywords.

  • Indexes are now used with ORDER BY on a whole InnoDB table.

D.3.18. Alterações na distribuição 4.0.0 (Oct 2001: Alpha)

  • Added --xml option to mysql for producing XML output.

  • Added full-text variables ft_min_word_len, ft_max_word_len, and ft_max_word_len_for_sort.

  • Added documentation for libmysqld, the embedded MySQL server library. Also added example programs (a mysql client and mysqltest test program) which use libmysqld.

  • Removed all Gemini hooks from MySQL server.

  • Removed my_thread_init() and my_thread_end() from mysql_com.h, and added mysql_thread_init() and mysql_thread_end() to mysql.h.

  • Support for communication packets > 16M. In 4.0.1 we will extend MyISAM to be able to handle these.

  • Secure connections (with SSL).

  • Unsigned BIGINT constants now work. MIN() and MAX() now handle signed and unsigned BIGINT numbers correctly.

  • New character set latin1_de which provides correct German sorting.

  • STRCMP() now uses the current character set when doing comparisons, which means that the default comparison behaviour now is case-insensitive.

  • TRUNCATE TABLE and DELETE FROM tbl_name are now separate functions. One bonus is that DELETE FROM tbl_name now returns the number of deleted rows, rather than zero.

  • DROP DATABASE now executes a DROP TABLE on all tables in the database, which fixes a problem with InnoDB tables.

  • Added support for UNION.

  • Added support for multi-table DELETE operations.

  • A new HANDLER interface to MyISAM tables.

  • Added support for INSERT on MERGE tables. Patch from Benjamin Pflugmann.

  • Changed WEEK(date,0) to match the calendar in the USA.

  • COUNT(DISTINCT) is about 30% faster.

  • Speed up all internal list handling.

  • Speed up IS NULL, ISNULL() and some other internal primitives.

  • Full-text index creation now is much faster.

  • Tree-like cache to speed up bulk inserts and myisam_bulk_insert_tree_size variable.

  • Searching on packed (CHAR/VARCHAR) keys is now much faster.

  • Optimized queries of type: SELECT DISTINCT * from tbl_name ORDER by key_part1 LIMIT row_count.

  • SHOW CREATE TABLE now shows all table attributes.

  • ORDER BY ... DESC can now use keys.

  • LOAD DATA FROM MASTER ``automatically'' sets up a slave.

  • Renamed safe_mysqld to mysqld_safe to make this name more in line with other MySQL scripts/commands.

  • Added support for symbolic links to MyISAM tables. Symlink handling is now enabled by default for Windows.

  • Added SQL_CALC_FOUND_ROWS and FOUND_ROWS(). This makes it possible to know how many rows a query would have returned without a LIMIT clause.

  • Changed output format of SHOW OPEN TABLES.

  • Allow SELECT expression LIMIT ....

  • Added ORDER BY syntax to UPDATE and DELETE.

  • SHOW INDEXES is now a synonym for SHOW INDEX.

  • Added ALTER TABLE tbl_name DISABLE KEYS and ALTER TABLE tbl_name ENABLE KEYS commands.

  • Allow use of IN as a synonym for FROM in SHOW commands.

  • Implemented ``repair by sort'' for FULLTEXT indexes. REPAIR TABLE, ALTER TABLE, and OPTIMIZE TABLE for tables with FULLTEXT indexes are now up to 100 times faster.

  • Allow SQL-99 syntax X'hexadecimal-number'.

  • Cleaned up global lock handling for FLUSH TABLES WITH READ LOCK.

  • Fixed problem with DATETIME = constant in WHERE optimization.

  • Added --master-data and --no-autocommit options to mysqldump. (Thanks to Brian Aker for this.)

  • Added script mysql_explain_log.sh to distribution. (Thanks to mobile.de).

D.4. Alterações na distribuição 3.23.x (Recent; still supported)

D.4.1. Alterações na distribuição 3.23.59 (not released yet)
D.4.2. Alterações na distribuição 3.23.58 (11 Sep 2003)
D.4.3. Alterações na distribuição 3.23.57 (06 Jun 2003)
D.4.4. Alterações na distribuição 3.23.56 (13 Mar 2003)
D.4.5. Alterações na distribuição 3.23.55 (23 Jan 2003)
D.4.6. Alterações na distribuição 3.23.54 (05 Dec 2002)
D.4.7. Alterações na distribuição 3.23.53 (09 Oct 2002)
D.4.8. Alterações na distribuição 3.23.52 (14 Aug 2002)
D.4.9. Alterações na distribuição 3.23.51 (31 May 2002)
D.4.10. Alterações na distribuição 3.23.50 (21 Apr 2002)
D.4.11. Alterações na distribuição 3.23.49
D.4.12. Alterações na distribuição 3.23.48 (07 Feb 2002)
D.4.13. Alterações na distribuição 3.23.47 (27 Dec 2001)
D.4.14. Alterações na distribuição 3.23.46 (29 Nov 2001)
D.4.15. Alterações na distribuição 3.23.45 (22 Nov 2001)
D.4.16. Alterações na distribuição 3.23.44 (31 Oct 2001)
D.4.17. Alterações na distribuição 3.23.43 (04 Oct 2001)
D.4.18. Alterações na distribuição 3.23.42 (08 Sep 2001)
D.4.19. Alterações na distribuição 3.23.41 (11 Aug 2001)
D.4.20. Alterações na distribuição 3.23.40
D.4.21. Alterações na distribuição 3.23.39 (12 Jun 2001)
D.4.22. Alterações na distribuição 3.23.38 (09 May 2001)
D.4.23. Alterações na distribuição 3.23.37 (17 Apr 2001)
D.4.24. Alterações na distribuição 3.23.36 (27 Mar 2001)
D.4.25. Alterações na distribuição 3.23.35 (15 Mar 2001)
D.4.26. Alterações na distribuição 3.23.34a
D.4.27. Alterações na distribuição 3.23.34 (10 Mar 2001)
D.4.28. Alterações na distribuição 3.23.33 (09 Feb 2001)
D.4.29. Alterações na distribuição 3.23.32 (22 Jan 2001: Production)
D.4.30. Alterações na distribuição 3.23.31 (17 Jan 2001)
D.4.31. Alterações na distribuição 3.23.30 (04 Jan 2001)
D.4.32. Alterações na distribuição 3.23.29 (16 Dec 2000)
D.4.33. Alterações na distribuição 3.23.28 (22 Nov 2000: Gamma)
D.4.34. Alterações na distribuição 3.23.27 (24 Oct 2000)
D.4.35. Alterações na distribuição 3.23.26 (18 Oct 2000)
D.4.36. Alterações na distribuição 3.23.25 (29 Sep 2000)
D.4.37. Alterações na distribuição 3.23.24 (08 Sep 2000)
D.4.38. Alterações na distribuição 3.23.23 (01 Sep 2000)
D.4.39. Alterações na distribuição 3.23.22 (31 Jul 2000)
D.4.40. Alterações na distribuição 3.23.21
D.4.41. Alterações na distribuição 3.23.20
D.4.42. Alterações na distribuição 3.23.19
D.4.43. Alterações na distribuição 3.23.18
D.4.44. Alterações na distribuição 3.23.17
D.4.45. Alterações na distribuição 3.23.16
D.4.46. Alterações na distribuição 3.23.15 (May 2000: Beta)
D.4.47. Alterações na distribuição 3.23.14
D.4.48. Alterações na distribuição 3.23.13
D.4.49. Alterações na distribuição 3.23.12 (07 Mar 2000)
D.4.50. Alterações na distribuição 3.23.11
D.4.51. Alterações na distribuição 3.23.10
D.4.52. Alterações na distribuição 3.23.9
D.4.53. Alterações na distribuição 3.23.8 (02 Jan 2000)
D.4.54. Alterações na distribuição 3.23.7 (10 Dec 1999)
D.4.55. Alterações na distribuição 3.23.6
D.4.56. Alterações na distribuição 3.23.5 (20 Oct 1999)
D.4.57. Alterações na distribuição 3.23.4 (28 Sep 1999)
D.4.58. Alterações na distribuição 3.23.3
D.4.59. Alterações na distribuição 3.23.2 (09 Aug 1999)
D.4.60. Alterações na distribuição 3.23.1
D.4.61. Alterações na distribuição 3.23.0 (05 Aug 1999: Alpha)

Please note that since release 4.0 is now production level, only critical fixes are done in the 3.23 release series. You are recommended to upgrade when possible, to take advantage of all speed and feature improvements in 4.0. See Seção 2.5.2, “Atualizando da Versão 3.23 para 4.0”.

The 3.23 release has several major features that are not present in previous versions. We have added three new table types:

  • MyISAM

    A new ISAM library which is tuned for SQL and supports large files.

  • InnoDB

    A transaction-safe storage engine that supports row level locking, and many Oracle-like features.

  • BerkeleyDB or BDB

    Uses the Berkeley DB library from Sleepycat Software to implement transaction-safe tables.

Note that only MyISAM is available in the standard binary distribution.

The 3.23 release also includes support for database replication between a master and many slaves, full-text indexing, and much more.

All new features are being developed in the 4.x version. Only bug fixes and minor enhancements to existing features will be added to 3.23.

The replication code and BerkeleyDB code is still not as tested and as the rest of the code, so we will probably need to do a couple of future releases of 3.23 with small fixes for this part of the code. As long as you don't use these features, you should be quite safe with MySQL 3.23!

Note that the above doesn't mean that replication or Berkeley DB don't work. We have done a lot of testing of all code, including replication and BDB without finding any problems. It only means that not as many users use this code as the rest of the code and because of this we are not yet 100% confident in this code.

D.4.1. Alterações na distribuição 3.23.59 (not released yet)

  • If a query was ignored on the slave (because of replicate-ignore-table and other similar rules), the slave still checked if the query got the same error code (0, no error) as on the master. So if the master had an error on the query (for example, ``Duplicate entry'' in a multiple-row insert), then the slave stopped and warned that the error codes didn't match. This is a backport of the fix for MySQL 4.0. (Bug#797)

  • mysqlbinlog now asks for a password at console when the -p/--password option is used with no argument. This is how the other clients (mysqladmin, mysqldump..) already behave. Note that one now has to use mysqlbinlog -p<my_password>; mysqlbinlog -p <my_password> will not work anymore (in other words, put no space after -p). (Bug#1595)

  • On some 64-bit machines (some HP-UX and Solaris machines), a slave installed with the 64-bit MySQL binary could not connect to its master (it connected to itself instead). (Bug#1256, #1381)

  • Fixed a Windows-specific bug present since MySQL version 3.23.57 and 3.23.58, which caused Windows slaves to crash when they started replication if a master.info file existed. (Bug#1720)

D.4.2. Alterações na distribuição 3.23.58 (11 Sep 2003)

  • Fixed buffer overflow in password handling which could potentially be exploited by MySQL users with ALTER privilege on the mysql.user table to execute random code or to gain shell access with the UID of the mysqld process (thanks to Jedi/Sector One for spotting and reporting this bug).

  • mysqldump now correctly quotes all identifiers when communicating with the server. This assures that during the dump process, mysqldump will never send queries to the server that result in a syntax error. This problem is not related to the mysqldump program's output, which was not changed. (Bug#1148)

  • Fixed table/column grant handling - proper sort order (from most specific to less specific, see Seção 4.3.10, “Controle de Acesso, Estágio 2: Verificação da Requisição”) was not honored. (Bug#928)

  • Fixed overflow bug in MyISAM and ISAM when a row is updated in a table with a large number of columns and at least one BLOB/TEXT column.

  • Fixed MySQL so that field length (in C API) for the second column in SHOW CREATE TABLE is always larger than the data length. The only known application that was affected by the old behaviour was Borland dbExpress, which truncated the output from the command. (Bug#1064)

  • Fixed ISAM bug in MAX() optimization.

  • Fixed Unknown error when doing ORDER BY on reference table which was used with NULL value on NOT NULL column. (Bug#479)

D.4.3. Alterações na distribuição 3.23.57 (06 Jun 2003)

  • Fixed problem in alarm handling that could cause problems when getting a packet that is too large.

  • Fixed problem when installing MySQL as a service on Windows when one gave 2 arguments (option file group name and service name) to mysqld.

  • Fixed kill pid-of-mysqld to work on Mac OS X.

  • SHOW TABLE STATUS displayed incorrect Row_format value for tables that have been compressed with myisampack. (Bug#427)

  • SHOW VARIABLES LIKE 'innodb_data_file_path' displayed only the name of the first datafile. (Bug#468)

  • Fixed security problem where mysqld didn't allow one to UPDATE rows in a table even if one had a global UPDATE privilege and a database SELECT privilege.

  • Fixed a security problem with SELECT and wildcarded select list, when user only had partial column SELECT privileges on the table.

  • Fixed unlikely problem in optimising WHERE clause with a constant expression such as in WHERE 1 AND (a=1 AND b=1).

  • Fixed problem on IA-64 with timestamps that caused mysqlbinlog to fail.

  • The default option for innodb_flush_log_at_trx_commit was changed from 0 to 1 to make InnoDB tables ACID by default. Veja mais informações sobre isto na Seção 7.5.3, “Opções de Inicialização do InnoDB”.

  • Fixed problem with too many allocated alarms on slave when connecting to master many times (normally not a very critical error).

  • Fixed a bug in replication of temporary tables. (Bug#183)

  • Fixed 64 bit bug that affected at least AMD hammer systems.

  • Fixed a bug when doing LOAD DATA INFILE IGNORE: When reading the binary log, mysqlbinlog and the replication code read REPLACE instead of IGNORE. This could make the slave's table become different from the master's table. (Bug#218)

  • Fixed overflow bug in MyISAM when a row is inserted into a table with a large number of columns and at least one BLOB/TEXT column. Bug was caused by incorrect calculation of the needed buffer to pack data.

  • The binary log was not locked during TRUNCATE table_name or DELETE FROM table_name statements, which could cause an INSERT to table_name to be written to the log before the TRUNCATE or DELETE statements.

  • Fixed rare bug in UPDATE of InnoDB tables where one row could be updated multiple times.

  • Produce an error for empty table and column names.

  • Changed PROCEDURE ANALYSE() to report DATE instead of NEWDATE.

  • Changed PROCEDURE ANALYSE(#) to restrict the number of values in an ENUM column to # also for string values.

  • mysqldump no longer silently deletes the binary logs when invoked with the --master-data or --first-slave option; while this behaviour was convenient for some users, others may suffer from it. Now one has to explicitly ask for binary logs to be deleted by using the new --delete-master-logs option.

  • Fixed a bug in mysqldump when it was invoked with the --master-data option: The CHANGE MASTER TO statements that were appended to the SQL dump had incorrect coordinates. (Bug#159)

D.4.4. Alterações na distribuição 3.23.56 (13 Mar 2003)

  • Fixed mysqld crash on extremely small values of sort_buffer variable.

  • Fixed a bug in privilege system for GRANT UPDATE on column level.

  • Fixed a rare bug when using a date in HAVING with GROUP BY.

  • Fixed checking of random part of WHERE clause. (Bug#142)

  • Fixed MySQL (and myisamchk) crash on artificially corrupted .MYI files.

  • Security enhancement: mysqld no longer reads options from world-writeable config files.

  • Security enhancement: mysqld and safe_mysqld now only use the first --user option specified on the command line. (Normally this comes from /etc/my.cnf)

  • Security enhancement: Don't allow BACKUP TABLE to overwrite existing files.

  • Fixed unlikely deadlock bug when one thread did a LOCK TABLE and another thread did a DROP TABLE. In this case one could do a KILL on one of the threads to resolve the deadlock.

  • LOAD DATA INFILE was not replicated by slave if replicate_*_table was set on the slave.

  • Fixed a bug in handling CHAR(0) columns that could cause incorrect results from the query.

  • Fixed a bug in SHOW VARIABLES on 64-bit platforms. The bug was caused by incorrect declaration of variable server_id.

  • The Comment column in SHOW TABLE STATUS now reports that it can contain NULL values (which is the case for a crashed .frm file).

  • Fixed the rpl_rotate_logs test to not fail on certain platforms (e.g. Mac OS X) due to a too long file name (changed slave-master-info.opt to .slave-mi).

  • Fixed a problem with BLOB NOT NULL columns used with IS NULL.

  • Fixed bug in MAX() optimization in MERGE tables.

  • Better RAND() initialisation for new connections.

  • Fixed bug with connect timeout. This bug was manifested on OS's with poll() system call, which resulted in timeout the value specified as it was executed in both select() and poll().

  • Fixed bug in SELECT * FROM table WHERE datetime1 IS NULL OR datetime2 IS NULL.

  • Fixed bug in using aggregate functions as argument for INTERVAL, CASE, FIELD, CONCAT_WS, ELT and MAKE_SET functions.

  • When running with --lower-case-table-names (default on Windows) and you had tables or databases with mixed case on disk, then executing SHOW TABLE STATUS followed with DROP DATABASE or DROP TABLE could fail with Errcode 13.

  • Fixed bug in logging to binary log (which affects replication) a query that inserts a NULL in an auto_increment field and also uses LAST_INSERT_ID().

  • Fixed bug in mysqladmin --relative.

  • On some 64 bit systems, show status reported a strange number for Open_files and Open_streams.

D.4.5. Alterações na distribuição 3.23.55 (23 Jan 2003)

  • Fixed double free'd pointer bug in mysql_change_user() handling, that enabled a specially hacked version of MySQL client to crash mysqld. Note, that one needs to login to the server by using a valid user account to be able to exploit this bug.

  • Fixed bug with the --slow-log when logging an administrator command (like FLUSH TABLES).

  • Fixed bug in GROUP BY when used on BLOB column with NULL values.

  • Fixed a bug in handling NULL values in CASE ... WHEN ....

  • Bugfix for --chroot (see Seção D.4.6, “Alterações na distribuição 3.23.54 (05 Dec 2002)”) is reverted. Unfortunately, there is no way to make it to work, without introducing backward-incompatible changes in my.cnf. Those who need --chroot functionality, should upgrade to MySQL 4.0. (The fix in the 4.0 branch did not break backward-compatibility).

  • Make --lower-case-table-names default on Mac OS X as the default file system (HFS+) is case insensitive.

  • Fixed a bug in scripts/mysqld_safe.sh in NOHUP_NICENESS testing.

  • Transactions in AUTOCOMMIT=0 mode didn't rotate binary log.

  • Fixed a bug in scripts/make_binary_distribution that resulted in a remaining @HOSTNAME@ variable instead of replacing it with the correct path to the hostname binary.

  • Fixed a very unlikely bug that could cause SHOW PROCESSLIST to core dump in pthread_mutex_unlock() if a new thread was connecting.

  • Forbid SLAVE STOP if the thread executing the query has locked tables. This removes a possible deadlock situation.

D.4.6. Alterações na distribuição 3.23.54 (05 Dec 2002)

  • Fixed a bug, that allowed to crash mysqld with a specially crafted packet.

  • Fixed a rare crash (double free'd pointer) when altering a temporary table.

  • Fixed buffer overrun in libmysqlclient library that allowed malicious MySQL server to crash the client application.

  • Fixed security-related bug in mysql_change_user() handling. All users are strongly recommended to upgrade to the version 3.23.54.

  • Fixed bug that prevented --chroot command-line option of mysqld from working.

  • Fixed bug that made OPTIMIZE TABLE to corrupt the table under some rare circumstances.

  • Fixed mysqlcheck so it can deal with table names containing dashes.

  • Fixed shutdown problem on Mac OS X.

  • Fixed bug with comparing an indexed NULL field with <=> NULL.

  • Fixed bug that caused IGNORE INDEX and USE INDEX sometimes to be ignored.

  • Fixed rare core dump problem in complicated GROUP BY queries that didn't return any result.

  • Fixed a bug where MATCH ... AGAINST () >=0 was treated as if it was >.

  • Fixed core dump in SHOW PROCESSLIST when running with an active slave (unlikely timing bug).

  • Make it possible to use multiple MySQL servers on Windows (code backported from 4.0.2).

  • One can create TEMPORARY MERGE tables now.

  • Fixed that --core-file works on Linux (at least on kernel 2.4.18).

  • Fixed a problem with BDB and ALTER TABLE.

  • Fixed reference to freed memory when doing complicated GROUP BY ... ORDER BY queries. Symptom was that mysqld died in function send_fields.

  • Allocate heap rows in smaller blocks to get better memory usage.

  • Fixed memory allocation bug when storing BLOB values in internal temporary tables used for some (unlikely) GROUP BY queries.

  • Fixed a bug in key optimising handling where the expression WHERE column_name = key_column_name was calculated as true for NULL values.

  • Fixed core dump bug when doing LEFT JOIN ... WHERE key_column=NULL.

  • Fixed MyISAM crash when using dynamic-row tables with huge numbers of packed fields.

  • Updated source tree to be built using automake 1.5 and libtool 1.4.

D.4.7. Alterações na distribuição 3.23.53 (09 Oct 2002)

  • Fixed crash when SHOW INNODB STATUS was used and skip-innodb was defined.

  • Fixed possible memory corruption bug in binary log file handling when slave rotated the logs (only affected 3.23, not 4.0).

  • Fixed problem in LOCK TABLES on Windows when one connects to a database that contains upper case letters.

  • Fixed that --skip-show-databases doesn't reset the --port option.

  • Small fix in safe_mysqld for some shells.

  • Fixed that FLUSH STATUS doesn't reset delayed_insert_threads.

  • Fixed core dump bug when using the BINARY cast on a NULL value.

  • Fixed race condition when someone did a GRANT at the same time a new user logged in or did a USE database.

  • Fixed bug in ALTER TABLE and RENAME TABLE when running with -O lower_case_table_names=1 (typically on Windows) when giving the table name in uppercase.

  • Fixed that -O lower_case_table_names=1 also converts database names to lower case.

  • Fixed unlikely core dump with SELECT ... ORDER BY ... LIMIT.

  • Changed AND/OR to report that they can return NULL. This fixes a bug in GROUP BY on AND/OR expressions that return NULL.

  • Fixed a bug that OPTIMIZE of locked and modified MyISAM table, reported table corruption.

  • Fixed a BDB-related ALTER TABLE bug with dropping a column and shutting down immediately thereafter.

  • Fixed problem with configure ... --localstatedir=....

  • Fixed problem with UNSIGNED BIGINT on AIX (again).

  • Fixed bug in pthread_mutex_trylock() on HPUX 11.0.

  • Multi-threaded stress tests for InnoDB.

D.4.8. Alterações na distribuição 3.23.52 (14 Aug 2002)

  • Wrap BEGIN/COMMIT around transaction in the binary log. This makes replication honour transactions.

  • Fixed security bug when having an empty database name in the user.db table.

  • Changed initialisation of RND() to make it less predicatable.

  • Fixed problem with GROUP BY on result with expression that created a BLOB field.

  • Fixed problem with GROUP BY on columns that have NULL values. To solve this we now create an MyISAM temporary table when doing a GROUP BY on a possible NULL item. From MySQL 4.0.5 we can use in memory HEAP tables for this case.

  • Fixed problem with privilege tables when downgrading from 4.0.2 to 3.23.

  • Fixed thread bug in SLAVE START, SLAVE STOP and automatic repair of MyISAM tables that could cause table cache to be corrupted.

  • Fixed possible thread related key-cache-corruption problem with OPTIMIZE TABLE and REPAIR TABLE.

  • Added name of 'administrator command' logs.

  • Fixed bug with creating an auto-increment value on second part of a UNIQUE() key where first part could contain NULL values.

  • Don't write slave-timeout reconnects to the error log.

  • Fixed bug with slave net read timeouting

  • Fixed a core-dump bug with MERGE tables and MAX() function.

  • Fixed bug in ALTER TABLE with BDB tables.

  • Fixed bug when logging LOAD DATA INFILE to binary log with no active database.

  • Fixed a bug in range optimiser (causing crashes).

  • Fixed possible problem in replication when doing DROP DATABASE on a database with InnoDB tables.

  • Fixed that mysql_info() returns 0 for 'Duplicates' when using INSERT DELAYED IGNORE.

  • Added -DHAVE_BROKEN_REALPATH to the Mac OS X (darwin) compile options in configure.in to fix a failure under high load.

D.4.9. Alterações na distribuição 3.23.51 (31 May 2002)

  • Fix bug with closing tags missing slash for mysqldump XML output.

  • Remove end space from ENUM values. (This fixed a problem with SHOW CREATE TABLE.)

  • Fixed bug in CONCAT_WS() that cut the result.

  • Changed name of server variables Com_show_master_stat to Com_show_master_status and Com_show_slave_stat to Com_show_slave_status.

  • Changed handling of gethostbyname() to make the client library thread-safe even if gethostbyname_r doesn't exist.

  • Fixed core-dump problem when giving a wrong password string to GRANT.

  • Fixed bug in DROP DATABASE with symlinked directory.

  • Fixed optimization problem with DATETIME and value outside DATETIME range.

  • Removed Sleepycat's BDB doc files from the source tree, as they're not needed (MySQL covers BDB in its own documentation).

  • Fixed MIT-pthreads to compile with glibc 2.2 (needed for make dist).

  • Fixed the FLOAT(X+1,X) is not converted to FLOAT(X+2,X). (This also affected DECIMAL, DOUBLE and REAL types)

  • Fixed the result from IF() is case in-sensitive if the second and third arguments are case sensitive.

  • Fixed core dump problem on OSF/1 in gethostbyname_r.

  • Fixed that underflowed decimal fields are not zero filled.

  • If we get an overflow when inserting '+11111' for DECIMAL(5,0) UNSIGNED columns, we will just drop the sign.

  • Fixed optimization bug with ISNULL(expression_which_cannot_be_null) and ISNULL(constant_expression).

  • Fixed host lookup bug in the glibc library that we used with the 3.23.50 Linux-x86 binaries.

D.4.10. Alterações na distribuição 3.23.50 (21 Apr 2002)

  • Fixed buffer overflow problem if someone specified a too long datadir parameter to mysqld

  • Add missing <row> tags for mysqldump XML output.

  • Fixed problem with crash-me and gcc 3.0.4.

  • Fixed that @@unknown_variable doesn't hang server.

  • Added @@VERSION as a synonym for VERSION().

  • SHOW VARIABLES LIKE 'xxx' is now case-insensitive.

  • Fixed timeout for GET_LOCK() on HP-UX with DCE threads.

  • Fixed memory allocation bug in the glibc library used to build Linux binaries, which caused mysqld to die in 'free()'.

  • Fixed SIGINT and SIGQUIT problems in mysql.

  • Fixed bug in character table converts when used with big ( > 64K) strings.

  • InnoDB now retains foreign key constraints through ALTER TABLE and CREATE/DROP INDEX.

  • InnoDB now allows foreign key constraints to be added through the ALTER TABLE syntax.

  • InnoDB tables can now be set to automatically grow in size (autoextend).

  • Our Linux RPMS and binaries are now compiled with gcc 3.0.4, which should make them a bit faster.

  • Fixed some buffer overflow problems when reading startup parameters.

  • Because of problems on shutdown we have now disabled named pipes on Windows by default. One can enable named pipes by starting mysqld with --enable-named-pipe.

  • Fixed bug when using WHERE key_column = 'J' or key_column='j'.

  • Fixed core-dump bug when using --log-bin with LOAD DATA INFILE without an active database.

  • Fixed bug in RENAME TABLE when used with lower_case_table_names=1 (default on Windows).

  • Fixed unlikely core-dump bug when using DROP TABLE on a table that was in use by a thread that also used queries on only temporary tables.

  • Fixed problem with SHOW CREATE TABLE and PRIMARY KEY when using 32 indexes.

  • Fixed that one can use SET PASSWORD for the anonymous user.

  • Fixed core dump bug when reading client groups from option files using mysql_options().

  • Memory leak (16 bytes per every corrupted table) closed.

  • Fixed binary builds to use --enable-local-infile.

  • Update source to work with new version of bison.

  • Updated shell scripts to now agree with new POSIX standard.

  • Fixed bug where DATE_FORMAT() returned empty string when used with GROUP BY.

D.4.11. Alterações na distribuição 3.23.49

  • Don't give warning for a statement that is only a comment; this is needed for mysqldump --disable-keys to work.

  • Fixed unlikely caching bug when doing a join without keys. In this case the last used field for a table always returned NULL.

  • Added options to make LOAD DATA LOCAL INFILE more secure.

  • MySQL binary release 3.23.48 for Linux contained a new glibc library, which has serious problems under high load and Red Hat 7.2. The 3.23.49 binary release doesn't have this problem.

  • Fixed shutdown problem on NT.

D.4.12. Alterações na distribuição 3.23.48 (07 Feb 2002)

  • Added --xml option to mysqldump for producing XML output.

  • Changed to use autoconf 2.52 (from autoconf 2.13)

  • Fixed bug in complicated join with const tables.

  • Added internal safety checks for InnoDB.

  • Some InnoDB variables were always shown in SHOW VARIABLES as OFF on high-byte-first systems (like SPARC).

  • Fixed problem with one thread using an InnoDB table and another thread doing an ALTER TABLE on the same table. Before that, mysqld could crash with an assertion failure in row0row.c, line 474.

  • Tuned the InnoDB SQL optimiser to favor index searches more often over table scans.

  • Fixed a performance problem with InnoDB tables when several large SELECT queries are run concurrently on a multiprocessor Linux computer. Large CPU-bound SELECT queries will now also generally run faster on all platforms.

  • If MySQL binlogging is used, InnoDB now prints after crash recovery the latest MySQL binlog name and the offset InnoDB was able to recover to. This is useful, for example, when resynchronising a master and a slave database in replication.

  • Added better error messages to help in installation problems of InnoDB tables.

  • It is now possible to recover MySQL temporary tables that have become orphaned inside the InnoDB tablespace.

  • InnoDB now prevents a FOREIGN KEY declaration where the signedness is not the same in the referencing and referenced integer columns.

  • Calling SHOW CREATE TABLE or SHOW TABLE STATUS could cause memory corruption and make mysqld crash. Especially at risk was mysqldump, because it frequently calls SHOW CREATE TABLE.

  • If inserts to several tables containing an AUTO_INCREMENT column were wrapped inside one LOCK TABLES, InnoDB asserted in lock0lock.c.

  • In 3.23.47 we allowed several NULL values in a UNIQUE secondary index for an InnoDB table. But CHECK TABLE was not relaxed: it reports the table as corrupt. CHECK TABLE no longer complains in this situation.

  • SHOW GRANTS now shows REFERENCES instead of REFERENCE.

D.4.13. Alterações na distribuição 3.23.47 (27 Dec 2001)

  • Fixed bug when using the following construct: SELECT ... WHERE key=@var_name OR key=@var_name2

  • Restrict InnoDB keys to 500 bytes.

  • InnoDB now supports NULL in keys.

  • Fixed shutdown problem on HP-UX. (Introduced in 3.23.46)

  • Fixed core dump bug in replication when using SELECT RELEASE_LOCK().

  • Added new command: DO expression,[expression]

  • Added slave-skip-errors option.

  • Added statistics variables for all MySQL commands. (SHOW STATUS is now much longer.)

  • Fixed default values for InnoDB tables.

  • Fixed that GROUP BY expr DESC works.

  • Fixed bug when using t1 LEFT JOIN t2 ON t2.key=constant.

  • mysql_config now also works with binary (relocated) distributions.

D.4.14. Alterações na distribuição 3.23.46 (29 Nov 2001)

  • Fixed problem with aliased temporary table replication.

  • InnoDB and BDB tables will now use index when doing an ORDER BY on the whole table.

  • Fixed bug where one got an empty set instead of a DEADLOCK error when using BDB tables.

  • One can now kill ANALYZE, REPAIR, and OPTIMIZE TABLE when the thread is waiting to get a lock on the table.

  • Fixed race condition in ANALYZE TABLE.

  • Fixed bug when joining with caching (unlikely to happen).

  • Fixed race condition when using the binary log and INSERT DELAYED which could cause the binary log to have rows that were not yet written to MyISAM tables.

  • Changed caching of binary log to make replication slightly faster.

  • Fixed bug in replication on Mac OS X.

D.4.15. Alterações na distribuição 3.23.45 (22 Nov 2001)

  • (UPDATE|DELETE) ...WHERE MATCH bugfix.

  • shutdown should now work on Darwin (Mac OS X).

  • Fixed core dump when repairing corrupted packed MyISAM files.

  • --core-file now works on Solaris.

  • Fix a bug which could cause InnoDB to complain if it cannot find free blocks from the buffer cache during recovery.

  • Fixed bug in InnoDB insert buffer B-tree handling that could cause crashes.

  • Fixed bug in InnoDB lock timeout handling.

  • Fixed core dump bug in ALTER TABLE on a TEMPORARY InnoDB table.

  • Fixed bug in OPTIMIZE TABLE that reset index cardinality if it was up to date.

  • Fixed problem with t1 LEFT_JOIN t2 ... WHERE t2.date_column IS NULL when date_column was declared as NOT NULL.

  • Fixed bug with BDB tables and keys on BLOB columns.

  • Fixed bug in MERGE tables on OS with 32-bit file pointers.

  • Fixed bug in TIME_TO_SEC() when using negative values.

D.4.16. Alterações na distribuição 3.23.44 (31 Oct 2001)

  • Fixed Rows_examined count in slow query log.

  • Fixed bug when using a reference to an AVG() column in HAVING.

  • Fixed that date functions that require correct dates, like DAYOFYEAR(column), will return NULL for 0000-00-00 dates.

  • Fixed bug in const-propagation when comparing columns of different types. (SELECT * FROM date_col="2001-01-01" and date_col=time_col)

  • Fixed bug that caused error message Can't write, because of unique constraint with some GROUP BY queries.

  • Fixed problem with sjis character strings used within quoted table names.

  • Fixed core dump when using CREATE ... FULLTEXT keys with other storage engines than MyISAM.

  • Don't use signal() on Windows because this appears to not be 100% reliable.

  • Fixed bug when doing WHERE col_name=NULL on an indexed column that had NULL values.

  • Fixed bug when doing LEFT JOIN ... ON (col_name = constant) WHERE col_name = constant.

  • When using replications, aborted queries that contained % could cause a core dump.

  • TCP_NODELAY was not used on some systems. (Speed problem.)

  • Applied portability fixes for OS/2. (Patch by Yuri Dario.)

The following changes are for InnoDB tables:

  • Add missing InnoDB variables to SHOW VARIABLES.

  • Foreign keys checking is now done for InnoDB tables.

  • DROP DATABASE now works also for InnoDB tables.

  • InnoDB now supports datafiles and raw disk partitions bigger than 4 GB on those operating systems that have big files.

  • InnoDB calculates better table cardinality estimates for the MySQL optimiser.

  • Accent characters in the default character set latin1 are ordered according to the MySQL ordering.

    Note: if you are using latin1 and have inserted characters whose code is greater than 127 into an indexed CHAR column, you should run CHECK TABLE on your table when you upgrade to 3.23.44, and drop and reimport the table if CHECK TABLE reports an error!

  • A new my.cnf parameter, innodb_thread_concurrency, helps in performance tuning in heavily concurrent environments.

  • A new my.cnf parameter, innodb_fast_shutdown, speeds up server shutdown.

  • A new my.cnf parameter, innodb_force_recovery, helps to save your data in case the disk image of the database becomes corrupt.

  • innodb_monitor has been improved and a new innodb_table_monitor added.

  • Increased maximum key length from 500 to 7000 bytes.

  • Fixed a bug in replication of AUTO_INCREMENT columns with multiple-line inserts.

  • Fixed a bug when the case of letters changes in an update of an indexed secondary column.

  • Fixed a hang when there are > 24 datafiles.

  • Fixed a crash when MAX(col) is selected from an empty table, and col is not the first column in a multi-column index.

  • Fixed a bug in purge which could cause crashes.

D.4.17. Alterações na distribuição 3.23.43 (04 Oct 2001)

  • Fixed a bug in INSERT DELAYED and FLUSH TABLES introduced in 3.23.42.

  • Fixed unlikely bug, which returned non-matching rows, in SELECT with many tables and multi-column indexes and 'range' type.

  • Fixed an unlikely core dump bug when doing EXPLAIN SELECT when using many tables and ORDER BY.

  • Fixed bug in LOAD DATA FROM MASTER when using table with CHECKSUM=1.

  • Added unique error message when one gets a DEADLOCK during a transaction with BDB tables.

  • Fixed problem with BDB tables and UNIQUE columns defined as NULL.

  • Fixed problem with myisampack when using pre-space filled CHAR columns.

  • Applied patch from Yuri Dario for OS/2.

  • Fixed bug in --safe-user-create.

D.4.18. Alterações na distribuição 3.23.42 (08 Sep 2001)

  • Fixed problem when using LOCK TABLES and BDB tables.

  • Fixed problem with REPAIR TABLE on MyISAM tables with row lengths in the range from 65517 to 65520 bytes.

  • Fixed rare hang when doing mysqladmin shutdown when there was a lot of activity in other threads.

  • Fixed problem with INSERT DELAYED where delay thread could be hanging on upgrading locks with no apparent reason.

  • Fixed problem with myisampack and BLOB.

  • Fixed problem when one edited .MRG tables by hand. (Patch from Benjamin Pflugmann).

  • Enforce that all tables in a MERGE table come from the same database.

  • Fixed bug with LOAD DATA INFILE and transactional tables.

  • Fix bug when using INSERT DELAYED with wrong column definition.

  • Fixed core dump during REPAIR of some particularly broken tables.

  • Fixed bug in InnoDB and AUTO_INCREMENT columns.

  • Fixed bug in InnoDB and RENAME TABLE columns.

  • Fixed critical bug in InnoDB and BLOB columns. If you have used BLOB columns larger than 8000 bytes in an InnoDB table, it is necessary to dump the table with mysqldump, drop it and restore it from the dump.

  • Applied large patch for OS/2 from Yuri Dario.

  • Fixed problem with InnoDB when one could get the error Can't execute the given command... even when no transaction was active.

  • Applied some minor fixes that concern Gemini.

  • Use real arithmetic operations even in integer context if not all arguments are integers. (Fixes uncommon bug in some integer contexts).

  • Don't force everything to lowercase on Windows. (To fix problem with Windows and ALTER TABLE). Now --lower_case_names also works on Unix.

  • Fixed that automatic rollback is done when thread end doesn't lock other threads.

D.4.19. Alterações na distribuição 3.23.41 (11 Aug 2001)

  • Added --sql-mode=value[,value[,value]] option to mysqld. See Seção 4.1.1, “Opções de Linha de Comando do mysqld.

  • Fixed possible problem with shutdown on Solaris where the .pid file wasn't deleted.

  • InnoDB now supports < 4 GB rows. The former limit was 8000 bytes.

  • The doublewrite file flush method is used in InnoDB. It reduces the need for Unix fsync() calls to a fraction and improves performance on most Unix flavors.

  • You can now use the InnoDB Monitor to print a lot of InnoDB state information, including locks, to the standard output. This is useful in performance tuning.

  • Several bugs which could cause hangs in InnoDB have been fixed.

  • Split record_buffer to record_buffer and record_rnd_buffer. To make things compatible to previous MySQL versions, if record_rnd_buffer is not set, then it takes the value of record_buffer.

  • Fixed optimising bug in ORDER BY where some ORDER BY parts where wrongly removed.

  • Fixed overflow bug with ALTER TABLE and MERGE tables.

  • Added prototypes for my_thread_init() and my_thread_end() to mysql_com.h

  • Added --safe-user-create option to mysqld.

  • Fixed bug in SELECT DISTINCT ... HAVING that caused error message Can't find record in #...

D.4.20. Alterações na distribuição 3.23.40

  • Fixed problem with --low-priority-updates and INSERT statements.

  • Fixed bug in slave thread when under some rare circumstances it could get 22 bytes ahead on the offset in the master.

  • Added slave_net_timeout for replication.

  • Fixed problem with UPDATE and BDB tables.

  • Fixed hard bug in BDB tables when using key parts.

  • Fixed problem when using GRANT FILE ON database.* ...; previously we added the DROP privilege for the database.

  • Fixed DELETE FROM tbl_name ... LIMIT 0 and UPDATE FROM tbl_name ... LIMIT 0, which acted as though the LIMIT clause was not present (they deleted or updated all selected rows).

  • CHECK TABLE now checks if an AUTO_INCREMENT column contains the value 0.

  • Sending a SIGHUP to mysqld will now only flush the logs, not reset the replication.

  • Fixed parser to allow floats of type 1.0e1 (no sign after e).

  • Option --force to myisamchk now also updates states.

  • Added option --warnings to mysqld. Now mysqld prints the error Aborted connection only if this option is used.

  • Fixed problem with SHOW CREATE TABLE when you didn't have a PRIMARY KEY.

  • Properly fixed the rename of innodb_unix_file_flush_method variable to innodb_flush_method.

  • Fixed bug when converting BIGINT UNSIGNED to DOUBLE. This caused a problem when doing comparisons with BIGINT values outside of the signed range.

  • Fixed bug in BDB tables when querying empty tables.

  • Fixed a bug when using COUNT(DISTINCT) with LEFT JOIN and there weren't any matching rows.

  • Removed all documentation referring to the GEMINI table type. GEMINI is not released under an Open Source license.

D.4.21. Alterações na distribuição 3.23.39 (12 Jun 2001)

  • The AUTO_INCREMENT sequence wasn't reset when dropping and adding an AUTO_INCREMENT column.

  • CREATE ... SELECT now creates non-unique indexes delayed.

  • Fixed problem where LOCK TABLES tbl_name READ followed by FLUSH TABLES put an exclusive lock on the table.

  • REAL @variable values were represented with only 2 digits when converted to strings.

  • Fixed problem that client ``hung'' when LOAD TABLE FROM MASTER failed.

  • myisamchk --fast --force will no longer repair tables that only had the open count wrong.

  • Added functions to handle symbolic links to make life easier in 4.0.

  • We are now using the -lcma thread library on HP-UX 10.20 so that MySQL will be more stable on HP-UX.

  • Fixed problem with IF() and number of decimals in the result.

  • Fixed date-part extraction functions to work with dates where day and/or month is 0.

  • Extended argument length in option files from 256 to 512 chars.

  • Fixed problem with shutdown when INSERT DELAYED was waiting for a LOCK TABLE.

  • Fixed core dump bug in InnoDB when tablespace was full.

  • Fixed problem with MERGE tables and big tables (> 4G) when using ORDER BY.

D.4.22. Alterações na distribuição 3.23.38 (09 May 2001)

  • Fixed a bug when SELECT from MERGE table sometimes results in incorrectly ordered rows.

  • Fixed a bug in REPLACE() when using the ujis character set.

  • Applied Sleepycat BDB patches 3.2.9.1 and 3.2.9.2.

  • Added --skip-stack-trace option to mysqld.

  • CREATE TEMPORARY now works with InnoDB tables.

  • InnoDB now promotes sub keys to whole keys.

  • Added option CONCURRENT to LOAD DATA.

  • Better error message when slave max_allowed_packet is too low to read a very long log event from the master.

  • Fixed bug when too many rows where removed when using SELECT DISTINCT ... HAVING.

  • SHOW CREATE TABLE now returns TEMPORARY for temporary tables.

  • Added Rows_examined to slow query log.

  • Fixed problems with function returning empty string when used together with a group function and a WHERE that didn't match any rows.

  • New program mysqlcheck.

  • Added database name to output for administrative commands like CHECK, REPAIR, OPTIMIZE.

  • Lots of portability fixes for InnoDB.

  • Changed optimiser so that queries like SELECT * FROM tbl_name,tbl_name2 ... ORDER BY key_part1 LIMIT row_count will use index on key_part1 instead of filesort.

  • Fixed bug when doing LOCK TABLE to_table WRITE,...; INSERT INTO to_table... SELECT ... when to_table was empty.

  • Fixed bug with LOCK TABLE and BDB tables.

D.4.23. Alterações na distribuição 3.23.37 (17 Apr 2001)

  • Fixed a bug when using MATCH() in HAVING clause.

  • Fixed a bug when using HEAP tables with LIKE.

  • Added --mysql-version option to safe_mysqld

  • Changed INNOBASE to InnoDB (because the INNOBASE name was already used). All configure options and mysqld start options now use innodb instead of innobase. This means that before upgrading to this version, you have to change any configuration files where you have used innobase options!

  • Fixed bug when using indexes on CHAR(255) NULL columns.

  • Slave thread will now be started even if master-host is not set, as long as server-id is set and valid master.info is present.

  • Partial updates (terminated with kill) are now logged with a special error code to the binary log. Slave will refuse to execute them if the error code indicates the update was terminated abnormally, and will have to be recovered with SET SQL_SLAVE_SKIP_COUNTER=1; SLAVE START after a manual sanity check/correction of data integrity.

  • Fixed bug that erroneously logged a drop of internal temporary table on thread termination to the binary log --- this bug affected replication.

  • Fixed a bug in REGEXP on 64-bit machines.

  • UPDATE and DELETE with WHERE unique_key_part IS NULL didn't update/delete all rows.

  • Disabled INSERT DELAYED for tables that support transactions.

  • Fixed bug when using date functions on TEXT/BLOB column with wrong date format.

  • UDFs now also work on Windows. (Patch by Ralph Mason.)

  • Fixed bug in ALTER TABLE and LOAD DATA INFILE that disabled key-sorting. These commands should now be faster in most cases.

  • Fixed performance bug where reopened tables (tables that had been waiting for FLUSH or REPAIR) would not use indexes for the next query.

  • Fixed problem with ALTER TABLE to InnoDB tables on FreeBSD.

  • Added mysqld variables myisam_max_sort_file_size and myisam_max_extra_sort_file_size.

  • Initialise signals early to avoid problem with signals in InnoDB.

  • Applied patch for the tis620 character set to make comparisons case-independent and to fix a bug in LIKE for this character set. Note: All tables that uses the tis620 character set must be fixed with myisamchk -r or REPAIR TABLE !

  • Added --skip-safemalloc option to mysqld.

D.4.24. Alterações na distribuição 3.23.36 (27 Mar 2001)

  • Fixed a bug that allowed use of database names containing a ‘.’ character. This fixes a serious security issue when mysqld is run as root.

  • Fixed bug when thread creation failed (could happen when doing a lot of connections in a short time).

  • Fixed some problems with FLUSH TABLES and TEMPORARY tables. (Problem with freeing the key cache and error Can't reopen table....)

  • Fixed a problem in InnoDB with other character sets than latin1 and another problem when using many columns.

  • Fixed bug that caused a core dump when using a very complex query involving DISTINCT and summary functions.

  • Added SET TRANSACTION ISOLATION LEVEL ...

  • Added SELECT ... FOR UPDATE.

  • Fixed bug where the number of affected rows was not returned when MySQL was compiled without transaction support.

  • Fixed a bug in UPDATE where keys weren't always used to find the rows to be updated.

  • Fixed a bug in CONCAT_WS() where it returned incorrect results.

  • Changed CREATE ... SELECT and INSERT ... SELECT to not allow concurrent inserts as this could make the binary log hard to repeat. (Concurrent inserts are enabled if you are not using the binary or update log.)

  • Changed some macros to be able to use fast mutex with glibc 2.2.

D.4.25. Alterações na distribuição 3.23.35 (15 Mar 2001)

  • Fixed newly introduced bug in ORDER BY.

  • Fixed wrong define CLIENT_TRANSACTIONS.

  • Fixed bug in SHOW VARIABLES when using INNOBASE tables.

  • Setting and using user variables in SELECT DISTINCT didn't work.

  • Tuned SHOW ANALYZE for small tables.

  • Fixed handling of arguments in the benchmark script run-all-tests.

D.4.26. Alterações na distribuição 3.23.34a

  • Added extra files to the distribution to allow INNOBASE support to be compiled.

D.4.27. Alterações na distribuição 3.23.34 (10 Mar 2001)

  • Added the INNOBASE storage engine and the BDB storage engine to the MySQL source distribution.

  • Updated the documentation about GEMINI tables.

  • Fixed a bug in INSERT DELAYED that caused threads to hang when inserting NULL into an AUTO_INCREMENT column.

  • Fixed a bug in CHECK TABLE / REPAIR TABLE that could cause a thread to hang.

  • REPLACE will not replace a row that conflicts with an AUTO_INCREMENT generated key.

  • mysqld now only sets CLIENT_TRANSACTIONS in mysql->server_capabilities if the server supports a transaction-safe storage engine.

  • Fixed LOAD DATA INFILE to allow numeric values to be read into ENUM and SET columns.

  • Improved error diagnostic for slave thread exit.

  • Fixed bug in ALTER TABLE ... ORDER BY.

  • Added max_user_connections variable to mysqld.

  • Limit query length for replication by max_allowed_packet, not the arbitrary limit of 4 MB.

  • Allow space around = in argument to --set-variable.

  • Fixed problem in automatic repair that could leave some threads in state Waiting for table.

  • SHOW CREATE TABLE now displays the UNION=() for MERGE tables.

  • ALTER TABLE now remembers the old UNION=() definition.

  • Fixed bug when replicating timestamps.

  • Fixed bug in bidirectional replication.

  • Fixed bug in the BDB storage engine that occurred when using an index on multi-part key where a key part may be NULL.

  • Fixed MAX() optimization on sub-key for BDB tables.

  • Fixed problem where garbage results were returned when using BDB tables and BLOB or TEXT fields when joining many tables.

  • Fixed a problem with BDB tables and TEXT columns.

  • Fixed bug when using a BLOB key where a const row wasn't found.

  • Fixed that mysqlbinlog writes the timestamp value for each query. This ensures that one gets same values for date functions like NOW() when using mysqlbinlog to pipe the queries to another server.

  • Allow --skip-gemini, --skip-bdb, and --skip-innodb options to be specified when invoking mysqld, even if these storage engines are not compiled in to mysqld.

  • One can now do GROUP BY ... DESC.

  • Fixed a deadlock in the SET code, when one ran SET @foo=bar, where bar is a column reference, an error was not properly generated.

D.4.28. Alterações na distribuição 3.23.33 (09 Feb 2001)

  • Fixed DNS lookups not to use the same mutex as the hostname cache. This will enable known hosts to be quickly resolved even if a DNS lookup takes a long time.

  • Added --character-sets-dir option to myisampack.

  • Removed warnings when running REPAIR TABLE ... EXTENDED.

  • Fixed a bug that caused a core dump when using GROUP BY on an alias, where the alias was the same as an existing column name.

  • Added SEQUENCE() as an example UDF function.

  • Changed mysql_install_db to use BINARY for CHAR columns in the privilege tables.

  • Changed TRUNCATE tbl_name to TRUNCATE TABLE tbl_name to use the same syntax as Oracle. Until 4.0 we will also allow TRUNCATE tbl_name to not crash old code.

  • Fixed ``no found rows'' bug in MyISAM tables when a BLOB was first part of a multi-part key.

  • Fixed bug where CASE didn't work with GROUP BY.

  • Added --sort-recover option to myisamchk.

  • myisamchk -S and OPTIMIZE TABLE now work on Windows.

  • Fixed bug when using DISTINCT on results from functions that referred to a group function, like:

    SELECT a, DISTINCT SEC_TO_TIME(SUM(a))
    FROM tbl_name GROUP BY a, b;
    

  • Fixed buffer overrun in libmysqlclient library. Fixed bug in handling STOP event after ROTATE event in replication.

  • Fixed another buffer overrun in DROP DATABASE.

  • Added Table_locks_immediate and Table_locks_waited status variables.

  • Fixed bug in replication that broke slave server start with existing master.info. This fixes a bug introduced in 3.23.32.

  • Added SET SQL_SLAVE_SKIP_COUNTER=n command to recover from replication glitches without a full database copy.

  • Added max_binlog_size variable; the binary log will be rotated automatically when the size crosses the limit.

  • Added Last_Error, Last_Errno, and Slave_skip_counter variables to SHOW SLAVE STATUS.

  • Fixed bug in MASTER_POS_WAIT() function.

  • Execute core dump handler on SIGILL, and SIGBUS in addition to SIGSEGV.

  • On x86 Linux, print the current query and thread (connection) id, if available, in the core dump handler.

  • Fixed several timing bugs in the test suite.

  • Extended mysqltest to take care of the timing issues in the test suite.

  • ALTER TABLE can now be used to change the definition for a MERGE table.

  • Fixed creation of MERGE tables on Windows.

  • Portability fixes for OpenBSD and OS/2.

  • Added --temp-pool option to mysqld. Using this option will cause most temporary files created to use a small set of names, rather than a unique name for each new file. This is to work around a problem in the Linux kernel dealing with creating a bunch of new files with different names. With the old behaviour, Linux seems to "leak" memory, as it's being allocated to the directory entry cache instead of the disk cache.

D.4.29. Alterações na distribuição 3.23.32 (22 Jan 2001: Production)

  • Changed code to get around compiler bug in Compaq C++ on OSF/1, that broke BACKUP, RESTORE, CHECK, REPAIR, and ANALYZE TABLE.

  • Added option FULL to SHOW COLUMNS. Now we show the privilege list for the columns only if this option is given.

  • Fixed bug in SHOW LOGS when there weren't any BDB logs.

  • Fixed a timing problem in replication that could delay sending an update to the client until a new update was done.

  • Don't convert field names when using mysql_list_fields(). This is to keep this code compatible with SHOW FIELDS.

  • MERGE tables didn't work on Windows.

  • Fixed problem with SET PASSWORD=... on Windows.

  • Added missing my_config.h to RPM distribution.

  • TRIM("foo" from "foo") didn't return an empty string.

  • Added --with-version-suffix option to configure.

  • Fixed core dump when client aborted connection without mysql_close().

  • Fixed a bug in RESTORE TABLE when trying to restore from a non-existent directory.

  • Fixed a bug which caused a core dump on the slave when replicating SET PASSWORD.

  • Added MASTER_POS_WAIT().

D.4.30. Alterações na distribuição 3.23.31 (17 Jan 2001)

  • The test suite now tests all reachable BDB interface code. During testing we found and fixed many errors in the interface code.

  • Using HAVING on an empty table could produce one result row when it shouldn't.

  • Fixed the MySQL RPM so it no longer depends on Perl5.

  • Fixed some problems with HEAP tables on Windows.

  • SHOW TABLE STATUS didn't show correct average row length for tables larger than 4G.

  • CHECK TABLE ... EXTENDED didn't check row links for fixed size tables.

  • Added option MEDIUM to CHECK TABLE.

  • Fixed problem when using DECIMAL() keys on negative numbers.

  • HOUR() (and some other TIME functions) on a CHAR column always returned NULL.

  • Fixed security bug in something (please upgrade if you are using an earlier MySQL 3.23 version).

  • Fixed buffer overflow bug when writing a certain error message.

  • Added usage of setrlimit() on Linux to get -O --open-files-limit=# to work on Linux.

  • Added bdb_version variable to mysqld.

  • Fixed bug when using expression of type:

    SELECT ... FROM t1 LEFT JOIN t2 ON (t1.a=t2.a) WHERE t1.a=t2.a
    

    In this case the test in the WHERE clause was wrongly optimised away.

  • Fixed bug in MyISAM when deleting keys with possible NULL values, but the first key-column was not a prefix-compressed text column.

  • Fixed mysql.server to read the [mysql.server] option file group rather than the [mysql_server] group.

  • Fixed safe_mysqld and mysql.server to also read the server option section.

  • Added Threads_created status variable to mysqld.

D.4.31. Alterações na distribuição 3.23.30 (04 Jan 2001)

  • Added SHOW OPEN TABLES command.

  • Fixed that myisamdump works against old mysqld servers.

  • Fixed myisamchk -k# so that it works again.

  • Fixed a problem with replication when the binary log file went over 2G on 32-bit systems.

  • LOCK TABLES will now automatically start a new transaction.

  • Changed BDB tables to not use internal subtransactions and reuse open files to get more speed.

  • Added --mysqld=# option to safe_mysqld.

  • Allow hex constants in the --fields-*-by and --lines-terminated-by options to mysqldump and mysqlimport. By Paul DuBois.

  • Added --safe-show-database option to mysqld.

  • Added have_bdb, have_gemini, have_innobase, have_raid and have_openssl to SHOW VARIABLES to make it easy to test for supported extensions.

  • Added --open-files-limit option to mysqld.

  • Changed --open-files option to --open-files-limit in safe_mysqld.

  • Fixed a bug where some rows were not found with HEAP tables that had many keys.

  • Fixed that --bdb-no-sync works.

  • Changed --bdb-recover to --bdb-no-recover as recover should be on by default.

  • Changed the default number of BDB locks to 10000.

  • Fixed a bug from 3.23.29 when allocating the shared structure needed for BDB tables.

  • Changed mysqld_multi.sh to use configure variables. Patch by Christopher McCrory.

  • Added fixing of include files for Solaris 2.8.

  • Fixed bug with --skip-networking on Debian Linux.

  • Fixed problem that some temporary files where reported as having the name UNOPENED in error messages.

  • Fixed bug when running two simultaneous SHOW LOGS queries.

D.4.32. Alterações na distribuição 3.23.29 (16 Dec 2000)

  • Configure updates for Tru64, large file support, and better TCP wrapper support. By Albert Chin-A-Young.

  • Fixed bug in <=> operator.

  • Fixed bug in REPLACE with BDB tables.

  • LPAD() and RPAD() will shorten the result string if it's longer than the length argument.

  • Added SHOW LOGS command.

  • Remove unused BDB logs on shutdown.

  • When creating a table, put PRIMARY keys first, followed by UNIQUE keys.

  • Fixed a bug in UPDATE involving multi-part keys where one specified all key parts both in the update and the WHERE part. In this case MySQL could try to update a record that didn't match the whole WHERE part.

  • Changed drop table to first drop the tables and then the .frm file.

  • Fixed a bug in the hostname cache which caused mysqld to report the hostname as '' in some error messages.

  • Fixed a bug with HEAP type tables; the variable max_heap_table_size wasn't used. Now either MAX_ROWS or max_heap_table_size can be used to limit the size of a HEAP type table.

  • Changed the default server-id to 1 for masters and 2 for slaves to make it easier to use the binary log.

  • Renamed bdb_lock_max variable to bdb_max_lock.

  • Added support for AUTO_INCREMENT on sub-fields for BDB tables.

  • Added ANALYZE of BDB tables.

  • In BDB tables, we now store the number of rows; this helps to optimise queries when we need an approximation of the number of rows.

  • If we get an error in a multi-row statement, we now only roll back the last statement, not the entire transaction.

  • If you do a ROLLBACK when you have updated a non-transactional table you will get an error as a warning.

  • Added --bdb-shared-data option to mysqld.

  • Added Slave_open_temp_tables status variable to mysqld

  • Added binlog_cache_size and max_binlog_cache_size variables to mysqld.

  • DROP TABLE, RENAME TABLE, CREATE INDEX and DROP INDEX are now transaction endpoints.

  • If you do a DROP DATABASE on a symbolically linked database, both the link and the original database is deleted.

  • Fixed DROP DATABASE to work on OS/2.

  • Fixed bug when doing a SELECT DISTINCT ... table1 LEFT JOIN table2 ... when table2 was empty.

  • Added --abort-slave-event-count and --disconnect-slave-event-count options to mysqld for debugging and testing of replication.

  • Fixed replication of temporary tables. Handles everything except slave server restart.

  • SHOW KEYS now shows whether key is FULLTEXT.

  • New script mysqld_multi. See Seção 4.8.3, “mysqld_multi, programa para gerenciar múltiplos servidores MySQL”.

  • Added new script, mysql-multi.server.sh. Thanks to Tim Bunce for modifying mysql.server to easily handle hosts running many mysqld processes.

  • safe_mysqld, mysql.server, and mysql_install_db have been modified to use mysql_print_defaults instead of various hacks to read the my.cnf files. In addition, the handling of various paths has been made more consistent with how mysqld handles them by default.

  • Automatically remove Berkeley DB transaction logs that no longer are in use.

  • Fixed bug with several FULLTEXT indexes in one table.

  • Added a warning if number of rows changes on REPAIR/OPTIMIZE.

  • Applied patches for OS/2 by Yuri Dario.

  • FLUSH TABLES tbl_name didn't always flush the index tree to disk properly.

  • --bootstrap is now run in a separate thread. This fixes a problem that caused mysql_install_db to core dump on some Linux machines.

  • Changed mi_create() to use less stack space.

  • Fixed bug with optimiser trying to over-optimise MATCH() when used with UNIQUE key.

  • Changed crash-me and the MySQL benchmarks to also work with FrontBase.

  • Allow RESTRICT and CASCADE after DROP TABLE to make porting easier.

  • Reset status variable which could cause problem if one used --slow-log.

  • Added connect_timeout variable to mysql and mysqladmin.

  • Added connect-timeout as an alias for timeout for option files read by mysql_options().

D.4.33. Alterações na distribuição 3.23.28 (22 Nov 2000: Gamma)

  • Added new options --pager[=...], --no-pager, --tee=... and --no-tee to the mysql client. The new corresponding interactive commands are pager, nopager, tee and notee. See Seção 4.9.2, “mysql, A Ferramenta de Linha de Comando”, mysql --help and the interactive help for more information.

  • Fixed crash when automatic repair of MyISAM table failed.

  • Fixed a major performance bug in the table locking code when one constantly had a lot of SELECT, UPDATE and INSERT statements running. The symptom was that the UPDATE and INSERT queries were locked for a long time while new SELECT statements were executed before the updates.

  • When reading options_files with mysql_options() the return-found-rows option was ignored.

  • One can now specify interactive-timeout in the option file that is read by mysql_options(). This makes it possible to force programs that run for a long time (like mysqlhotcopy) to use the interactive_timeout time instead of the wait_timeout time.

  • Added to the slow query log the time and the user name for each logged query. If you are using --log-long-format then also queries that do not use an index are logged, even if the query takes less than long_query_time seconds.

  • Fixed a problem in LEFT JOIN which caused all columns in a reference table to be NULL.

  • Fixed a problem when using NATURAL JOIN without keys.

  • Fixed a bug when using a multi-part keys where the first part was of type TEXT or BLOB.

  • DROP of temporary tables wasn't stored in the update/binary log.

  • Fixed a bug where SELECT DISTINCT * ... LIMIT row_count only returned one row.

  • Fixed a bug in the assembler code in strstr() for SPARC and cleaned up the global.h header file to avoid a problem with bad aliasing with the compiler submitted with Red Hat 7.0. (Reported by Trond Eivind Glomsrød)

  • The --skip-networking option now works properly on NT.

  • Fixed a long outstanding bug in the ISAM tables when a row with a length of more than 65K was shortened by a single byte.

  • Fixed a bug in MyISAM when running multiple updating processes on the same table.

  • Allow one to use FLUSH TABLE tbl_name.

  • Added --replicate-ignore-table, --replicate-do-table, --replicate-wild-ignore-table, and --replicate-wild-do-table options to mysqld.

  • Changed all log files to use our own IO_CACHE mechanism instead of FILE to avoid OS problems when there are many files open.

  • Added --open-files and --timezone options to safe_mysqld.

  • Fixed a fatal bug in CREATE TEMPORARY TABLE ... SELECT ....

  • Fixed a problem with CREATE TABLE ... SELECT NULL.

  • Added variables large_file_support,net_read_timeout, net_write_timeout and query_buffer_size to SHOW VARIABLES.

  • Added status variables created_tmp_files and sort_merge_passes to SHOW STATUS.

  • Fixed a bug where we didn't allow an index name after the FOREIGN KEY definition.

  • Added TRUNCATE table_name as a synonym for DELETE FROM table_name.

  • Fixed a bug in a BDB key compare function when comparing part keys.

  • Added bdb_lock_max variable to mysqld.

  • Added more tests to the benchmark suite.

  • Fixed an overflow bug in the client code when using overly long database names.

  • mysql_connect() now aborts on Linux if the server doesn't answer in timeout seconds.

  • SLAVE START did not work if you started with --skip-slave-start and had not explicitly run CHANGE MASTER TO.

  • Fixed the output of SHOW MASTER STATUS to be consistent with SHOW SLAVE STATUS. (It now has no directory in the log name.)

  • Added PURGE MASTER LOGS TO.

  • Added SHOW MASTER LOGS.

  • Added --safemalloc-mem-limit option to mysqld to simulate memory shortage when compiled with the --with-debug=full option.

  • Fixed several core dumps in out-of-memory conditions.

  • SHOW SLAVE STATUS was using an uninitialised mutex if the slave had not been started yet.

  • Fixed bug in ELT() and MAKE_SET() when the query used a temporary table.

  • CHANGE MASTER TO without specifying MASTER_LOG_POS would set it to 0 instead of 4 and hit the magic number in the master binlog.

  • ALTER TABLE ... ORDER BY ... syntax added. This will create the new table with the rows in a specific order.

D.4.34. Alterações na distribuição 3.23.27 (24 Oct 2000)

  • Fixed a bug where the automatic repair of MyISAM tables sometimes failed when the datafile was corrupt.

  • Fixed a bug in SHOW CREATE when using AUTO_INCREMENT columns.

  • Changed BDB tables to use new compare function in Berkeley DB 3.2.3.

  • You can now use Unix sockets with MIT-pthreads.

  • Added the latin5 (turkish) character set.

  • Small portability fixes.

D.4.35. Alterações na distribuição 3.23.26 (18 Oct 2000)

  • Renamed FLUSH MASTER and FLUSH SLAVE to RESET MASTER and RESET SLAVE.

  • Fixed <> to work properly with NULL.

  • Fixed a problem with SUBSTRING_INDEX() and REPLACE(). (Patch by Alexander Igonitchev)

  • Fix CREATE TEMPORARY TABLE IF NOT EXISTS not to produce an error if the table exists.

  • If you don't create a PRIMARY KEY in a BDB table, a hidden PRIMARY KEY will be created.

  • Added read-only-key optimization to BDB tables.

  • LEFT JOIN in some cases preferred a full table scan when there was no WHERE clause.

  • When using --log-slow-queries, don't count the time waiting for a lock.

  • Fixed bug in lock code on Windows which could cause the key cache to report that the key file was crashed even if it was okay.

  • Automatic repair of MyISAM tables if you start mysqld with --myisam-recover.

  • Removed the TYPE= keyword from CHECK and REPAIR. Allow CHECK options to be combined. (You can still use TYPE=, but this usage is deprecated.)

  • Fixed mutex bug in the binary replication log --- long update queries could be read only in part by the slave if it did it at the wrong time, which was not fatal, but resulted in a performance-degrading reconnect and a scary message in the error log.

  • Changed the format of the binary log --- added magic number, server version, binlog version. Added server ID and query error code for each query event.

  • Replication thread from the slave now will kill all the stale threads from the same server.

  • Long replication user names were not being handled properly.

  • Added --replicate-rewrite-db option to mysqld.

  • Added --skip-slave-start option to mysqld.

  • Updates that generated an error code (such as INSERT INTO foo(some_key) values (1),(1)) erroneously terminated the slave thread.

  • Added optimization of queries where DISTINCT is only used on columns from some of the tables.

  • Allow floating-point numbers where there is no sign after the exponent (like 1e1).

  • SHOW GRANTS didn't always show all column grants.

  • Added --default-extra-file=# option to all MySQL clients.

  • Columns referenced in INSERT statements now are initialised properly.

  • UPDATE didn't always work when used with a range on a timestamp that was part of the key that was used to find rows.

  • Fixed a bug in FULLTEXT index when inserting a NULL column.

  • Changed to use mkstemp() instead of tempnam(). Based on a patch from John Jones.

D.4.36. Alterações na distribuição 3.23.25 (29 Sep 2000)

  • Fixed that databasename works as second argument to mysqlhotcopy.

  • The values for the UMASK and UMASK_DIR environment variables now can be specified in octal by beginning the value with a zero.

  • Added RIGHT JOIN. This makes RIGHT a reserved word.

  • Added @@IDENTITY as a synonym for LAST_INSERT_ID(). (This is for MSSQL compatibility.)

  • Fixed a bug in myisamchk and REPAIR when using FULLTEXT index.

  • LOAD DATA INFILE now works with FIFOs. (Patch by Toni L. Harbaugh-Blackford.)

  • FLUSH LOGS broke replication if you specified a log name with an explicit extension as the value of the log-bin option.

  • Fixed a bug in MyISAM with packed multi-part keys.

  • Fixed crash when using CHECK TABLE on Windows.

  • Fixed a bug where FULLTEXT index always used the koi8_ukr character set.

  • Fixed privilege checking for CHECK TABLE.

  • The MyISAM repair/reindex code didn't use the --tmpdir option for its temporary files.

  • Added BACKUP TABLE and RESTORE TABLE.

  • Fixed core dump on CHANGE MASTER TO when the slave did not have the master to start with.

  • Fixed incorrect Time in the processlist for Connect of the slave thread.

  • The slave now logs when it connects to the master.

  • Fixed a core dump bug when doing FLUSH MASTER if you didn't specify a filename argument to --log-bin.

  • Added missing ha_berkeley.x files to the MySQL Windows distribution.

  • Fixed some mutex bugs in the log code that could cause thread blocks if new log files couldn't be created.

  • Added lock time and number of selected processed rows to slow query log.

  • Added --memlock option to mysqld to lock mysqld in memory on systems with the mlockall() call (as in Solaris).

  • HEAP tables didn't use keys properly. (Bug from 3.23.23.)

  • Added better support for MERGE tables (keys, mapping, creation, documentation...). See Seção 7.2, “Tabelas MERGE.

  • Fixed bug in mysqldump from 3.23 which caused some CHAR columns not to be quoted.

  • Merged analyze, check, optimize and repair code.

  • OPTIMIZE TABLE is now mapped to REPAIR with statistics and sorting of the index tree. This means that for the moment it only works on MyISAM tables.

  • Added a pre-alloced block to root_malloc to get fewer mallocs.

  • Added a lot of new statistics variables.

  • Fixed ORDER BY bug with BDB tables.

  • Removed warning that mysqld couldn't remove the .pid file under Windows.

  • Changed --log-isam to log MyISAM tables instead of isam tables.

  • Fixed CHECK TABLE to work on Windows.

  • Added file mutexes to make pwrite() safe on Windows.

D.4.37. Alterações na distribuição 3.23.24 (08 Sep 2000)

  • Added created_tmp_disk_tables variable to mysqld.

  • To make it possible to reliably dump and restore tables with TIMESTAMP(X) columns, MySQL now reports columns with X other than 14 or 8 to be strings.

  • Changed sort order for latin1 as it was before MySQL Version 3.23.23. Any table that was created or modified with 3.23.22 must be repaired if it has CHAR columns that may contain characters with ASCII values greater than 128!

  • Fixed small memory leak introduced from 3.23.22 when creating a temporary table.

  • Fixed problem with BDB tables and reading on a unique (not primary) key.

  • Restored the win1251 character set (it's now only marked deprecated).

D.4.38. Alterações na distribuição 3.23.23 (01 Sep 2000)

  • Changed sort order for 'German'; all tables created with 'German' sortorder must be repaired with REPAIR TABLE or myisamchk before use!

  • Added --core-file option to mysqld to get a core file on Linux if mysqld dies on the SIGSEGV signal.

  • MySQL client mysql now starts with option --no-named-commands (-g) by default. This option can be disabled with --enable-named-commands (-G). This may cause incompatibility problems in some cases, for example, in SQL scripts that use named commands without a semicolon, etc.! Long format commands still work from the first line.

  • Fixed a problem when using many pending DROP TABLE statements at the same time.

  • Optimizer didn't use keys properly when using LEFT JOIN on an empty table.

  • Added shorter help text when invoking mysqld with incorrect options.

  • Fixed non-fatal free() bug in mysqlimport.

  • Fixed bug in MyISAM index handling of DECIMAL/NUMERIC keys.

  • Fixed a bug in concurrent insert in MyISAM tables. In some contexts, usage of MIN(key_part) or MAX(key_part) returned an empty set.

  • Updated mysqlhotcopy to use the new FLUSH TABLES table_list syntax. Only tables which are being backed up are flushed now.

  • Changed behaviour of --enable-thread-safe-client so that both non-threaded (-lmysqlclient) and threaded (-lmysqlclient_r) libraries are built. Users who linked against a threaded -lmysqlclient will need to link against -lmysqlclient_r now.

  • Added atomic RENAME TABLE command.

  • Don't count NULL values in COUNT(DISTINCT ...).

  • Changed ALTER TABLE, LOAD DATA INFILE on empty tables and INSERT ... SELECT ... on empty tables to create non-unique indexes in a separate batch with sorting. This will make the above calls much faster when you have many indexes.

  • ALTER TABLE now logs the first used insert_id correctly.

  • Fixed crash when adding a default value to a BLOB column.

  • Fixed a bug with DATE_ADD/DATE_SUB where it returned a datetime instead of a date.

  • Fixed a problem with the thread cache which made some threads show up as ***DEAD*** in SHOW PROCESSLIST.

  • Fixed a lock in our thr_rwlock code, which could make selects that run at the same time as concurrent inserts crash. This only affects systems that don't have the pthread_rwlock_rdlock code.

  • When deleting rows with a non-unique key in a HEAP table, all rows weren't always deleted.

  • Fixed bug in range optimiser for HEAP tables for searches on a part index.

  • Fixed SELECT on part keys to work with BDB tables.

  • Fixed INSERT INTO bdb_table ... SELECT to work with BDB tables.

  • CHECK TABLE now updates key statistics for the table.

  • ANALYZE TABLE will now only update tables that have been changed since the last ANALYZE. Note that this is a new feature and tables will not be marked to be analysed until they are updated in any way with 3.23.23 or newer. For older tables, you have to do CHECK TABLE to update the key distribution.

  • Fixed some minor privilege problems with CHECK, ANALYZE, REPAIR and SHOW CREATE commands.

  • Added CHANGE MASTER TO statement.

  • Added FAST, QUICK EXTENDED check types to CHECK TABLES.

  • Changed myisamchk so that --fast and --check-only-changed are also honored with --sort-index and --analyze.

  • Fixed fatal bug in LOAD TABLE FROM MASTER that did not lock the table during index re-build.

  • LOAD DATA INFILE broke replication if the database was excluded from replication.

  • More variables in SHOW SLAVE STATUS and SHOW MASTER STATUS.

  • SLAVE STOP now will not return until the slave thread actually exits.

  • Full-text search via the MATCH() function and FULLTEXT index type (for MyISAM files). This makes FULLTEXT a reserved word.

D.4.39. Alterações na distribuição 3.23.22 (31 Jul 2000)

  • Fixed that lex_hash.h is created properly for each MySQL distribution.

  • Fixed that MASTER and COLLECTION are not reserved words.

  • The log generated by --slow-query-log didn't contain the whole queries.

  • Fixed that open transactions in BDB tables are rolled back if the connection is closed unexpectedly.

  • Added workaround for a bug in gcc 2.96 (intel) and gcc 2.9 (IA-64) in gen_lex_hash.c.

  • Fixed memory leak in the client library when using host= in the my.cnf file.

  • Optimized functions that manipulate the hours/minutes/seconds.

  • Fixed bug when comparing the result of DATE_ADD()/DATE_SUB() against a number.

  • Changed the meaning of -F, --fast for myisamchk. Added -C, --check-only-changed option to myisamchk.

  • Added ANALYZE tbl_name to update key statistics for tables.

  • Changed binary items 0x... to be regarded as integers by default.

  • Fix for SCO and SHOW PROCESSLIST.

  • Added auto-rehash on reconnect for the mysql client.

  • Fixed a newly introduced bug in MyISAM, where the index file couldn't get bigger than 64M.

  • Added SHOW MASTER STATUS and SHOW SLAVE STATUS.

D.4.40. Alterações na distribuição 3.23.21

  • Added mysql_character_set_name() function to the MySQL C API.

  • Made the update log ASCII 0 safe.

  • Added the mysql_config script.

  • Fixed problem when using < or > with a char column that was only partly indexed.

  • One would get a core dump if the log file was not readable by the MySQL user.

  • Changed mysqladmin to use CREATE DATABASE and DROP DATABASE statements instead of the old deprecated API calls.

  • Fixed chown warning in safe_mysqld.

  • Fixed a bug in ORDER BY that was introduced in 3.23.19.

  • Only optimise the DELETE FROM tbl_name to do a drop+create of the table if we are in AUTOCOMMIT mode (needed for BDB tables).

  • Added extra checks to avoid index corruption when the ISAM/MyISAM index files get full during an INSERT/UPDATE.

  • myisamchk didn't correctly update row checksum when used with -ro (this only gave a warning in subsequent runs).

  • Fixed bug in REPAIR TABLE so that it works with tables without indexes.

  • Fixed buffer overrun in DROP DATABASE.

  • LOAD TABLE FROM MASTER is sufficiently bug-free to announce it as a feature.

  • MATCH and AGAINST are now reserved words.

D.4.41. Alterações na distribuição 3.23.20

  • Fixed bug in 3.23.19; DELETE FROM tbl_name removed the .frm file.

  • Added SHOW CREATE TABLE.

D.4.42. Alterações na distribuição 3.23.19

  • Changed copyright for all files to GPL for the server code and utilities and to LGPL for the client libraries. See http://www.fsf.org/licenses/.

  • Fixed bug where all rows matching weren't updated on a MyISAM table when doing update based on key on a table with many keys and some key changed values.

  • The Linux MySQL RPMs and binaries are now statically linked with a linuxthread version that has faster mutex handling when used with MySQL.

  • ORDER BY can now use REF keys to find subsets of the rows that need to be sorted.

  • Changed name of print_defaults program to my_print_defaults to avoid name confusion.

  • Fixed NULLIF() to work as required by SQL-99.

  • Added net_read_timeout and net_write_timeout as startup parameters to mysqld.

  • Fixed bug that destroyed index when doing myisamchk --sort-records on a table with prefix compressed index.

  • Added pack_isam and myisampack to the standard MySQL distribution.

  • Added the syntax BEGIN WORK (the same as BEGIN).

  • Fixed core dump bug when using ORDER BY on a CONV() expression.

  • Added LOAD TABLE FROM MASTER.

  • Added FLUSH MASTER and FLUSH SLAVE.

  • Fixed big/little endian problem in the replication.

D.4.43. Alterações na distribuição 3.23.18

  • Fixed a problem from 3.23.17 when choosing character set on the client side.

  • Added FLUSH TABLES WITH READ LOCK to make a global lock suitable for making a copy of MySQL datafiles.

  • CREATE TABLE ... SELECT ... PROCEDURE now works.

  • Internal temporary tables will now use compressed index when using GROUP BY on VARCHAR/CHAR columns.

  • Fixed a problem when locking the same table with both a READ and a WRITE lock.

  • Fixed problem with myisamchk and RAID tables.

D.4.44. Alterações na distribuição 3.23.17

  • Fixed a bug in FIND_IN_SET() when the first argument was NULL.

  • Added table locks to Berkeley DB.

  • Fixed a bug with LEFT JOIN and ORDER BY where the first table had only one matching row.

  • Added 4 sample my.cnf example files in the support-files directory.

  • Fixed duplicated key problem when doing big GROUP BY operations. (This bug was probably introduced in 3.23.15.)

  • Changed syntax for INNER JOIN to match SQL-99.

  • Added NATURAL JOIN syntax.

  • A lot of fixes in the BDB interface.

  • Added handling of --no-defaults and --defaults-file to safe_mysqld.sh and mysql_install_db.sh.

  • Fixed bug in reading compressed tables with many threads.

  • Fixed that USE INDEX works with PRIMARY keys.

  • Added BEGIN statement to start a transaction in AUTOCOMMIT mode.

  • Added support for symbolic links for Windows.

  • Changed protocol to let client know if the server is in AUTOCOMMIT mode and if there is a pending transaction. If there is a pending transaction, the client library will give an error before reconnecting to the server to let the client know that the server did a rollback. The protocol is still backward-compatible with old clients.

  • KILL now works on a thread that is locked on a 'write' to a dead client.

  • Fixed memory leak in the replication slave thread.

  • Added new log-slave-updates option to mysqld, to allow daisy-chaining the slaves.

  • Fixed compile error on FreeBSD and other systems where pthread_t is not the same as int.

  • Fixed master shutdown aborting the slave thread.

  • Fixed a race condition in INSERT DELAYED code when doing ALTER TABLE.

  • Added deadlock detection sanity checks to INSERT DELAYED.

D.4.45. Alterações na distribuição 3.23.16

  • Added SLAVE START and SLAVE STOP statements.

  • Added TYPE=QUICK option to CHECK and to REPAIR.

  • Fixed bug in REPAIR TABLE when the table was in use by other threads.

  • Added a thread cache to make it possible to debug MySQL with gdb when one does a lot of reconnects. This will also improve systems where you can't use persistent connections.

  • Lots of fixes in the Berkeley DB interface.

  • UPDATE IGNORE will not abort if an update results in a DUPLICATE_KEY error.

  • Put CREATE TEMPORARY TABLE commands in the update log.

  • Fixed bug in handling of masked IP numbers in the privilege tables.

  • Fixed bug with delay_key_write tables and CHECK TABLE.

  • Added replicate-do-db and replicate-ignore-db options to mysqld, to restrict which databases get replicated.

  • Added SQL_LOG_BIN option.

D.4.46. Alterações na distribuição 3.23.15 (May 2000: Beta)

  • To start mysqld as root, you must now use the --user=root option.

  • Added interface to Berkeley DB. (This is not yet functional; play with it at your own risk!)

  • Replication between master and slaves.

  • Fixed bug that other threads could steal a lock when a thread had a lock on a table and did a FLUSH TABLES command.

  • Added the slow_launch_time variable and the Slow_launch_threads status variable to mysqld. These can be examined with mysqladmin variables and mysqladmin extended-status.

  • Added functions INET_NTOA() and INET_ATON().

  • The default type of IF() now depends on the second and third arguments and not only on the second argument.

  • Fixed case when myisamchk could go into a loop when trying to repair a crashed table.

  • Don't write INSERT DELAYED to update log if SQL_LOG_UPDATE=0.

  • Fixed problem with REPLACE on HEAP tables.

  • Added possible character sets and time zone to SHOW VARIABLES output.

  • Fixed bug in locking code that could result in locking problems with concurrent inserts under high load.

  • Fixed a problem with DELETE of many rows on a table with compressed keys where MySQL scanned the index to find the rows.

  • Fixed problem with CHECK on table with deleted keyblocks.

  • Fixed a bug in reconnect (at the client side) where it didn't free memory properly in some contexts.

  • Fixed problems in update log when using LAST_INSERT_ID() to update a table with an AUTO_INCREMENT key.

  • Added NULLIF() function.

  • Fixed bug when using LOAD DATA INFILE on a table with BLOB/TEXT columns.

  • Optimized MyISAM to be faster when inserting keys in sorted order.

  • EXPLAIN SELECT ... now also prints out whether MySQL needs to create a temporary table or use file sorting when resolving the SELECT.

  • Added optimization to skip ORDER BY parts where the part is a constant expression in the WHERE part. Indexes can now be used even if the ORDER BY doesn't match the index exactly, as long as all the unused index parts and all the extra ORDER BY columns are constants in the WHERE clause. See Seção 5.4.3, “Como o MySQL Utiliza Índices”.

  • UPDATE and DELETE on a whole unique key in the WHERE part are now faster than before.

  • Changed RAID_CHUNKSIZE to be in 1024-byte increments.

  • Fixed core dump in LOAD_FILE(NULL).

D.4.47. Alterações na distribuição 3.23.14

  • Added mysql_real_escape_string() function to the MySQL C API.

  • Fixed a bug in CONCAT() where one of the arguments was a function that returned a modified argument.

  • Fixed a critical bug in myisamchk, where it updated the header in the index file when one only checked the table. This confused the mysqld daemon if it updated the same table at the same time. Now the status in the index file is only updated if one uses --update-state. With older myisamchk versions you should use --read-only when only checking tables, if there is the slightest chance that the mysqld server is working on the table at the same time!

  • Fixed that DROP TABLE is logged in the update log.

  • Fixed problem when searching on DECIMAL() key field where the column data contained leading zeros.

  • Fix bug in myisamchk when the AUTO_INCREMENT column isn't the first key.

  • Allow DATETIME in ISO8601 format: 2000-03-12T12:00:00

  • Dynamic character sets. A mysqld binary can now handle many different character sets (you can choose which when starting mysqld).

  • Added command REPAIR TABLE.

  • Added mysql_thread_safe() function to the MySQL C API.

  • Added the UMASK_DIR environment variable.

  • Added CONNECTION_ID() function to return the client connection thread ID.

  • When using = on BLOB or VARCHAR BINARY keys, where only a part of the column was indexed, the whole column of the result row wasn't compared.

  • Fix for sjis character set and ORDER BY.

  • When running in ANSI mode, don't allow columns to be used that aren't in the GROUP BY part.

D.4.48. Alterações na distribuição 3.23.13

  • Fixed problem when doing locks on the same table more than 2 times in the same LOCK TABLE command; this fixed the problem one got when running the test-ATIS test with --fast or --check-only-changed.

  • Added SQL_BUFFER_RESULT option to SELECT.

  • Removed end space from double/float numbers in results from temporary tables.

  • Added CHECK TABLE command.

  • Added changes for MyISAM in 3.23.12 that didn't get into the source distribution because of CVS problems.

  • Fixed bug so that mysqladmin shutdown will wait for the local server to close down.

  • Fixed a possible endless loop when calculating timestamp.

  • Added print_defaults program to the .rpm files. Removed mysqlbug from the client .rpm file.

D.4.49. Alterações na distribuição 3.23.12 (07 Mar 2000)

  • Fixed bug in MyISAM involving REPLACE ... SELECT ... which could give a corrupted table.

  • Fixed bug in myisamchk where it incorrectly reset the AUTO_INCREMENT value.

  • LOTS of patches for Linux Alpha. MySQL now appears to be relatively stable on Alpha.

  • Changed DISTINCT on HEAP temporary tables to use hashed keys to quickly find duplicated rows. This mostly concerns queries of type SELECT DISTINCT ... GROUP BY .... This fixes a problem where not all duplicates were removed in queries of the above type. In addition, the new code is MUCH faster.

  • Added patches to make MySQL compile on Mac OS X.

  • Added IF NOT EXISTS clause to CREATE DATABASE.

  • Added --all-databases and --databases options to mysqldump to allow dumping of many databases at the same time.

  • Fixed bug in compressed DECIMAL() index in MyISAM tables.

  • Fixed bug when storing 0 into a timestamp.

  • When doing mysqladmin shutdown on a local connection, mysqladmin now waits until the PID file is gone before terminating.

  • Fixed core dump with some COUNT(DISTINCT ...) queries.

  • Fixed that myisamchk works properly with RAID tables.

  • Fixed problem with LEFT JOIN and key_field IS NULL.

  • Fixed bug in net_clear() which could give the error Aborted connection in the MySQL clients.

  • Added options USE INDEX (key_list) and IGNORE INDEX (key_list) as parameters in SELECT.

  • DELETE and RENAME should now work on RAID tables.

D.4.50. Alterações na distribuição 3.23.11

  • Allow the ALTER TABLE tbl_name ADD (field_list) syntax.

  • Fixed problem with optimiser that could sometimes use incorrect keys.

  • Fixed that GRANT/REVOKE ALL PRIVILEGES doesn't affect GRANT OPTION.

  • Removed extra ‘)’ from the output of SHOW GRANTS.

  • Fixed problem when storing numbers in timestamps.

  • Fix problem with timezones that have half hour offsets.

  • Allow the syntax UNIQUE INDEX in CREATE statements.

  • mysqlhotcopy - fast online hot-backup utility for local MySQL databases. By Tim Bunce.

  • New more secure mysqlaccess. Thanks to Steve Harvey for this.

  • Added --i-am-a-dummy and --safe-updates options to mysql.

  • Added select_limit and max_join_size variables to mysql.

  • Added SQL_MAX_JOIN_SIZE and SQL_SAFE_UPDATES options.

  • Added READ LOCAL lock that doesn't lock the table for concurrent inserts. (This is used by mysqldump.)

  • Changed that LOCK TABLES ... READ doesn't anymore allow concurrent inserts.

  • Added --skip-delay-key-write option to mysqld.

  • Fixed security problem in the protocol regarding password checking.

  • _rowid can now be used as an alias for an integer type unique indexed column.

  • Added back blocking of SIGPIPE when compiling with --thread-safe-clients to make things safe for old clients.

D.4.51. Alterações na distribuição 3.23.10

  • Fixed bug in 3.23.9 where memory wasn't properly freed when using LOCK TABLES.

D.4.52. Alterações na distribuição 3.23.9

  • Fixed problem that affected queries that did arithmetic on group functions.

  • Fixed problem with timestamps and INSERT DELAYED.

  • Fixed that date_col BETWEEN const_date AND const_date works.

  • Fixed problem when only changing a 0 to NULL in a table with BLOB/TEXT columns.

  • Fixed bug in range optimiser when using many key parts and or on the middle key parts: WHERE K1=1 and K3=2 and (K2=2 and K4=4 or K2=3 and K4=5)

  • Added source command to mysql to allow reading of batch files inside the mysql client. Original patch by Matthew Vanecek.

  • Fixed critical problem with the WITH GRANT OPTION option.

  • Don't give an unnecessary GRANT error when using tables from many databases in the same query.

  • Added VIO wrapper (needed for SSL support; by Andrei Errapart and Tõnu Samuel).

  • Fixed optimiser problem on SELECT when using many overlapping indexes. MySQL should now be able to choose keys even better when there are many keys to choose from.

  • Changed optimiser to prefer a range key instead of a ref key when the range key can uses more columns than the ref key (which only can use columns with =). For example, the following type of queries should now be faster: SELECT * from key_part_1=const and key_part_2 > const2

  • Fixed bug that a change of all VARCHAR columns to CHAR columns didn't change row type from dynamic to fixed.

  • Disabled floating-point exceptions for FreeBSD to fix core dump when doing SELECT FLOOR(POW(2,63)).

  • Renamed mysqld startup option from --delay-key-write to --delay-key-write-for-all-tables.

  • Added read-next-on-key to HEAP tables. This should fix all problems with HEAP tables when using non-UNIQUE keys.

  • Added option to print default arguments to all clients.

  • Added --log-slow-queries option to mysqld to log all queries that take a long time to a separate log file with a time indicating how long the query took.

  • Fixed core dump when doing WHERE key_col=RAND(...).

  • Fixed optimization bug in SELECT ... LEFT JOIN ... key_col IS NULL, when key_col could contain NULL values.

  • Fixed problem with 8-bit characters as separators in LOAD DATA INFILE.

D.4.53. Alterações na distribuição 3.23.8 (02 Jan 2000)

  • Fixed problem when handling indexfiles larger than 8G.

  • Added latest patches to MIT-pthreads for NetBSD.

  • Fixed problem with timezones that are < GMT - 11.

  • Fixed a bug when deleting packed keys in NISAM.

  • Fixed problem with ISAM when doing some ORDER BY ... DESC queries.

  • Fixed bug when doing a join on a text key which didn't cover the whole key.

  • Option --delay-key-write didn't enable delayed key writing.

  • Fixed update of TEXT column which involved only case changes.

  • Fixed that INSERT DELAYED doesn't update timestamps that are given.

  • Added function YEARWEEK() and options x, X, v and V to DATE_FORMAT().

  • Fixed problem with MAX(indexed_column) and HEAP tables.

  • Fixed problem with BLOB NULL keys and LIKE "prefix%".

  • Fixed problem with MyISAM and fixed-length rows < 5 bytes.

  • Fixed problem that could cause MySQL to touch freed memory when doing very complicated GROUP BY queries.

  • Fixed core dump if you got a crashed table where an ENUM field value was too big.

D.4.54. Alterações na distribuição 3.23.7 (10 Dec 1999)

  • Fixed workaround under Linux to avoid problems with pthread_mutex_timedwait, which is used with INSERT DELAYED. See Seção 2.6.2, “Notas Linux (Todas as versões)”.

  • Fixed that one will get a 'disk full' error message if one gets disk full when doing sorting (instead of waiting until we got more disk space).

  • Fixed a bug in MyISAM with keys > 250 characters.

  • In MyISAM one can now do an INSERT at the same time as other threads are reading from the table.

  • Added max_write_lock_count variable to mysqld to force a READ lock after a certain number of WRITE locks.

  • Inverted flag delay_key_write on show variables.

  • Renamed concurrency variable to thread_concurrency.

  • The following functions are now multi-byte-safe: LOCATE(substr,str), POSITION(substr IN str), LOCATE(substr,str,pos), INSTR(str,substr), LEFT(str,len), RIGHT(str,len), SUBSTRING(str,pos,len), SUBSTRING(str FROM pos FOR len), MID(str,pos,len), SUBSTRING(str,pos), SUBSTRING(str FROM pos), SUBSTRING_INDEX(str,delim,count), RTRIM(str), TRIM([[BOTH | TRAILING] [remstr] FROM] str), REPLACE(str,from_str,to_str), REVERSE(str), INSERT(str,pos,len,newstr), LCASE(str), LOWER(str), UCASE(str) and UPPER(str); patch by Wei He.

  • Fix core dump when releasing a lock from a non-existent table.

  • Remove locks on tables before starting to remove duplicates.

  • Added option FULL to SHOW PROCESSLIST.

  • Added option --verbose to mysqladmin.

  • Fixed problem when automatically converting HEAP to MyISAM.

  • Fixed bug in HEAP tables when doing insert + delete + insert + scan the table.

  • Fixed bugs on Alpha with REPLACE() and LOAD DATA INFILE.

  • Added interactive_timeout variable to mysqld.

  • Changed the argument to mysql_data_seek() from ulong to ulonglong.

D.4.55. Alterações na distribuição 3.23.6

  • Added -O lower_case_table_names={0|1} option to mysqld to allow users to force table names to lowercase.

  • Added SELECT ... INTO DUMPFILE.

  • Added --ansi option to mysqld to make some functions SQL-99 compatible.

  • Temporary table names now start with #sql.

  • Added quoting of identifiers with ` (" in --ansi mode).

  • Changed to use snprintf() when printing floats to avoid some buffer overflows on FreeBSD.

  • Made FLOOR() overflow safe on FreeBSD.

  • Added --quote-names option to mysqldump.

  • Fixed bug that one could make a part of a PRIMARY KEY NOT NULL.

  • Fixed encrypt() to be thread-safe and not reuse buffer.

  • Added mysql_odbc_escape_string() function to support big5 characters in MyODBC.

  • Rewrote the storage engine to use classes. This introduces a lot of new code, but will make table handling faster and better.

  • Added patch by Sasha for user-defined variables.

  • Changed that FLOAT and DOUBLE (without any length modifiers) no longer are fixed decimal point numbers.

  • Changed the meaning of FLOAT(X): Now this is the same as FLOAT if X <= 24 and a DOUBLE if 24 < X <= 53.

  • DECIMAL(X) is now an alias for DECIMAL(X,0) and DECIMAL is now an alias for DECIMAL(10,0). The same goes for NUMERIC.

  • Added option ROW_FORMAT={default | dynamic | fixed | compressed} to CREATE_TABLE.

  • DELETE FROM table_name didn't work on temporary tables.

  • Changed function CHAR_LENGTH() to be multi-byte character safe.

  • Added function ORD(string).

D.4.56. Alterações na distribuição 3.23.5 (20 Oct 1999)

  • Fixed some Y2K problems in the new date handling in 3.23.

  • Fixed problem with SELECT DISTINCT ... ORDER BY RAND().

  • Added patches by Sergei A. Golubchik for text searching on the MyISAM level.

  • Fixed cache overflow problem when using full joins without keys.

  • Fixed some configure issues.

  • Some small changes to make parsing faster.

  • Adding a column after the last field with ALTER TABLE didn't work.

  • Fixed problem when using an AUTO_INCREMENT column in two keys

  • With MyISAM, you now can have an AUTO_INCREMENT column as a key sub part: CREATE TABLE foo (a INT NOT NULL AUTO_INCREMENT, b CHAR(5), PRIMARY KEY (b,a))

  • Fixed bug in MyISAM with packed char keys that could be NULL.

  • AS on field name with CREATE TABLE table_name SELECT ... didn't work.

  • Allow use of NATIONAL and NCHAR when defining character columns. This is the same as not using BINARY.

  • Don't allow NULL columns in a PRIMARY KEY (only in UNIQUE keys).

  • Clear LAST_INSERT_ID() if one uses this in ODBC: WHERE auto_increment_column IS NULL. This seems to fix some problems with Access.

  • SET SQL_AUTO_IS_NULL=0|1 now turns on/off the handling of searching after the last inserted row with WHERE auto_increment_column IS NULL.

  • Added new variable concurrency to mysqld for Solaris.

  • Added --relative option to mysqladmin to make extended-status more useful to monitor changes.

  • Fixed bug when using COUNT(DISTINCT ...) on an empty table.

  • Added support for the Chinese character set GBK.

  • Fixed problem with LOAD DATA INFILE and BLOB columns.

  • Added bit operator ~ (negation).

  • Fixed problem with UDF functions.

D.4.57. Alterações na distribuição 3.23.4 (28 Sep 1999)

  • Inserting a DATETIME into a TIME column no longer will 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 a user a GRANT option for a database, he couldn't grant privileges to other users.

  • New command: 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 filesystem detection.

  • REGEXP is now case-insensitive if you use non-binary strings.

D.4.58. Alterações na distribuição 3.23.3

  • Added patches for MIT-pthreads on NetBSD.

  • Fixed range bug in MyISAM.

  • ASC is now the default again for ORDER BY.

  • Added LIMIT to UPDATE.

  • Added mysql_change_user() function to the MySQL C API.

  • Added character set to SHOW VARIABLES.

  • Added support of --[whitespace] comments.

  • Allow INSERT into tbl_name VALUES (), that is, you may now specify an empty value list to insert a row in which each column is set to its default value.

  • Changed SUBSTRING(text FROM pos) to conform to SQL-99. (Before this construct returned the rightmost pos characters.)

  • SUM() with GROUP BY returned 0 on some systems.

  • Changed output for SHOW TABLE STATUS.

  • Added DELAY_KEY_WRITE option to CREATE TABLE.

  • Allow AUTO_INCREMENT on any key part.

  • Fixed problem with YEAR(NOW()) and YEAR(CURDATE()).

  • Added CASE construct.

  • New function COALESCE().

D.4.59. Alterações na distribuição 3.23.2 (09 Aug 1999)

  • Fixed range optimiser bug: SELECT * FROM table_name WHERE key_part1 >= const AND (key_part2 = const OR key_part2 = const). The bug was that some rows could be duplicated in the result.

  • Running myisamchk without -a updated the index distribution incorrectly.

  • SET SQL_LOW_PRIORITY_UPDATES=1 was causing a parse error.

  • You can now update index columns that are used in the WHERE clause. UPDATE tbl_name SET KEY=KEY+1 WHERE KEY > 100

  • Date handling should now be a bit faster.

  • Added handling of fuzzy dates (dates where day or month is 0), such as '1999-01-00'.

  • Fixed optimization of SELECT ... WHERE key_part1=const1 AND key_part_2=const2 AND key_part1=const4 AND key_part2=const4; indextype should be range instead of ref.

  • Fixed egcs 1.1.2 optimiser bug (when using BLOB values) on Linux Alpha.

  • Fixed problem with LOCK TABLES combined with DELETE FROM table.

  • MyISAM tables now allow keys on NULL and BLOB/TEXT columns.

  • The following join is now much faster: SELECT ... FROM t1 LEFT JOIN t2 ON ... WHERE t2.not_null_column IS NULL.

  • ORDER BY and GROUP BY can be done on functions.

  • Changed handling of 'const_item' to allow handling of ORDER BY RAND().

  • Indexes are now used for WHERE key_column = function.

  • Indexes are now used for WHERE key_column = col_name even if the columns are not identically packed.

  • Indexes are now used for WHERE col_name IS NULL.

  • Changed heap tables to be stored in low_byte_first order (to make it easy to convert to MyISAM tables)

  • Automatic change of HEAP temporary tables to MyISAM tables in case of ``table is full'' errors.

  • Added --init-file=file_name option to mysqld.

  • Added COUNT(DISTINCT value, [value, ...]).

  • CREATE TEMPORARY TABLE now creates a temporary table, in its own namespace, that is automatically deleted if connection is dropped.

  • New reserved words (required for CASE): CASE, THEN, WHEN, ELSE and END.

  • New functions EXPORT_SET() and MD5().

  • Support for the GB2312 Chinese character set.

D.4.60. Alterações na distribuição 3.23.1

  • Fixed some compilation problems.

D.4.61. Alterações na distribuição 3.23.0 (05 Aug 1999: Alpha)

  • A new storage engine library (MyISAM) with a lot of new features. See Seção 7.1, “Tabelas MyISAM.

  • You can create in-memory HEAP tables which are extremely fast for lookups.

  • Support for big files (63-bit) on OSs that support big files.

  • New function LOAD_FILE(filename) to get the contents of a file as a string value.

  • New operator <=> which will act as = but will return TRUE if both arguments are NULL. This is useful for comparing changes between tables.

  • Added the ODBC 3.0 EXTRACT(interval FROM datetime) function.

  • Columns defined as FLOAT(X) are not rounded on storage and may be in scientific notation (1.0 E+10) when retrieved.

  • REPLACE is now faster than before.

  • Changed LIKE character comparison to behave as =; This means that 'e' LIKE 'é' is now true. (If the line doesn't display correctly, the latter 'e' is a French 'e' with a dot above.)

  • SHOW TABLE STATUS returns a lot of information about the tables.

  • Added LIKE to the SHOW STATUS command.

  • Added Privileges column to SHOW COLUMNS.

  • Added Packed and Comment columns to SHOW INDEX.

  • Added comments to tables (with CREATE TABLE ... COMMENT "xxx").

  • Added UNIQUE, as in CREATE TABLE table_name (col INT not null UNIQUE)

  • New create syntax: CREATE TABLE table_name SELECT ...

  • New create syntax: CREATE TABLE IF NOT EXISTS ...

  • Allow creation of CHAR(0) columns.

  • DATE_FORMAT() now requires ‘%’ before any format character.

  • DELAYED is now a reserved word (sorry about that :( ).

  • An example procedure is added: analyse, file: sql_analyse.c. This will describe the data in your query. Try the following:

    SELECT ... FROM ...
    WHERE ... PROCEDURE ANALYSE([max elements,[max memory]])
    

    This procedure is extremely useful when you want to check the data in your table!

  • BINARY cast to force a string to be compared in case-sensitive fashion.

  • Added --skip-show-database option to mysqld.

  • Check whether a row has changed in an UPDATE now also works with BLOB/TEXT columns.

  • Added the INNER join syntax. NOTE: This made INNER a reserved word!

  • Added support for netmasks to the hostname in the MySQL grant tables. You can specify a netmask using the IP/NETMASK syntax.

  • If you compare a NOT NULL DATE/DATETIME column with IS NULL, this is changed to a compare against 0 to satisfy some ODBC applications. (By .)

  • NULL IN (...) now returns NULL instead of 0. This will ensure that null_column NOT IN (...) doesn't match NULL values.

  • Fix storage of floating-point values in TIME columns.

  • Changed parsing of TIME strings to be more strict. Now the fractional second part is detected (and currently skipped). The following formats are supported:

    • [[DAYS] [H]H:]MM:]SS[.fraction]

    • [[[[[H]H]H]H]MM]SS[.fraction]

  • Detect (and ignore) fractional second part from DATETIME.

  • Added the LOW_PRIORITY attribute to LOAD DATA INFILE.

  • The default index name now uses the same case as the column name on which the index name is based.

  • Changed default number of connections to 100.

  • Use bigger buffers when using LOAD DATA INFILE.

  • DECIMAL(x,y) now works according to SQL-99.

  • Added aggregate UDF functions. Thanks to Andreas F. Bobak () for this!

  • LAST_INSERT_ID() is now updated for INSERT INTO ... SELECT.

  • Some small changes to the join table optimiser to make some joins faster.

  • SELECT DISTINCT is much faster; it uses the new UNIQUE functionality in MyISAM. One difference compared to MySQL Version 3.22 is that the output of DISTINCT is no longer sorted.

  • All C client API macros are now functions to make shared libraries more reliable. Because of this, you can no longer call mysql_num_fields() on a MYSQL object, you must use mysql_field_count() instead.

  • Added use of LIBWRAP; patch by Henning P. Schmiedehausen.

  • Don't allow AUTO_INCREMENT for other than numerical columns.

  • Using AUTO_INCREMENT will now automatically make the column NOT NULL.

  • Show NULL as the default value for AUTO_INCREMENT columns.

  • Added SQL_BIG_RESULT; SQL_SMALL_RESULT is now default.

  • Added a shared library RPM. This enhancement was contributed by David Fox ().

  • Added --enable-large-files and --disable-large-files switches to configure. See configure.in for some systems where this is automatically turned off because of broken implementations.

  • Upgraded readline to 4.0.

  • New CREATE TABLE options: PACK_KEYS and CHECKSUM.

  • Added --default-table-type option to mysqld.

D.5. Alterações na distribuição 3.22.x (Old; discontinued)

D.5.1. Alterações na distribuição 3.22.35
D.5.2. Alterações na distribuição 3.22.34
D.5.3. Alterações na distribuição 3.22.33
D.5.4. Alterações na distribuição 3.22.32 (14 Feb 2000)
D.5.5. Alterações na distribuição 3.22.31
D.5.6. Alterações na distribuição 3.22.30
D.5.7. Alterações na distribuição 3.22.29 (02 Jan 2000)
D.5.8. Alterações na distribuição 3.22.28 (20 Oct 1999)
D.5.9. Alterações na distribuição 3.22.27
D.5.10. Alterações na distribuição 3.22.26 (16 Sep 1999)
D.5.11. Alterações na distribuição 3.22.25
D.5.12. Alterações na distribuição 3.22.24 (05 Jul 1999)
D.5.13. Alterações na distribuição 3.22.23 (08 Jun 1999)
D.5.14. Alterações na distribuição 3.22.22 (30 Apr 1999)
D.5.15. Alterações na distribuição 3.22.21
D.5.16. Alterações na distribuição 3.22.20 (18 Mar 1999)
D.5.17. Alterações na distribuição 3.22.19 (Mar 1999: Production)
D.5.18. Alterações na distribuição 3.22.18
D.5.19. Alterações na distribuição 3.22.17
D.5.20. Alterações na distribuição 3.22.16 (Feb 1999: Gamma)
D.5.21. Alterações na distribuição 3.22.15
D.5.22. Alterações na distribuição 3.22.14
D.5.23. Alterações na distribuição 3.22.13
D.5.24. Alterações na distribuição 3.22.12
D.5.25. Alterações na distribuição 3.22.11
D.5.26. Alterações na distribuição 3.22.10
D.5.27. Alterações na distribuição 3.22.9
D.5.28. Alterações na distribuição 3.22.8
D.5.29. Alterações na distribuição 3.22.7 (Sep 1998: Beta)
D.5.30. Alterações na distribuição 3.22.6
D.5.31. Alterações na distribuição 3.22.5
D.5.32. Alterações na distribuição 3.22.4
D.5.33. Alterações na distribuição 3.22.3
D.5.34. Alterações na distribuição 3.22.2
D.5.35. Alterações na distribuição 3.22.1 (Jun 1998: Alpha)
D.5.36. Alterações na distribuição 3.22.0

The 3.22 version has faster and safer connect code than version 3.21, as well as a lot of new nice enhancements. As there aren't really any major changes, upgrading from 3.21 to 3.22 should be very easy and painless. Veja mais informações sobre isto na Seção 2.5.4, “Atualizando da versão 3.21 para 3.22”.

D.5.1. Alterações na distribuição 3.22.35

  • Fixed problem with STD().

  • Merged changes from the newest ISAM library from 3.23.

  • Fixed problem with INSERT DELAYED.

  • Fixed a bug core dump when using a LEFT JOIN/STRAIGHT_JOIN on a table with only one row.

D.5.2. Alterações na distribuição 3.22.34

  • Fixed problem with GROUP BY on TINYBLOB columns; this caused bugzilla to not show rows in some queries.

  • Had to do total recompile of the Windows binary version as VC++ didn't compile all relevant files for 3.22.33 :(

D.5.3. Alterações na distribuição 3.22.33

  • Fixed problems in Windows when locking tables with LOCK TABLE.

  • Quicker kill of SELECT DISTINCT queries.

D.5.4. Alterações na distribuição 3.22.32 (14 Feb 2000)

  • Fixed problem when storing numbers in timestamps.

  • Fix problem with timezones that have half hour offsets.

  • Added mysqlhotcopy, a fast online hot-backup utility for local MySQL databases. By Tim Bunce.

  • New more secure mysqlaccess. Thanks to Steve Harvey for this.

  • Fixed security problem in the protocol regarding password checking.

  • Fixed problem that affected queries that did arithmetic on GROUP functions.

  • Fixed a bug in the ISAM code when deleting rows on tables with packed indexes.

D.5.5. Alterações na distribuição 3.22.31

  • A few small fixes for the Windows version.

D.5.6. Alterações na distribuição 3.22.30

  • Fixed optimiser problem on SELECT when using many overlapping indexes.

  • Disabled floating-point exceptions for FreeBSD to fix core dump when doing SELECT FLOOR(POW(2,63)).

  • Added print of default arguments options to all clients.

  • Fixed critical problem with the WITH GRANT OPTION option.

  • Fixed non-critical Y2K problem when writing short date to log files.

D.5.7. Alterações na distribuição 3.22.29 (02 Jan 2000)

  • Upgraded the configure and include files to match the latest 3.23 version. This should increase portability and make it easier to build shared libraries.

  • Added latest patches to MIT-pthreads for NetBSD.

  • Fixed problem with timezones that are < GMT -11.

  • Fixed a bug when deleting packed keys in NISAM.

  • Fixed problem that could cause MySQL to touch freed memory when doing very complicated GROUP BY queries.

  • Fixed core dump if you got a crashed table where an ENUM field value was too big.

  • Added mysqlshutdown.exe and mysqlwatch.exe to the Windows distribution.

  • Fixed problem when doing ORDER BY on a reference key.

  • Fixed that INSERT DELAYED doesn't update timestamps that are given.

D.5.8. Alterações na distribuição 3.22.28 (20 Oct 1999)

  • Fixed problem with LEFT JOIN and COUNT() on a column which was declared NULL + and it had a DEFAULT value.

  • Fixed core dump problem when using CONCAT() in a WHERE clause.

  • Fixed problem with AVG() and STD() with NULL values.

D.5.9. Alterações na distribuição 3.22.27

  • Fixed prototype in my_ctype.h when using other character sets.

  • Some configure issues to fix problems with big filesystem detection.

  • Fixed problem when sorting on big BLOB columns.

  • ROUND() will now work on Windows.

D.5.10. Alterações na distribuição 3.22.26 (16 Sep 1999)

  • Fixed core dump with empty BLOB/TEXT column argument to REVERSE().

  • Extended /*! */ with version numbers.

  • Changed SUBSTRING(text FROM pos) to conform to SQL-99. (Before this construct returned the rightmost 'pos' characters.)

  • Fixed problem with LOCK TABLES combined with DELETE FROM table

  • Fixed problem that INSERT ... SELECT didn't use BIG_TABLES.

  • SET SQL_LOW_PRIORITY_UPDATES=# didn't work.

  • Password wasn't updated correctly if privileges didn't change on: GRANT ... IDENTIFIED BY

  • Fixed range optimiser bug in SELECT * FROM table_name WHERE key_part1 >= const AND (key_part2 = const OR key_part2 = const).

  • Fixed bug in compression key handling in ISAM.

D.5.11. Alterações na distribuição 3.22.25

  • Fixed some small problems with the installation.

D.5.12. Alterações na distribuição 3.22.24 (05 Jul 1999)

  • DATA is no longer a reserved word.

  • Fixed optimiser bug with tables with only one row.

  • Fixed bug when using LOCK TABLES table_name READ; FLUSH TABLES;

  • Applied some patches for HP-UX.

  • isamchk should now work on Windows.

  • Changed configure to not use big file handling on Linux as this crashes some Red Hat 6.0 systems

D.5.13. Alterações na distribuição 3.22.23 (08 Jun 1999)

  • Upgraded to use Autoconf 2.13, Automake 1.4 and libtool 1.3.2.

  • Better support for SCO in configure.

  • Added option --defaults-file=file_name to option file handling to force use of only one specific option file.

  • Extended CREATE syntax to ignore MySQL Version 3.23 keywords.

  • Fixed deadlock problem when using INSERT DELAYED on a table locked with LOCK TABLES.

  • Fixed deadlock problem when using DROP TABLE on a table that was locked by another thread.

  • Add logging of GRANT/REVOKE commands in the update log.

  • Fixed isamchk to detect a new error condition.

  • Fixed bug in NATURAL LEFT JOIN.

D.5.14. Alterações na distribuição 3.22.22 (30 Apr 1999)

  • Fixed problem in the C API when you called mysql_close() directly after mysql_init().

  • Better client error message when you can't open socket.

  • Fixed delayed_insert_thread counting when you couldn't create a new delayed_insert thread.

  • Fixed bug in CONCAT() with many arguments.

  • Added patches for DEC 3.2 and SCO.

  • Fixed path-bug when installing MySQL as a service on NT.

  • MySQL on Windows is now compiled with VC++ 6.0 instead of with VC++ 5.0.

  • New installation setup for MySQL on Windows.

D.5.15. Alterações na distribuição 3.22.21

  • Fixed problem with DELETE FROM TABLE when table was locked by another thread.

  • Fixed bug in LEFT JOIN involving empty tables.

  • Changed the mysql.db column from CHAR(32) to CHAR(60).

  • MODIFY and DELAYED are no longer reserved words.

  • Fixed a bug when storing days in a TIME column.

  • Fixed a problem with Host '...' is not allowed to connect to this MySQL server after one had inserted a new MySQL user with a GRANT command.

  • Changed to use TCP_NODELAY also on Linux (should give faster TCP/IP connections).

D.5.16. Alterações na distribuição 3.22.20 (18 Mar 1999)

  • Fixed STD() for big tables when result should be 0.

  • The update log didn't have newlines on some operating systems.

  • INSERT DELAYED had some garbage at end in the update log.

D.5.17. Alterações na distribuição 3.22.19 (Mar 1999: Production)

  • Fixed bug in mysql_install_db (from 3.22.17).

  • Changed default key cache size to 8M.

  • Fixed problem with queries that needed temporary tables with BLOB columns.

D.5.18. Alterações na distribuição 3.22.18

  • Fixes a fatal problem in 3.22.17 on Linux; after shutdown not all threads died properly.

  • Added option -O flush_time=# to mysqld. This is mostly useful on Windows and tells how often MySQL should close all unused tables and flush all updated tables to disk.

  • Fixed problem that a VARCHAR column compared with CHAR column didn't use keys efficiently.

D.5.19. Alterações na distribuição 3.22.17

  • Fixed a core dump problem when using --log-update and connecting without a default database.

  • Fixed some configure and portability problems.

  • Using LEFT JOIN on tables that had circular dependencies caused mysqld to hang forever.

D.5.20. Alterações na distribuição 3.22.16 (Feb 1999: Gamma)

  • mysqladmin processlist could kill the server if a new user logged in.

  • DELETE FROM tbl_name WHERE key_column=col_name didn't find any matching rows. Fixed.

  • DATE_ADD(column, ...) didn't work.

  • INSERT DELAYED could deadlock with status 'upgrading lock'

  • Extended ENCRYPT() to take longer salt strings than 2 characters.

  • longlong2str is now much faster than before. For Intel x86 platforms, this function is written in optimised assembler.

  • Added the MODIFY keyword to ALTER TABLE.

D.5.21. Alterações na distribuição 3.22.15

  • GRANT used with IDENTIFIED BY didn't take effect until privileges were flushed.

  • Name change of some variables in SHOW STATUS.

  • Fixed problem with ORDER BY with 'only index' optimization when there were multiple key definitions for a used column.

  • DATE and DATETIME columns are now up to 5 times faster than before.

  • INSERT DELAYED can be used to let the client do other things while the server inserts rows into a table.

  • LEFT JOIN USING (col1,col2) didn't work if one used it with tables from 2 different databases.

  • LOAD DATA LOCAL INFILE didn't work in the Unix version because of a missing file.

  • Fixed problems with VARCHAR/BLOB on very short rows (< 4 bytes); error 127 could occur when deleting rows.

  • Updating BLOB/TEXT through formulas didn't work for short (< 256 char) strings.

  • When you did a GRANT on a new host, mysqld could die on the first connect from this host.

  • Fixed bug when one used ORDER BY on column name that was the same name as an alias.

  • Added BENCHMARK(loop_count,expression) function to time expressions.

D.5.22. Alterações na distribuição 3.22.14

  • Allow empty arguments to mysqld to make it easier to start from shell scripts.

  • Setting a TIMESTAMP column to NULL didn't record the timestamp value in the update log.

  • Fixed lock handler bug when one did INSERT INTO TABLE ... SELECT ... GROUP BY.

  • Added a patch for localtime_r() on Windows so that it will no lonher crash if your date is > 2039, but instead will return a time of all zero.

  • Names for user-defined functions are no longer case-sensitive.

  • Added escape of ^Z (ASCII 26) to \Z as ^Z doesn't work with pipes on Windows.

  • mysql_fix_privileges adds a new column to the mysql.func to support aggregate UDF functions in future MySQL releases.

D.5.23. Alterações na distribuição 3.22.13

  • Saving NOW(), CURDATE() or CURTIME() directly in a column didn't work.

  • SELECT COUNT(*) ... LEFT JOIN ... didn't work with no WHERE part.

  • Updated config.guess to allow MySQL to configure on UnixWare 7.1.x.

  • Changed the implementation of pthread_cond() on the Windows version. get_lock() now correctly times out on Windows!

D.5.24. Alterações na distribuição 3.22.12

  • Fixed problem when using DATE_ADD() and DATE_SUB() in a WHERE clause.

  • You can now set the password for a user with the GRANT ... TO user IDENTIFIED BY 'password' syntax.

  • Fixed bug in GRANT checking with SELECT on many tables.

  • Added missing file mysql_fix_privilege_tables to the RPM distribution. This is not run by default because it relies on the client package.

  • Added option SQL_SMALL_RESULT to SELECT to force use of fast temporary tables when you know that the result set will be small.

  • Allow use of negative real numbers without a decimal point.

  • Day number is now adjusted to maximum days in month if the resulting month after DATE_ADD/DATE_SUB() doesn't have enough days.

  • Fix that GRANT compares columns in case-insensitive fashion.

  • Fixed a bug in sql_list.h that made ALTER TABLE dump core in some contexts.

  • The hostname in user@hostname can now include ‘.’ and ‘-’ without quotes in the context of the GRANT, REVOKE and SET PASSWORD FOR ... statements.

  • Fix for isamchk for tables which need big temporary files.

D.5.25. Alterações na distribuição 3.22.11

  • Important: You must run the mysql_fix_privilege_tables script when you upgrade to this version! This is needed because of the new GRANT system. If you don't do this, you will get Access denied when you try to use ALTER TABLE, CREATE INDEX, or DROP INDEX.

  • GRANT to allow/deny users table and column access.

  • Changed USER() to return a value in user@host format. Formerly it returned only user.

  • Changed the syntax for how to set PASSWORD for another user.

  • New command FLUSH STATUS that resets most status variables to zero.

  • New status variables: aborted_threads, aborted_connects.

  • New option variable: connection_timeout.

  • Added support for Thai sorting (by Pruet Boonma ).

  • Slovak and Japanese error messages.

  • Configuration and portability fixes.

  • Added option SET SQL_WARNINGS=1 to get a warning count also for simple (single-row) inserts.

  • MySQL now uses SIGTERM instead of SIGQUIT with shutdown to work better on FreeBSD.

  • Added option \G (print vertically) to mysql.

  • SELECT HIGH_PRIORITY ... killed mysqld.

  • IS NULL on a AUTO_INCREMENT column in a LEFT JOIN didn't work as expected.

  • New function MAKE_SET().

D.5.26. Alterações na distribuição 3.22.10

  • mysql_install_db no longer starts the MySQL server! You should start mysqld with safe_mysqld after installing it! The MySQL RPM will, however, start the server as before.

  • Added --bootstrap option to mysqld and recoded mysql_install_db to use it. This will make it easier to install MySQL with RPMs.

  • Changed +, - (sign and minus), *, /, %, ABS() and MOD() to be BIGINT aware (64-bit safe).

  • Fixed a bug in ALTER TABLE that caused mysqld to crash.

  • MySQL now always reports the conflicting key values when a duplicate key entry occurs. (Before this was only reported for INSERT.)

  • New syntax: INSERT INTO tbl_name SET col_name=value, col_name=value, ...

  • Most errors in the .err log are now prefixed with a time stamp.

  • Added option MYSQL_INIT_COMMAND to mysql_options() to make a query on connect or reconnect.

  • Added option MYSQL_READ_DEFAULT_FILE and MYSQL_READ_DEFAULT_GROUP to mysql_options() to read the following parameters from the MySQL option files: port, socket, compress, password, pipe, timeout, user, init-command, host and database.

  • Added maybe_null to the UDF structure.

  • Added option IGNORE to INSERT statements with many rows.

  • Fixed some problems with sorting of the koi8 character sets; users of koi8 must run isamchk -rq on each table that has an index on a CHAR or VARCHAR column.

  • New script mysql_setpermission, by Luuk de Boer. It allows easy creation of new users with permissions for specific databases.

  • Allow use of hexadecimal strings (0x...) when specifying a constant string (like in the column separators with LOAD DATA INFILE).

  • Ported to OS/2 (thanks to Antony T. Curtis ).

  • Added more variables to SHOW STATUS and changed format of output to be like SHOW VARIABLES.

  • Added extended-status command to mysqladmin which will show the new status variables.

D.5.27. Alterações na distribuição 3.22.9

  • SET SQL_LOG_UPDATE=0 caused a lockup of the server.

  • New SQL command: FLUSH [ TABLES | HOSTS | LOGS | PRIVILEGES ] [, ...]

  • New SQL command: KILL thread_id.

  • Added casts and changed include files to make MySQL easier to compile on AIX and DEC OSF/1 4.x

  • Fixed conversion problem when using ALTER TABLE from a INT to a short CHAR() column.

  • Added SELECT HIGH_PRIORITY; this will get a lock for the SELECT even if there is a thread waiting for another SELECT to get a WRITE LOCK.

  • Moved wild_compare() to string class to be able to use LIKE on BLOB/TEXT columns with \0.

  • Added ESCAPE option to LIKE.

  • Added a lot more output to mysqladmin debug.

  • You can now start mysqld on Windows with the --flush option. This will flush all tables to disk after each update. This makes things much safer on the Windows platforms but also much slower.

D.5.28. Alterações na distribuição 3.22.8

  • Czech character sets should now work much better.

  • DATE_ADD() and DATE_SUB() didn't work with group functions.

  • mysql will now also try to reconnect on USE database commands.

  • Fix problem with ORDER BY and LEFT JOIN and const tables.

  • Fixed problem with ORDER BY if the first ORDER BY column was a key and the rest of the ORDER BY columns wasn't part of the key.

  • Fixed a big problem with OPTIMIZE TABLE.

  • MySQL clients on NT will now by default first try to connect with named pipes and after this with TCP/IP.

  • Fixed a problem with DROP TABLE and mysqladmin shutdown on Windows (a fatal bug from 3.22.6).

  • Fixed problems with TIME columns and negative strings.

  • Added an extra thread signal loop on shutdown to avoid some error messages from the client.

  • MySQL now uses the next available number as extension for the update log file.

  • Added patches for UNIXWARE 7.

D.5.29. Alterações na distribuição 3.22.7 (Sep 1998: Beta)

  • Added LIMIT clause for the DELETE statement.

  • You can now use the /*! ... */ syntax to hide MySQL-specific keywords when you write portable code. MySQL will parse the code inside the comments as if the surrounding /*! and */ comment characters didn't exist.

  • OPTIMIZE TABLE tbl_name can now be used to reclaim disk space after many deletes. Currently, this uses ALTER TABLE to regenerate the table, but in the future it will use an integrated isamchk for more speed.

  • Upgraded libtool to get the configure more portable.

  • Fixed slow UPDATE and DELETE operations when using DATETIME or DATE keys.

  • Changed optimiser to make it better at deciding when to do a full join and when using keys.

  • You can now use mysqladmin proc to display information about your own threads. Only users with the PROCESS privilege can get information about all threads. (In 4.0.2 one needs the SUPER privilege for this.)

  • Added handling of formats YYMMDD, YYYYMMDD, YYMMDDHHMMSS for numbers when using DATETIME and TIMESTAMP types. (Formerly these formats only worked with strings.)

  • Added connect option CLIENT_IGNORE_SPACE to allow use of spaces after function names and before ‘(’ (Powerbuilder requires this). This will make all function names reserved words.

  • Added the --log-long-format option to mysqld to enable timestamps and INSERT_IDs in the update log.

  • Added --where option to mysqldump (patch by Jim Faucette).

  • The lexical analyser now uses ``perfect hashing'' for faster parsing of SQL statements.

D.5.30. Alterações na distribuição 3.22.6

  • Faster mysqldump.

  • For the LOAD DATA INFILE statement, you can now use the new LOCAL keyword to read the file from the client. mysqlimport will automatically use LOCAL when importing with the TCP/IP protocol.

  • Fixed small optimise problem when updating keys.

  • Changed makefiles to support shared libraries.

  • MySQL-NT can now use named pipes, which means that you can now use MySQL-NT without having to install TCP/IP.

D.5.31. Alterações na distribuição 3.22.5

  • All table lock handing is changed to avoid some very subtle deadlocks when using DROP TABLE, ALTER TABLE, DELETE FROM TABLE and mysqladmin flush-tables under heavy usage. Changed locking code to get better handling of locks of different types.

  • Updated DBI to 1.00 and DBD to 1.2.0.

  • Added a check that the error message file contains error messages suitable for the current version of mysqld. (To avoid errors if you accidentally try to use an old error message file.)

  • All count structures in the client (affected_rows(), insert_id(), ...) are now of type BIGINT to allow 64-bit values to be used. This required a minor change in the MySQL protocol which should affect only old clients when using tables with AUTO_INCREMENT values > 16M.

  • The return type of mysql_fetch_lengths() has changed from uint * to ulong *. This may give a warning for old clients but should work on most machines.

  • Change mysys and dbug libraries to allocate all thread variables in one struct. This makes it easier to make a threaded libmysql.dll library.

  • Use the result from gethostname() (instead of uname()) when constructing .pid file names.

  • New better compressed server/client protocol.

  • COUNT(), STD() and AVG() are extended to handle more than 4G rows.

  • You can now store values in the range -838:59:59 <= x <= 838:59:59 in a TIME column.

  • Warning: incompatible change!! If you set a TIME column to too short a value, MySQL now assumes the value is given as: [[[D ]HH:]MM:]SS instead of HH[:MM[:SS]].

  • TIME_TO_SEC() and SEC_TO_TIME() can now handle negative times and hours up to 32767.

  • Added new option SET SQL_LOG_UPDATE={0|1} to allow users with the PROCESS privilege to bypass the update log. (Modified patch from Sergey A Mukhin .)

  • Fixed fatal bug in LPAD().

  • Initialise line buffer in mysql.cc to make BLOB reading from pipes safer.

  • Added -O max_connect_errors=# option to mysqld. Connect errors are now reset for each correct connection.

  • Increased the default value of max_allowed_packet to 1M in mysqld.

  • Added --low-priority-updates option to mysqld, to give table-modifying operations (INSERT, REPLACE, UPDATE, DELETE) lower priority than retrievals. You can now use {INSERT | REPLACE | UPDATE | DELETE} LOW_PRIORITY ... You can also use SET SQL_LOW_PRIORITY_UPDATES={0|1} to change the priority for one thread. One side effect is that LOW_PRIORITY is now a reserved word. :(

  • Add support for INSERT INTO table ... VALUES(...),(...),(...), to allow inserting multiple rows with a single statement.

  • INSERT INTO tbl_name is now also cached when used with LOCK TABLES. (Previously only INSERT ... SELECT and LOAD DATA INFILE were cached.)

  • Allow GROUP BY functions with HAVING:

    mysql> SELECT col FROM table GROUP BY col HAVING COUNT(*)>0;
    

  • mysqld will now ignore trailing ‘;’ characters in queries. This is to make it easier to migrate from some other SQL servers that require the trailing ‘;’.

  • Fix for corrupted fixed-format output generated by SELECT INTO OUTFILE.

  • Warning: incompatible change! Added Oracle GREATEST() and LEAST() functions. You must now use these instead of the MAX() and MIN() functions to get the largest/smallest value from a list of values. These can now handle REAL, BIGINT and string (CHAR or VARCHAR) values.

  • Warning: incompatible change! DAYOFWEEK() had offset 0 for Sunday. Changed the offset to 1.

  • Give an error for queries that mix GROUP BY columns and fields when there is no GROUP BY specification.

  • Added --vertical option to mysql, for printing results in vertical mode.

  • Index-only optimization; some queries are now resolved using only indexes. Until MySQL 4.0, this works only for numeric columns. Veja mais informações sobre isto na Seção 5.4.3, “Como o MySQL Utiliza Índices”.

  • Lots of new benchmarks.

  • A new C API chapter and lots of other improvements in the manual.

D.5.32. Alterações na distribuição 3.22.4

  • Added --tmpdir option to mysqld, for specifying the location of the temporary file directory.

  • MySQL now automatically changes a query from an ODBC client:

    SELECT ... FROM table WHERE auto_increment_column IS NULL
    

    to:

    SELECT ... FROM table WHERE auto_increment_column == LAST_INSERT_ID()
    

    This allows some ODBC programs (Delphi, Access) to retrieve the newly inserted row to fetch the AUTO_INCREMENT id.

  • DROP TABLE now waits for all users to free a table before deleting it.

  • Fixed small memory leak in the new connect protocol.

  • New functions BIN(), OCT(), HEX() and CONV() for converting between different number bases.

  • Added function SUBSTRING() with 2 arguments.

  • If you created a table with a record length smaller than 5, you couldn't delete rows from the table.

  • Added optimization to remove const reference tables from ORDER BY and GROUP BY.

  • mysqld now automatically disables system locking on Linux and Windows, and for systems that use MIT-pthreads. You can force the use of locking with the --enable-external-locking option.

  • Added --console option to mysqld, to force a console window (for error messages) when using Windows.

  • Fixed table locks for Windows.

  • Allow ‘$’ in identifiers.

  • Changed name of user-specific configuration file from my.cnf to .my.cnf (Unix only).

  • Added DATE_ADD() and DATE_SUB() functions.

D.5.33. Alterações na distribuição 3.22.3

  • Fixed a lock problem (bug in MySQL Version 3.22.1) when closing temporary tables.

  • Added missing mysql_ping() to the client library.

  • Added --compress option to all MySQL clients.

  • Changed byte to char in mysql.h and mysql_com.h.

D.5.34. Alterações na distribuição 3.22.2

  • Searching on multiple constant keys that matched more than 30% of the rows didn't always use the best possible key.

  • New functions <<, >>, RPAD() and LPAD().

  • You can now save default options (like passwords) in a configuration file (my.cnf).

  • Lots of small changes to get ORDER BY to work when no records are found when using fields that are not in GROUP BY (MySQL extension).

  • Added --chroot option to mysqld, to start mysqld in a chroot environment (by Nikki Chumakov ).

  • Trailing spaces are now ignored when comparing case-sensitive strings; this should fix some problems with ODBC and flag 512!

  • Fixed a core dump bug in the range optimiser.

  • Added --one-thread option to mysqld, for debugging with LinuxThreads (or glibc). (This replaces the -T32 flag)

  • Added DROP TABLE IF EXISTS to prevent an error from occurring if the table doesn't exist.

  • IF and EXISTS are now reserved words (they would have to be sooner or later).

  • Added lots of new options to mysqldump.

  • Server error messages are now in mysqld_error.h.

  • The server/client protocol now supports compression.

  • All bug fixes from MySQL Version 3.21.32.

D.5.35. Alterações na distribuição 3.22.1 (Jun 1998: Alpha)

  • Added new C API function mysql_ping().

  • Added new API functions mysql_init() and mysql_options(). You now MUST call mysql_init() before you call mysql_real_connect(). You don't have to call mysql_init() if you only use mysql_connect().

  • Added mysql_options(...,MYSQL_OPT_CONNECT_TIMEOUT,...) so you can set a timeout for connecting to a server.

  • Added --timeout option to mysqladmin, as a test of mysql_options().

  • Added AFTER column and FIRST options to ALTER TABLE ... ADD columns. This makes it possible to add a new column at some specific location within a row in an existing table.

  • WEEK() now takes an optional argument to allow handling of weeks when the week starts on Monday (some European countries). By default, WEEK() assumes the week starts on Sunday.

  • TIME columns weren't stored properly (bug in MySQL Version 3.22.0).

  • UPDATE now returns information about how many rows were matched and updated, and how many ``warnings'' occurred when doing the update.

  • Fixed incorrect result from FORMAT(-100,2).

  • ENUM and SET columns were compared in binary (case-sensitive) fashion; changed to be case-insensitive.

D.5.36. Alterações na distribuição 3.22.0

  • New (backward-compatible) connect protocol that allows you to specify the database to use when connecting, to get much faster connections to a specific database.

    The mysql_real_connect() call is changed to:

    mysql_real_connect(MYSQL *mysql, const char *host, const char *user,
                       const char *passwd, const char *db, uint port,
                       const char *unix_socket, uint client_flag)
    
  • Each connection is handled by its own thread, rather than by the master accept() thread. This fixes permanently the telnet bug that was a topic on the mail list some time ago.

  • All TCP/IP connections are now checked with backward-resolution of the hostname to get better security. mysqld now has a local hostname resolver cache so connections should actually be faster than before, even with this feature.

  • A site automatically will be blocked from future connections if someone repeatedly connects with an ``improper header'' (like when one uses telnet).

  • You can now refer to tables in different databases with references of the form tbl_name@db_name or db_name.tbl_name. This makes it possible to give a user read access to some tables and write access to others simply by keeping them in different databases!

  • Added --user option to mysqld, to allow it to run as another Unix user (if it is started as the Unix root user).

  • Added caching of users and access rights (for faster access rights checking)

  • Normal users (not anonymous ones) can change their password with mysqladmin password 'new_password'. This uses encrypted passwords that are not logged in the normal MySQL log!

  • All important string functions are now coded in assembler for x86 Linux machines. This gives a speedup of 10% in many cases.

  • For tables that have many columns, the column names are now hashed for much faster column name lookup (this will speed up some benchmark tests a lot!)

  • Some benchmarks are changed to get better individual timing. (Some loops were so short that a specific test took < 2 seconds. The loops have been changed to take about 20 seconds to make it easier to compare different databases. A test that took 1-2 seconds before now takes 11-24 seconds, which is much better)

  • Re-arranged SELECT code to handle some very specific queries involving group functions (like COUNT(*)) without a GROUP BY but with HAVING. The following now works:

    mysql> SELECT COUNT(*) as C FROM table HAVING C > 1;
    

  • Changed the protocol for field functions to be faster and avoid some calls to malloc().

  • Added -T32 option to mysqld, for running all queries under the main thread. This makes it possible to debug mysqld under Linux with gdb!

  • Added optimization of not_null_column IS NULL (needed for some Access queries).

  • Allow STRAIGHT_JOIN to be used between two tables to force the optimiser to join them in a specific order.

  • String functions now return VARCHAR rather than CHAR and the column type is now VARCHAR for fields saved as VARCHAR. This should make the MyODBC driver better, but may break some old MySQL clients that don't handle FIELD_TYPE_VARCHAR the same way as FIELD_TYPE_CHAR.

  • CREATE INDEX and DROP INDEX are now implemented through ALTER TABLE. CREATE TABLE is still the recommended (fast) way to create indexes.

  • Added --set-variable option wait_timeout to mysqld.

  • Added time column to mysqladmin processlist to show how long a query has taken or how long a thread has slept.

  • Added lots of new variables to show variables and some new to show status.

  • Added new type YEAR. YEAR is stored in 1 byte with allowable values of 0, and 1901 to 2155.

  • Added new DATE type that is stored in 3 bytes rather than 4 bytes. All new tables are created with the new date type if you don't use the --old-protocol option to mysqld.

  • Fixed bug in record caches; for some queries, you could get Error from table handler: # on some operating systems.

  • Added --enable-assembler option to configure, for x86 machines (tested on Linux + gcc). This will enable assembler functions for the most important string functions for more speed!

D.6. Alterações na distribuição 3.21.x

D.6.1. Alterações na distribuição 3.21.33
D.6.2. Alterações na distribuição 3.21.32
D.6.3. Alterações na distribuição 3.21.31
D.6.4. Alterações na distribuição 3.21.30
D.6.5. Alterações na distribuição 3.21.29
D.6.6. Alterações na distribuição 3.21.28
D.6.7. Alterações na distribuição 3.21.27
D.6.8. Alterações na distribuição 3.21.26
D.6.9. Alterações na distribuição 3.21.25
D.6.10. Alterações na distribuição 3.21.24
D.6.11. Alterações na distribuição 3.21.23
D.6.12. Alterações na distribuição 3.21.22
D.6.13. Alterações na distribuição 3.21.21a
D.6.14. Alterações na distribuição 3.21.21
D.6.15. Alterações na distribuição 3.21.20
D.6.16. Alterações na distribuição 3.21.19
D.6.17. Alterações na distribuição 3.21.18
D.6.18. Alterações na distribuição 3.21.17
D.6.19. Alterações na distribuição 3.21.16
D.6.20. Alterações na distribuição 3.21.15
D.6.21. Alterações na distribuição 3.21.14b
D.6.22. Alterações na distribuição 3.21.14a
D.6.23. Alterações na distribuição 3.21.13
D.6.24. Alterações na distribuição 3.21.12
D.6.25. Alterações na distribuição 3.21.11
D.6.26. Alterações na distribuição 3.21.10
D.6.27. Alterações na distribuição 3.21.9
D.6.28. Alterações na distribuição 3.21.8
D.6.29. Alterações na distribuição 3.21.7
D.6.30. Alterações na distribuição 3.21.6
D.6.31. Alterações na distribuição 3.21.5
D.6.32. Alterações na distribuição 3.21.4
D.6.33. Alterações na distribuição 3.21.3
D.6.34. Alterações na distribuição 3.21.2
D.6.35. Alterações na distribuição 3.21.0

Version 3.21 is quite old now, and should be avoided if possible. This information is kept here for historical purposes only.

D.6.1. Alterações na distribuição 3.21.33

  • Fixed problem when sending SIGHUP to mysqld; mysqld core dumped when starting from boot on some systems.

  • Fixed problem with losing a little memory for some connections.

  • DELETE FROM tbl_name without a WHERE condition is now done the long way when you use LOCK TABLES or if the table is in use, to avoid race conditions.

  • INSERT INTO TABLE (timestamp_column) VALUES (NULL); didn't set timestamp.

D.6.2. Alterações na distribuição 3.21.32

  • Fixed some possible race conditions when doing many reopen/close on the same tables under heavy load! This can happen if you execute mysqladmin refresh often. This could in some very rare cases corrupt the header of the index file and cause error 126 or 138.

  • Fixed fatal bug in refresh() when running with the --skip-external-locking option. There was a ``very small'' time gap after a mysqladmin refresh when a table could be corrupted if one thread updated a table while another thread did mysqladmin refresh and another thread started a new update ont the same table before the first thread had finished. A refresh (or --flush-tables) will now not return until all used tables are closed!

  • SELECT DISTINCT with a WHERE clause that didn't match any rows returned a row in some contexts (bug only in 3.21.31).

  • GROUP BY + ORDER BY returned one empty row when no rows where found.

  • Fixed a bug in the range optimiser that wrote Use_count: Wrong count for ... in the error log file.

D.6.3. Alterações na distribuição 3.21.31

  • Fixed a sign extension problem for the TINYINT type on Irix.

  • Fixed problem with LEFT("constant_string",function).

  • Fixed problem with FIND_IN_SET().

  • LEFT JOIN core dumped if the second table is used with a constant WHERE/ON expression that uniquely identifies one record.

  • Fixed problems with DATE_FORMAT() and incorrect dates. DATE_FORMAT() now ignores '%' to make it possible to extend it more easily in the future.

D.6.4. Alterações na distribuição 3.21.30

  • mysql now returns an exit code > 0 if the query returned an error.

  • Saving of command-line history to file in mysql client. By Tommy Larsen .

  • Fixed problem with empty lines that were ignored in mysql.cc.

  • Save the pid of the signal handler thread in the pid file instead of the pid of the main thread.

  • Added patch by to support Japanese characters SJIS and UJIS.

  • Changed safe_mysqld to redirect startup messages to 'hostname'.err instead of 'hostname'.log to reclaim file space on mysqladmin refresh.

  • ENUM always had the first entry as default value.

  • ALTER TABLE wrote two entries to the update log.

  • sql_acc() now closes the mysql grant tables after a reload to save table space and memory.

  • Changed LOAD DATA to use less memory with tables and BLOB columns.

  • Sorting on a function which made a division / 0 produced a wrong set in some cases.

  • Fixed SELECT problem with LEFT() when using the czech character set.

  • Fixed problem in isamchk; it couldn't repair a packed table in a very unusual case.

  • SELECT statements with & or | (bit functions) failed on columns with NULL values.

  • When comparing a field = field, where one of the fields was a part key, only the length of the part key was compared.

D.6.5. Alterações na distribuição 3.21.29

  • LOCK TABLES + DELETE from tbl_name never removed locks properly.

  • Fixed problem when grouping on an OR function.

  • Fixed permission problem with umask() and creating new databases.

  • Fixed permission problem on result file with SELECT ... INTO OUTFILE ...

  • Fixed problem in range optimiser (core dump) for a very complex query.

  • Fixed problem when using MIN(integer) or MAX(integer) in GROUP BY.

  • Fixed bug on Alpha when using integer keys. (Other keys worked on Alpha.)

  • Fixed bug in WEEK("XXXX-xx-01").

D.6.6. Alterações na distribuição 3.21.28

  • Fixed socket permission (clients couldn't connect to Unix socket on Linux).

  • Fixed bug in record caches; for some queries, you could get Error from table handler: # on some operating systems.

D.6.7. Alterações na distribuição 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.)

D.6.8. Alterações na distribuição 3.21.26

  • FROM_DAYS(0) now returns "0000-00-00".

  • In DATE_FORMAT(), PM and AM were swapped for hours 00 and 12.

  • Extended the default maximum key size to 256.

  • Fixed bug when using BLOB/TEXT in GROUP BY with many tables.

  • An ENUM field that is not declared NOT NULL has NULL as the default value. (Previously, the default value was the first enumeration value.)

  • Fixed bug in the join optimiser code when using many part keys on the same key: INDEX (Organisation,Surname(35),Initials(35)).

  • Added some tests to the table order optimiser to get some cases with SELECT ... FROM many_tables much faster.

  • Added a retry loop around accept() to possibly fix some problems on some Linux machines.

D.6.9. Alterações na distribuição 3.21.25

  • Changed typedef 'string' to typedef 'my_string' for better portability.

  • You can now kill threads that are waiting on a disk-full condition.

  • Fixed some problems with UDF functions.

  • Added long options to isamchk. Try isamchk --help.

  • Fixed a bug when using 8 bytes long (alpha); filesort() didn't work. Affects DISTINCT, ORDER BY and GROUP BY on 64-bit processors.

D.6.10. Alterações na distribuição 3.21.24

  • Dynamic loadable functions. Based on source from Alexis Mikhailov.

  • You couldn't delete from a table if no one had done a SELECT on the table.

  • Fixed problem with range optimiser with many OR operators on key parts inside each other.

  • Recoded MIN() and MAX() to work properly with strings and HAVING.

  • Changed default umask value for new files from 0664 to 0660.

  • Fixed problem with LEFT JOIN and constant expressions in the ON part.

  • Added Italian error messages from .

  • configure now works better on OSF/1 (tested on 4.0D).

  • Added hooks to allow LIKE optimization with international character support.

  • Upgraded DBI to 0.93.

D.6.11. Alterações na distribuição 3.21.23

  • The following symbols are now reserved words: TIME, DATE, TIMESTAMP, TEXT, BIT, ENUM, NO, ACTION, CHECK, YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, STATUS, VARIABLES.

  • Setting a TIMESTAMP to NULL in LOAD DATA INFILE ... didn't set the current time for the TIMESTAMP.

  • Fix BETWEEN to recognise binary strings. Now BETWEEN is case-sensitive.

  • Added --skip-thread-priority option to mysqld, for systems where mysqld's thread scheduling doesn't work properly (BSDI 3.1).

  • Added ODBC functions DAYNAME() and MONTHNAME().

  • Added function TIME_FORMAT(). This works like DATE_FORMAT(), but takes a time string ('HH:MM:SS') as argument.

  • Fixed unlikely(?) key optimiser bug when using OR operators of key parts inside AND expressions.

  • Added variables command to mysqladmin.

  • A lot of small changes to the binary releases.

  • Fixed a bug in the new protocol from MySQL Version 3.21.20.

  • Changed ALTER TABLE to work with Windows (Windows can't rename open files). Also fixed a couple of small bugs in the Windows version.

  • All standard MySQL clients are now ported to MySQL for Windows.

  • MySQL can now be started as a service on NT.

D.6.12. Alterações na distribuição 3.21.22

  • Starting with this version, all MySQL distributions will be configured, compiled and tested with crash-me and the benchmarks on the following platforms: SunOS 5.6 sun4u, SunOS 5.5.1 sun4u, SunOS 4.14 sun4c, SunOS 5.6 i86pc, Irix 6.3 mips5k, HP-UX 10.20 hppa, AIX 4.2.1 ppc, OSF/1 V4.0 alpha, FreeBSD 2.2.2 i86pc and BSDI 3.1 i386.

  • Fix COUNT(*) problems when the WHERE clause didn't match any records. (Bug from 3.21.17.)

  • Removed that NULL = NULL is true. Now you must use IS NULL or IS NOT NULL to test whether a value is NULL. (This is according to SQL-99 but may break old applications that are ported from mSQL.) You can get the old behaviour by compiling with -DmSQL_COMPLIANT.

  • Fixed bug that core dumped when using many LEFT OUTER JOIN clauses.

  • Fixed bug in ORDER BY on string formula with possible NULL values.

  • Fixed problem in range optimiser when using <= on sub index.

  • Added functions DAYOFYEAR(), DAYOFMONTH(), MONTH(), YEAR(), WEEK(), QUARTER(), HOUR(), MINUTE(), SECOND() and FIND_IN_SET().

  • Added SHOW VARIABLES command.

  • Added support of ``long constant strings'' from SQL-99:

    mysql> SELECT 'first ' 'second';       -> 'first second'
    

  • Upgraded Msql-Mysql-modules to 1.1825.

  • Upgraded mysqlaccess to 2.02.

  • Fixed problem with Russian character set and LIKE.

  • Ported to OpenBSD 2.1.

  • New Dutch error messages.

D.6.13. Alterações na distribuição 3.21.21a

  • Configure changes for some operating systems.

D.6.14. Alterações na distribuição 3.21.21

  • Fixed optimiser bug when using WHERE data_field = date_field2 AND date_field2 = constant.

  • Added SHOW STATUS command.

  • Removed manual.ps from the source distribution to make it smaller.

D.6.15. Alterações na distribuição 3.21.20

  • Changed the maximum table name and column name lengths from 32 to 64.

  • Aliases can now be of ``any'' length.

  • Fixed mysqladmin stat to return the right number of queries.

  • Changed protocol (downward compatible) to mark if a column has the AUTO_INCREMENT attribute or is a TIMESTAMP. This is needed for the new Java driver.

  • Added Hebrew sorting order by Zeev Suraski.

  • Solaris 2.6: Fixed configure bugs and increased maximum table size from 2G to 4G.

D.6.16. Alterações na distribuição 3.21.19

  • Upgraded DBD to 1.1823. This version implements mysql_use_result in DBD-Mysql.

  • Benchmarks updated for empress (by Luuk).

  • Fixed a case of slow range searching.

  • Configure fixes (Docs directory).

  • Added function REVERSE() (by Zeev Suraski).

D.6.17. Alterações na distribuição 3.21.18

  • Issue error message if client C functions are called in wrong order.

  • Added automatic reconnect to the libmysql.c library. If a write command fails, an automatic reconnect is done.

  • Small sort sets no longer use temporary files.

  • Upgraded DBI to 0.91.

  • Fixed a couple of problems with LEFT OUTER JOIN.

  • Added CROSS JOIN syntax. CROSS is now a reserved word.

  • Recoded yacc/bison stack allocation to be even safer and to allow MySQL to handle even bigger expressions.

  • Fixed a couple of problems with the update log.

  • ORDER BY was slow when used with key ranges.

D.6.18. Alterações na distribuição 3.21.17

  • Changed documentation string of --with-unix-socket-path to avoid confusion.

  • Added ODBC and SQL-99 style LEFT OUTER JOIN.

  • The following are new reserved words: LEFT, NATURAL, USING.

  • The client library now uses the value of the environment variable MYSQL_HOST as the default host if it's defined.

  • SELECT col_name, SUM(expr) now returns NULL for col_name when there are matching rows.

  • Fixed problem with comparing binary strings and BLOB values with ASCII characters over 127.

  • Fixed lock problem: when freeing a read lock on a table with multiple read locks, a thread waiting for a write lock would have been given the lock. This shouldn't affect data integrity, but could possibly make mysqld restart if one thread was reading data that another thread modified.

  • LIMIT offset,count didn't work in INSERT ... SELECT.

  • Optimized key block caching. This will be quicker than the old algorithm when using bigger key caches.

D.6.19. Alterações na distribuição 3.21.16

  • Added ODBC 2.0 & 3.0 functions POWER(), SPACE(), COT(), DEGREES(), RADIANS(), ROUND(2 arg) and TRUNCATE().

  • Warning: Incompatible change! LOCATE() parameters were swapped according to ODBC standard. Fixed.

  • Added function TIME_TO_SEC().

  • In some cases, default values were not used for NOT NULL fields.

  • Timestamp wasn't always updated properly in UPDATE SET ... statements.

  • Allow empty strings as default values for BLOB and TEXT, to be compatible with mysqldump.

D.6.20. Alterações na distribuição 3.21.15

  • Warning: Incompatible change! mysqlperl is now from Msql-Mysql-modules. This means that connect() now takes host, database, user, password arguments! The old version took host, database, password, user.

  • Allow DATE '1997-01-01', TIME '12:10:10' and TIMESTAMP '1997-01-01 12:10:10' formats required by SQL-99. Warning: Incompatible change! This has the unfortunate side-effect that you no longer can have columns named DATE, TIME or TIMESTAMP. :( Old columns can still be accessed through tablename.columnname!)

  • Changed Makefiles to hopefully work better with BSD systems. Also, manual.dvi is now included in the distribution to avoid having stupid make programs trying to rebuild it.

  • readline library upgraded to version 2.1.

  • A new sortorder german-1. That is a normal ISO-Latin1 with a german sort order.

  • Perl DBI/DBD is now included in the distribution. DBI is now the recommended way to connect to MySQL from Perl.

  • New portable benchmark suite with DBD, with test results from mSQL 2.0.3, MySQL, PostgreSQL 6.2.1 and Solid server 2.2.

  • crash-me is now included with the benchmarks; this is a Perl program designed to find as many limits as possible in an SQL server. Tested with mSQL, PostgreSQL, Solid and MySQL.

  • Fixed bug in range-optimiser that crashed MySQL on some queries.

  • Table and column name completion for mysql command-line tool, by Zeev Suraski and Andi Gutmans.

  • Added new command REPLACE that works like INSERT but replaces conflicting records with the new record. REPLACE INTO TABLE ... SELECT ... works also.

  • Added new commands CREATE DATABASE db_name and DROP DATABASE db_name.

  • Added RENAME option to ALTER TABLE: ALTER TABLE name RENAME TO new_name.

  • make_binary_distribution now includes libgcc.a in libmysqlclient.a. This should make linking work for people who don't have gcc.

  • Changed net_write() to my_net_write() because of a name conflict with Sybase.

  • New function DAYOFWEEK() compatible with ODBC.

  • Stack checking and bison memory overrun checking to make MySQL safer with weird queries.

D.6.21. Alterações na distribuição 3.21.14b

  • Fixed a couple of small configure problems on some platforms.

D.6.22. Alterações na distribuição 3.21.14a

  • Ported to SCO Openserver 5.0.4 with FSU Pthreads.

  • HP-UX 10.20 should work.

  • Added new function DATE_FORMAT().

  • Added NOT IN.

  • Added automatic removal of 'ODBC function conversions': {fn now() }

  • Handle ODBC 2.50.3 option flags.

  • Fixed comparison of DATE and TIME values with NULL.

  • Changed language name from germany to german to be consistent with the other language names.

  • Fixed sorting problem on functions returning a FLOAT. Previously, the values were converted to INT values before sorting.

  • Fixed slow sorting when sorting on key field when using key_column=constant.

  • Sorting on calculated DOUBLE values sorted on integer results instead.

  • mysql no longer requires a database argument.

  • Changed the place where HAVING should be. According to the SQL standards, it should be after GROUP BY but before ORDER BY. MySQL Version 3.20 incorrectly had it last.

  • Added Sybase command USE database to start using another database.

  • Added automatic adjusting of number of connections and table cache size if the maximum number of files that can be opened is less than needed. This should fix that mysqld doesn't crash even if you haven't done a ulimit -n 256 before starting mysqld.

  • Added lots of limit checks to make it safer when running with too little memory or when doing weird queries.

D.6.23. Alterações na distribuição 3.21.13

  • Added retry of interrupted reads and clearing of errno. This makes Linux systems much safer!

  • Fixed locking bug when using many aliases on the same table in the same SELECT.

  • Fixed bug with LIKE on number key.

  • New error message so you can check whether the connection was lost while the command was running or whether the connection was down from the start.

  • Added --table option to mysql to print in table format. Moved time and row information after query result. Added automatic reconnect of lost connections.

  • Added != as a synonym for <>.

  • Added function VERSION() to make easier logs.

  • New multi-user test tests/fork_test.pl to put some strain on the thread library.

D.6.24. Alterações na distribuição 3.21.12

  • Fixed ftruncate() call in MIT-pthreads. This made isamchk destroy the .ISM files on (Free)BSD 2.x systems.

  • Fixed broken __P_ patch in MIT-pthreads.

  • Many memory overrun checks. All string functions now return NULL if the returned string should be longer than max_allowed_packet bytes.

  • Changed the name of the INTERVAL type to ENUM, because INTERVAL is used in SQL-99.

  • In some cases, doing a JOIN + GROUP + INTO OUTFILE, the result wasn't grouped.

  • LIKE with '_' as last character didn't work. Fixed.

  • Added extended SQL-99 TRIM() function.

  • Added CURTIME().

  • Added ENCRYPT() function by Zeev Suraski.

  • Fixed better FOREIGN KEY syntax skipping. New reserved words: MATCH, FULL, PARTIAL.

  • mysqld now allows IP number and hostname for the --bind-address option.

  • Added SET CHARACTER SET cp1251_koi8 to enable conversions of data to and from the cp1251_koi8 character set.

  • Lots of changes for Windows 95 port. In theory, this version should now be easily portable to Windows 95.

  • Changed the CREATE COLUMN syntax of NOT NULL columns to be after the DEFAULT value, as specified in the SQL-99 standard. This will make mysqldump with NOT NULL and default values incompatible with MySQL Version 3.20.

  • Added many function name aliases so the functions can be used with ODBC or SQL-92 syntax.

  • Fixed syntax of ALTER TABLE tbl_name ALTER COLUMN col_name SET DEFAULT NULL.

  • Added CHAR and BIT as synonyms for CHAR(1).

  • Fixed core dump when updating as a user who has only SELECT privilege.

  • INSERT ... SELECT ... GROUP BY didn't work in some cases. An Invalid use of group function error occurred.

  • When using LIMIT, SELECT now always uses keys instead of record scan. This will give better performance on SELECT and a WHERE that matches many rows.

  • Added Russian error messages.

D.6.25. Alterações na distribuição 3.21.11

  • Configure changes.

  • MySQL now works with the new thread library on BSD/OS 3.0.

  • Added new group functions BIT_OR() and BIT_AND().

  • Added compatibility functions CHECK and REFERENCES. CHECK is now a reserved word.

  • Added ALL option to GRANT for better compatibility. (GRANT is still a dummy function.)

  • Added partly-translated Dutch error messages.

  • Fixed bug in ORDER BY and GROUP BY with NULL columns.

  • Added function LAST_INSERT_ID() SQL function to retrieve last AUTO_INCREMENT value. This is intended for clients to ODBC that can't use the mysql_insert_id() API function, but can be used by any client.

  • Added --flush-logs option to mysqladmin.

  • Added command STATUS to mysql.

  • Fixed problem with ORDER BY/GROUP BY because of bug in gcc.

  • Fixed problem with INSERT ... SELECT ... GROUP BY.

D.6.26. Alterações na distribuição 3.21.10

  • New program mysqlaccess.

  • CREATE now supports all ODBC types and the mSQL TEXT type. All ODBC 2.5 functions are also supported (added REPEAT). This provides better portability.

  • Added text types TINYTEXT, TEXT, MEDIUMTEXT and LONGTEXT. These are actually BLOBtypes, but all searching is done in case-insensitive fashion.

  • All old BLOB fields are now TEXT fields. This only changes that all searching on strings is done in case-sensitive fashion. You must do an ALTER TABLE and change the datatype to BLOB if you want to have tests done in case-sensitive fashion.

  • Fixed some configure issues.

  • Made the locking code a bit safer. Fixed very unlikely deadlock situation.

  • Fixed a couple of bugs in the range optimiser. Now the new range benchmark test-select works.

D.6.27. Alterações na distribuição 3.21.9

  • Added --enable-unix-socket=pathname option to configure.

  • Fixed a couple of portability problems with include files.

  • Fixed bug in range calculation that could return empty set when searching on multiple key with only one entry (very rare).

  • Most things ported to FSU Pthreads, which should allow MySQL to run on SCO. Veja mais informações sobre isto na Seção 2.6.6.9, “Notas SCO”.

D.6.28. Alterações na distribuição 3.21.8

  • Works now in Solaris 2.6.

  • Added handling of calculation of SUM() functions. For example, you can now use SUM(column)/COUNT(column).

  • Added handling of trigometric functions: PI(), ACOS(), ASIN(), ATAN(), COS(), SIN() and TAN().

  • New languages: Norwegian, Norwegian-ny and Portuguese.

  • Fixed parameter bug in net_print() in procedure.cc.

  • Fixed a couple of memory leaks.

  • Now allow also the old SELECT ... INTO OUTFILE syntax.

  • Fixed bug with GROUP BY and SELECT on key with many values.

  • mysql_fetch_lengths() sometimes returned incorrect lengths when you used mysql_use_result(). This affected at least some cases of mysqldump --quick.

  • Fixed bug in optimization of WHERE const op field.

  • Fixed problem when sorting on NULL fields.

  • Fixed a couple of 64-bit (Alpha) problems.

  • Added --pid-file=# option to mysqld.

  • Added date formatting to FROM_UNIXTIME(), originally by Zeev Suraski.

  • Fixed bug in BETWEEN in range optimiser (did only test = of the first argument).

  • Added machine-dependent files for MIT-pthreads i386-SCO. There is probably more to do to get this to work on SCO 3.5.

D.6.29. Alterações na distribuição 3.21.7

  • Changed Makefile.am to take advantage of Automake 1.2.

  • Added the beginnings of a benchmark suite.

  • Added more secure password handling.

  • Added new client function mysql_errno(), to get the error number of the error message. This makes error checking in the client much easier. This makes the new server incompatible with the 3.20.x server when running without --old-protocol. The client code is backward-compatible. More information can be found in the README file!

  • Fixed some problems when using very long, illegal names.

D.6.30. Alterações na distribuição 3.21.6

  • Fixed more portability issues (incorrect sigwait and sigset defines).

  • configure should now be able to detect the last argument to accept().

D.6.31. Alterações na distribuição 3.21.5

  • Should now work with FreeBSD 3.0 if used with FreeBSD-3.0-libc_r-1.0.diff, which can be found at http://www.mysql.com/downloads/os-freebsd.html.

  • Added new -O tmp_table_size=# option to mysqld.

  • New function FROM_UNIXTIME(timestamp) which returns a date string in 'YYYY-MM-DD HH:MM:SS' format.

  • New function SEC_TO_TIME(seconds) which returns a string in 'HH:MM:SS' format.

  • New function SUBSTRING_INDEX(), originally by Zeev Suraski.

D.6.32. Alterações na distribuição 3.21.4

  • Should now configure and compile on OSF/1 4.0 with the DEC compiler.

  • Configuration and compilation on BSD/OS 3.0 works, but due to some bugs in BSD/OS 3.0, mysqld doesn't work on it yet.

  • Configuration and compilation on FreeBSD 3.0 works, but I couldn't get pthread_create to work.

D.6.33. Alterações na distribuição 3.21.3

  • Added reverse check lookup of hostnames to get better security.

  • Fixed some possible buffer overflows if filenames that are too long are used.

  • mysqld doesn't accept hostnames that start with digits followed by a '.', because the hostname may look like an IP number.

  • Added --skip-networking option to mysqld, to allow only socket connections. (This will not work with MIT-pthreads!)

  • Added check of too long table names for alias.

  • Added check if database name is okay.

  • Added check if too long table names.

  • Removed incorrect free() that killed the server on CREATE DATABASE or DROP DATABASE.

  • Changed some mysqld -O options to better names.

  • Added -O join_cache_size=# option to mysqld.

  • Added -O max_join_size=# option to mysqld, to be able to set a limit how big queries (in this case big = slow) one should be able to handle without specifying SET SQL_BIG_SELECTS=1. A # = is about 10 examined records. The default is ``unlimited''.

  • When comparing a TIME, DATE, DATETIME or TIMESTAMP column to a constant, the constant is converted to a time value before performing the comparison. This will make it easier to get ODBC (particularly Access97) to work with the above types. It should also make dates easier to use and the comparisons should be quicker than before.

  • Applied patch from Jochen Wiedmann that allows query() in mysqlperl to take a query with \0 in it.

  • Storing a timestamp with a 2-digit year (YYMMDD) didn't work.

  • Fix that timestamp wasn't automatically updated if set in an UPDATE clause.

  • Now the automatic timestamp field is the FIRST timestamp field.

  • SELECT * INTO OUTFILE, which didn't correctly if the outfile already existed.

  • mysql now shows the thread ID when starting or doing a reconnect.

  • Changed the default sort buffer size from 2M to 1M.

D.6.34. Alterações na distribuição 3.21.2

  • The range optimiser is coded, but only 85% tested. It can be enabled with --new, but it crashes core a lot yet...

  • More portable. Should compile on AIX and alpha-digital. At least the isam library should be relatively 64-bit clean.

  • New isamchk which can detect and fix more problems.

  • New options for isamlog.

  • Using new version of Automake.

  • Many small portability changes (from the AIX and alpha-digital port) Better checking of pthread(s) library.

  • czech error messages by .

  • Decreased size of some buffers to get fewer problems on systems with little memory. Also added more checks to handle ``out of memory'' problems.

  • mysqladmin: you can now do mysqladmin kill 5,6,7,8 to kill multiple threads.

  • When the maximum connection limit is reached, one extra connection by a user with the process_acl privilege is granted.

  • Added -O backlog=# option to mysqld.

  • Increased maximum packet size from 512K to 1024K for client.

  • Almost all of the function code is now tested in the internal test suite.

  • ALTER TABLE now returns warnings from field conversions.

  • Port changed to 3306 (got it reserved from ISI).

  • Added a fix for Visual FoxBase so that any schema name from a table specification is automatically removed.

  • New function ASCII().

  • Removed function BETWEEN(a,b,c). Use the standard SQL syntax instead: expr BETWEEN expr AND expr.

  • MySQL no longer has to use an extra temporary table when sorting on functions or SUM() functions.

  • Fixed bug that you couldn't use tbl_name.field_name in UPDATE.

  • Fixed SELECT DISTINCT when using 'hidden group'. For example:

    mysql> SELECT DISTINCT MOD(some_field,10) FROM test
        ->        GROUP BY some_field;
    

    Note: some_field is normally in the SELECT part. Standard SQL should require it.

D.6.35. Alterações na distribuição 3.21.0

  • New reserved words used: INTERVAL, EXPLAIN, READ, WRITE, BINARY.

  • Added ODBC function CHAR(num,...).

  • New operator IN. This uses a binary search to find a match.

  • New command LOCK TABLES tbl_name [AS alias] {READ|WRITE} ...

  • Added --log-update option to mysqld, to get a log suitable for incremental updates.

  • New command EXPLAIN SELECT ... to get information about how the optimiser will do the join.

  • For easier client code, the client should no longer use FIELD_TYPE_TINY_BLOB, FIELD_TYPE_MEDIUM_BLOB, FIELD_TYPE_LONG_BLOB or FIELD_TYPE_VAR_STRING (as previously returned by mysql_list_fields). You should instead only use FIELD_TYPE_BLOB or FIELD_TYPE_STRING. If you want exact types, you should use the command SHOW FIELDS.

  • Added varbinary syntax: 0x###### which can be used as a string (default) or a number.

  • FIELD_TYPE_CHAR is renamed to FIELD_TYPE_TINY.

  • Changed all fields to C++ classes.

  • Removed FORM struct.

  • Fields with DEFAULT values no longer need to be NOT NULL.

  • New field types:

    • ENUM

      A string which can take only a couple of defined values. The value is stored as a 1-3 byte number that is mapped automatically to a string. This is sorted according to string positions!

    • SET

      A string which may have one or many string values separated with ','. The string is stored as a 1-, 2-, 3-, 4- or 8-byte number where each bit stands for a specific set member. This is sorted according to the unsigned value of the stored packed number.

  • Now all function calculation is done with double or long long. This will provide the full 64-bit range with bit functions and fix some conversions that previously could result in precision losses. One should avoid using unsigned long long columns with full 64-bit range (numbers bigger than 9223372036854775807) because calculations are done with signed long long.

  • ORDER BY will now put NULL field values first. GROUP BY will also work with NULL values.

  • Full WHERE with expressions.

  • New range optimiser that can resolve ranges when some keypart prefix is constant. Example:

    mysql> SELECT * FROM tbl_name
        ->          WHERE key_part_1="customer"
        ->          AND key_part_2>=10 AND key_part_2<=10;
    

D.7. Alterações na distribuição 3.20.x

Version 3.20 is quite old now, and should be avoided if possible. This information is kept here for historical purposes only.

Changes from 3.20.18 to 3.20.32b are not documented here because the 3.21 release branched here. And the relevant changes are also documented as changes to the 3.21 version.

D.7.1. Alterações na distribuição 3.20.18

  • Added -p# (remove # directories from path) to isamlog. All files are written with a relative path from the database directory Now mysqld shouldn't crash on shutdown when using the --log-isam option.

  • New mysqlperl version. It is now compatible with msqlperl-0.63.

  • New DBD module available.

  • Added group function STD() (standard deviation).

  • The mysqld server is now compiled by default without debugging information. This will make the daemon smaller and faster.

  • Now one usually only has to specify the --basedir option to mysqld. All other paths are relative in a normal installation.

  • BLOB columns sometimes contained garbage when used with a SELECT on more than one table and ORDER BY.

  • Fixed that calculations that are not in GROUP BY work as expected (SQL-99 extension). Example:

    mysql> SELECT id,id+1 FROM table GROUP BY id;
    

  • The test of using MYSQL_PWD was reversed. Now MYSQL_PWD is enabled as default in the default release.

  • Fixed conversion bug which caused mysqld to core dump with Arithmetic error on SPARC-386.

  • Added --unbuffered option to mysql, for new mysqlaccess.

  • When using overlapping (unnecessary) keys and join over many tables, the optimiser could get confused and return 0 records.

D.7.2. Alterações na distribuição 3.20.17

  • You can now use BLOB columns and the functions IS NULL and IS NOT NULL in the WHERE clause.

  • All communication packets and row buffers are now allocated dynamically on demand. The default value of max_allowed_packet is now 64K for the server and 512K for the client. This is mainly used to catch incorrect packets that could trash all memory. The server limit may be changed when it is started.

  • Changed stack usage to use less memory.

  • Changed safe_mysqld to check for running daemon.

  • The ELT() function is renamed to FIELD(). The new ELT() function returns a value based on an index: FIELD() is the inverse of ELT() Example: ELT(2,"A","B","C") returns "B". FIELD("B","A","B","C") returns 2.

  • COUNT(field), where field could have a NULL value, now works.

  • A couple of bugs fixed in SELECT ... GROUP BY.

  • Fixed memory overrun bug in WHERE with many unoptimisable brace levels.

  • Fixed some small bugs in the grant code.

  • If hostname isn't found by get_hostname, only the IP is checked. Previously, you got Access denied.

  • Inserts of timestamps with values didn't always work.

  • INSERT INTO ... SELECT ... WHERE could give the error Duplicated field.

  • Added some tests to safe_mysqld to make it ``safer''.

  • LIKE was case-sensitive in some places and case-insensitive in others. Now LIKE is always case-insensitive.

  • mysql.cc: Allow '#' anywhere on the line.

  • New command SET SQL_SELECT_LIMIT=#. See the FAQ for more details.

  • New version of the mysqlaccess script.

  • Change FROM_DAYS() and WEEKDAY() to also take a full TIMESTAMP or DATETIME as argument. Before they only took a number of type YYYYMMDD or YYMMDD.

  • Added new function UNIX_TIMESTAMP(timestamp_column).

D.7.3. Alterações na distribuição 3.20.16

  • More changes in MIT-pthreads to get them safer. Fixed also some link bugs at least in SunOS.

  • Changed mysqld to work around a bug in MIT-pthreads. This makes multiple small SELECT operations 20 times faster. Now lock_test.pl should work.

  • Added mysql_FetchHash(handle) to mysqlperl.

  • The mysqlbug script is now distributed built to allow for reporting bugs that appear during the build with it.

  • Changed libmysql.c to prefer getpwuid() instead of cuserid().

  • Fixed bug in SELECT optimiser when using many tables with the same column used as key to different tables.

  • Added new latin2 and Russian KOI8 character tables.

  • Added support for a dummy GRANT command to satisfy Powerbuilder.

D.7.4. Alterações na distribuição 3.20.15

  • Fixed fatal bug packets out of order when using MIT-pthreads.

  • Removed possible loop when a thread waits for command from client and fcntl() fails. Thanks to Mike Bretz for finding this bug.

  • Changed alarm loop in mysqld.cc because shutdown didn't always succeed in Linux.

  • Removed use of termbits from mysql.cc. This conflicted with glibc 2.0.

  • Fixed some syntax errors for at least BSD and Linux.

  • Fixed bug when doing a SELECT as superuser without a database.

  • Fixed bug when doing SELECT with group calculation to outfile.

D.7.5. Alterações na distribuição 3.20.14

  • If one gives -p or --password option to mysql without an argument, the user is solicited for the password from the tty.

  • Added default password from MYSQL_PWD (by Elmar Haneke).

  • Added command kill to mysqladmin to kill a specific MySQL thread.

  • Sometimes when doing a reconnect on a down connection this succeeded first on second try.

  • Fixed adding an AUTO_INCREMENT key with ALTER_TABLE.

  • AVG() gave too small value on some SELECT statements with GROUP BY and ORDER BY.

  • Added new DATETIME type (by Giovanni Maruzzelli ).

  • Fixed that defining DONT_USE_DEFAULT_FIELDS works.

  • Changed to use a thread to handle alarms instead of signals on Solaris to avoid race conditions.

  • Fixed default length of signed numbers. (George Harvey .)

  • Allow anything for CREATE INDEX.

  • Add prezeros when packing numbers to DATE, TIME and TIMESTAMP.

  • Fixed a bug in OR of multiple tables (gave empty set).

  • Added many patches to MIT-pthreads. This fixes at least one lookup bug.

D.7.6. Alterações na distribuição 3.20.13

  • Added standard SQL-92 DATE and TIME types.

  • Fixed bug in SELECT with AND-OR levels.

  • Added support for Slovenian characters. The Contrib directory contains source and instructions for adding other character sets.

  • Fixed bug with LIMIT and ORDER BY.

  • Allow ORDER BY and GROUP BY on items that aren't in the SELECT list. (Thanks to Wim Bonis , for pointing this out.)

  • Allow setting of timestamp values in INSERT.

  • Fixed bug with SELECT ... WHERE ... = NULL.

  • Added changes for glibc 2.0. To get glibc to work, you should add the gibc-2.0-sigwait-patch before compiling glibc.

  • Fixed bug in ALTER TABLE when changing a NOT NULL field to allow NULL values.

  • Added some SQL-92 synonyms as field types to CREATE TABLE. CREATE TABLE now allows FLOAT(4) and FLOAT(8) to mean FLOAT and DOUBLE.

  • New utility program mysqlaccess by . This program shows the access rights for a specific user and the grant rows that determine this grant.

  • Added WHERE const op field (by ).

D.7.7. Alterações na distribuição 3.20.11

  • When using SELECT ... INTO OUTFILE, all temporary tables are ISAM instead of HEAP to allow big dumps.

  • Changed date functions to be string functions. This fixed some ``funny'' side effects when sorting on dates.

  • Extended ALTER TABLE for SQL-92 compliance.

  • Some minor compatibility changes.

  • Added --port and --socket options to all utility programs and mysqld.

  • Fixed MIT-pthreads readdir_r(). Now mysqladmin create database and mysqladmin drop database should work.

  • Changed MIT-pthreads to use our tempnam(). This should fix the ``sort aborted'' bug.

  • Added sync of records count in sql_update. This fixed slow updates on first connection. (Thanks to Vaclav Bittner for the test.)

D.7.8. Alterações na distribuição 3.20.10

  • New insert type: INSERT INTO ... SELECT ...

  • MEDIUMBLOB fixed.

  • Fixed bug in ALTER TABLE and BLOB values.

  • SELECT ... INTO OUTFILE now creates the file in the current database directory.

  • DROP TABLE now can take a list of tables.

  • Oracle synonym DESCRIBE (DESC).

  • Changes to make_binary_distribution.

  • Added some comments to installation instructions about configure's C++ link test.

  • Added --without-perl option to configure.

  • Lots of small portability changes.

D.7.9. Alterações na distribuição 3.20.9

  • ALTER TABLE didn't copy null bit. As a result, fields that were allowed to have NULL values were always NULL.

  • CREATE didn't take numbers as DEFAULT.

  • Some compatibility changes for SunOS.

  • Removed config.cache from old distribution.

D.7.10. Alterações na distribuição 3.20.8

  • Fixed bug with ALTER TABLE and multi-part keys.

D.7.11. Alterações na distribuição 3.20.7

  • New commands: ALTER TABLE, SELECT ... INTO OUTFILE and LOAD DATA INFILE.

  • New function: NOW().

  • Added new field File_priv to mysql/user table.

  • New script add_file_priv which adds the new field File_priv to the user table. This script must be executed if you want to use the new SELECT ... INTO and LOAD DATA INFILE ... commands with a version of MySQL earlier than 3.20.7.

  • Fixed bug in locking code, which made lock_test.pl test fail.

  • New files NEW and BUGS.

  • Changed select_test.c and insert_test.c to include config.h.

  • Added status command to mysqladmin for short logging.

  • Increased maximum number of keys to 16 and maximum number of key parts to 15.

  • Use of sub keys. A key may now be a prefix of a string field.

  • Added -k option to mysqlshow, to get key information for a table.

  • Added long options to mysqldump.

D.7.12. 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.

  • mysql 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.

  • mysql now allows doubled '' or "" within strings for embedded ' or ".

  • New math functions: EXP(), LOG(), SQRT(), ROUND(), CEILING().

D.7.13. Alterações na distribuição 3.20.3

  • The configure source now compiles a thread-free client library -lmysqlclient. This is the only library that needs to be linked with client applications. When using the binary releases, you must link with -lmysql -lmysys -ldbug -lmystrings as before.

  • New readline library from bash-2.0.

  • LOTS of small changes to configure and makefiles (and related source).

  • It should now be possible to compile in another directory using VPATH. Tested with GNU Make 3.75.

  • safe_mysqld and mysql.server changed to be more compatible between the source and the binary releases.

  • LIMIT now takes one or two numeric arguments. If one argument is given, it indicates the maximum number of rows in a result. If two arguments are given, the first argument indicates the offset of the first row to return, the second is the maximum number of rows. With this it's easy to do a poor man's next page/previous page WWW application.

  • Changed name of SQL function FIELDS() to ELT(). Changed SQL function INTERVALL() to INTERVAL().

  • Made SHOW COLUMNS a synonym for SHOW FIELDS. Added compatibility syntax FRIEND KEY to CREATE TABLE. In MySQL, this creates a non-unique key on the given columns.

  • Added CREATE INDEX and DROP INDEX as compatibility functions. In MySQL, CREATE INDEX only checks if the index exists and issues an error if it doesn't exist. DROP INDEX always succeeds.

  • mysqladmin.c: added client version to version information.

  • Fixed core dump bug in sql_acl (core on new connection).

  • Removed host, user and db tables from database test in the distribution.

  • FIELD_TYPE_CHAR can now be signed (-128 to 127) or unsigned (0 to 255) Previously, it was always unsigned.

  • Bug fixes in CONCAT() and WEEKDAY().

  • Changed a lot of source to get mysqld to be compiled with SunPro compiler.

  • SQL functions must now have a '(' immediately after the function name (no intervening space). For example, 'USER(' is regarded as beginning a function call, and 'USER (' is regarded as an identifier USER followed by a '(', not as a function call.

D.7.14. Alterações na distribuição 3.20.0

  • The source distribution is done with configure and Automake. It will make porting much easier. The readline library is included in the distribution.

  • Separate client compilation: the client code should be very easy to compile on systems which don't have threads.

  • The old Perl interface code is automatically compiled and installed. Automatic compiling of DBD will follow when the new DBD code is ported.

  • Dynamic language support: mysqld can now be started with Swedish or English (default) error messages.

  • New functions: INSERT(), RTRIM(), LTRIM() and FORMAT().

  • mysqldump now works correctly for all field types (even AUTO_INCREMENT). The format for SHOW FIELDS FROM tbl_name is changed so the Type column contains information suitable for CREATE TABLE. In previous releases, some CREATE TABLE information had to be patched when re-creating tables.

  • Some parser bugs from 3.19.5 (BLOB and TIMESTAMP) are corrected. TIMESTAMP now returns different date information depending on its create length.

  • Changed parser to allow a database, table or field name to start with a number or '_'.

  • All old C code from Unireg changed to C++ and cleaned up. This makes the daemon a little smaller and easier to understand.

  • A lot of small bug fixes done.

  • New INSTALL files (not final version) and some information regarding porting.

D.8. Alterações na distribuição 3.19.x

Version 3.19 is quite old now, and should be avoided if possible. This information is kept here for historical purposes only.

D.8.1. Alterações na distribuição 3.19.5

  • Some new functions, some more optimization on joins.

  • Should now compile clean on Linux (2.0.x).

  • Added functions DATABASE(), USER(), POW(), LOG10() (needed for ODBC).

  • In a WHERE with an ORDER BY on fields from only one table, the table is now preferred as first table in a multi-join.

  • HAVING and IS NULL or IS NOT NULL now works.

  • A group on one column and a sort on a group function (SUM(), AVG()...) didn't work together. Fixed.

  • mysqldump: Didn't send password to server.

D.8.2. Alterações na distribuição 3.19.4

  • Fixed horrible locking bug when inserting in one thread and reading in another thread.

  • Fixed one-off decimal bug. 1.00 was output as 1.0.

  • Added attribute 'Locked' to process list as information if a query is locked by another query.

  • Fixed full magic timestamp. Timestamp length may now be 14, 12, 10, 8, 6, 4 or 2 bytes.

  • Sort on some numeric functions could sort incorrectly on last number.

  • IF(arg,syntax_error,syntax_error) crashed.

  • Added functions CEILING(), ROUND(), EXP(), LOG() and SQRT().

  • Enhanced BETWEEN to handle strings.

D.8.3. Alterações na distribuição 3.19.3

  • Fixed SELECT with grouping on BLOB columns not to return incorrect BLOB info. Grouping, sorting and distinct on BLOB columns will not yet work as expected (probably it will group/sort by the first 7 characters in the BLOB). Grouping on formulas with a fixed string size (use MID() on a BLOB) should work.

  • Ao se fazer um full join (sem chave diretas) em tabelas múltiplas com campos BLOB, o BLOB vinha como lixo na saída.

  • Corrigido DISTINCT com colunas calculadas.


This is a translation of the MySQL Reference Manual that can be found at dev.mysql.com. The original Reference Manual is in English, and this translation is not necessarily as up to date as the English version.