RE: MySQL 5.0.6-beta has been released

2005-06-01 Thread mel list_php

Hi,

I downloaded and tried to install from the sources.
./configure, make seem ok, however the make install exit very quickly with 
an error code 127 (perror gives record-file is crashed, no idea of what 
that means!).


My old 5.0.4 istall is working fine, so I don't think the system is in 
cause,but in case of it's a mandriva cooker.


Anybody has any clue?

Thanks
Melanie


From: Matt Wagner [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
CC: mysql@lists.mysql.com mysql@lists.mysql.com,
[EMAIL PROTECTED]

Subject: MySQL 5.0.6-beta has been released
Date: Tue, 31 May 2005 18:01:48 -0500

Hi,

A new version of MySQL Community Edition 5.0.6-beta Open Source database
management system has been released.  This version includes support for
Stored Procedures, Triggers, Views and many other features. It is now
available in source and binary form for a number of platforms from our
download pages at http://dev.mysql.com/downloads/ and mirror sites.

Note that not all mirror sites may be up-to-date at this point. If you
cannot find this version on a particular mirror, please try again later or
choose another download site.

This is the third published Beta release in the 5.0 series. All attention
will now be focused on fixing bugs and stabilizing 5.0 for later production
release.

NOTE: This Beta release, as any other pre-production release, should not be
installed on ``production'' level systems or systems with critical data. It
is good practice to back up your data before installing any new version of
software.  Although MySQL has done its best to ensure a high level of
quality, protect your data by making a backup as you would for any software
beta release.

Please refer to our bug database at http://bugs.mysql.com/ for more details
about the individual open and resolved bugs in this version.

Changes in release 5.0.6:

  Functionality added or changed:
* INCOMPATIBLE CHANGE: `MyISAM' and `InnoDB' tables created
  with `DECIMAL' columns in MySQL 5.0.3 to 5.0.5 will appear corrupt
  after an upgrade to MySQL 5.0.6.  Dump such tables with
  `mysqldump' before upgrading, and then reload them after
  upgrading.  (The same incompatibility will occur for these tables
  created in MySQL 5.0.6 after a downgrade to MySQL 5.0.3 to 5.0.5.)
  (Bug #10465, Bug #10625)
* Added `REFERENCED_TABLE_SCHEMA', `REFERENCED_TABLE_NAME', and
  `REFERENCED_COLUMN_NAME' columns to the `KEY_COLUMN_USAGE' table of
  `INFORMATION_SCHEMA'.  (Bug #9587)
* Added a `--show-warnings' option to `mysql' to cause warnings to
  be shown after each statement if there are any.  This option
  applies to interactive and batch mode.  In interactive mode, `\w'
  and `\W' may be used to enable and disable warning display.  (Bug
  #8684)
* Removed a limitation that prevented use of FIFOs as logging
  targets (such as for the general query log).  This modification
  _does not apply_ to the binary log and the relay log.  (Bug #8271)
* Added a `--debug' option to `my_print_defaults'.
* When the server cannot read a table because it cannot read the
  `.frm' file, print a message that the table was created with a
  different version of MySQL.  (This can happen if you create tables
  that use new features and then downgrade to an older version of
  MySQL.)  (Bug #10435)
* `SHOW VARIABLES' now shows the `slave_compresed_protocol',
  `slave_load_tmpdir' and `slave_skip_errors' system variables.
  (Bug #7800)
* Removed unused system variable `myisam_max_extra_sort_file_size'.
* Changed default value of `myisam_data_pointer_size' from 4 to 6.
  This allows us to avoid `table is full' errors for most cases.
* The variable `concurrent_insert' now takes 3 values.  Setting this
  to 2 changes MyISAM to do concurrent inserts to end of table if
  table is in use by another thread.
* New `/*' prompt for `mysql'. This prompt indicates that a `/* ...
  */' comment was begun on an earlier line and the closing `*/'
  sequence has not yet been seen.  (Bug #9186)
* If strict SQL mode is enabled, `VARCHAR' and `VARBINARY' columns
  with a length greater than 65,535 no longer are silently converted
  to `TEXT' or `BLOB' columns.  Instead, an error occurs.  (Bug
  #8295, Bug #8296)
* The `INFORMATION_SCHEMA.SCHEMATA' table now has a
  `DEFAULT_COLLATION_NAME' column.  (Bug #8998)
* `InnoDB': When the maximum length of `SHOW INNODB STATUS' output
  would be exceeded, truncate the beginning of the list of active
  transactions, instead of truncating the end of the output.  (Bug
  #5436)
* `InnoDB': If `innodb_locks_unsafe_for_binlog' option is set and
  the isolation level of the transaction is not set to serializable
  then `InnoDB' uses a consistent read for select in clauses like
  `INSERT INTO ... SELECT' and `UPDATE ...  (SELECT)' that do not
  specify `FOR UPDATE

Re: MySQL 5.0.6-beta has been released

2005-06-01 Thread Josh Trutwin
On Tue, 31 May 2005 18:01:48 -0500
Matt Wagner [EMAIL PROTECTED] wrote:

snip

 This is the third published Beta release in the 5.0 series. All
 attention will now be focused on fixing bugs and stabilizing 5.0 for
 later production release.

Just curious - was there a 5.0.5-beta release?  The last beta I had
was 5.0.4 unless I missed a release announcement...

Thanks,

Josh

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: [Nevermind!] MySQL 5.0.6-beta has been released

2005-06-01 Thread Josh Trutwin
On Wed, 1 Jun 2005 10:40:10 -0500
Josh Trutwin [EMAIL PROTECTED] wrote:

 On Tue, 31 May 2005 18:01:48 -0500
 Matt Wagner [EMAIL PROTECTED] wrote:
 
 snip
 
  This is the third published Beta release in the 5.0 series. All
  attention will now be focused on fixing bugs and stabilizing 5.0
  for later production release.
 
 Just curious - was there a 5.0.5-beta release?  The last beta I had
 was 5.0.4 unless I missed a release announcement...

Just saw this in the release:

Changes in release 5.0.5 (not released):

Sorry for wasting bandwidth...

Josh

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: MySQL 5.0.6-beta has been released

2005-06-01 Thread Jeff Smelser
On Wednesday 01 June 2005 10:40 am, Josh Trutwin wrote:

 Just curious - was there a 5.0.5-beta release?  The last beta I had
 was 5.0.4 unless I missed a release announcement...

You need to read that email.. it says it was never released.

Jeff


pgpk9pJzWINTK.pgp
Description: PGP signature


MySQL 5.0.6-beta has been released

2005-05-31 Thread Matt Wagner
Hi,

A new version of MySQL Community Edition 5.0.6-beta Open Source database
management system has been released.  This version includes support for
Stored Procedures, Triggers, Views and many other features. It is now
available in source and binary form for a number of platforms from our
download pages at http://dev.mysql.com/downloads/ and mirror sites.

Note that not all mirror sites may be up-to-date at this point. If you
cannot find this version on a particular mirror, please try again later or
choose another download site.

This is the third published Beta release in the 5.0 series. All attention
will now be focused on fixing bugs and stabilizing 5.0 for later production
release.

NOTE: This Beta release, as any other pre-production release, should not be
installed on ``production'' level systems or systems with critical data. It
is good practice to back up your data before installing any new version of
software.  Although MySQL has done its best to ensure a high level of
quality, protect your data by making a backup as you would for any software
beta release.

Please refer to our bug database at http://bugs.mysql.com/ for more details
about the individual open and resolved bugs in this version.

Changes in release 5.0.6:

  Functionality added or changed:
* INCOMPATIBLE CHANGE: `MyISAM' and `InnoDB' tables created
  with `DECIMAL' columns in MySQL 5.0.3 to 5.0.5 will appear corrupt
  after an upgrade to MySQL 5.0.6.  Dump such tables with
  `mysqldump' before upgrading, and then reload them after
  upgrading.  (The same incompatibility will occur for these tables
  created in MySQL 5.0.6 after a downgrade to MySQL 5.0.3 to 5.0.5.)
  (Bug #10465, Bug #10625)
* Added `REFERENCED_TABLE_SCHEMA', `REFERENCED_TABLE_NAME', and
  `REFERENCED_COLUMN_NAME' columns to the `KEY_COLUMN_USAGE' table of
  `INFORMATION_SCHEMA'.  (Bug #9587)
* Added a `--show-warnings' option to `mysql' to cause warnings to
  be shown after each statement if there are any.  This option
  applies to interactive and batch mode.  In interactive mode, `\w'
  and `\W' may be used to enable and disable warning display.  (Bug
  #8684)
* Removed a limitation that prevented use of FIFOs as logging
  targets (such as for the general query log).  This modification
  _does not apply_ to the binary log and the relay log.  (Bug #8271)
* Added a `--debug' option to `my_print_defaults'.
* When the server cannot read a table because it cannot read the
  `.frm' file, print a message that the table was created with a
  different version of MySQL.  (This can happen if you create tables
  that use new features and then downgrade to an older version of
  MySQL.)  (Bug #10435)
* `SHOW VARIABLES' now shows the `slave_compresed_protocol',
  `slave_load_tmpdir' and `slave_skip_errors' system variables.
  (Bug #7800)
* Removed unused system variable `myisam_max_extra_sort_file_size'.
* Changed default value of `myisam_data_pointer_size' from 4 to 6.
  This allows us to avoid `table is full' errors for most cases.
* The variable `concurrent_insert' now takes 3 values.  Setting this
  to 2 changes MyISAM to do concurrent inserts to end of table if
  table is in use by another thread.
* New `/*' prompt for `mysql'. This prompt indicates that a `/* ...
  */' comment was begun on an earlier line and the closing `*/'
  sequence has not yet been seen.  (Bug #9186)
* If strict SQL mode is enabled, `VARCHAR' and `VARBINARY' columns
  with a length greater than 65,535 no longer are silently converted
  to `TEXT' or `BLOB' columns.  Instead, an error occurs.  (Bug
  #8295, Bug #8296)
* The `INFORMATION_SCHEMA.SCHEMATA' table now has a
  `DEFAULT_COLLATION_NAME' column.  (Bug #8998)
* `InnoDB': When the maximum length of `SHOW INNODB STATUS' output
  would be exceeded, truncate the beginning of the list of active
  transactions, instead of truncating the end of the output.  (Bug
  #5436)
* `InnoDB': If `innodb_locks_unsafe_for_binlog' option is set and
  the isolation level of the transaction is not set to serializable
  then `InnoDB' uses a consistent read for select in clauses like
  `INSERT INTO ... SELECT' and `UPDATE ...  (SELECT)' that do not
  specify `FOR UPDATE' or `IN SHARE MODE'.  Thus no locks are set to
  rows read from selected table.
* Updated version of `libedit' to 2.9.  (Bug #2596)
* Removed `mysqlshutdown.exe' and `mysqlwatch.exe' from the Windows
  With Installer distribution.

  Bugs fixed:
* `MERGE' tables could fail on Windows due to incorrect
  interpretation of pathname separator characters for filenames in
  the `.MRG' file.  (Bug #10687)
* Fixed a server crash for `INSERT ... ON DUPLICATE KEY UPDATE' with
  `MERGE' tables, which do not have unique indexes.  (Bug #10400)
* Fix `FORMAT()' to do better