MySQL 6 Features Roll Into MySQL 5.5 Milestone - page 2
Faster Release Cycle, Enhancements
"You can also define ranges or lists based on multiple column values when partitioning tables by RANGE COLUMNS or LIST COLUMNS, respectively," MySQL's release notes read. "Such a range or list may refer to up to 16 columns."
Support for the SIGNAL and RESIGNAL SQL statements has also been added to the MySQL 5.5 milestone release. Both the SIGNAL and RESIGNAL statements are ways in which an error condition can be returned to a database hander.
"Without SIGNAL, it is necessary to resort to workarounds such as deliberately referring to a nonexistent table to cause a routine to return an error," MySQL said in the 5.5 reference manual."RESIGNAL makes it possible to both handle an error and return the error information. Otherwise, by executing an SQL statement within the handler, information that caused the handler's activation is destroyed."
From MySQL 5.1 to MySQL 5.5
For now, the MySQL 5.5 milestone is a development release and is not yet intended for full production deployment. That doesn't mean that Sun doesn't want people to try out the new version, however: Curry said MySQL 5.5 testers are an important component, enabling Sun to receive feedback and gauge progress.
In terms of the migration path from the current MySQL 5.1 release to the in-development MySQL 5.5, it's not a path that users will need to figure out on their own.
"We will be providing plenty of migration materials to help users with the upgrade -- and encourage them to start familiarizing themselves with 5.5's features," Curry said. "We don't expect the process to be anything out-of-the-ordinary."
As to when MySQL 5.5 will be officially released beyond its current developer milestone incarnation, that has yet to be determined, Curry said.
"We'll have a better idea once we get initial feedback from the community, customers and internal QA," he said. "We are trying to improve things with this new milestone model. Initial reaction has been positive, but it's too early to tell. We are happy to get software out into the community's hands and they will tell us how the software is developing."
Sean Michael Kerner is a senior editor at InternetNews.com, covering Linux and open source, application development and networking.
Story courtesy of Internetnews
Story courtesy of Internetnews
Solid state disks (SSDs) made a splash in consumer technology, and now the technology has its eyes on the enterprise storage market. Download this eBook to see what SSDs can do for your infrastructure and review the pros and cons of this potentially game-changing storage technology.
- 1Linux Top 3: GNOME 3.12 and New Betas for Ubuntu 14.04 and OpenMandriva Lx 2014.0
- 2Linux Top 3: Linus Lashes out, Linux 3.14 Gets PIE and Ubuntu One is Done.
- 3Linux Top 3: Ubuntu 14.04, Debian Gives Squeeze More Life and Red Hat Goes Atomic
- 4Linux Top 3: CoreOS, Oracle Enterprise Linux 7 and Ubuntu 14.10
- 5Linux Top 3: Debian Dumps SPARC, Ubuntu Takes Over Linux 3.13 and the Core Infrastructure Initiative