Release Notes: Performance enhancements were made for the following functionalities: prepared statement caching for select queries at the JDBC driver level, select query with the order by clause, retrieving objects from java.sql.ResultSet, select query with user defined functions, and time reduction in index navigation.
Release Notes: User defined functions, support for updatable views, scalar functions, and table aliases in Update and Delete queries, support for using scalar functions in Group By clauses, addition and subtraction using (+) and (-) operators with Date and Timestamp data types, and support for scalar sub-queries in the select-list of a select query. This release also supports sorting using the Order By clause in a sub-query column, support for accessing cursor columns in FOR LOOP statements using a single variable, support for recursive routines, and performance enhancements related to DDL.
Release Notes: New features include full text search, support for external Java methods, support for read-only data, and multi line comments.
Release Notes: New features include significantly reduced boot-up time, a visual interface for creating triggers, tables, and stored procedures, Select For Update, support for Default in Insert query, natural join, and support for expressions in the 'IN' predicate. Current Timestamp function, Backup and Restore. The 'AUTOCOMMIT TRUE' transaction performance was improved. Changes were incorporated in the locking and index handling mechanism. Bugs related to privileges of procedure execution have been fixed, and much more.