Software-update: MySQL 3.23.51

Er is alweer een verse versie van de bekende database-server MySQL. Dit wist BrZ ons als eerste te melden. Zoals gewoonlijk zijn er weer veel bugs opgelost. Voor de mensen met linux kernel 2.2.14 staat er een waarschuwing op de download pagina van MySQL.com. Er wordt geadviseerd, als je deze versie gaat gebruiken, om een nieuwe kernel te installeren wegens een bug in kernel 2.2.14. Hieronder het changelog van 3.23.51:

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 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 threadsafe even if gethostbyname_r doesn't exists.

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 BDB 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 2 and third arguments are case sensitive.

Fixed core dump problem on OSF in gethostbyname_r.

Fixed that underflowed decimal fields is 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.

Versienummer	3.23.51
Besturingssystemen	Windows 9x, Windows NT, Windows 2000, Linux, BSD, Windows XP, Linux x86, macOS, OS/2, Solaris, UNIX
Website	MySQL.com
Download	http://www.mysql.com/downloads/mysql-3.23.html

Reacties (8)

[Femme]

Voor de volledigheid ook nog de niet onbelangrijke changelog van 3.23.50, die nooit officieel is uitgebracht. Vooral InnoDB heeft in .50 belangrijke wijzigingen ondergaan, zoals volwaardige support voor foreign key constraints.

<img src=g/nblt.gif width=6 height=9> MySQL 3.23.50 changelog:

[list]
[li]Fixed problem with `crash-me' and gcc 3.0.4.
[li]Fixed that `@@unknown_variable' doesn't hang server.
[li]Added `@@VERSION' as a synonym for `VERSION()'.
[li]`SHOW VARIABLES LIKE 'xxx'' is now case insensitive.
[li]Fixed timeout for `GET_LOCK()' on HPUX with DCE threads.
[li]Fixed memory allocation bug in the glibc library used to build
Linux binaries, which caused mysqld to die in 'free()'.
[li]Fixed `SIGINT' and `SIGQUIT' problems in `mysql'.
[li]Fixed bug in character table converts when used with big ( > 64K)
strings.
[li]`InnoDB' now retains foreign key constraints through `ALTER TABLE'
and `CREATE/DROP INDEX'.
[li]`InnoDB' now allows foreign key constraints to be added through the
`ALTER TABLE' syntax.
[li]`InnoDB' tables can now be set to automatically grow in size
(autoextend).
[li]Fixed some buffer overflow problems when reading startup
parameters.
[li]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'.
[li]Fixed bug when using `WHERE key_column = 'J' or key_column='j''.
[li]Fixed core-dump bug when using `--log-bin' with `LOAD DATA INFILE'
without an active database.
[li]Fixed bug in `RENAME TABLE' when used with
`lower_case_table_names=1' (default on Windows).
[li]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.
[li]Fixed problem with `SHOW CREATE TABLE' and `PRIMARY KEY' when using
32 indexes.
[li]Fixed that one can use `SET PASSWORD' for the anonymous user.
[li]Fixed core-dump bug when reading client groups from option files
using `mysql_options()'.
[li]Memory leak (16 bytes per every *corrupted* table) closed.
[li]Fixed binary builds to use `--enable-local-infile'.
[li]Update source to work with new `bison' version.
[li]Updated shell scripts to new agree with new POSIX standard.
[li]Fixed bug where `DATE_FORMAT()' returned empty string when used
with `GROUP BY'.[/list]


<img src=g/nblt.gif width=6 height=9> InnoDB 3.23.50 changelog:
[list]
[li]InnoDB now supports an auto-extending last data file. You do not need to preallocate the whole data file at the database startup.
[li]Made several changes to facilitate the use of the InnoDB Hot Backup tool. It is a separate non-free tool you can use to take online backups of your database without shutting down the server or setting any locks.
[li]If you want to run the InnoDB Hot Backup tool on an auto-extending data file you have to upgrade it to version ibbackup-0.35.
[li]The log scan phase in crash recovery will now run much faster.
[li]Starting from this server version, the hot backup tool truncates unused ends in the backup InnoDB data files.
[li]To allow the hot backup tool to work, on Windows we no longer use unbuffered i/o or native async i/o; instead we use the same simulated async i/o as on Unix.
[li]You can now define the ON DELETE CASCADE or ON DELETE SET NULL clause on foreign keys.
[li]FOREIGN KEY constraints now survive ALTER TABLE and CREATE INDEX.
[li]We suppress the FOREIGN KEY check if any of the column values in the foreign key or referenced key to be checked is the SQL NULL. This is compatible with Oracle, for example.
[li]SHOW CREATE TABLE now lists also foreign key constraints. Also mysqldump no longer forgets about foreign keys in table definitions.
[li]You can now add a new foreign key constraint with ALTER TABLE ... ADD CONSTRAINT FOREIGN KEY (...) REFERENCES ... (...).
[li]FOREIGN KEY definitions now allow backquotes around table and column names.
[li]MySQL command SET TRANSACTION ISOLATION LEVEL ... has now the following effect on InnoDB tables: if a transaction is defined as SERIALIZABLE then InnoDB conceptually adds LOCK IN SHARE MODE to all consistent reads. If a transaction is defined to have any other isolation level, then InnoDB obeys its default locking strategy which is REPEATABLE READ.
[li]SHOW TABLE STATUS no longer sets an x-lock at the end of an auto-increment index if the auto-increment counter has already been initialized. This removes in almost all cases the surprising deadlocks caused by SHOW TABLE STATUS.

[li]Fixed a bug: in a CREATE TABLE statement the string 'foreign' followed by a non-space character confused the FOREIGN KEY parser and caused table creation to fail with errno 150. [/list]

[Stephan Oudmaijer]

Wel koel dat nu standaard de windows binary op dezelfde datum als de linux binary wordt gereleased.

Bij deze ook nog de innodb changelog:

* Fixed a bug: a join could result in a seg fault in copying of a BLOB or TEXT column if some of the BLOB or TEXT columns in the table contained SQL NULL values.
* Fixed a bug: if you added self-referential foreign key constraints with ON DELETE CASCADE to tables and a row deletion caused InnoDB to attempt the deletion of the same row twice because of a cascading delete, then you got an assertion failure.
* Fixed a bug: if you use MySQL 'user level locks' and close a connection, then InnoDB may assert in ha_innobase.cc, line 302.

[Robinski]

iemand een mirrortje om de win binary te downloaden?

MySQL.com is down:

Not Found
The requested URL / was not found on this server.

[ironx]

Win-Binary:

http://belnet.dl.sourceforge.net/sourceforge/mysql/mysql-3.23.51-win.z ip

[Robinski]

Thanx

[Mr.CeeJay]

en dat op de dag dat ik tentamen mySQL heb

[Coen Rosdorff]

Als je replicatie gebruikt kan je deze versie beter laten staan. Er zit namelijk een fout in waardoor het niet echt wil werken.

[xenobia12345]

het kon korter.....