Hi,
Mysql 5.0.2-Alpha, A New Version of The Popular Open Source / Free Software
Database Management System Has Been Released. It is now available in Souce. 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 at the latter OR
Choose Another Download Site.
THIS is a snapshot of the alpha development tree, adding new features and
FIXING Recently Discovered Bugs.
Note: this is an alpha release. This build passes MOUR TEST Suite
And Fixes a Lot of Reported Bugs Found in The Previous 5.0.1 Release.
However, please be aware this is not a 'standard mysql release'.
There Are Still Some Open critical Bugs in Our Bug Database
(http://bugs.mysql.com/) That Affect this Release
AS Well. and there area
A Number of Platforms That Are Experience Build Issues.
WE Are Actively Working to FIX THESE ISSUES AND WILL MAKE A New RELEASE
WHERE THESE ARE FIXED AS Soon as Possible. this snapshot gives you an
Opportunity for testing and evatating the new mysql 5.0 features for
FUTURE PRODUCTS.
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.2:
FunctionAlicity Added or Changed:
* Warning: incompatible change! The Precedency of NOT OPERATOR HAS
Changed so this expressions such as not a betWeen B and C Are
PARSED CORRECTLY As Not (A Between B and C) Rather Than As (Not A)
Between B and C. The Pre-5.0 Higher-Precedence Behavior Can Be
Obtained by enabling the new high_not_precedence SQL Mode.
* Added is [not] Boolean_Value Syntax, WHERE Boolean_Value IS true, false, or unknown.
* Added Several InnoDB Status Variables. See Section 5.2.4
Server status variables.
* Implement The with check option.
* The Schema and Schemas Keywords Are Now Accepted As Synonyms for
Database and databases.
* Added Initial Support for Rudimentary Triggers (The Create Trigger
AND DROP TRIGGER STATEMENTS.
* Added Basic Support for Read-Only Server Side Cursors.
* mysqldump --single-transaction --Master-data is now Able To Take
An online (non-blocking) Dump of innodb and report the
Corresponding Binary Log Coordinates, Which Makes A Backup
Suitable for Point-in-Time Recovery, Roll-Forward or Replication
Slave Creation. See Section 8.8 The MySQLDUMP DATABASE
Backup program.
* Added --Start-datetime, --stop-datetime, --start-position,
--Stop-position options to mysqlbinlog (Makes Point-in-Time
Recovery Easier.
* Made the MySQL Server Not React To Signals SIGHUP AND SIGQUIT ON
Mac OS X 10.3. This is needed Because Under this OS, The MySQL
Server Receives Lots of these Signals (Reported AS bug # 2030).
* New --Auto-increment-increment and --auto-inccess-offset startup
Options. THESE Allow you to set up a server to generate
Auto-Increment Values That Don't Conflict With Another Server.
* Mysql now by Default Will Check Dates and Only Allow Fully Correct
Dates. if you want to mysql to behave as default, you shouth
Enable the new allow_INVALID_DATES SQL MODE.
* Added strict_trans_tables, stric_all_tables, no_zero_in_date,
NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, AND TRADITIONAL SQL
Modes. The traditional mode is shorthand for all the preceding
MODES. WHEN USING MODE TRADIAL, MYSQL GeneRates An Error Ifyou Try To INSERT A WRONG VALUE IN A Column. It Does Not Adjust
The value to the closest possible legal value.
* MySQL now Remembers Which Column Were Declared to Have Default
Values. in strict_trans_tables / strict_all_tables mode, you now get
An Error if you do an insert without specifying all columns That
Don't have a default value. a side effect of this is that when you you do
Do Show Create for a New Table, you will no longer see a default
Value for a column for Which you Didn't Specify A Default Value.
* The compilation flag dont_use_default_fields Was Removed Because
You can get the Same Behavior by Setting The SQL_MODE SYSTEM
Variable to strict_trans_tables.
* Added no_auto_create_user SQL Mode to Prevent Grant from
Automatically Creating New Users if it 10 OtherWise Do So,
Unless A Password Also is Specified.
* We now detect TOO-LARGE FLOATING POINT NUMBERS DURING STATEMENT
Parsing and generate an error message for them.
* Renamed the SQL_UPDATABLE_VIEW_KEY SYSTEM VARIABLE TO
Updatable_views_with_limit. this variable now can have online only two
VALUES:
1 or yes: don't issue an error message (warning only) if a
View WITHOUT Presence of a Key In the underlying Table IS
Used in queries with a limit clause for updating. (this is
The Default value.)
0 or no: Prohibit Update of a View, Which Does Not Contain A
Key in the underlying Table and the query buy a limited clause
USUALLY FOUND in GUI Tools.
* REVERTED OUTPUT FORMAT OF SHOW TABLES To Old Pre-5.0.1 Format That
DID NOT INCLUDE A TABLE TY Column. To Get The Additional Column
That Lists The Table Type, Use show full tables now.
* The mysql_fix_privilege_tables script now Initializes the globalcreate view and show view privileges in the user table to the
Value of the create privilege in what table.
* If The Server Finds That That User Table Has Not Been Upgraded To
INCLUDE The View-Related Privilege Column, IT Treats Each Account
AS Having View Privileges That Are The Same As ITS Create
PRIVILEGE.
* Check Table Now Works with Views (i.e. Check View Integrity: all
Underlying Tables and Column Are Present and so on
* Added Merge Algorithm for Join View (View Consists of Several Tables)
And Update / INSERT Support for One of underlying Tables in Such Views.
Bugs fixed:
* Fixed That mysqlbinlog --Read-from-transote-Server Sometimes
Couldn't Accept Two Binary Logfiles On The Command Line. (BUG)
# 4507)
* Fixed That mysqlbinlog --Position --Read-from-transote-server had
INCORRECT # at lines. (bug # 4506)
* Fixed what create Table ... type = heap ... as select ... caused
Replication slave to stop. (bug # 4971)
* Fixed what mysql_options (..., mysql_opt_local_infile, ...) Failed to
Disable Load Data Local Infile. (BUG # 5038)
* Fixed That Disable-local-infile option Had No Effect if Client
Read it from a configuration file using
MySQL_Options (..., mysql_read_default, ...). (bug # 5073)
* Fixed That SET GLOBAL SYNC_BINLOG DID NOT WORK ON Some Platforms
(Mac OS X). (BUG # 5064)
* Fixed That MySQL-TEST-Run Failed on The RPL_TRUNC_BINLOG TEST IF
Running test from the installed (the target of 'make install ")
Directory. (bug # 5050)
* Fixed That mysql-test-run failed on the grant_cache test when run
As UNIX User 'root'. (bug # 4678)
* Fixed An Unlikely Deadlock Which Could Happen When Using Kill.
(Bug # 4810)
* Fixed a crashen one connections got killed while it is doingstart slave. (Bug # 4827)
* Made Flush Tables With Read Lock Block Commit IF Server Is Running
With binary logging; this Ensures That the binary log position can
BE TRUSTED WHEN DOING A FULL Backup of Tables and The Binary Log.
(Bug # 4953)
* Fixed That the counter of an auto_increment column was not reset
BY TRUNCATE TABLE I The Table Was a Temporary One. (bug # 5033)
* Fixed Slave Sql Thread So That The Set Collation_server ...
Statements IT Replicates Don't advance its position (SO That if IT
Gets Interrupted Before The Actual Update Query, IT Will Later
Redo the set). (bug # 5705)
* Fixed That if the slave SQL Thread Found A Syntax Error In A Query
(Which Should Be Rare, As the Master Parsed It Success, IT
Stops. (bug # 5711)
* Fixed That IF a Write to a Myisam Table Fails Because of a fulll
Disk OR An Exceededed Disk Quota, It Prints a Message To The Error
Log Every 10 Minutes, and Waits Until Disk Becomes Free. (BUG)
# 3248)
* Fixed Problem Introducesd in 4.0.21 Where a connection starting a
Transaction, Doing Updates, Then Flush Tables with Read Lock, Then
Commit, Would Cause Replication Slaves To Stop (Complaining About
Error 1223). Bug Surfaced When Using The InnoDB Innobackup Script.
(Bug # 5949)
* Optimize Table, Repair Table, And Analyze Table Are Now Replicated
WITHOUT Any Error Code in The Binary Log. (BUG # 5551)
Enjoy!
Matt
-
Matt Wagner, Production Engineer
MySQL AB, www.mysql.com
Northfield, Mn, USA
