XOOPS Brasil


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.