EMS logo

Навигация по продуктам

выберите Ваш продукт

Наш партнерский статус

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

Новости SQL индустрии

Все SQL новости

03/12/2004
MySQL 5.0.2-alpha released.

MySQL 5.0.2-alpha, a new version of the popular Open Source/Free Software Database Management System is released. 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.

There are still some open critical bugs in our bugs database (http://bugs.mysql.com/) that affect this release as well. And there are a number of platforms that are experiencing build issues.

Changes in release 5.0.2:

 Functionality added or changed:

  • Warning: Incompatible change! The precedence of NOT operator has changed so that 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.
  • Implemented the WITH CHECK OPTION clause for CREATE VIEW.
  • Added initial support for rudimentary triggers (the CREATE TRIGGER and DROP TRIGGER statements).
  • Added basic support for read-only server side cursors.
  • MySQL now by default will check dates and only allow fully correct dates. If you want MySQL to behave as default, you should enable the new ALLOW_INVALID_DATES SQL mode.
  • CHECK TABLE now works with VIEWs (i.e. check view integrity: all underlying tables and columns 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.
  • Much more new features and bugfixes. See complete list of enhancements at here

Source: dev.mysql.com

twitterfacebook