(mysql.info.gz) TODO MySQL 5

 
 C.1 New Features Planned for 5.0
 ================================
 
 The following features are planned for inclusion into MySQL 5.0.  Some
 of the features such as stored procedures are complete and are included
 in MySQL 5.0 alpha.  Others such as cursors are only partially
 available. Expect these and other features to mature and be fully
 supported in upcoming releases.
 
 Note that because we have many developers that are working on different
 projects, there will also be many additional features. There is also a
 small chance that some of these features will be added to MySQL 4.1.
 For a list what is done in MySQL 4.1, see  Nutshell 4.1 features.
 
 For those wishing to take a look at the bleeding edge of MySQL
 development, we make our BitKeeper repository for MySQL version 5.0
 publicly available.   Installing source tree.
 
 Views
         * Views, implemented in stepwise fashion up to full
           functionality.   ANSI diff Views.  `CREATE VIEW'
           CREATE VIEW.
 
 Stored Procedures
         * Stored procedures currently are implemented, based on the
           SQL:2003 standard.   Stored Procedures.
 
 
 New functionality
         * Elementary cursor support.   Cursors.
 
         * The ability to specify explicitly for `MyISAM' tables that an
           index should be created as an `RTREE' index.  (In MySQL 4.1,
           `RTREE' indexes are used internally for geometrical data that
           use GIS data types, but cannot be created on request.)
 
         * Dynamic length rows for `MEMORY' tables.
 
 Standards compliance, portability and migration
         * Support for Data Dictionary / `INFORMATION_SCHEMA'.  
           `INFORMATION_SCHEMA' INFORMATION_SCHEMA.
 
         * Add true `VARCHAR' support (column lengths longer than 255,
           and no stripping of trailing whitespace).  There is support
           for this in the `MyISAM' storage engine, but it is not
           available at the user level.
 
 Speed enhancements
         * `SHOW COLUMNS FROM TBL_NAME' (used by the `mysql' client to
           allow expansions of column names) should not open the table,
           only the definition file. This will require less memory and
           be much faster.
 
         * Allow `DELETE' on `MyISAM' tables to use the record cache.
           To do this, we need to update the threads record cache when
           we update the `.MYD' file.
 
         * Better support for `MEMORY' tables:
              * Dynamic length rows.
 
              * Faster row handling (less copying).
 
 Usability enhancements
         * Resolving the issue of `RENAME TABLE' on a table used in an
           active `MERGE' table possibly corrupting the table.
 
 
 The news section of this manual includes a more in-depth list of
 features.   News-5.0.x.
Info Catalog
(mysql.info.gz) TODO
(mysql.info.gz) TODO MySQL 5
automatically generated byinfo2html