Jbtje liet weten dat er vandaag een nieuwe stable release van MySQL is uitgebracht. Zoals je waarschijnlijk weet is MySQL de database server die deze pagina voor jou naar boven tovert. Kees is inmiddels bezig om .39 op Apollo en Artemis te installeren. We verwachten van jou hetzelfde! Anyway, mocht je dit boeiend vinden dan kun je hier de vanilla 3.23.39 en hier de super-dope MySQL 3.23.39 Max (met leuke goodies zoals InnoDB en BerkeleyDB support) neertanken. Release .39 kent de volgende veranderingen:
- If one dropped and added an AUTO_INCREMENT column, the AUTO_INCREMENT sequence wasn't reset.
- CREATE .. SELECT now creates not unique indexes delayed.
- Fixed problem where LOCK TABLES table_name READ followed by FLUSH TABLES put a exclusive lock on the table.
- REAL @variables with was represented with 2 digits when converted to strings.
- Fixed problem that client 'hung' when LOAD TABLE FROM MASTER failed.
- Running 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 to get MySQL 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 coredump bug in InnoDB when tablespace was full.
- Fixed problem with MERGE tables and big tables (> 4G) when using ORDER BY.