The new statement EXPLAIN ANALYZE executes the statement, and displays the query plan with the actual row scan count for each table.

If baseDir is set, and a database name is given which points to a directory above (eg. "../dbname"), an exception is thrown.

If baseDir is set, and a database name is given which points to a directory above (eg. "../dbname"), an exception is thrown.

The functions isBeforeFirst() and isAfterLast() were not compliant to the JDBC spec. If the ResultSet contains no rows, they must return false. Fixed.

--no commit message

--no commit message

Newer Sun Java versions throw expections if java.sql.Date.valueOf is not in yyyy-mm-dd format. http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=6898593

Workaround for a java.sql.Date issue: years above 9999 are not formatted correctly. When calling ResultSet.getString() on a date value, an alternative formatting algorithm is used.

ROWNUM could not be used for pagination. The follow query returned no rows: select x from (select *, rownum as r from system_range(1, 3)) where r=2;

Prepared statements with nested subqueries did not always return the correct result. Example: select ?, ?, (select count(*) from test t, (select id from test where 0=?) t2 where t2.id=t.id) from test