All Projects : Derby (Key: DERBY)

Project Lead: Andrew McIntyre
URL: http://db.apache.org/derby/

Release Notes

Road Map View personal road map Scope: next 3 versions | all versions 10.0.2.2 ( Release Notes ) Progress:    22 of 22 issues have been resolved    DERBY-662 FIXED during crash recovery of a drop table, on case insensitive files systems derby may delete wrong file    DERBY-182 FIXED BUILDING.txt 3.4.6 refers to a readme file for testing that does not exist    DERBY-153 FIXED Bad Eclipse plugin version specification    DERBY-488 FIXED DatabaseMetaData.getColumns() fails on iSeries JDK 1.4 with verfier error on generated class.    DERBY-55 FIXED Derby documentation mentions script and batch files that don't exist    DERBY-388 FIXED Intermittent failures when executing UPDATE trigger statements    DERBY-139 FIXED LOCAL as a reserved keyword does not match other databases    DERBY-2062 FIXED Need to filter out this line from the output with jcc 2.6.90. DB2ConnectionCorrelator: NF000001.GDBA.010EB568BF46    DERBY-1324 FIXED Need to remove old copyright notice    DERBY-56 FIXED NsSample sample program refered to in documentation is missing    DERBY-45 FIXED Request support for CAST() in Like clause    DERBY-91 FIXED XA .sql tests fail with jar files    DERBY-226 FIXED intermittent SQLException in test jdbcapi/testRelative.java    DERBY-261 FIXED Document Network Client in Derby docs    DERBY-233 FIXED Fix copyright notices and other IBM/Cloudscape references in java/demo/*    DERBY-77 FIXED Test instructions incomplete for setting classpath.    DERBY-228 FIXED need some OSGI related changes to MANIFEST.MF    DERBY-266 FIXED test tools/dblook_test.java fails if run in a directory having "*derby/*" in its path    DERBY-197 FIXED Add tip for Windows users in BUILDING.txt file regarding file paths in the ant.properties file    DERBY-249 FIXED Builds fail during splitmessages step if path contains spaces    DERBY-196 FIXED Link for Jikes 1.14 in BUILDING.txt needs to be changed to http://jikes.sourceforge.net/    DERBY-1366 FIXED minor patching up of some test issues - state May 31 2006 10.1.3.2 ( Release Notes ) Progress:    49 of 49 issues have been resolved    DERBY-756 FIXED OutOfMemory Error on continous execution of select statement using COUNT() and DISTINCT on same connection    DERBY-3023 FIXED Different result rows depending on the sequence of INNER JOIN and OUTER JOIN    DERBY-3093 FIXED Intermittent transaction failure caused by internal duplicate savepoint name for triggers    DERBY-2142 FIXED NullPointerException while using XAConnection/PooledConnection in a heavily contended multithreaded scenario    DERBY-1500 FIXED PreparedStatement#setObject(int parameterIndex, Object x) throws SQL Exception when binding Short value in embedded mode    DERBY-1533 FIXED ArrayIndexOutOfBoundsException in DDMReader, on a specific data size    DERBY-1304 FIXED DROP view does not always completely remove view    DERBY-876 FIXED DatabaseMetaData.getSchemas() is not JDBC 3.0 compliant    DERBY-176 FIXED Derby throws ERROR XBCM1: Java linkage error thrown during load of generated class org.apache.derby.exe.aced07c066x0102xca87x3319x00004aa5686e1 during execution of large query    DERBY-1485 FIXED DERBY-1466 Document that autoflush is needed if Network Server is started with a PrintWriter specified for console output    DERBY-732 FIXED ERROR XBCM1: Java linkage error thrown during load of generated class for query with large number of logical operators and substitution parameters.    DERBY-1939 FIXED ERROR XSDA7 while executing query that spills to BackingStoreHashTable    DERBY-1373 FIXED Encrypted databases cannot be booted using the jar subprotocol (and possibly also using http/https/classpath)    DERBY-1554 FIXED IDENTITY_VAL_LOCAL() returned value is modified incorrectly by a multi-row INSERT statement.    DERBY-766 FIXED DERBY-176 Improve code generation to handle 5000 unions in a select the union test in largeCodeGen    DERBY-353 FIXED It is desirable to have IDENTITY_VAL_LOCAL() function return last recent user specified value or system generated value for BY DEFAULT identity columns.    DERBY-1856 FIXED Multiple communication failures when starting server with derby.drda.timeSlice    DERBY-1466 FIXED Network Server should flush the PrintWriter after console output    DERBY-638 FIXED Network driver setTransactionIsolation() causes a commit, but does not complete it locally    DERBY-428 FIXED NetworkClient PreparedStatement.executeBatch() hangs if batch is too large (ArrayIndexOutOfBoundsException in Network Server)    DERBY-1633 FIXED Regression: The fields of views are not being calculated properly since 10.1.2.4    DERBY-1777 FIXED Regression: query works in 10.1.2.1 but fails with NullPointerException in 10.2.1.1    DERBY-537 FIXED SQLJ.INSTALL_JAR and SQLJ.UPDATE_JAR fail when running with a SecurityManager enabled.    DERBY-1894 FIXED SQLSTATE 42X10 occurs when qualifying a column with a synonym in ORDER BY clause    DERBY-2040 FIXED Setting derby.database.classpath to contain installed jars causes the database to be unbootable when a Securitymanager is installed.    DERBY-1315 FIXED Statement optimization/compilation fails with OutOfMemoryException in largeCodeGen test with embedded and framework DerbyNetClient    DERBY-1108 FIXED The test jdbcapi/setTransactionIsolation.java fails with ibm jvm1.5    DERBY-1652 FIXED Update trigger updating the same rows as the original update does not throw an exception ERROR 54038: "Maximum depth of nested triggers was exceeded" as it should    DERBY-3238 FIXED When table contains large LOB values (> ~32K) trigger execution fails for that row with ERROR XCL30: An IOException was thrown when reading a 'BLOB'    DERBY-2526 FIXED Wrong results with queries that use the JOIN ... ON syntax to join with views or other non-base table expressions.    DERBY-1719 FIXED autoincrement regression test fails with single diff - looks like just a master issue    DERBY-1810 FIXED derbynet/testProperties fails when timeout for successful ping is low.    DERBY-2059 FIXED derbynetmats/derbynetmats.fail:jdbcapi/resultset.java,derbynetmats/derbynetmats.fail:jdbcapi/LOBTest.java,derbynetmats/derbynetmats.fail:jdbcapi/parameterMapping.java are failing with JCC 2.8.47 with IBM JVM 142 and 15 on 10.1    DERBY-2084 FIXED getTransactionIsolation() in network client should not activate a transaction    DERBY-1793 FIXED testSecMec in DerbyNetClient framework fails with "FAIL: Server failed to respond to ping - ending test"    DERBY-3538 FIXED NullPointerException during execution for query with LEFT OUTER JOIN whose inner table selects all constants.    DERBY-1872 FIXED Backport lang/wisconsin.java at 10.2.0.4-alpha to the 10.1 branch    DERBY-2606 FIXED Derby should print the parameters to failed statements to the derby.log when it logs the error    DERBY-740 FIXED DERBY-732 Have BCMethod.cast() optimize the case when the requested cast is to the same Java type.    DERBY-738 FIXED DERBY-732 Initialize parameters within activation without using generated code.    DERBY-1456 FIXED DERBY-1011 Network Server agentError calls log only to console and are hard to diagnose    DERBY-1693 FIXED Out of Memory Error with derby.language.logStatementText=true    DERBY-541 FIXED Read-only databases fail to boot after soft upgrade. Raises error message: 40XD1: Container was opened in read-only mode.    DERBY-739 FIXED DERBY-732 Reduce generated code required to access a parameter's value    DERBY-921 FIXED DERBY-176 Support 32bit branch offsets for conditional logic in generated code.    DERBY-742 FIXED DERBY-732 Use a single result BooleanDataValue for a boolean expression in class generation    DERBY-990 FIXED store/access.sql fails - incorrect index?    DERBY-989 FIXED unit/daemonService.unit fails intermittently: 'ran out of time'    DERBY-1453 WON'T FIX jdbcapi/blobclob4BLOB.java fails with 10.1 client and 10.2 server 10.1.3.3 ( 22/Oct/08 | Release Notes ) Progress:    9 of 9 issues have been resolved Maintenance version bump for sps update    DERBY-555 FIXED Unable to restart after disk is full    DERBY-3919 FIXED Changing derby versions can cause java.lang.NoSuchMethodError on DatabaseMetaData call    DERBY-4310 FIXED Closing a prepared statement with an embedded XAConnection can cause the statement to be reprepared and errors related to missing dependencies. This can interfere with network server closeSession()    DERBY-3926 FIXED Incorrect ORDER BY caused by index    DERBY-4331 FIXED Join returns results in wrong order    DERBY-4050 FIXED Multithreaded clob update causes growth in table that does not get reclaimed    DERBY-4287 FIXED call to System.getProperty in BCClass.java is not wrapped in a priv block so may fail when running under SecurityManager    DERBY-861 FIXED Intermittent failure of store/readlocks.sql    DERBY-4072 FIXED shutdown with incorrect permission on log files shows java.lang.NullPointerException at org.apache.derby.impl.store.raw.log.LogToFile.flush(LogToFile.java:3964). Should give bettter message. 10.1.4.0 ( Release Notes ) Progress:    13 of 13 issues have been resolved    DERBY-4239 FIXED Possible corruption if SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE is called during checkpoint    DERBY-1854 FIXED SYSCS_COMPRESS_TABLE corrupts table with a single column which is both a primary key and a foreign key    DERBY-1866 FIXED Assert failure in sane mode for queries that used to work in 10.1.2.1    DERBY-1373 FIXED Encrypted databases cannot be booted using the jar subprotocol (and possibly also using http/https/classpath)    DERBY-1420 FIXED Make JitTest.java independent of Derby release    DERBY-1227 FIXED Network Server should not use the underlying embedded prepared statement when accessing a BrokeredPreparedStatement    DERBY-1681 FIXED Regression (wrong results): Join predicate can be ignored for left-most child in a chain of nested unions.    DERBY-2183 FIXED Trigger recompilation problem when trigger action has its table not qualified with a schema    DERBY-1784 FIXED When qualifying a column name with its synonym name in the select list, Derby throws SQLSTATE 42X04.    DERBY-1426 FIXED Derby Server and Administration Guide - Using the Derby ij tool with the Network Server    DERBY-744 FIXED Problem setting sanity state to false by using 'ant -Dsane=false'    DERBY-1351 FIXED lang/forupdate.sql fails with derbyclient in the 10.1 branch    DERBY-3863 FIXED improve test importExportIJ.sql 10.2.2.1 ( Release Notes ) Progress:    54 of 54 issues have been resolved    DERBY-4268 FIXED "SECURITY" is reserved as SQL keyword.    DERBY-2237 FIXED Cleanup copyrights in the DITA source and generated docs    DERBY-3023 FIXED Different result rows depending on the sequence of INNER JOIN and OUTER JOIN    DERBY-3093 FIXED Intermittent transaction failure caused by internal duplicate savepoint name for triggers    DERBY-2142 FIXED NullPointerException while using XAConnection/PooledConnection in a heavily contended multithreaded scenario    DERBY-2566 FIXED OutOfMemory/Sanity-assert failed when updating database    DERBY-2376 FIXED DERBY-1931 Patch available to make .classpath entries portable - relative to ECLIPSE_HOME    DERBY-2681 FIXED SetQueryTimeoutTest. fails in J2ME environment    DERBY-1132 FIXED Truncation Error with Concat    DERBY-3028 FIXED Broken links generated on 10.2.2 dowload page [release-10.2.2.0.html]    DERBY-893 FIXED Build failures introduced by SQLException rototill: optional jdbc4 classes fail to build    DERBY-1130 FIXED Client should not allow databaseName to be set with setConnectionAttributes    DERBY-4310 FIXED Closing a prepared statement with an embedded XAConnection can cause the statement to be reprepared and errors related to missing dependencies. This can interfere with network server closeSession()    DERBY-2584 FIXED Creating a database with JPOX SchemaTool sometimes gives ArrayIndexOutOfBoundsException when getIndexInfo() is called    DERBY-3085 FIXED Fails to handle BLOB fields with a PreparedStatement with size >32750 bytes    DERBY-1752 FIXED DERBY-1377 Fix javadoc to account for changes required by new licence header policy.    DERBY-2551 FIXED Global Xid value garbled in syscs_diag.transaction_table.    DERBY-3926 FIXED Incorrect ORDER BY caused by index    DERBY-1540 FIXED JDBC 4 EoD with default QueryObjectGenerator fails with SecurityManager    DERBY-2279 FIXED JDBC3 driver is loaded instead of JDBC4 when running with jdk1.7    DERBY-4331 FIXED Join returns results in wrong order    DERBY-4050 FIXED Multithreaded clob update causes growth in table that does not get reclaimed    DERBY-3909 FIXED Race condition in NetXAResource.removeXaresFromSameRMchain()    DERBY-790 FIXED SQLException used by the networked interface to Derby is not serializable    DERBY-537 FIXED SQLJ.INSTALL_JAR and SQLJ.UPDATE_JAR fail when running with a SecurityManager enabled.    DERBY-2040 FIXED Setting derby.database.classpath to contain installed jars causes the database to be unbootable when a Securitymanager is installed.    DERBY-1133 FIXED Split jdbc4 tests so that the suite can be run independently under the embedded and DerbyNetClients like other Derby test suites    DERBY-4095 FIXED Trigger fails with ERROR 38000: The exception 'java.sql.SQLException: ResultSet not open during VTIResultSet.getNextRowCore()    DERBY-2220 FIXED Uncommitted transactions executed throught XAResource will held locks after the application terminates (or crashes during the transaction).    DERBY-3238 FIXED When table contains large LOB values (> ~32K) trigger execution fails for that row with ERROR XCL30: An IOException was thrown when reading a 'BLOB'    DERBY-2941 FIXED DERBY-2892 With 10.2, Closing a resultset after retrieving a large > 32665 bytes value with Network Server does not release locks    DERBY-2526 FIXED Wrong results with queries that use the JOIN ... ON syntax to join with views or other non-base table expressions.    DERBY-1129 FIXED compatibility tests fail with security related errors.    DERBY-2208 FIXED setNetworkServerCP scripts need not add derby.jar into the CLASSPATH    DERBY-2613 FIXED upgrade test problem when attempting to test 10.0.2.1 -    DERBY-1662 FIXED Document derbyrun.jar    DERBY-3538 FIXED NullPointerException during execution for query with LEFT OUTER JOIN whose inner table selects all constants.    DERBY-4287 FIXED call to System.getProperty in BCClass.java is not wrapped in a priv block so may fail when running under SecurityManager    DERBY-2906 FIXED derbynet.jar & derbytools.jar incorrectly have a META-INF/services/java.sql.Driver entry    DERBY-3308 FIXED Broken synchronization for event handling in ClientPooledConnection40    DERBY-2606 FIXED Derby should print the parameters to failed statements to the derby.log when it logs the error    DERBY-2214 FIXED Fix Getting Started file to reflect classpath change    DERBY-1541 FIXED Make test jdbc4/TestPreparedStatement run under the security manager    DERBY-2218 FIXED Null Pointer Exception when an untyped NULL subquery ("values null") appears outside of the FROM list in a SELECT query.    DERBY-815 FIXED DERBY-212 Prevent unneeded object creation and excessive decoding in parseSQLDTA_work()    DERBY-3133 FIXED Syntax for GRANT table permission does not mention that several privileges may be specified in a list    DERBY-1814 FIXED Tests should always be compiled with line number information.    DERBY-967 FIXED lang/autoincrement.sql intermittently fails on SunOS-5.10_i86    DERBY-2325 FIXED lang/grantRevokeDDL.sql is failing on wctme5.7_foundation jvm ...    DERBY-1760 FIXED remote server testing with 10.2 snapshot showed 8 failures    DERBY-4072 FIXED shutdown with incorrect permission on log files shows java.lang.NullPointerException at org.apache.derby.impl.store.raw.log.LogToFile.flush(LogToFile.java:3964). Should give bettter message.    DERBY-3309 FIXED DERBY-3308 Minor cleanups in ClientPooledConnection40 and ClientPooledConnection    DERBY-2184 FIXED QuickStart section of java/testing/README.htm should contain Sun JDK6 as supported java version for running tests    DERBY-1955 FIXED Unquoted path in .bat files may cause errors (Win) 10.2.3.0 ( Release Notes ) Progress:    24 of 24 issues have been resolved    DERBY-4239 FIXED Possible corruption if SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE is called during checkpoint    DERBY-2549 FIXED ArrayIndexOutOfBoundsException in SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE    DERBY-2371 FIXED Setting a default value for a VARCHAR column fails when column contains data    DERBY-595 FIXED Using derby.language.logStatementText=true can mask certain exceptions and lead to incorrect behavior in some cases    DERBY-2222 FIXED 'show indexes in SCHEMANAME' does not work with the client driver    DERBY-2134 FIXED Add long running System test for Derby    DERBY-1920 FIXED DOCS - Improve topic titles for vague and duplicate topics    DERBY-2789 FIXED DatabaseMetaData .locatorsUpdateCopy() should return true    DERBY-1709 FIXED Deprecate scripts in frameworks directory    DERBY-147 FIXED ERROR 42X79 not consistant ? - same column name specified twice    DERBY-2195 FIXED Nested triggers not working properly after maximum trigger count exception is thrown    DERBY-1847 FIXED SELECT statement asserts with XJ001 when attempted to select a newly added column in SQL authorization mode    DERBY-2228 FIXED Support Derby on J2ME/CDC/Foundation 1.1    DERBY-2183 FIXED Trigger recompilation problem when trigger action has its table not qualified with a schema    DERBY-2103 FIXED After a Lexical Error due to syntax error , even a simple create table does not work on the same connection.    DERBY-2202 FIXED DROP PROCEDURE depends on SET SCHEMA    DERBY-425 FIXED Developer's guide issues    DERBY-2093 FIXED Error in initSlotTable() can cause NPE or ASSERT rather than reporting page number in corrupt page message.    DERBY-2125 FIXED Getting Started with Derby - Installing Derby    DERBY-2154 FIXED Graphic in Dev Guide contains inaccurate text    DERBY-2218 FIXED Null Pointer Exception when an untyped NULL subquery ("values null") appears outside of the FROM list in a SELECT query.    DERBY-3133 FIXED Syntax for GRANT table permission does not mention that several privileges may be specified in a list    DERBY-1972 FIXED Working With Derby needs some formatting fixes and other minor cleanup    DERBY-3863 FIXED improve test importExportIJ.sql 10.3.3.1 ( Release Notes ) Progress:    46 of 48 issues have been resolved    DERBY-3037 UNRESOLVED Language ResultSet.finish() is called even when the ResultSet is going to be re-used.    DERBY-2720 UNRESOLVED remove dead code associated with unsupported National Char implementation    DERBY-4268 FIXED "SECURITY" is reserved as SQL keyword.    DERBY-700 FIXED Derby does not prevent dual boot of database from different classloaders on Linux and Mac OS X    DERBY-3593 FIXED ErrorCode 30000 when quering a select with 'having' clause and named tables with aliases for selected fields    DERBY-4060 FIXED Blob.getBinaryStream(long,long) is off by one for the pos+len check    DERBY-3730 FIXED Bundle-SymbolicName: needed in Derby manifest for OSGi 4 environment    DERBY-3035 FIXED Cannot restore backups without BACKUP.HISTORY file    DERBY-4063 FIXED Constraint causes wrong query result when using exists    DERBY-3813 FIXED Derby tests for the existance of BigDecimal methods toPlainString and bdPrecison but does not check if they were found before using them.    DERBY-3546 FIXED Failed to get database schemas of a JAR database    DERBY-4061 FIXED InputStream returned from Blob.getBinaryStream(long, long) terminates the stream by returning 0, should return -1    DERBY-3360 FIXED Invalid method java.lang.Integer >> void <init>(short) because java.lang.NoSuchMethodException: java.lang.Integer.<init>(short)    DERBY-4304 FIXED Network Server shutdown should handle exceptions and finish the server shutdown completely    DERBY-3997 FIXED ORDER BY causes column to be returned    DERBY-3764 FIXED Union Query fail on Derby 10.4.1.3    DERBY-3803 FIXED 'org.apache.derbyTesting.functionTests.tests.lang.XMLTypeAndOpsTest' failures on JVM 1.5 on trunk, 10.4 and 10.3    DERBY-3978 FIXED Clob.truncate(long) in the client driver doesn't update the cached Clob length    DERBY-4310 FIXED Closing a prepared statement with an embedded XAConnection can cause the statement to be reprepared and errors related to missing dependencies. This can interfere with network server closeSession()    DERBY-4073 FIXED Creation/configuration of ClientXDataSource fails because of two setSsl methods    DERBY-4230 FIXED DatabaseMetaData.getColumns() returns extra column from view with group by and expression in SELECT list    DERBY-3745 FIXED Derby can leak classloaders in an app server environment    DERBY-3926 FIXED Incorrect ORDER BY caused by index    DERBY-4331 FIXED Join returns results in wrong order    DERBY-3889 FIXED LOBStreamControl.truncate() doesn't delete temporary files    DERBY-4050 FIXED Multithreaded clob update causes growth in table that does not get reclaimed    DERBY-3909 FIXED Race condition in NetXAResource.removeXaresFromSameRMchain()    DERBY-3975 FIXED SELECT DISTINCT may return duplicates with territory-based collation    DERBY-3741 FIXED SQL LENGTH function materializes CLOB into memory    DERBY-4040 FIXED SQLChar.getLength returns wrong length for some data values    DERBY-4376 FIXED Simple select runs forever    DERBY-4095 FIXED Trigger fails with ERROR 38000: The exception 'java.sql.SQLException: ResultSet not open during VTIResultSet.getNextRowCore()    DERBY-4141 FIXED XAExceptions thrown by Derby can have errorCode 0    DERBY-2209 FIXED derbynet/getCurrentProperties.java fails intermittently    DERBY-3655 FIXED errror in nightly regression test: LobStreamsTest:encryptedjunit.framework.AssertionFailedError: f:\jartest\JarResults.2008-04-29\ibm16_suites.All\system\singleUse\oneuse1e\tmp\lob6165.tmp    DERBY-3869 FIXED intermittent hang pinging server on Linux    DERBY-3701 FIXED java.lang.Exception: DRDA_UnableToAccept.S:Unable to accept connections and client hang if tracing is turned on but traceDirectory does not exist    DERBY-3880 FIXED NPE on a query with having clause involving a join    DERBY-4287 FIXED call to System.getProperty in BCClass.java is not wrapped in a priv block so may fail when running under SecurityManager    DERBY-576 FIXED xaHelper in ij creates global id that is not the same across platforms    DERBY-1945 DUPLICATE Need changes to manifest for OSGi environment    DERBY-3589 FIXED AllocPage.createPage() doesn't initialize minimumRecordSize correctly    DERBY-3883 FIXED LOBStreamControl.replaceBytes() leaves temporary files open    DERBY-4004 FIXED DERBY-728 Remove required RDBNAM from ACCSEC. Use SECCHK RDBNAM if none is provided on ACCSEC    DERBY-3732 FIXED SQL Length function materializes BLOB into memory    DERBY-4072 FIXED shutdown with incorrect permission on log files shows java.lang.NullPointerException at org.apache.derby.impl.store.raw.log.LogToFile.flush(LogToFile.java:3964). Should give bettter message.    DERBY-3772 FIXED testclientij (NetIjTest) failed on Zos with derby10.3    DERBY-3863 FIXED improve test importExportIJ.sql 10.3.4.0 ( Release Notes ) Progress:    5 of 5 issues have been resolved    DERBY-4239 FIXED Possible corruption if SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE is called during checkpoint    DERBY-4063 FIXED Constraint causes wrong query result when using exists    DERBY-4330 FIXED NullPointerException or assert failure when re-executing PreparedStatement after lock timeout    DERBY-4182 FIXED SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE does not reclaim space lost from an aborted insert    DERBY-4450 FIXED GROUP BY in an IN-subquery inside HAVING clause whose select list is subset of group by columns, gives NPE 10.4.2.1 ( Release Notes ) Progress:    62 of 64 issues have been resolved Subversion #: 706043    DERBY-3769 UNRESOLVED Make LOBStoredProcedure on the server side smarter about the read buffer size    DERBY-3632 UNRESOLVED Replication tests must ensure stable replication state has been reached before attempting further connection or new replication commands.    DERBY-4268 FIXED "SECURITY" is reserved as SQL keyword.    DERBY-4027 FIXED An attempt was made to access an out of range slot on a page    DERBY-700 FIXED Derby does not prevent dual boot of database from different classloaders on Linux and Mac OS X    DERBY-3887 FIXED Embedded Derby fails under JBoss because of JMX-related conflicts    DERBY-3043 FIXED 'Schema <schemaname> does not exist' when constraint used in table definition    DERBY-4060 FIXED Blob.getBinaryStream(long,long) is off by one for the pos+len check    DERBY-3035 FIXED Cannot restore backups without BACKUP.HISTORY file    DERBY-4224 FIXED Commit after setAsciiStream() makes execution fail with the client driver    DERBY-4063 FIXED Constraint causes wrong query result when using exists    DERBY-4088 FIXED DDMReader readBytes ArrayIndexOutOfBoundsException    DERBY-4435 FIXED Emptying index fails with NPE doing replacement import of empty file    DERBY-4061 FIXED InputStream returned from Blob.getBinaryStream(long, long) terminates the stream by returning 0, should return -1    DERBY-3904 FIXED NPE on left join with aggregate    DERBY-4304 FIXED Network Server shutdown should handle exceptions and finish the server shutdown completely    DERBY-3872 FIXED NullPoinerException thrown when INTEGER function used as a predicate in a WHERE clause of a SELECT .. GROUP BY .. HAVING statement    DERBY-4306 FIXED NullPointerException in JMXManagementService.unregisterMBean when running jdbcapi._Suite    DERBY-3997 FIXED ORDER BY causes column to be returned    DERBY-3878 FIXED Replication: stopSlave does not close serversocket when master has crashed.    DERBY-4361 FIXED testDefault fixture in engine.ErrorStreamTest has been failing with junit.framework.AssertionFailedError: File C:\jartest\JarResults.XXdateXX\ibm15_suites.All\system\derby.log could not be deleted    DERBY-4356 FIXED testStartStopManagementFromApplication(org.apache.derbyTesting.functionTests.tests.management.ManagementMBeanTest)junit.framework.AssertionFailedError: expected:<2> but was:<%>    DERBY-3561 FIXED testStartStopManagementFromApplication(org.apache.derbyTesting.functionTests.tests.management.ManagementMBeanTest)junit.framework.AssertionFailedError: expected:<2> but was:<5>    DERBY-4028 FIXED two rows can be inserted with the same value in a column that a unique constraint on that column should prevent    DERBY-4006 FIXED ALTER COLUMN ... WITH DEFAULT NULL does not change the default    DERBY-2822 FIXED Add caching of store stream length in StoreStreamClob, if appropriate    DERBY-4071 FIXED AssertFailure when selecting rows from a table with CHARACTER and VARCHAR columns    DERBY-4081 FIXED BTreeController.comparePreviousRecord() may fail to release latch on left-most leaf    DERBY-3978 FIXED Clob.truncate(long) in the client driver doesn't update the cached Clob length    DERBY-4310 FIXED Closing a prepared statement with an embedded XAConnection can cause the statement to be reprepared and errors related to missing dependencies. This can interfere with network server closeSession()    DERBY-3858 FIXED Create Eclipse plugin for the release 10.4.2.0    DERBY-4073 FIXED Creation/configuration of ClientXDataSource fails because of two setSsl methods    DERBY-4230 FIXED DatabaseMetaData.getColumns() returns extra column from view with group by and expression in SELECT list    DERBY-3875 FIXED Derby cannot replace a database after encountering corruption    DERBY-3871 FIXED EmbedBlob.setBytes returns incorrect insertion count    DERBY-3926 FIXED Incorrect ORDER BY caused by index    DERBY-4331 FIXED Join returns results in wrong order    DERBY-3889 FIXED LOBStreamControl.truncate() doesn't delete temporary files    DERBY-4050 FIXED Multithreaded clob update causes growth in table that does not get reclaimed    DERBY-4053 FIXED Network Server's failure to rollback local transactions on shutdown can cause hang on startup with message java.net.BindException: Address already in use: NET_Bind in derby.log    DERBY-3909 FIXED Race condition in NetXAResource.removeXaresFromSameRMchain()    DERBY-3975 FIXED SELECT DISTINCT may return duplicates with territory-based collation    DERBY-4040 FIXED SQLChar.getLength returns wrong length for some data values    DERBY-4312 FIXED SQLException XJ215 on insert with setCharacterStream() and autocommit off in mailjdbc test    DERBY-4376 FIXED Simple select runs forever    DERBY-3825 FIXED StoreStreamClob.getReader(charPos) performs poorly    DERBY-4095 FIXED Trigger fails with ERROR 38000: The exception 'java.sql.SQLException: ResultSet not open during VTIResultSet.getNextRowCore()    DERBY-4141 FIXED XAExceptions thrown by Derby can have errorCode 0    DERBY-4126 FIXED You can't invoke a table function which is stored in a jar file inside the database    DERBY-3655 FIXED errror in nightly regression test: LobStreamsTest:encryptedjunit.framework.AssertionFailedError: f:\jartest\JarResults.2008-04-29\ibm16_suites.All\system\singleUse\oneuse1e\tmp\lob6165.tmp    DERBY-3869 FIXED intermittent hang pinging server on Linux    DERBY-3880 FIXED NPE on a query with having clause involving a join    DERBY-4287 FIXED call to System.getProperty in BCClass.java is not wrapped in a priv block so may fail when running under SecurityManager    DERBY-576 FIXED xaHelper in ij creates global id that is not the same across platforms    DERBY-4097 FIXED 'testMixedInsertDelete(org.apache.derbyTesting.functionTests.tests.lang.NullableUniqueConstraintTest)org.apache.derby.client.am.BatchUpdateException'    DERBY-3991 FIXED Clob.truncate(0) throws exception    DERBY-3731 FIXED Improve calculation of refSize in ClassSize.java    DERBY-3883 FIXED LOBStreamControl.replaceBytes() leaves temporary files open    DERBY-3970 FIXED PositionedStoreStream doesn't initialize itself properly    DERBY-4004 FIXED DERBY-728 Remove required RDBNAM from ACCSEC. Use SECCHK RDBNAM if none is provided on ACCSEC    DERBY-3793 FIXED Remove unnecessary methods from InternalClob interface    DERBY-4072 FIXED shutdown with incorrect permission on log files shows java.lang.NullPointerException at org.apache.derby.impl.store.raw.log.LogToFile.flush(LogToFile.java:3964). Should give bettter message.    DERBY-3863 FIXED improve test importExportIJ.sql    DERBY-3601 FIXED Optimize LOBStateTracker for non-locator servers 10.4.3.0 ( Release Notes ) Progress:    10 of 10 issues have been resolved    DERBY-4239 FIXED Possible corruption if SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE is called during checkpoint    DERBY-4063 FIXED Constraint causes wrong query result when using exists    DERBY-4338 FIXED Network client raises error "executeQuery method can not be used for update" when sql is preceded by /* */ comments    DERBY-4330 FIXED NullPointerException or assert failure when re-executing PreparedStatement after lock timeout    DERBY-4182 FIXED SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE does not reclaim space lost from an aborted insert    DERBY-4071 FIXED AssertFailure when selecting rows from a table with CHARACTER and VARCHAR columns    DERBY-4450 FIXED GROUP BY in an IN-subquery inside HAVING clause whose select list is subset of group by columns, gives NPE    DERBY-3717 FIXED convert derbynet/getCurrentProperties.java to junit    DERBY-2209 FIXED derbynet/getCurrentProperties.java fails intermittently    DERBY-1945 DUPLICATE Need changes to manifest for OSGi environment 10.5.3.1 ( Release Notes ) Progress:    26 of 27 issues have been resolved    DERBY-858 UNRESOLVED ijConnName test output order is non-deterministic.    DERBY-4348 FIXED Copy table content with "INSERT INTO table SELECT FROM (...)" statement leads to corrupt data    DERBY-700 FIXED Derby does not prevent dual boot of database from different classloaders on Linux and Mac OS X    DERBY-4372 FIXED Wrong result for simple join when index is created    DERBY-4284 FIXED All Columns become Nullable when Using left join    DERBY-4451 FIXED ArrayIndexOutOfBoundsException or ASSERT FAILED when inserting generated columns out of order    DERBY-4435 FIXED Emptying index fails with NPE doing replacement import of empty file    DERBY-4432 FIXED Memory leak when attempting to boot non-existing database with the in-memory back end    DERBY-4304 FIXED Network Server shutdown should handle exceptions and finish the server shutdown completely    DERBY-4338 FIXED Network client raises error "executeQuery method can not be used for update" when sql is preceded by /* */ comments    DERBY-4330 FIXED NullPointerException or assert failure when re-executing PreparedStatement after lock timeout    DERBY-4365 FIXED NullPointerException when preparing LEFT OUTER JOIN between VALUES statements    DERBY-4420 FIXED NullPointerException with INSERT INTO ... from EXCEPT/INTERSECT    DERBY-4342 FIXED SQLSTATE 38000 (NullPointerException) at inner self join and value(x1, x2...)    DERBY-4361 FIXED testDefault fixture in engine.ErrorStreamTest has been failing with junit.framework.AssertionFailedError: File C:\jartest\JarResults.XXdateXX\ibm15_suites.All\system\derby.log could not be deleted    DERBY-4356 FIXED testStartStopManagementFromApplication(org.apache.derbyTesting.functionTests.tests.management.ManagementMBeanTest)junit.framework.AssertionFailedError: expected:<2> but was:<%>    DERBY-4450 FIXED GROUP BY in an IN-subquery inside HAVING clause whose select list is subset of group by columns, gives NPE    DERBY-4388 FIXED NullPointerException in RIGHT JOIN with NOT BETWEEN    DERBY-4391 FIXED NullPointerException when comparing indexed column with result from a set operation    DERBY-4411 FIXED Scalar subquery erroneously rejected for not returning exactly one row    DERBY-4376 FIXED Simple select runs forever    DERBY-4326 FIXED hang on winvista with IBM 1.6 SR5 in NSSecurityMechanismTest    DERBY-4151 FIXED java.net.ConnectException in J2EEDataSourceTest (with network server) on IBM iseries    DERBY-4281 FIXED 10.6 Upgrade test fails: SYSCS_UTIL.SYSCS_SET_XPLAIN_SCHEMA is not recognized as a function    DERBY-4286 FIXED Need to evaluate test results from 10.3 soft upgrade to 10.5 on suites.all    DERBY-4347 FIXED Provide a property to increase network server start timeout for JUnit tests    DERBY-3478 FIXED Simple column names specified as part of "AS" clause in a table expression are ignored if the table expression is a view. 10.5.4.0 ( Release Notes ) Progress:    10 of 11 issues have been resolved Head of 10.5 branch    DERBY-4328 UNRESOLVED The Developer's Guide falsely claims that you can use SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY to change the boot password on an encrypted database.    DERBY-4451 FIXED ArrayIndexOutOfBoundsException or ASSERT FAILED when inserting generated columns out of order    DERBY-4338 FIXED Network client raises error "executeQuery method can not be used for update" when sql is preceded by /* */ comments    DERBY-4330 FIXED NullPointerException or assert failure when re-executing PreparedStatement after lock timeout    DERBY-4081 FIXED BTreeController.comparePreviousRecord() may fail to release latch on left-most leaf    DERBY-4450 FIXED GROUP BY in an IN-subquery inside HAVING clause whose select list is subset of group by columns, gives NPE    DERBY-4092 FIXED You should not be able to invoke a table function as a scalar function    DERBY-3478 FIXED Simple column names specified as part of "AS" clause in a table expression are ignored if the table expression is a view.