-
Regular expression search added (SIMILAR predicate and SUBSTRING( ... SIMILAR ... ESCAPE ...) function)
-
Stored events added
-
NOW, CONCAT, and UNIX_TIMESTAMP functions added for compatibility with MySQL
-
FROM_DAYS function added
-
LEAD and LAG functions added, with syntax similar to those in Oracle (OVER (PARTITION BY ... ORDER BY...) construction)
-
EXTRACT function for working with date fields added
-
VSIZE function returning the number of bytes in the argument internal view added
-
Sub-queries allowed in the left part of the IN and NOT IN predicates, equalities and inequalities
-
Sub-queries allowed in a SELECT list (with some limitations)
-
Non-constant templates allowed in LIKE and NOT LIKE predicates
-
Expressions in lists allowed in the right part of the IN and NOT IN predicates
-
Empty list in the right part of the NOT IN predicate allowed
-
Duplicate column names in sub-queries allowed
-
ORDER BY construction allowed in sub-queries (makes sense in combination with ROWNUM construction)
-
BOOLEAN expressions allowed (in a SELECT list; in INSERT in VALUES list; in UPDATE after =; in GROUP BY; in ORDER BY)
-
Reference of an external character key to a primary key of the same type but different length allowed
-
LINTER_SYSTEM_USER pseudo-value returning the numeric ID of the current user added
-
CORRECT INDEX and CORRECT BITMAP commands added to make minor corrections to the table structure
-
Commands for temporary reference integrity prohibition added
-
SORT {DATA|INDEX} hint added for sorting method selection management
-
UNION/INTERSECT/EXCEPT operation result command naming modified
-
Commands for deleting the source code of stored procedures and triggers from the database added
-
BY APPEND modifier allowed at the end of ALTER TABLE ADD PRIMARY KEY, ALTER TABLE ADD UNIQUE, ALTER TABLE ADD FOREIGN KEY (creating an index by successively adding elements, not by sorting)
-
SLEEP function for stored procedures added
-
Transaction support added to the stored procedure language
-
OVER ([PARTITION BY : ORDER BY ...) construction for agregate functions now supported (partial support of SQL2003 analytical capabilities)
-
Conversion of an inequality predicate pair to a range search predicate optimized
-
Calculation of complex queries with several AND and OR predicate junctions optimized
-
Time quantization of queries implemented to enhance execution of parallel queries
-
Kernel interface enhanced to support new startup parameters
-
Multilanguage assembly for Windows CE revised
-
Automatic authentication for UNIX added
-
Detailed information about loaded page types shown during startup with the /trace=decomp key
-
UNION ALL query execution optimized
-
Sorting optimized using hash search of pages in the sorting pool
-
/IGNERROR kernel start key added to ignore database recovery errors
-
New columns added to the $$$CHAN information table: BASE_PRIORITY - channel priority, QUERY_PRIORITY - current query priority, CURRENT_PRIORITY - current execution quantum priority
-
Index structure testing by TEST TABLE command (and TESTDB utility) optimized
-
Parallel processing of several SELECT queries optimized
