February 20, 2019

MySQL 6 Features Roll Into MySQL 5.5 Milestone - page 2

Faster Release Cycle, Enhancements

  • December 22, 2009
  • By Sean Michael Kerner

"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

Most Popular LinuxPlanet Stories