changelog.html 64.8 KB
Newer Older
1 2
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<!--
3
Copyright 2004-2010 H2 Group. Multiple-Licensed under the H2 License, Version 1.0,
4 5
and under the Eclipse Public License, Version 1.0
(http://h2database.com/html/license.html).
6 7 8 9 10 11
Initial Developer: H2 Group
-->
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
<head><meta http-equiv="Content-Type" content="text/html;charset=utf-8" /><title>
Change Log
</title><link rel="stylesheet" type="text/css" href="stylesheet.css" />
12
<!-- [search] { -->
13 14 15
<script type="text/javascript" src="navigation.js"></script>
</head><body onload="frameMe();">
<table class="content"><tr class="content"><td class="content"><div class="contentDiv">
16
<!-- } -->
17 18 19 20

<h1>Change Log</h1>

<h2>Next Version (unreleased)</h2>
21 22
<ul><li>The SLF4J 1.6 API is now used by default (this should not have any user visible effect).
</li><li>The org.h2.tools.Console no longer calls System.exit on shutdown
23 24
    (this should not have any user visible effect, but should allow to integrate the tool easier into other applications).
</li><li>Improved date / time arithmetics. Adding and subtracting a 
25 26
    floating point value from a date or timestamp is now supported.
</li><li>When creating a BLOB with in InputStream or a CLOB with a Reader, and the InputStream or Reader
27 28
    threw an non-IOException, then the LOB storage was broken when storing LOBs in the database.
</li><li>EXPLAIN SELECT didn't include the sample size if one was set.
Thomas Mueller's avatar
Thomas Mueller committed
29 30
</li><li>Improved EXPLAIN plan formatting and documentation.
</li><li>Issue 266: Domains: a NOT NULL clause in a domain definition ignored.
31
</li><li>More accurate calculation of variance and standard deviation for large number of samples with low variance
Thomas Mueller's avatar
Thomas Mueller committed
32 33
    (now using Welford's method).
</li><li>Server: CLOB data with unicode characters between character code 0xd800 and 0xdfff
34 35
    were not transferred correctly. In many cases, the thread was stuck afterwards.
</li><li>Issue 264: the Hibernate dialect in src/tools was removed because it is outdated.
36 37
</li><li>Cache size limit could be exceeded for certain queries, leading to an OutOfMemoryError
    in some cases. Fixed.
Thomas Mueller's avatar
Thomas Mueller committed
38 39 40
</li></ul>

<h2>Version 1.3.148 Beta (2010-12-12)</h2>
41 42 43
<ul><li>The built-in connection pool was simplified a bit.
    The dispose() method no longer throws an exception (it only logs it).
</li><li>The database upgrade (to upgrade from H2 version 1.1.x) has been simplified.
44 45
</li><li>The feature to log all errors (system properties h2.logAllErrors and h2.logAllErrorsFile) has been removed.
</li><li>When starting the H2 Console, the properties file can now be completely disabled.
Thomas Mueller's avatar
Thomas Mueller committed
46 47 48 49
</li><li>Server.openBrowser no longer writes to System.out directly if opening the URL failed.
</li><li>The INSERT optimizations (INSERT ... DIRECT SORTED SELECT) were not parsed correctly when using a column list.
</li><li>H2 Console: the tables and columns are now listed for SQLite as well.
</li><li>H2 Console: improved autocomplete feature (also simplified the source code for this feature).
Thomas Mueller's avatar
Thomas Mueller committed
50
</li><li>Issue 260: the DbStarter servlet context listener now starts the server before opening a connection,
Thomas Mueller's avatar
Thomas Mueller committed
51 52
    so that connecting using the server mode works.
</li><li>The Shell tool can now enable, disable, and display the current autocommit mode.
Thomas Mueller's avatar
Thomas Mueller committed
53
</li><li>Issue 259: there is a limitation in the cluster mode:
54 55
    The SQL statement SET AUTOCOMMIT FALSE doesn't work.
    To disable autocommit, the method Connection.setAutoCommit(false) needs to be called.
Thomas Mueller's avatar
Thomas Mueller committed
56
    This is now documented.
57
</li><li>Connection pool / DataSource: a NullPointerException was thrown when
Thomas Mueller's avatar
Thomas Mueller committed
58 59
    using a database URL that doesn't start with "jdbc:h2:".
</li><li>Using the java.sql.Blob or java.sql.Clob interfaces could throw the wrong
60
    exception after the object was closed.
61 62 63
</li><li>LOB: in server mode, if the feature "LOBs in database" is disabled,
the temporary files are now created in the temp directory (the same as
when "LOBs in database" is enabled).
Thomas Mueller's avatar
Thomas Mueller committed
64 65 66
</li></ul>

<h2>Version 1.2.147 (2010-11-21)</h2>
67 68 69
<ul><li>H2 Console: the server properties directory can now be set on the command line using
    java ... -properties &lt;directory&gt;. Issue 159.
</li><li>New feature INSERT INTO ... DIRECT SELECT, mainly to speed up loading tables
Thomas Mueller's avatar
Thomas Mueller committed
70
    from a CSV file. When using DIRECT, then the results from the query are directly applied
Thomas Mueller's avatar
Thomas Mueller committed
71 72 73 74 75 76 77 78 79
    in the target table without any intermediate step (without temporary file).
</li><li>Converting binary data to UUID was incorrect when the converting more than 31 bytes.
    Now always the first 16 bytes are used.
</li><li>Improved date / time arithmetics. Now supported are
    multiplying and dividing a time with / by a number,
    adding and subtracting a time to / from a time or date,
    subtracting a time or timestamp from a timestamp.
</li><li>The Ant build script has been removed because it is no longer up to date.
</li><li>Nested outer joins without brackets were not working as expected. Example:
Thomas Mueller's avatar
Thomas Mueller committed
80 81
    select * from a inner join b inner join c on c.id = b.id on b.id = a.id;
</li><li>JMX (the Java management extension) is now supported. Issue 253.
Thomas Mueller's avatar
Thomas Mueller committed
82 83 84
</li><li>Creating a comment on a column didn't work if the schema name was equal the database name.
</li><li>When using multi-version concurrency, re-running a prepared statement with the same parameters
    would sometimes give the same result even if another connection committed a change (the previous result was sometimes
85 86 87 88 89
    re-used incorrectly).
</li><li>When using SELECT_FOR_UPDATE_MVCC (lock only the selected rows when using MVCC),
    the selected rows were sometimes not locked correctly.
</li><li>When using Lucene 3, the index files were not always closed when the database was closed.
</li><li>Concurrently preparing a statement and altering a table could throw a table not found exception.
Thomas Mueller's avatar
Thomas Mueller committed
90
</li><li>When concurrently preparing many statements with a subquery, in some cases the query didn't run
Thomas Mueller's avatar
Thomas Mueller committed
91 92
    (Column "..." must be in the GROUP BY list).
</li><li>CallableStatement: now the syntax "{? = CALL...}" is supported as well.
Thomas Mueller's avatar
Thomas Mueller committed
93
</li><li>Issue Lob in databases: two small BLOB or CLOB values were always considered equal.
Thomas Mueller's avatar
Thomas Mueller committed
94 95 96 97 98
    This also affected unique indexes.
</li><li>The shutdown hook is (re-) enabled by default even for H2 version 1.3.x.
</li><li>When creating a database from a recovery script, the same user can now be used
    (CREATE USER now always includes IF EXISTS).
</li><li>The H2 Console now prints a status message if started with parameters.
Thomas Mueller's avatar
Thomas Mueller committed
99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118
</li></ul>

<h2>Version 1.3.146 Beta (2010-11-08)</h2>
<ul><li>This is a beta version. The next version will be 1.2.147. The differences between 1.2.x and 1.3.x are:
</li><li>In version 1.3.x, h2.lobInDatabase (store CLOB and BLOB in the database file) is enabled by default.
</li><li>In version 1.3.x, ANALYZE_AUTO is 2000 (automatic ANALYZE).
</li><li>In version 1.3.x, DB_CLOSE_ON_EXIT (the shutdown hook) is disabled by default.
</li><li>In version 1.3.x, DROP_RESTRICT (default action for DROP is RESTRICT) is enabled.
</li><li>In version 1.3.x, FUNCTIONS_IN_SCHEMA (allow to store functions in a schema) is enabled.
</li><li>In version 1.3.x, LARGE_TRANSACTIONS (support for very large transactions) is enabled.
    Changes to tables without a primary key can be buffered to disk.
</li><li>In version 1.3.x, MAX_MEMORY_ROWS_DISTINCT is set to a 10000.
</li><li>In version 1.3.x, NESTED_JOINS (nested joins and right outer joins) is enabled.
</li><li>In version 1.3.x, OPTIMIZE_INSERT_FROM_SELECT (speed up CREATE TABLE ... AS SELECT) is enabled.
</li><li>In version 1.3.x, OPTIMIZE_OR (convert OR conditions to IN(..) if possible) is enabled.
</li><li>In version 1.3.x, QUERY_CACHE_SIZE is enabled.
</li><li>In version 1.3.x, SELECT_FOR_UPDATE_MVCC (MVCC and SELECT FOR UPDATE) is enabled.
</li><li>In version 1.3.x, RUNSCRIPT and SCRIPT (commands and tools), use UTF-8 by default (ScriptCommand.charset).
</li><li>In version 1.3.x, Lucene 3 is used by default. Issue 147.
</li><li>When the system property h2.lobInDatabase is set, the lob tables were always
119 120
    created when closing the database, even if the tables were not needed.
</li><li>In the MySQL mode, SHOW TABLES didn't work, and meta data tables were not
Thomas Mueller's avatar
Thomas Mueller committed
121 122
    case insensitive. Updatable result sets didn't work as expected. Issue 249.
</li><li>Connection-created Clob and Blob objects can now be filled using
Thomas Mueller's avatar
Thomas Mueller committed
123 124 125 126 127
    Clob.setCharacterStream(1), Clob.setString(1, s), Blob.setBytes(1, x), Blob.setBinaryStream(1).
    Issue 235.
</li><li>Trying to convert a very small CLOB to a BLOB or a very small CLOB to a BLOB threw a NullPointerException.
</li><li>INFORMATION_SCHEMA.SETTINGS: now the current page count can be queried using
    select * from information_schema.settings where name = 'info.PAGE_COUNT'.
Thomas Mueller's avatar
Thomas Mueller committed
128
</li><li>For an invalid value exception, the parameter name and value was
Thomas Mueller's avatar
Thomas Mueller committed
129
    switched in some cases.
Thomas Mueller's avatar
Thomas Mueller committed
130
</li><li>When using trace level 3, opening a database no longer prints
Thomas Mueller's avatar
Thomas Mueller committed
131
    there is a EOFException (because that is the expected behavior).
Thomas Mueller's avatar
Thomas Mueller committed
132
</li><li>CALL calling a Java function with return type ResultSet and
Thomas Mueller's avatar
Thomas Mueller committed
133
    return value null threw a ClassCastException.
Thomas Mueller's avatar
Thomas Mueller committed
134
</li><li>SELECT ... FROM CSVREAD no longer creates a temporary file.
135
    Some large imports are now twice as fast.
Thomas Mueller's avatar
Thomas Mueller committed
136 137 138
</li></ul>

<h2>Version 1.2.145 (2010-11-02)</h2>
Thomas Mueller's avatar
Thomas Mueller committed
139
<ul><li>A new String cache is now created at most once every 5 second, so that out of memory exceptions
Thomas Mueller's avatar
Thomas Mueller committed
140
    are not artificially delayed.
Thomas Mueller's avatar
Thomas Mueller committed
141 142 143 144
</li><li>After closing a database, the writer thread will stop after 100 ms at the latest (instead of 1 second).
</li><li>Opening a large database could fail in theory if the process was killed and then
    not fully compacted (because the unique transaction log key was re-used).
</li><li>Views now store the schema for Java functions if "functions in schemas" is enabled
145 146
    (system property h2.functionsInSchema).
</li><li>Improved error message if the LOB files are already deleted on the client side.
147
</li><li>Closing a Statement or PreparedStatement at the same time as executing a statement
Thomas Mueller's avatar
Thomas Mueller committed
148 149
    could throw a strange exception. Issue 241.
</li><li>The Recover tool did not work with compressed lob files (set compress_lob lzf).
150
    Also, sometimes the Recover tool was very slow, specially using a 64-bit JVM, because
Thomas Mueller's avatar
Thomas Mueller committed
151
    it tried to de-compress lob files even if they were not compressed
152 153
    (which could allocate a lot of memory).
</li><li>H2 Console: webAllowOthers and webSSL were swapped if they didn't exist in the properties file. Issue 244.
154
</li><li>When the system property h2.lobInDatabase is set, CREATE TABLE ... AS SELECT
Thomas Mueller's avatar
Thomas Mueller committed
155
    with a LOB column did not always work.
Thomas Mueller's avatar
Thomas Mueller committed
156
</li><li>Some system properties are not supported any longer, because they can
157
    already be set in the database URL. The constants are:
Thomas Mueller's avatar
Thomas Mueller committed
158 159 160 161
    CACHE_SIZE_DEFAULT, CACHE_TYPE_DEFAULT, DEFAULT_LOCK_MODE,
    LOCK_MODE_READ_COMMITTED, DEFAULT_MAX_LENGTH_INPLACE_LOB,
    DEFAULT_MAX_LENGTH_INPLACE_LOB2, DEFAULT_MAX_MEMORY_UNDO,
    DEFAULT_MAX_OPERATION_MEMORY, DEFAULT_PAGE_SIZE,
162
    DEFAULT_RESULT_SET_CONCURRENCY, MIN_WRITE_DELAY.
163
</li><li>Various system properties have been replaced with database level settings:
Thomas Mueller's avatar
Thomas Mueller committed
164 165 166 167 168 169 170 171 172 173
    ALIAS_COLUMN_NAME, ANALYZE_AUTO, ANALYZE_SAMPLE, DATABASE_TO_UPPER,
    DEFAULT_ESCAPE, DEFRAG_ALWAYS, DROP_RESTRICT,
    ESTIMATED_FUNCTION_TABLE_ROWS, FUNCTIONS_IN_SCHEMA,
    LARGE_RESULT_BUFFER_SIZE, LARGE_TRANSACTIONS, MAX_COMPACT_COUNT,
    MAX_COMPACT_TIME, MAX_MEMORY_ROWS_DISTINCT, MAX_QUERY_TIMEOUT,
    NESTED_JOINS, OPTIMIZE_DISTINCT, OPTIMIZE_EVALUATABLE_SUBQUERIES,
    OPTIMIZE_INSERT_FROM_SELECT, OPTIMIZE_IN_LIST, OPTIMIZE_IS_NULL,
    OPTIMIZE_OR, OPTIMIZE_SUBQUERY_CACHE, OPTIMIZE_TWO_EQUALS,
    OPTIMIZE_UPDATE, PAGE_STORE_INTERNAL_COUNT, PAGE_STORE_TRIM,
    QUERY_CACHE_SIZE, RECOMPILE_ALWAYS, RECONNECT_CHECK_DELAY,
174
    SELECT_FOR_UPDATE_MVCC, SHARE_LINKED_CONNECTIONS.
175
    See the Javadoc documentation of DbSettings for details.
176 177
    The system properties are still supported for backward compatibility.
</li><li>When the system property h2.nestedJoins was enabled, some outer joins returned the wrong result.
Thomas Mueller's avatar
Thomas Mueller committed
178
</li><li>Opening a database could throw a NullPointerException.
Thomas Mueller's avatar
Thomas Mueller committed
179
</li><li>After a crash, the database file did not always shrink because
180 181
    old transaction log pages were not removed from the file.
</li><li>Various CallableStatement methods could throw a NullPointerException.
182
</li><li>LOB files were not deleted when running DROP ALL OBJECTS.
Thomas Mueller's avatar
Thomas Mueller committed
183
</li><li>MS SQL Server compatibility: support "N" in front of string literals ("National Language" strings). Issue 240.
184
</li><li>CAST: when converting a string to binary, it is hex encoded (every byte two characters);
Thomas Mueller's avatar
Thomas Mueller committed
185 186
    a hex string can be converted to a number by first converting it to binary. Examples:
    CAST(CAST('FFFF' AS BINARY) AS INT) = 65535, CAST(65535 AS BINARY) = '0000FFFF'.
Thomas Mueller's avatar
Thomas Mueller committed
187
</li><li>When a domain (user defined data type) contained a user defined function, the database could not be opened.
Thomas Mueller's avatar
Thomas Mueller committed
188
</li><li>CAST('011' AS INT) will no longer use decode the value as an octal number (using Integer.decode) but now use Integer.parseInt.
Thomas Mueller's avatar
Thomas Mueller committed
189
    The same logic applied to byte, short, and long. This also means that trying to convert hex numbers (0x...) with CAST now fails.
190
</li><li>A table in the Recover tool script could not be imported if the script contained duplicate keys.
Thomas Mueller's avatar
Thomas Mueller committed
191 192
</li></ul>

Thomas Mueller's avatar
Thomas Mueller committed
193
<h2>Version 1.2.144 (2010-10-15)</h2>
Thomas Mueller's avatar
Thomas Mueller committed
194 195 196
<ul><li>The Windows .bat files did not contain CR+LF.
</li><li>The LOB storage (when the system property h2.lobInDatabase is set) is now only initialized when needed.
</li><li>The index condition columnName IS NULL was not efficient when using a clustered index.
Thomas Mueller's avatar
Thomas Mueller committed
197 198 199
</li><li>The Recover tool did not work for databases larger than 2 GB.
</li><li>In memory database: outer joins with a condition "column is null" could return the wrong result.
</li><li>Temporary files were not created in the temporary directory of the system, but in the current working directory.
Thomas Mueller's avatar
Thomas Mueller committed
200 201 202 203
    This affected temporary undo log files for read-only databases, temporary files for large result sets when using read-only databases,
    and temporary LOB files when storing LOBs in the database (system property h2.lobInDatabase).
    When the setting h2.lobInDatabase is not set,
    temporary LOB files are still stored in a sub-directory (.lobs.db/) of the current working directory.
Thomas Mueller's avatar
Thomas Mueller committed
204
</li><li>New experimental feature to speed up CREATE TABLE ... AS SELECT.
Thomas Mueller's avatar
Thomas Mueller committed
205 206 207
    To enable the feature, set the system property h2.optimizeInsertFromSelect to true.
    For large queries, performance can be doubled.
</li><li>When LOB objects are stored in the database (using the experimental setting h2.lobInDatabase),
208 209
    and using the MVCC mode, opening a database with uncommitted transactions could throw a NullPointerException.
</li><li>Support of stored procedures with OUT parameters in CallableStatement is implemented.
Thomas Mueller's avatar
Thomas Mueller committed
210
</li><li>PreparedStatement.getMetaData() was not always consistent with resulting ResultSet.getMetaData().
211
</li><li>The build tool now uses JAVA_HOME for javac as well. Issue 233.
Thomas Mueller's avatar
Thomas Mueller committed
212
</li><li>Opening and closing encrypted databases is now much faster.
Thomas Mueller's avatar
Thomas Mueller committed
213 214 215 216 217 218 219
</li><li>H2 Console: new experimental feature to support file download and upload,
    but only if there is a directory called "transfer" in the current working directory.
    For security reasons, only very simple file names are supported. Sub-directories are not supported.
    To upload, use transfer.jsp; to download, use transfer/fileName.
</li><li>A new sample application that shows how to manually create an encrypted
    and compressed script file.
</li><li>Performance has been improved a bit.
Thomas Mueller's avatar
Thomas Mueller committed
220 221 222 223
</li><li>DatabaseMetaData.getJDBCMajorVersion now returns 4 (instead of 3) when the driver
    is compiled with Java 6 (the default).
</li><li>Re-added the internal utility class BitField which improves performance of opening
    and closing a database (because it supports setByte / getByte, unlike java.util.BitSet).
Thomas Mueller's avatar
Thomas Mueller committed
224
</li><li>INFORMATION_SCHEMA.SESSIONS: the start time of a SQL statement
Thomas Mueller's avatar
Thomas Mueller committed
225 226 227 228 229 230 231 232 233 234 235
    is no longer set in each case. It is only set for long running statements.
    This change should improve performance a bit on some devices, specially when using Android.
</li><li>A old databases without user name and password (created with H2 version 1.2.142 or older)
    couldn't be opened with version 1.2.143. Fixed.
</li><li>The database upgrade classes have been renamed.
</li><li>The database did not automatically upgrade when using a connection pool or data source.
</li><li>JaQu: a database object can now also be created using a DataSource. Issue 227.
</li><li>The built-in profiler now better supports the Dalvik VM.
</li><li>The jarSmall build target no longer includes assertions
    (SysProperties.CHECK, CHECK2, system properties h2.check and h2.check2).
</li><li>The jarSmall build target excluded the DbUpgrade classes by mistake.
Thomas Mueller's avatar
Thomas Mueller committed
236 237 238
</li></ul>

<h2>Version 1.2.143 (2010-09-18)</h2>
239 240 241 242
<ul><li>If the user name and password are not set or empty, then the password is not hashed.
    To disable this behavior, set the system property h2.emptyPassword to false.
    TCP server: the default user name for the management database is now an empty string.
</li><li>Cluster: auto-commit was disabled after opening a connection.
Thomas Mueller's avatar
Thomas Mueller committed
243 244 245 246
</li><li>Connection.getAutoCommit() is now much faster, specially when using the server mode.
</li><li>Statement.cancel() had no effect when using the server mode.
</li><li>SCRIPT: the SQL script no longer contains settings that match the default value.
</li><li>Statement.cancel() did not work when running RUNSCRIPT and SCRIPT.
247 248
</li><li>Statement.cancel() could cause a NullPointerException.
</li><li>In some cases (specially when using a small cache size or a large database over 1 GB) for some
Thomas Mueller's avatar
Thomas Mueller committed
249 250 251 252 253
    operations like ALTER TABLE the data was written before the transaction log entries, which could cause a corrupt database
    if the process was killed during the ALTER TABLE operation. Thanks a lot to Victor Pyankov for helping solve this problem!
</li><li>The Recover tool could throw a ArrayIndexOutOfBoundsException
    when trying to recover a corrupt database file.
</li><li>The SCRIPT command and tool now uses the default file encoding
Thomas Mueller's avatar
Thomas Mueller committed
254 255 256 257 258 259 260 261
    for the system now instead of UTF-8 (as before).
    In most cases, this will not affect existing applications, as the encoding
    only affects how SQL identifiers (table names and so on) that contain special characters
    are stored. Table data is escaped, and therefore is no problem.
</li><li>The SCRIPT command and tool now also support the CHARSET option
    (like RUNSCRIPT).
</li><li>When closing a database, sometimes empty space in the database was not freed up.
</li><li>Trying to create a view with parameters in the query will now throw an exception.
262 263
    So far, creating the view was allowed, but the parameter value was not used (null was used instead).
</li><li>New experimental feature SHUTDOWN DEFRAG.
Thomas Mueller's avatar
Thomas Mueller committed
264
    This option re-orders the pages while closing the database so that table scans are faster.
Thomas Mueller's avatar
Thomas Mueller committed
265 266
</li><li>When using the MULTI_THREADED option, concurrently reading from a database
    (specially from a larger database, or when using a small cache size) could throw an exception.
Thomas Mueller's avatar
Thomas Mueller committed
267
</li><li>When adding a comment to a column that has a check constraint,
Thomas Mueller's avatar
Thomas Mueller committed
268
    the database couldn't be re-opened.
Thomas Mueller's avatar
Thomas Mueller committed
269
</li><li>New system property h2.lobClientMaxSizeMemory to set the maximum size
Thomas Mueller's avatar
Thomas Mueller committed
270
    of a LOB object to keep in memory on the client side when using the server mode.
Thomas Mueller's avatar
Thomas Mueller committed
271 272 273
</li></ul>

<h2>Version 1.2.142 (2010-08-31)</h2>
Thomas Mueller's avatar
Thomas Mueller committed
274 275
<ul><li>Documentation for using H2 on Android devices has been added under Tutorial - Android.
</li><li>An ArrayIndexOutOfBoundsException was thrown when querying the table
Thomas Mueller's avatar
Thomas Mueller committed
276 277 278 279
    information_schema.function_aliases while there are any user defined aggregate functions.
</li><li>The jar files are now about 50 KB smaller.
    In the last few versions they contained superfluous classes.
</li><li>The default time to compact a database when closing (system property h2.maxCompactTime)
Thomas Mueller's avatar
Thomas Mueller committed
280 281 282 283
    is now 0.2 seconds instead of 1 second.
</li><li>Opening an closing a database is now faster.
</li><li>In theory, when using indexes with large index rows (or when using a very small page size),
    removing rows could throw an internal exception in some cases.
Thomas Mueller's avatar
Thomas Mueller committed
284
</li><li>Inserting rows in reverse order could throw an ArrayIndexOutOfBoundsException
Thomas Mueller's avatar
Thomas Mueller committed
285 286 287 288 289 290 291
    in some cases (specially rows larger than the page size, which is 2 KB by default). Issue 226.
</li><li>H2 Console: with Chrome and Safari, resizing the table/query frame doesn't work. Issue 225.
</li><li>New experimental database file locking mechanism "FS" to use native file locking
    (no *.lock.db file is created in this case, and no background thread is started). This mechanism
    may not work on all systems (on some systems it's possible to lock the same file multiple
    times within the same virtual machine, and on some system native file locking is not working
    or unlocking is not working).
292 293 294 295
</li></ul>

<h2>Version 1.2.141 (2010-08-22)</h2>
<ul><li>New experimental pseudo-encryption algorithm "FOG".
Thomas Mueller's avatar
Thomas Mueller committed
296
    It makes the data appear to be encrypted. This algorithm is cryptographically extremely weak,
297 298 299 300
    and should only be used to hide data from reading the plain text using a text editor.
    Please let us know if you think this is useful or not.
</li><li>Documentation: the grammar and function documentation can now be easier translated.
</li><li>Password hash: in addition to connecting with the plain text password,
Thomas Mueller's avatar
Thomas Mueller committed
301 302 303 304 305 306 307 308 309 310 311 312
    H2 now supports connecting with the password hash.
    Like this you don't have to store plain text passwords in config files.
    For details, see the documentation at Advanced / Password Hash.
</li><li>Lucene 3.x support was added in the source code, however it is not yet enabled by default
    and is not yet supported when using the default h2 jar file. To enable Lucene 3.x support,
    the source code of H2 needs to be switched using <code>./build.sh -Dlucene=3 switchSource</code>,
    and then re-compile. To switch the source code back use <code>./build.sh -Dlucene=2 switchSource</code> (replace
    ./build.sh with build.bat on Windows).
    The plan is to use Lucene 3 by default in H2 version 1.3.x.
    Issue 147.
</li><li>The native fulltext search could cause a Java level deadlock if searching from multiple connections concurrently.
</li><li>CREATE FORCE VIEW didn't work in most cases if a referenced table didn't exist.
313 314 315 316 317 318 319 320 321 322
</li><li>MVCC: when trying to insert two rows with the same key from two connections,
    the second connection immediately threw the exception "Unique index or primary key violation".
    Instead, the second connection now waits throwing the exception until the first connection
    committed the change (same as when trying to concurrently update the same row).
</li><li>Server mode: if the client ran with a different timezone setting than the server, date values
    got shifted by the difference between the timezones. This problem affected the data types
    DATE, TIME, and TIMESTAMP, when using PreparedStatement.setDate / setTime / setTimestamp
    and ResultSet.getDate / getTime / getTimestamp.
    To solve the problem, both the client and the server need to be updated (otherwise the old transfer protocol is used).
</li><li>The built-in connection pool (JdbcConnectionPool) did not always honor the login timeout
323 324
    (the timeout could occur much too early). Thanks a lot to Dario Fassi for the patch!
</li><li>Translation: the new messages have been translated to Spanish. Thanks a lot to Dario Fassi!
Thomas Mueller's avatar
Thomas Mueller committed
325
</li><li>The table INFORMATION_SCHEMA.SETTINGS now contains all H2-specific system properties
Thomas Mueller's avatar
Thomas Mueller committed
326 327 328
    (the ones that start with "h2.") and that are explicitly set. Previously, some H2-specific settings
    (for example h2.analyzeAuto) were missing in this list.
</li><li>EXPLAIN ANALYZE with an in-memory database threw an exception. Issue 216.
Thomas Mueller's avatar
Thomas Mueller committed
329
</li><li>Data modifications (inserts, updates, and deletes) are now up to 5 times faster
330 331 332 333
    because converting objects to byte arrays is avoided if possible.
</li><li>LOG=0 is now a bit faster (previously undo log entries were still written).
</li><li>The command line tools now say so if the source directory of an option doesn't exist.
</li><li>It is now allowed to truncate a table if referential integrity has been disabled for this table or database.
334
</li><li>For unencrypted databases, the automatic upgrade temporary script file is now unencrypted again.
Thomas Mueller's avatar
Thomas Mueller committed
335 336 337
</li></ul>

<h2>Version 1.2.140 (2010-07-25)</h2>
Thomas Mueller's avatar
Thomas Mueller committed
338 339 340 341 342 343 344 345
<ul><li>The default MAX_LOG_SIZE is now 16 MB instead of 2 MB. Some uses cases are 3 times faster now.
</li><li>Improved cache memory usage calculation.
</li><li>Only resources that are actually used are loaded in memory.
    This can reduce the memory usage by about 400 KB.
</li><li>Profiling: the jar file can now be installed as an agent using
    java -javaagent:h2*.jar - this was be used to more accurately calculate the memory footprint of the cache.
    It has no effect when using H2 (using this feature in an application is not needed and not recommended).
</li><li>The cache was not used efficiently when reading
346 347
    (behaving like a FIFO cache instead of an LRU cache).
</li><li>Storing lobs in the database has been changed. It is now faster.
Thomas Mueller's avatar
Thomas Mueller committed
348 349
    Unfortunately, the change is not backward compatible; if you have used h2.lobInDatabase before
    you will need to re-build the database.
Thomas Mueller's avatar
Thomas Mueller committed
350
</li><li>SHUTDOWN COMPACT is now faster.
351 352 353
</li><li>H2 Console: requesting the status did not always show the window on top of others.
</li><li>H2 Console: on some system, the browser windows got opened when requesting a new one.
</li><li>The built-in profiling tool now uses a default stack depth of 32 elements and a default interval of 10 ms.
Thomas Mueller's avatar
Thomas Mueller committed
354
</li><li>Database files now grows in 1 MB blocks (and at least 20% at a time),
355
    instead of always 256 KB. This speeds up loading a new database.
356 357
</li><li>H2 Console: new built-in command @sleep to help profile another session.
</li><li>For improved performance, LOG=0 and LOG=1 are again supported.
358 359 360
    LOG=0 means the transaction log is disabled completely (fastest; for loading a database).
    LOG=1 means the transaction log is enabled, but FileDescriptor.sync is disabled (if no protection against power failure is required).
    LOG=2 is the default (transaction log is enabled, FileDescriptor.sync for each checkpoint).
Thomas Mueller's avatar
Thomas Mueller committed
361
</li><li>After deleting a lot of data (for example by dropping or altering tables, or indexes,
362 363 364 365
    or after a large transaction), opening a large database was very slow. Fixed.
</li><li>When killing the process after creating and dropping many tables (specially temporary tables),
    the database could not be opened sometimes.
</li><li>CAST(NULL AS ...) doesn't forget the data type, precision, and scale any longer.
Thomas Mueller's avatar
Thomas Mueller committed
366 367 368
</li><li>Experimental support for recursive queries (see 'Advanced' - 'Recursive Queries' for details).
</li><li>Problems with JDK 1.6.0_18 have been reports in the class StringUtils.quoteRemarkSQL. This method is now changed.
</li><li>The "small jar" distribution did not include the CompressTool,
369 370
    which was required for some operations. Fixed.
</li><li>The build tool now supports (minimalistic) shell mode, started using ./build.sh -
Thomas Mueller's avatar
Thomas Mueller committed
371 372 373 374 375
</li><li>IS NULL comparison with nested queries and linked tables did not work.
    Example: select * from (select x from test) where x is null.
</li><li>Support for null-safe equals. This includes the ANSI SQL standard syntax
    A IS [NOT] DISTINCT FROM B as well as the shorter A IS [NOT] B.
</li><li>Primary key violations threw a strange exception message when using a single column INT or BIGINT key.
376 377
</li><li>EXPLAIN ANALYZE now also lists the number of pages read from the file.
</li><li>Memory mapped files: There was a bug in version 1.2.139 so that memory mapped files
Thomas Mueller's avatar
Thomas Mueller committed
378 379
    could only be used together with split, for example: split:nioMapped: - the problem is now solved.
    It is still a good idea to use split:nioMapped: to work around the 2 GB limitation of memory mapped files.
Thomas Mueller's avatar
Thomas Mueller committed
380
</li><li>Memory mapped files: the system property h2.nioCleanerHack is now disabled by default
Thomas Mueller's avatar
Thomas Mueller committed
381 382 383
    because it was not always working as expected. Now System.gc() is used in a loop until the
    buffer is garbage collected. This of course is also not a nice solution, but the only one known to work.
    See also http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=4724038
384
</li><li>Bugfixes for the automatic 1.1 db migration.
385
</li><li>If an old 1.1 database file version is found on connect, it is now possible to let the old h2
Thomas Mueller's avatar
Thomas Mueller committed
386 387 388
    classes (v 1.2.128) connect to the database. The automatic upgrade .jar file must be present, and the url
    must contain NO_UPGRADE=TRUE
</li><li>The automatic upgrade temporary script file is now encrypted.
Thomas Mueller's avatar
Thomas Mueller committed
389 390 391
</li></ul>

<h2>Version 1.2.139 (2010-07-10)</h2>
christian.peter.io's avatar
christian.peter.io committed
392
<ul><li>There was a bug in the internal IntIntHashMap. There were no known side effects however.
Thomas Mueller's avatar
Thomas Mueller committed
393 394
</li><li>ANALYZE now uses less memory.
</li><li>Memory mapped file system: improved error messages if there is a problem.
Thomas Mueller's avatar
Thomas Mueller committed
395 396
</li><li>The Lucene fulltext search did not work well
    when using special file systems such as split or nioMapped.
Thomas Mueller's avatar
Thomas Mueller committed
397
</li><li>The memory mapped file system (nioMapped: file prefix) couldn't seek past the file length.
Thomas Mueller's avatar
Thomas Mueller committed
398
</li><li>Some file system operations did not work with stacked file systems
Thomas Mueller's avatar
Thomas Mueller committed
399
    (for example split and nioMapped). This also affected the DeleteDbFiles tool.
Thomas Mueller's avatar
Thomas Mueller committed
400
</li><li>New experimental query cache.
Thomas Mueller's avatar
Thomas Mueller committed
401
    The cache is only used if the SQL statement and all parameters match.
402
    Each session has it's own cache with the given size.
Thomas Mueller's avatar
Thomas Mueller committed
403
    Only the last returned result per query is cached.
404 405 406 407 408
    Only SELECT statements are cached (excluding UNION and FOR UPDATE statements).
    This works for both statements and prepared statement.
    To enable, set the system property h2.commandCacheSize to a value larger than 0.
    There is currently no plan to enable this option by default in future versions.
</li><li>Conditions with many OR operations could throw an UnsupportedOperationException if
Thomas Mueller's avatar
Thomas Mueller committed
409
    h2.optimizeOr was enabled.
Thomas Mueller's avatar
Thomas Mueller committed
410
</li><li>XA connection: after transaction commit or rollback,
Thomas Mueller's avatar
Thomas Mueller committed
411 412
    the physical connection is set into autocommit mode.
</li><li>MULTI_THREADED did not work correctly and could throw the exception
Thomas Mueller's avatar
Thomas Mueller committed
413 414
    "try to add a record twice" for larger databases because cache access was not correctly synchronized.
</li><li>Automatic database upgrade from non page store is now possible. If the
Thomas Mueller's avatar
Thomas Mueller committed
415
    classes from the h2mig_pagestore_addon.jar file are in the classpath, the database will be converted to the current
416
    page store format automatically. The file can be found here:
417 418
    <a href="http://h2database.com/h2mig_pagestore_addon.jar">http://h2database.com/h2mig_pagestore_addon.jar</a>
</li><li>The MultiDimension tools was extended with a few helper methods.
419
    The API was unified a bit.
Thomas Mueller's avatar
Thomas Mueller committed
420 421
</li><li>ODBC: MS Access could not link to a table with unique index or primary key.
    To solve this problem, index meta data is currently disabled for ODBC.
422 423 424
    When using the new H2 version to access a database over ODBC, the PostgreSQL catalog
    is automatically upgraded. Using a database with an upgraded PostgreSQL catalog
    with an older version of H2 is still possible, but not over ODBC.
Thomas Mueller's avatar
Thomas Mueller committed
425 426
</li><li>ODBC: MS Access could not link to a table with a name containing '_'.
</li><li>ODBC: additional connection settings can now be added to the database name.
427 428
    Example: ~/test;cipher=xtea. Therefore, encrypted databases are supported.
</li><li>Local temporary tables can now be created without having to commit a transaction
429
    using CREATE LOCAL TEMPORARY TABLE TEMP(ID INT PRIMARY KEY) TRANSACTIONAL.
Thomas Mueller's avatar
Thomas Mueller committed
430 431 432 433 434
</li><li>New system property h2.dropRestrict (default false) to change the
    default action for DROP TABLE and DROP VIEW (false for CASCADE, true for RESTRICT).
    The plan is to enable this property by default in version 1.3.x.
</li><li>DROP TABLE now also supports CASCADE (still the default) and RESTRICT.
</li><li>The wrong exception was thrown when trying to connect to a server if the server was not running.
Thomas Mueller's avatar
Thomas Mueller committed
435 436 437
</li><li>UNION queries where the first query contains a nested query were parsed incorrectly.
    Example: "select 1 from (select 2 from dual) union select 3 from dual" was parsed as
    "select 1 from ((select 2 from dual) union select 3 from dual)". Fixed.
Thomas Mueller's avatar
Thomas Mueller committed
438
</li><li>Support ALTER SCHEMA name RENAME TO newName (rename schema). (patch from Kerry Sainsbury)
Thomas Mueller's avatar
Thomas Mueller committed
439 440 441
</li></ul>

<h2>Version 1.2.138 (2010-06-27)</h2>
442 443 444
<ul><li>Referential integrity: it was not allowed to delete a row with NULL in the parent table,
    if there was a row with NULL in the child table.
</li><li>Experimental feature to support case sensitive catalog names
445 446 447 448 449
    and database names using the DATABASE() method.
    To use this feature, set the system property h2.databaseToUpper to false.
    The plan is to set the property to false by default in version 1.3.x.
    Issue 204 - thanks to Sylvain Cuaz (ILM Informatique) for the patch.
</li><li>Experimental feature to support nested joins.
Thomas Mueller's avatar
Thomas Mueller committed
450 451 452 453 454 455 456 457
    To enable, set the system property h2.nestedJoins to true.
    If enabled, nested joins and right outer joins should work as expected (issues 145, 177, and 203).
    The plan is to enable this feature by default in version 1.3.x.
</li><li>New sample application: CachedPreparedStatements.
</li><li>When creating functions within a schema, those functions could not be used
    in views, nested queries, and constraints. Fixed.
</li><li>The benchmarks have been run using recent database versions.
</li><li>Version 1.2.137 could still not be converted to Java 1.4
Thomas Mueller's avatar
Thomas Mueller committed
458 459
    (because the Retrotranslator doesn't support BigDecimal.precision).
</li><li>Cluster: non-admin users could not connect when one of the cluster node was stopped. Issue 206.
460 461
</li><li>DROP VIEW now supports the CASCADE and RESTRICT clauses (patch from Kerry Sainsbury)
</li><li>CREATE VIEW now supports the OR REPLACE clause (patch from Kerry Sainsbury)
462
</li><li>Build tool: ability to only run one test using the -Dtest=className setting.
Thomas Mueller's avatar
Thomas Mueller committed
463
    eg: build -Dtest=org.h2.test.db.TestViewDropView test (patch from Kerry Sainsbury).
464 465 466
</li></ul>

<h2>Version 1.2.137 (2010-06-06)</h2>
467 468
<ul><li>Statements with a nested query and a condition that was always NULL threw an
    IndexOutOfBoundsException. Example: select * from (select null as x) where x=1
Thomas Mueller's avatar
Thomas Mueller committed
469 470
</li><li>The changes that were made to support large transactions also fixed a bug
    with large transactions (when the undo log file size is larger than 2 GB).
471
</li><li>Experimental feature to support very large transactions (except when using MVCC).
472 473 474
    To enable, set the system property h2.largeTransactions to true.
    If enabled, changes to tables without a primary key can be buffered to disk.
    The plan is to enable this feature by default in version 1.3.x.
475 476
</li><li>H2 Console: editing result sets is now also working for database other than H2,
    if they do support updatable result sets. Add "@edit" before the query.
477 478 479
    Only limited testing has been done on this feature,
    some data types may not work (please provide feedback if you find issues).
</li><li>Cluster: an open transaction was committed when a cluster node was stopped
Thomas Mueller's avatar
Thomas Mueller committed
480 481 482 483 484 485 486 487 488 489 490 491 492 493
    (because disabling the cluster executes SET CLUSTER '', which committed the transaction).
    Transaction are no longer committed when calling SET CLUSTER. Issue 199.
</li><li>Cluster: non-admin users couldn't connect to the cluster and couldn't disable the cluster. Issue 201.
</li><li>Cluster: NEXTVAL('sequence') was only called on one cluster node,
    therefore sequence values could get out of sync.
</li><li>Version 1.2.136 could not be converted to Java 1.4
    (because the Retrotranslator doesn't support BigDecimal.precision).
    A workaround has been implemented.
</li><li>The error code of IO exceptions in CSV functions was incorrect.
</li><li>The TriggerPassData example now uses a prefix (the database name).
</li><li>The wrong exception was thrown when trying to reference a table that doesn't support references
    such as a table in the information schema.
</li><li>Server.shutdownTcpServer can now stop all TCP servers on this JVM.
</li><li>JdbcConnectionPool: the default connection timeout is now 30 seconds (it used to be 5 minutes).
494 495
</li><li>LOB storage: LOBs added with "h2.lobInDatabase" enabled couldn't
    be read later with this option disabled.
Thomas Mueller's avatar
Thomas Mueller committed
496 497
</li></ul>

Thomas Mueller's avatar
Thomas Mueller committed
498
<h2>Version 1.2.136 (2010-05-24)</h2>
Thomas Mueller's avatar
Thomas Mueller committed
499 500 501
<ul><li>When using ORDER BY and there are both ascending and descending indexes, the database used
    the first index even when the second one could be used for sorting.
</li><li>Conditions of the form columnName IS NULL now use an index. To disable this feature,
502 503 504 505 506 507 508
    set the system property h2.optimizeIsNull to false.
</li><li>H2 Console: when the settings were not stored yet (for example when running for the first time),
    the last recently used settings were not stored. A workaround was to create the file
    ".h2.server.properties" manually in the current user home directory, with the contents:
    webAllowOthers=false, webPort=8082, webSSL=false,
    0=Generic H2 (Embedded)|org.h2.Driver|jdbc\:h2\:~/test|sa
    (where a comma is a newline).
Thomas Mueller's avatar
Thomas Mueller committed
509
</li><li>The source code is now switched to Java 6 (JDK 1.6) by default.
510
    Java 5 (JDK 1.5) is still supported, and the jar file is still compiled for Java 5.
Thomas Mueller's avatar
Thomas Mueller committed
511
</li><li>The BOM (the byte-order-mark) character 0xfeff at the beginning of the file is ignored.
512 513
    This is for compatibility with Microsoft Excel.
</li><li>When opening an existing database, the cache size is set to at most
Thomas Mueller's avatar
Thomas Mueller committed
514
    half the amount of memory available for the virtual machine
515
    (Runtime.getRuntime().maxMemory()), even if the cache size setting stored in the database
Thomas Mueller's avatar
Thomas Mueller committed
516
    is larger. Setting the cache size in the database URL or explicitly using SET CACHE_SIZE
517 518 519
    overrides this value (even if larger than the physical memory).
</li><li>INFORMATION_SCHEMA.SETTINGS: the cache size is now returned in KB.
</li><li>New system property h2.selectForUpdateMvcc, the default is false (the feature is disabled).
520
    When enabled, SELECT ... FOR UPDATE only locks the selected rows in the MVCC mode.
521
    Aggregate or GROUP BY queries are not allowed in this case.
522
</li><li>Profiler: improved message if there was no stack trace.
Thomas Mueller's avatar
Thomas Mueller committed
523
</li><li>The H2 Console can now be used within another application, in a frame or iframe. Issue 197.
Thomas Mueller's avatar
Thomas Mueller committed
524 525 526 527 528 529 530
</li><li>Recover tool: the statistics section now includes page type counts again.
</li><li>Queries with multiple IN(...) conditions sometimes return the wrong results when there was a multi-column index for the column.
</li><li>Queries with IN(..., NULL) did sometimes return the wrong results when there was a index for the column.
</li><li>DECIMAL: faster precision and memory usage calculations.
</li><li>A new class org.h2.tools.TriggerAdapter allows to use the ResultSet interface within trigger implementations.
</li><li>A subselect which used an index could lead to wrong results. Fixed.
</li><li>Creating a cached temporary non persistent table with a primary key threw a NullPointerException.
Thomas Mueller's avatar
Thomas Mueller committed
531 532 533
</li></ul>

<h2>Version 1.2.135 (2010-05-08)</h2>
534
<ul><li>Temporary files were not deleted when using large transactions, disabling autocommit,
Thomas Mueller's avatar
Thomas Mueller committed
535 536
    and closing the session without committing.
</li><li>Queries using multiple IN(..) conditions on the same table could cause repeated rows in the result set.
537
</li><li>Translation: Lubomir Grajciar translated the H2 Console as well as all error message to Slovensky. Thanks a lot!
538 539
</li><li>There was a possible Java level deadlock when opening an uninitialized database and using
    a file system that also opened a database.
540
</li><li>When killing the process while the database was writing a checkpoint, while it was closing,
Thomas Mueller's avatar
Thomas Mueller committed
541
    or while running recovery (while removing temporary tables from a previous run), the database could become corrupt.
542
    A new test case has been implemented to ensure such problems can not occur in the future.
543 544 545 546
</li><li>File system: new method FileSystem.setReadOnly.
</li><li>The page size for new databases can now be set in the database URL using ;PAGE_SIZE=512.
    Currently this feature is only used to simplify testing.
</li><li>New system property h2.functionsInSchema (default is false).
547 548 549 550 551 552 553 554
    If enabled, the SCRIPT statement always includes the schema name in the CREATE ALIAS statement
    (even if the schema is PUBLIC). This is not backward compatible with H2 versions 1.2.134 and older.
</li><li>Functions: it is no longer required to add a space after a comma in the parameter list.
    Example: CREATE ALIAS PARSE_INT FOR "java.lang.Integer.parseInt(java.lang.String,int)"
</li><li>Functions now reside within a schema, similar to sequences.
    If you do create such functions in schemas other than PUBLIC, then the database
    can not be opened with older versions of H2.
</li><li>Cluster: after a cluster node failed, the second cluster node can now be re-created
Thomas Mueller's avatar
Thomas Mueller committed
555 556
    and started without having to stop the first cluster node, and without having to stop
    running applications. To do that, append ;AUTO_RECONNECT=TRUE to the database URL.
557
</li><li>Auto-reconnect: if another connection uses the database in exclusive mode
558 559
    then this connection will try to re-connect until the exclusive mode ends.
    This is important when using the cluster mode.
Thomas Mueller's avatar
Thomas Mueller committed
560 561 562 563 564 565
</li><li>SET EXCLUSIVE now supports 0 (disable), 1 (enable), and 2 (enable and close all other connections).
</li><li>Installing the H2 as a service should now work on Windows 7.
    The batch files now explicitly set the directory using pushd "%~dp0".
</li><li>Temporary tables can now be 'cached', that means indexes of temporary tables
    can be persisted. This enables very large temporary tables (both local and global).
</li><li>The CreateCluster tool now sets the source database in exclusive mode
Thomas Mueller's avatar
Thomas Mueller committed
566
    before copying data to the new database.
Thomas Mueller's avatar
Thomas Mueller committed
567 568 569
</li><li>The H2 Console now stream results one statement / result set at a time (using chunked transfer encoding).
    To disable, set the system property h2.consoleStream to false.
    This feature is not supported when using a servlet container.
Thomas Mueller's avatar
Thomas Mueller committed
570 571 572
</li><li>The H2 Console did not call the CreateCluster tool with the correctly escaped parameters.
</li><li>Improved PostgreSQL compatibility for ALTER TABLE ALTER COLUMN.
</li><li>Commas at the end of INSERT ... VALUES (), (), are now supported.
Thomas Mueller's avatar
Thomas Mueller committed
573 574 575 576 577 578 579 580 581 582 583
</li><li>The H2 Console "Start Browser" button now works even when the IP
    address changes while the tool runs (for example, because a wireless connection
    breaks, or when enabling / disabling the network connection).
</li><li>When casting from float or double to BigDecimal, the result was
    sometimes unexpected, because "new BigDecimal(double val)" was used.
    Now "BigDecimal.valueOf(double val)" and "new BigDecimal(Float.toString(f))" are used.
    But it is still not recommended to use float or double for currency values
    (see data type documentation).
</li><li>Global temporary tables are now deleted when closing the database.
    Before, they were deleted when opening the database the next time.
</li><li>UNIQUE was not listed as a keyword.
Thomas Mueller's avatar
Thomas Mueller committed
584 585 586 587 588 589 590 591 592
</li><li>Improved error message when an non-SQL-exception occurred in a user
    defined function. The method name and parameters are included in the error message.
</li><li>For some queries, the exception did not include the SQL statement. Example:
    select x from system_range(1, 2) group by 'a'.
</li><li>The Shell tool will execute SQL statements passed as using the command line
    parameter -sql.
</li><li>If InetAddress.getLocalHost() fails, the database should now throw an exception.
</li><li>New columns INFORMATION_SCHEMA.INDEXES.INDEX_CLASS and
    INFORMATION_SCHEMA.TABLES.TABLE_CLASS.
Thomas Mueller's avatar
Thomas Mueller committed
593
</li><li>INFORMATION_SCHEMA.INDEXES.SQL now contains the CREATE INDEX statement
Thomas Mueller's avatar
Thomas Mueller committed
594
    instead of just the fully qualified index name.
Thomas Mueller's avatar
Thomas Mueller committed
595 596 597
</li></ul>

<h2>Version 1.2.134 (2010-04-23)</h2>
Thomas Mueller's avatar
Thomas Mueller committed
598 599 600 601 602 603 604 605 606 607
<ul><li>New system property h2.analyzeAuto (default 0 meaning disabled) to
    automatically run ANALYZE after that many changes to a table.
    For details, see the Javadoc of this system property.
    The plan is to set this property to 2000 in version 1.3.x.
</li><li>JdbcXAConnection.start() does not support TMJOIN. Issue 189.
</li><li>MySQL compatibility: TIMESTAMPDIFF is now an alias for DATEDIFF.
</li><li>MERGE did not respect foreign key and check constraints.
</li><li>ALTER TABLE ALTER COLUMN: changing the data type of a column
    no longer makes it nullable.
</li><li>When using AUTO_SERVER=TRUE, the server is now started as a daemon thread.
608 609 610 611
    This was a problem when using Tomcat and a connection pool.
</li><li>Servers can now be started as a daemon thread using the command line options
    -tcpDaemon, -pgDaemon, and -webDaemon.
</li><li>H2 Console: the built-in commands are now documented.
612 613
</li><li>REPLACE: if any parameter is null, the result is null.
</li><li>Queries with DISTINCT and ORDER BY will now use the index on ORDER BY if possible.
614
    This is specially important for queries used inside IN(SELECT ...).
Thomas Mueller's avatar
Thomas Mueller committed
615
</li><li>The new statement EXPLAIN ANALYZE executes the statement,
616 617
    and displays the query plan with the actual row scan count for each table.
</li><li>H2 Console: the auto-complete feature didn't quote column names
618 619
    that need quoting. Issue 186.
</li><li>The experimental LOB storage mechanism now supports all features of the
Thomas Mueller's avatar
Thomas Mueller committed
620
    old one. To use it, set the system property "h2.lobInDatabase" to "true".
Thomas Mueller's avatar
Thomas Mueller committed
621
    If you have used this feature in version 1.2.133, you need to export
Thomas Mueller's avatar
Thomas Mueller committed
622
    and re-import the database using SCRIPT / RUNSCRIPT.
623 624
</li><li>The functions isBeforeFirst() and isAfterLast() were not compliant to the
    JDBC spec. If the ResultSet contains no rows, they must return false. Fixed.
625
</li><li>Filesystem parameters like "split:" didn't work in server mode with baseDir set.
626 627
</li><li>If baseDir is set, and a database name is given which points to a directory outside
    the baseDir (eg. "../dbname"), an exception is thrown.
Thomas Mueller's avatar
Thomas Mueller committed
628 629 630
</li></ul>

<h2>Version 1.2.133 (2010-04-10)</h2>
631 632 633 634 635 636
<ul><li>A new experimental LOB storage mechanism is available.
    When enabled, CLOB and BLOB data is stored in hidden tables in the database.
    To use it, set the system property "h2.lobInDatabase" to "true".
    Compression is not yet implemented. Duplicate objects are only stored once.
    Usually writing is slower, but reading is faster (mainly because of caching).
</li><li>The Shell tool threw a NumberFormatException on a empty statement.
637
</li><li>The h2small-*.jar did not support "drop all objects delete files".
638
    Now it is supported (the DeleteDbFiles tool is now included).
639
</li><li>Operations that don't fit in memory are now faster.
Thomas Mueller's avatar
Thomas Mueller committed
640 641
    Temporary file handling was changed.
</li><li>The default maximum log stream size is now 2 MB. This is a good value
Thomas Mueller's avatar
Thomas Mueller committed
642
    according to some performance tests.
643
</li><li>New system property "h2.syncMethod" to configure what method to call when
Thomas Mueller's avatar
Thomas Mueller committed
644 645 646
    closing the database, on checkpoint, and on CHECKPOINT SYNC. The default is "sync" which
    calls RandomAccessFile.getFD().sync().
</li><li>ROWNUM could not be used for pagination. The follow query returned no rows:
Thomas Mueller's avatar
Thomas Mueller committed
647 648 649 650
    select x from (select *, rownum as r from system_range(1, 3)) where r=2;
</li><li>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.
</li><li>Prepared statements with nested subqueries did not always return the correct result. Example:
651 652
    select ?, ?, (select count(*) from test t, (select id from test where 0=?) t2 where t2.id=t.id) from test
</li><li>When using MULTI_THREADED=TRUE, the exception following exception could be thrown:
Thomas Mueller's avatar
Thomas Mueller committed
653 654 655
    "object already exists: TABLES"
</li><li>Comparison of integer columns against float numbers was not always correct. Issue 182.
</li><li>H2 Console: Editing the result of a multi-line queries failed. Issue 183.
Thomas Mueller's avatar
Thomas Mueller committed
656
</li><li>H2 Console: if the settings file (.h2.properties) can't be accessed, the exception is now ignored.
Thomas Mueller's avatar
Thomas Mueller committed
657 658 659
</li></ul>

<h2>Version 1.2.132 (2010-03-21)</h2>
660
<ul><li>The implementation of a Java to C (source code level) converter has been started.
Thomas Mueller's avatar
Thomas Mueller committed
661
    The plan is: it should be possible to convert H2 (or a part of it) to C so that the database
662 663
    can be run without a JVM. This will be a long term project (it may take a year or so).
</li><li>User defined table implementation can now be used using CREATE TABLE ... ENGINE.
664 665
    Thanks to Sergi Vladykin for implementing this feature!
</li><li>Improved MS SQL Server compatibility: support string concatenation using "+".
666 667
    Thanks to Stepan for the patch!
</li><li>When using the multi-threaded mode, running ANALYZE concurrently in multiple
668 669
    connections could throw an exception.
</li><li>The MERGE statement is now about 30% faster when using a PreparedStatement.
670
</li><li>Multi-column indexes where the second or later column was descending did not always
671 672
    produce correct results (rows were missing in the result set, or the result set was empty).
</li><li>When using large transactions or a small log size, the database could get very slow
Thomas Mueller's avatar
Thomas Mueller committed
673 674 675
    (profiling shows the hotspot is in FileObjectDisk.sync()).
</li><li>The Shell tool now prints the stack trace when the list mode is enabled.
</li><li>CREATE ALIAS ... AS: Compilation was incorrect if the source code contained
676 677
    characters that are not supported by the default file encoding.
</li><li>Issue 176: the JdbcDataSource now also supports a 'description' property.
Thomas Mueller's avatar
Thomas Mueller committed
678
</li><li>The Shell tool threw a ArrayIndexOutOfBoundsException after 20 statements.
679
</li><li>When using the small version of H2 ('jarClient'), the first call to
680 681 682 683
    Connection.createBlob (or similar) could throw a ClassNotFoundException
    because the file org.h2.store.fs.FileSystemZip is not included. This missing class
    is now ignored.
</li><li>Literals of type BIGINT now have the correct data type.
Thomas Mueller's avatar
Thomas Mueller committed
684 685 686
</li></ul>

<h2>Version 1.2.131 (2010-03-05)</h2>
Thomas Mueller's avatar
Thomas Mueller committed
687 688 689
<ul><li>Older versions of H2 (version 1.2.127 and older) could not connect to a new version (version 1.2.129 and newer).
    The connection blocked when trying to connect. Now the connection no longer blocks, instead a SQL exception is thrown.
</li><li>In versions 1.2.129 and 1.2.130, a database could not be opened sometimes
690
    after dropping tables or indexes, and then creating new indexes for existing tables.
Thomas Mueller's avatar
Thomas Mueller committed
691
    The exception contained the text "parent not found" (version 1.2.129) or
Thomas Mueller's avatar
Thomas Mueller committed
692
    "Table not found" (version 1.2.130).
693
</li><li>After the database was closed, a null pointer exception could occur in Database.flush.
Thomas Mueller's avatar
Thomas Mueller committed
694
</li><li>An ArrayIndexOutOfBoundsException could occur in the page store (eg. on "delete from table"). Fixed.
Thomas Mueller's avatar
Thomas Mueller committed
695 696 697
</li></ul>

<h2>Version 1.2.130 (2010-02-26)</h2>
Thomas Mueller's avatar
Thomas Mueller committed
698
<ul><li>EXPLAIN: The query plan now contains ".tableScan" if a table scan is used.
699 700 701
</li><li>IN(..): when combining and IN(..) condition with a condition that didn't use an index,
    the result could contain duplicate rows.
</li><li>IN(..): the index was not used if there were multiple IN(..) conditions.
Thomas Mueller's avatar
Thomas Mueller committed
702 703 704
</li><li>For foreign key constraints, the metadata column
    INFORMATION_SCHEMA.INDEXES.CONSTRAINT_NAME was not set for non-unique indexes.
</li><li>PostgreSQL compatibility: when using the following exception was thrown:
705 706 707
    Column "T.TYPTYPMOD" not found. Fixed. This is only when using psqlodbc_08_04*.
</li><li>A tool to migrate an old database from the non-page store format to the
    newest version has been added in src/tools/org/h2/dev/util/Migrate.java. This file is not
708
    included in the jar file currently.
Thomas Mueller's avatar
Thomas Mueller committed
709
</li><li>When using temporary tables, the database didn't shrink sometimes when closing.
Thomas Mueller's avatar
Thomas Mueller committed
710
    Also, sometimes a database could not recover normally.
Thomas Mueller's avatar
Thomas Mueller committed
711
</li><li>Large transactions could run out of heap space. The maximum size of a transaction is now much larger.
712 713
</li><li>The default setting for the system property h2.webMaxValueLength is now 100000 (it was 10000 before).
</li><li>Creating a database was delayed about 2 seconds if the directory didn't exist.
714 715
</li><li>Implemented INIT feature. If the database URL contains ";INIT=...;" then the DDL or DML commands
    following are executed on startup. Example URL: jdbc:h2:mem:test;INIT=RUNSCRIPT FROM '~/create.sql'
Thomas Mueller's avatar
Thomas Mueller committed
716
    (patch from Kerry Sainsbury).
Thomas Mueller's avatar
Thomas Mueller committed
717 718
</li></ul>

719
<h2>Version 1.2.129 (2010-02-19)</h2>
Thomas Mueller's avatar
Thomas Mueller committed
720 721 722
<ul><li>The methods of the CloseListener are added to the Trigger interface.
    The interface CloseListener is removed. This is potentially a breaking change for existing triggers.
</li><li>CREATE ALIAS: error message when compiling Java code have been improved.
Thomas Mueller's avatar
Thomas Mueller committed
723 724
</li><li>MVCC: creating a table with an incorrect constraint could cause strange errors.
</li><li>Hash indexes now are only used for single column indexes.
725
</li><li>The cache types WEAK_* and TQ are no longer supported.
726 727 728
    A weak reference cache never frees up memory so it's the same as
    having a very large cache size. The TQ cache was not included in the
    jar file since a longer time, and was not tested.
729
</li><li>The file system abstraction no longer throws SQL exceptions.
730 731 732 733 734
</li><li>DatabaseEventListener.diskSpaceIsLow has changed.
</li><li>The CompressTool no longer throw as SQL exceptions. Instead, it throws runtime exceptions.
</li><li>SimpleResultSet.addColumn and addRow now can throw a IllegalStateException
    instead of a SQLException.
</li><li>When doing an index lookup, decimal values with the same value but different scale
Thomas Mueller's avatar
Thomas Mueller committed
735 736 737
    (for example 0.00 and 0.0) where not considered equal in version 1.2.128.
    Now they are (unlike BigDecimal.equals()).
</li><li>The BNF parser now uses the visitor pattern.
738
</li><li>Converting a UUID to bytes was incorrect. Because of that, updatable result sets on
Thomas Mueller's avatar
Thomas Mueller committed
739
    tables with UUID primary key did not work.
740 741 742
</li><li>The database URL property DATABASE_EVENT_LISTENER_OBJECT is no longer supported
    (there are problems passing objects when the PostgreSQL driver is installed as well).
</li><li>H2 Console: asynchronous login (using a DatabaseEventListener) is no longer supported.
743
</li><li>A workaround for a Windows socket problem has been implemented. Thanks a lot to Sergi Vladykin.
744
</li><li>The Recover tool did not convert correctly convert CLOB data with non-ASCII characters.
Thomas Mueller's avatar
Thomas Mueller committed
745
</li><li>Tools: the method run(String... args) has been renamed to runTool(String... args).
746 747
</li><li>Server.startWebServer(Connection) was not working as expected.
</li><li>The database URL option ACCESS_MODE_LOG is no longer supported.
Thomas Mueller's avatar
Thomas Mueller committed
748
</li><li>The database URL option RECOVER has currently no effect.
Thomas Mueller's avatar
Thomas Mueller committed
749
</li><li>Converting an old (non-page store) database is no longer supported using this version.
Thomas Mueller's avatar
Thomas Mueller committed
750 751 752
</li><li>The following system properties are no longer supported:
    h2.overflowExceptions, h2.optimizeDropDependencies, h2.optimizeGroupSorted,
    h2.optimizeMinMax, h2.optimizeNot, h2.optimizeIn, h2.optimizeInJoin, h2.reuseSpace*.
Thomas Mueller's avatar
Thomas Mueller committed
753 754
    Most of then were there for a long time, but always with the same value.
    There was no unit test with the other value. So changing them was potentially dangerous
755 756
    (not a lot, but still).
</li><li>The setting LOG has currently no effect (it only had an effect when the page store was disabled).
Thomas Mueller's avatar
Thomas Mueller committed
757
</li><li>Disabling the page store is no longer supported. The old storage mechanism
758
    has been removed, shrinking the jar file size by almost 10%.
759
</li><li>The translated resources are now stored in UTF-8 format.
760
</li><li>The Windows service wrapper now detects if multiple versions of H2 are installed.
Thomas Mueller's avatar
Thomas Mueller committed
761 762 763
</li></ul>

<h2>Version 1.2.128 (2010-01-30)</h2>
Thomas Mueller's avatar
Thomas Mueller committed
764 765 766
<ul><li>There are known errors on rollback when the page store is disabled and at the same time
    MVCC is used. See http://code.google.com/p/h2database/issues/detail?id=158
</li><li>The DeleteDbFiles tool deleted all files in the .lob.db directory,
767 768 769 770 771 772
    even files that didn't belong to the database.
</li><li>Automatic conversion of old databases to the page store format failed
    if the database contained LOB files.
</li><li>Nested subqueries didn't work for INSERT INTO and IN(..).
    Example: insert into test ((select 1));
</li><li>If the database was already closed using SHUTDOWN IMMEDIATELY, closing a second
Thomas Mueller's avatar
Thomas Mueller committed
773 774 775 776 777 778
    connection could throw a NullPointerException if there was a local temporary table.
</li><li>Less classes are loaded when using the database in embedded mode.
</li><li>The information schema tables are only initialized when needed.
    This reduces memory usage and speeds up creating in-memory databases.
    Each in-memory database needs about 8 KB of heap memory.
</li><li>Nested UNION/INTERSECT queries with brackets could produce the wrong result if used within a subquery. Example:
779
    select count(*) from (select 1 union (select 2 intersect select 2)) x;
780
</li><li>Comparing an column against a constant expression with a higher precision or length
Thomas Mueller's avatar
Thomas Mueller committed
781 782 783 784
    than the column could give wrong results (the expression was truncated before comparing).
</li><li>Improved PostgreSQL compatibility (support SHOW DEFAULT_TRANSACTION_ISOLATION).
</li><li>Documentation: the javadocs for Csv.write and read used the wrong default charset.
</li><li>MVCC: if the table was locked in exclusive mode (such as SELECT ... FOR UPDATE), another session
785 786
    could query the table. This is now longer possible.
</li><li>If a FOR UPDATE query was executed twice (using a PreparedStatement), the table was not locked.
Thomas Mueller's avatar
Thomas Mueller committed
787
</li><li>Triggers: INSTEAD OF triggers are now supported.
Thomas Mueller's avatar
Thomas Mueller committed
788 789 790
    Such triggers can be defined on views.
</li><li>New system property h2.identifiersToUpper. If set to false,
    identifiers in SQL statements are case sensitive even if they are not quoted.
791
</li><li>Slightly improved performance if the table is already locked.
792
</li><li>CompressLZF: faster decompression.
Thomas Mueller's avatar
Thomas Mueller committed
793 794
</li><li>PgServer: the wrong size was sent for VARCHAR data.
    Thanks again to Sergi Vladykin for the patch.
795
</li><li>Serialized access mode (server-less multi-connection mode): fixed getGeneratedKeys() for sequences.
Thomas Mueller's avatar
Thomas Mueller committed
796 797 798
</li></ul>

<h2>Version 1.2.127 (2010-01-15)</h2>
799 800 801
<ul><li>Serialized access mode (server-less multi-connection mode): sequences did not work as expected
    (there were gaps in generated values when using multiple connections).
</li><li>Page store: new databases can not be opened with older versions.
Thomas Mueller's avatar
Thomas Mueller committed
802 803
</li><li>Page store: adding data to new database is now faster.
</li><li>File system: getting the file name from a path is now faster. This should
Thomas Mueller's avatar
Thomas Mueller committed
804 805 806
    speed up BLOB and CLOB access.
</li><li>PgServer: incorrect SQL types were returned in result set meta data.
    Concurrently opening a database could fail (PG catalog initialization was not synchronized).
Thomas Mueller's avatar
Thomas Mueller committed
807
    Thanks a lot to Sergi Vladykin for providing the patches!
Thomas Mueller's avatar
Thomas Mueller committed
808 809 810 811 812
</li><li>SHOW COLUMNS did not work correctly if there where multiple indexes
    on the same columns.
</li><li>Page store: the wrong write count was written to the database header.
    This could cause the server-less multi-connection mode to fail.
</li><li>Result sets larger than 2 GB threw an exception "Negative seek offset". Fixed.
813
</li><li>If the system property h2.check was set to false, an ArrayIndexOutOfBoundsException could occur.
814
</li><li>Alter table is now supported even if a table has views defined. (Patch from Kerry Sainsbury).
815
</li><li>Fulltext search: exceptions within the fulltext search package had the wrong SQL state.
816 817 818
</li><li>The Lucene fulltext search ignored transaction rollback. Fixed using a trigger on rollback.
</li><li>Trigger can now be called on rollback.
</li><li>The shell script h2.sh ignored command line line arguments.
819 820 821
</li><li>When running H2 in the Google AppEngine for Java, a AccessControlException could be thrown
    when trying to open a read-only database. Fixed.
</li><li>The user home directory prefix (~) is now only expanded when followed by a slash
822 823 824 825
    or backslash, or standing alone.
</li><li>Native fulltext search: before inserting or deleting data, FT_INIT() had to be called.
    This is no longer required.
</li><li>The .trace.db file is now only created if required.
826
</li><li>Shell tool: improved PostgreSQL compatibility.
827
</li><li>Trying to open a database in read-only mode when a .lock.db file exists will now fail
828 829
    with a nice error message.
</li><li>H2 Console: data that is too long is now abbreviated as follows: text... (100000 characters).
830
    A large binary is abbreviated as follows: abcdef... (100000 bytes).
831
</li><li>Faster data conversion from BIGINT or INT to DECIMAL.
832
</li><li>Server-less multi-connection mode: try to delete log files if switching between read/write operations.
833
</li><li>CompressLZF: Faster decompress and improved javadocs
Thomas Mueller's avatar
Thomas Mueller committed
834 835 836
</li></ul>

<h2>Version 1.2.126 (2009-12-18)</h2>
837 838
<ul><li>The ChangeFileEncryption tool will now fail with an exception
    if the database is still in use. The Backup tool will also fail except when running in quiet mode.
839 840 841 842 843
</li><li>CSVREAD: when reading the column names from the CSV file, column names that contain
    no special characters are considered case insensitive now.
</li><li>Optimization index conditions of the form 'column=NULL' (which is always false; unlike 'column IS NULL').
</li><li>Script command and tool: the primary key constraint is now listed before inserting the data.
    This will result in a smaller database when using the page store.
844 845
</li><li>Statements with IN(SELECT..) conditions could produce the wrong result.
    Example: index on id, name; query: select * from test where id between 1 and 3 and name in (select 'World').
846 847 848 849
</li><li>Statements with IN(..) conditions could produce the wrong result when using views or nested select statements.
    Example: index on id; index on name; query: select * from (select * from test) where id=1 and name in('a', 'b').
    select * from (select * from test) where id=1 and name in('Hello', 'World').
</li><li>Page store: a rollback of a relatively large transaction could fail with an ArrayIndexOutOfBoundsException
850 851
    or a 'row not found' exception in the PageBtreeIndex in some cases.
</li><li>JaQu: the decompiler has been improved, and a few test cases already work. It is still incomplete however.
852 853 854 855
</li><li>LIKE: any letter is now allowed after the escape character (which is still '\' by default).
    Previously, an exception was thrown (unlike other databases) if it was not the escape character, '_' or '%'.
    If the escape character appears at the end of the pattern, the result is  it is ignored (like PostgreSQL and MS SQL Server).
</li><li>The reserve heap memory is no longer used.
856
</li><li>Database.checkpoint() could throw a NullPointerException.
Thomas Mueller's avatar
Thomas Mueller committed
857 858 859
</li></ul>

<h2>Version 1.2.125 (2009-12-06)</h2>
860 861 862 863
<ul><li>Lucene fulltext search: the Lucene field names now match the table column names,
    except if the column names start with _ (in which case another _ is prepended).
    Unfortunately this change means existing fulltext indexes need to be re-built.
</li><li>The shell tool now has a very simple statement history.
864 865 866
</li><li>The zip file system implementation now supports the '~' home directory prefix.
    Example database URL: jdbc:h2:zip:~/test.zip!/test
</li><li>Right outer joins on tables that were already 'inner joined' was processed incorrectly.
867 868 869
</li><li>Temporary files from LOB objects were not deleted early enough when using the server mode.
</li><li>Trying to alter a temporary table threw a strange exception.
    It is still not possible to do that, but the exception message is better now.
870 871 872 873
</li><li>When the system property h2.maxMemoryRowsDistinct was set, and
    using SELECT DISTINCT, the temporary table was not correctly dropped.
    This could cause problems in recovery when the process was killed.
</li><li>Trigger that are called before a select statement are now supported.
874
    This allows to create tables that work like materialized views.
875 876
</li><li>Non-row based triggers were called even if the action didn't match the
    declared action (INSERT triggers were also called when deleting rows).
877 878 879 880 881
    This has been changed. The MERGE statement calls both INSERT and DELETE triggers.
</li><li>Statements with IN(..) conditions could produce the wrong result or a data conversion error (since version 1.2.120).
    Examples: index on id, name, condition: id=1 and name in('Hello', 'x'); index on id, query:
    select * from (select * from test) where id=1 and name in('Hello', 'World').
</li><li>The CompressTool was not multithreading safe. Because of this, the following database
882 883
    operations where also not multithreading safe (even when using different databases): the SCRIPT command
    (only when using compression), the COMPRESS function, and storing CLOB or BLOB data (only when compression is enabled).
884
</li><li>The compression algorithm "LZF" is now about 33% faster than before when compressing small block
885
    (around 2 KB). It is much faster than Deflate, but the compression ratio is lower.
886
    Some of the optimizations are from Sam Van Oort, thanks a lot!
887 888 889
</li><li>Compressing large blocks of data didn't work when using the "Deflate" compression algorithm.
    Compressing a lot of data could run out of heap memory.
</li><li>The test cases don't access the file system directly, this simplifies GAE for Java testing.
890 891
    Thanks to Vince Bonfanti.
</li><li>More bugs in the server-less multi-connection mode have been fixed.
892
</li><li>When running against an old database, the SCRIPT statement could generate a
893 894 895
    SQL script that contained duplicate indexes (PRIMARY_KEY_E).
</li><li>JdbcConnectionPool.getConnection() could throw a NullPointerException.
</li><li>User defined functions: the source code is now available using
Thomas Mueller's avatar
Thomas Mueller committed
896 897 898 899 900
    SELECT SOURCE FROM INFORMATION_SCHEMA.FUNCTION_ALIASES.
</li><li>User defined functions with source code didn't work after re-opening the database.
</li><li>The newsfeeds are now Atom 1.0 standard compliant.
</li><li>The database is now closed after an out of memory exception, because
    the database could get corrupt otherwise.
901
</li><li>Better error message if both AUTO_SERVER and SERIALIZED parameters are set to TRUE.
902
</li><li>Drop table did not delete lob files in old file store (not PAGE_STORE).
Thomas Mueller's avatar
Thomas Mueller committed
903 904
</li></ul>

905 906
<!-- [close] { --></div></td></tr></table><!-- } --><!-- analytics --></body></html>