Apache Derby Changelog

What's new in Apache Derby 10.15.1.3

Mar 4, 2019

Overview:
The most up to date information about Derby releases can be found on the Derby download page.
Apache Derby is a pure Java relational database engine using standard SQL and JDBC as its APIs. More information about Derby can be found on the Apache web site. Derby functionality includes:
Embedded engine with JDBC drivers
Network Server
Network client JDBC drivers
Command line tools: ij (SQL scripting), dblook (schema dump) and sysinfo (system info)
The 10.15 release family supports the following Java and JDBC versions:
Java SE 9 and higher with JDBC 4.2.
New Features
This is a feature release. The following new feature was added:
JPMS modularization - Derby has been re-packaged as a set of JPMS modules. This introduced a new jar file, derbyshared.jar, required by all configurations. Module diagrams for Derby configurations can be found in the javadoc for the 10.15 public API.
New users should consult the 10.15 documentation, especially the Getting Started With Derby guide.
Existing users who want to continue running Derby with a classpath should read the extended release note for issue DERBY-6945 (see below).
Existing users who want to run Derby with a module path should consult the module diagrams in the javadoc for the 10.15 public API. Templates for wiring together a module path can be found in the setEmbeddedCP, setNetworkServerCP, and setNetworkClientCP scripts located in the bin directory of the release distributions, as described by the "Manually setting the CLASSPATH/MODULEPATH environment variables" topic in the Getting Started With Derby guide.
Bug Fixes:
The following issues are addressed by Derby release 10.15.1.3. These issues are not addressed in the preceding 10.14.2.0 release.
Issue Id
Description
DERBY-7020 Fix release targets to account for modularization changes
DERBY-7018 Test the demo programs after the changes made by DERBY-6945
DERBY-7016 Adjust the set*CP scripts to include derbyshared.jar and to set a MODULEPATH variable as well
DERBY-6981 "SQLSTATE: XJ001, SQLERRMC: java.lang.NullPointerException XJ001.U"
DERBY-6980 Documentation changes to accompany jigsaw-modularization of derby
DERBY-6973 Provide SHA-512 checksums on future releases
DERBY-6945 Re-package Derby as a collection of jigsaw modules
DERBY-6856 Make it possible to build Derby using JDK 9
DERBY-5543 include debug info in derby builds uploaded to maven
Issues
Compared with the previous release (10.14.2.0), Derby release 10.15.1.3 introduces the following new features and incompatibilities. These merit your special attention.
Note for DERBY-6945
Summary of Change
Modularize Derby, cleanly partitioning its packages across a small set of JPMS components.
Symptoms Seen by Applications Affected by Change
A new jar file (derbyshared.jar) has been added. All Derby configurations require it. In addition, the derbytools.jar library is now required when running the network server and/or when using Derby DataSources.
Slightly different privileges must be granted to the Derby jar files when running under a Security Manager.
Derby jar files can now be wired into a module path for use by module-aware applications.
Incompatibilities with Previous Release
Legacy applications may fail if their classpaths don't contain the required jar files. Code common to all Derby configurations has been isolated in the new derbyshared.jar file. DataSources have moved from derbyclient.jar and derby.jar into derbytools.jar
Legacy applications which run under a Java SecurityManager may fail due to insufficient privilege grants.
Rationale for Change
Derby was divided into JPMS components for the following reasons:
Footprint - Modularization reduces Derby's footprint when running embedded on resource-constrained devices.
Security - Modularization lets Derby protect its code via package-level encapsulation.
Application Changes Required
Consult the module diagrams for configurations described on the landing page of the 10.15 public API. Then adjust your application's classpath as follows:
Remote client - When running remote client applications, make sure that the classpath includes derbyshared.jar. Remote applications which use Derby DataSources should also include derbytools.jar.
Embedded engine - When running the embedded engine, make sure that the classpath includes derbyshared.jar. Embedded applications which use Derby DataSources should also include derbytools.jar.
Network server - When running the network server, make sure that the classpath includes derbyshared.jar and derbytools.jar. This is not necessary if you boot the server via the java -jar derbyrun.jar pattern. derbyrun.jar sets up its own classpath correctly.
Tools - When running Derby tools like ij, dblook, and sysinfo, make sure that the classpath includes derbyshared.jar. Again, no change should be necessary if you boot the tools via the java -jar derbyrun.jar pattern.
Java security policy files must grant slightly different privileges to Derby jar files. This is because packages have moved to different ProtectionDomains (chiefly into derbyshared.jar) and because an additional privilege is needed in order to read the module path. For more information, see the Configuring Java Security topic in the Derby Security Guide and consult the following template policy files in the demo/templates directory of the bin distribution:
clientTemplate.policy - Privileges needed by remote client applications.
engineTemplate.policy - Privileges needed by applications which embed the Derby engine.
serverTemplate.policy - Privileges needed when running the network server.
toolsTemplate.policy - Privileges needed when running Derby tools.
Build Environment

New in Apache Derby 10.14.2.0 (May 4, 2018)

Overview
The most up to date information about Derby releases can be found on the Derby download page.
Apache Derby is a pure Java relational database engine using standard SQL and JDBC as its APIs. More information about Derby can be found on the Apache web site. Derby functionality includes:
Embedded engine with JDBC drivers
Network Server
Network client JDBC drivers
Command line tools: ij (SQL scripting), dblook (schema dump) and sysinfo (system info)
Support for Java SE 8 is being sunsetted and will not be supported by the next (10.15) release family. The 10.14 release family supports the following Java and JDBC versions:
Java SE 8 and higher with JDBC 4.2.
Java SE 8 compact profile 2.
New Features
This is a patch release. No new features have been added.
Bug Fixes
The following issues are addressed by Derby release 10.14.2.0. These issues are not addressed in the preceding 10.14.1.0 release.
Issue Id
Description
DERBY-6987 The default Network Server security policy file could be trimmed down somewhat.
DERBY-6986 Network Server COMMAND_TESTCONNECTION need not try to open a database
Issues
Compared with the previous release (10.14.1.0), Derby release 10.14.2.0 introduces the following new features and incompatibilities. These merit your special attention.
Note for DERBY-6987
Summary of Change
The default Network Server security policy has been simplified.
Symptoms Seen by Applications Affected by Change
If you start the Network Server without specifying a security manager, the Network Server will install a default Java security manager that enforces a basic policy. This security policy is now simpler than it was in previous releases.
Incompatibilities with Previous Release
If your Network Server deployment has particular security requirements, the default security policy is not right for you. You should instead deploy the Network Server with a customized security policy file, as described in the Security guide.
Rationale for Change
A simpler default security policy file is preferable, as it is easier to understand.
Application Changes Required
Please review the "Configuring Java security" topic in the Security guide for a detailed description of how to configure the Network Server security policy.
Note for DERBY-6986
Summary of Change
COMMAND_TESTCONNECTION no longer has database open support.
Symptoms Seen by Applications Affected by Change
The Network Server's COMMAND_TESTCONNECTION operation, which is used by the Network Server 'ping' feature, contained code which could attempt to open a database specified as part of the 'ping' request. This code has been removed.
Rationale for Change
It is not necessary to attempt to open a database in order to ping the Network Server.
Build Environment
Derby release 10.14.2.0 was built using the following environment:
Branch - Source code came from the 10.14 branch.
Machine - Fedora 27
Ant - Apache Ant(TM) version 1.9.5 compiled on May 31 2015
Compiler - All classes were compiled by the javac from the 1.8.0_151 JDK, OpenJDK 64-Bit Server VM (build 25.151-b12, mixed mode)
Verifying Releases
It is essential that you verify the integrity of the downloaded files using the PGP and MD5 signatures. MD5 verification ensures the file was not corrupted during the download process. PGP verification ensures that the file came from a certain person.
The PGP signatures can be verified using PGP or GPG. First download the Apache Derby KEYS as well as the asc signature file for the particular distribution. It is important that you get these files from the ultimate trusted source - the main ASF distribution site, rather than from a mirror. Then verify the signatures using ...
% pgpk -a KEYS
% pgpv db-derby-X.Y.tar.gz.asc
% pgp -ka KEYS
% pgp db-derby-X.Y.tar.gz.asc
% gpg --import KEYS
% gpg --verify db-derby-X.Y.tar.gz.asc
To verify the MD5 signature on the files, you need to use a program called md5 or md5sum, which is included in many unix distributions. It is also available as part of GNU Textutils. Windows users can get binary md5 programs from here, here, or here.
We strongly recommend that you verify your downloads with both PGP and MD5.

New in Apache Derby 10.14.1.0 (Oct 15, 2017)

New in Apache Derby 10.13.1.1 (Oct 26, 2016)

New Features:
DERBY-6136: tool for siphoning data out of corrupted databases
DERBY-6725: system function which prints out the name of the current database
DERBY-4555: system procedures to import CSV file with headers
DERBY-6852: allow identity columns to cycle.
Bug Fixes:
DERBY-6914 Incorrect example for new SYSCS_UTIL.SYSCS_IMPORT_TABLE_BULK procedure
DERBY-6913 Document the new ability of identity columns to cycle
DERBY-6900 docs build for ref.html gives errors about rrefjavstateautogen.dita -- possible typo?
DERBY-6895 Add documentation for new SYSCS_IMPORT_TABLE_BULK, SYSCS_IMPORT_DATA_BULK procedures
DERBY-6894 Enhance COLUMNINDEXES parsing for SYSCS_IMPORT_DATA_BULK to recognize columns by name
DERBY-6893 Create new SYSCS_IMPORT_DATA_BULK procedure
DERBY-6892 Create new SYSCS_IMPORT_TABLE_BULK procedure
DERBY-6890 ALTER TABLE DROP COLUMN corrupts secondary index collation information
DERBY-6886 Fix links to CI test results
DERBY-6885 Remove ReuseFactory
DERBY-6884 SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE can't import more than Integer.MAX_VALUE bytes of blob data
DERBY-6883 Document the new SET GENERATED clause of ALTER TABLE introduced by DERBY-6882
DERBY-6882 Add functionality to ALTER TABLE: switch from GENERATED ALWAYS to GENERATED BY DEFAULT
DERBY-6881 Test failures with JDK 9-ea b111
DERBY-6880 Update failing with java.sql.SQLDataException
DERBY-6879 Engine deadlock between XA timeout handling and cleanupOnError
DERBY-6875 Partially broken download pages
DERBY-6870 Google Summer of Code 2016: Derby bug fixing
DERBY-6869 XMLXXETest fails in non-English locales
DERBY-6868 Remove the dependency on Jakarta ORO
DERBY-6866 Add URLs to Maven pom files
DERBY-6864 RawDBReaderTest fails on Windows
DERBY-6860 Automatic download of junit.jar broken
DERBY-6852 Allow identity columns to cycle (as defined in SQL:2003)
DERBY-6847 Document SYSCS_UTIL.SYSCS_GET_DATABASE_NAME()
DERBY-6845 Document the rawDBReader optional tool
DERBY-6828 Network Server don't start in czech localized enviroment due missing key DRDA_MissingNetworkJar.S
DERBY-6752 AutoloadedDriver tries to load a non-existent class, AutoloadedDriver40
DERBY-6726 NPE from trigger
DERBY-6725 Add a system function which returns the name of the database.
DERBY-6391 remove unneeded object creation in newException() calls in releases > 10.10
DERBY-6334 Test harness security policy prevents running DatabaseClassLoadingTest twice
DERBY-6136 Create a custom/optional tool for dumping the data in a corrupted database.
DERBY-5950 PlanExporter and SignatureChecker don't appear in the list of tools supported by derbyrun.
DERBY-5944 The hard-coded PlanExporter help message should be internationalized so that it can be translated
DERBY-5605 Calling Blob/Clob free() explicitly after implicit free throws exception in client driver
DERBY-5585 Improve error messages used when Derby can't find the class or method backing up a SQL routine or type
DERBY-4555 Expand SYSCS_IMPORT_TABLE to accept CSV file with header lines
DERBY-4091 Investigate "size_problem" column in MailJdbc terst
DERBY-3181 isNullable on ResultSetMetaData from DatabaseMetaData.getBestRowIdentifier values are opposite when there is no rows in ResultSet vs. when there is a row.
DERBY-1773 insertRow() and updateRow() fail with syntax error when column has an alias
DERBY-853 ResultSetMetaData.getScale returns inconsistent values for DOUBLE type.

New in Apache Derby 10.12.1.1 (Oct 17, 2015)

New Features:
ALTER TABLE and identity columns - The ALTER TABLE command can be used to add identity columns now.
Cache-monitoring MBean - An MBean has been added for monitoring internal Derby caches. See the description of CacheManagerMBean in the "Introduction to the Derby MBeans" section of the Derby Server and Administration Guide
Optional Tool for Handling JSON Data - An optional tool has been added for packing query results into JSON documents and for unpacking JSON documents into tabular result sets.
Statistics aggregates - SQL Standard VAR_POP(), VAR_SAMP(), STDDEV_POP(), and STDDEV_SAMP() aggregates have been added.
Bug Fixes:
DERBY-6829 Document the simpleJson optional tool and the SimpleJsonVTI.
DERBY-6825 Add basic JSON support to Derby.
DERBY-6824 Move ShutdownException into shared code area
DERBY-6820 Improve error handling in XmlVTI
DERBY-6807 XXE attack possible by using XmlVTI and the XML datatype
DERBY-6801 Implement MessageUtils class so client and server can share message argument encoding/decoding
DERBY-6800 Implement DerbySQLIntegrityConstraintViolationException class
DERBY-6783 WHEN clause in CREATE TRIGGER for UPDATE is not working for the sql script below
DERBY-6774 background post commit threads cause ASSERTS/errors on interaction with alter table add column
DERBY-6769 sane.derbyTesting.jar.lastcontents can be "out of date" but no build error results
DERBY-6768 List the enabled protocols in derby.log for network server configuration
DERBY-6753 Docs for IDENTITY_VAL_LOCAL needs to be updated to indicate that the return value will be impacted by single row UPDATE of identity column
DERBY-6751 Prevent user code from getting the LanguageConnectionContext from an EmbedConnection
DERBY-6748 Localize messages introduced or changed in 10.11.1
DERBY-6744 Update the documentation of security policy files to include the new usederbyinternals SystemPermission
DERBY-6742 For update statement, collect generated keys if Statement.RETURN_GENERATED_KEYS flag is supplied to the JDBC call.
DERBY-6741 User code can get the ContextManager from an EmbedConnection
DERBY-6737 CLOB retrieve exceptions after moving cursor around
DERBY-6733 Implement an MBean for monitoring caches
DERBY-6730 Cannot create a Lucene index if a key column's name is case-sensitive
DERBY-6724 NPE if insert statement needs recompilation after having fired a trigger
DERBY-6722 GenericStatementContext.cleanupOnError() needs protection from later errors during statement cleanup
DERBY-6720 Add derbyoptionaltools.jar to the maven artifacts we publish
DERBY-6719 Add derbyoptionaltools.jar to the class paths of the scripts in the bin directory
DERBY-6717 Policies with multiple SystemPermissions are not handled well
DERBY-6714 RuntimeInfoTest failed with insufficient data from server
DERBY-6705 Triggers should not allow MERGE statements that reference temporary tables
DERBY-6703 MERGE statement fails with NullPointerException if ON clause references non-existent column
DERBY-6662 DatabaseMetaData.usesLocalFiles() returns true for in-memory databases
DERBY-6654 Require that generated code live in the org.apache.derby.exe package.
DERBY-6648 Application code should not be able to call ContextService.getContextOrNull()
DERBY-6636 The public api of BaseDataFileFactory may allow blackhats to assume elevated privileges.
DERBY-6635 OptimizerTracer.unloadTool() could be used to write garbage over Derby data files.
DERBY-6632 Applications may be able to use StorageFactoryService to delete Derby databases and overwrite service.properties.
DERBY-6631 FileMonitor can be used to elevate an application's privileges
DERBY-6630 Applications can use JCECipherFactory to elevate their privileges to those granted to Derby
DERBY-6619 After silently swallowing SecurityExceptions, Derby can leak class loaders
DERBY-6617 Silently swallowed SecurityExceptions may disable Derby features, including security features.
DERBY-6592 Update the version of ant which we tell new developers to use.
DERBY-6569 NULLIF may return incorrect results if first operand calls non-deterministic function
DERBY-6475 Update documentation for SYSTRIGGERS after DERBY-5866 changes
DERBY-6414 Incorrect handling when using an UPDATE to SET an identity column to DEFAULT
DERBY-5466 Add support for SQL Standard statistics functions, such as STDDEV_POP, STDDEV_SAMP, VAR_POP, VAR_SAMP
DERBY-5165 Prepared XA transaction locks are not kept across DB restart
DERBY-4057 Space is not reclaimed if transaction is rolled back
DERBY-3888 ALTER TABLE ... ADD COLUMN cannot add identity columns
DERBY-3195 Describe if default security manager & policy is installed or not on each of the mechanisms to start the network server.
DERBY-3005 Document possibility to specify method signature in EXTERNAL NAME when creating a procedure/function
DERBY-2238 Example of ScalarSubquery in Derby Reference Manual is not ScalarSubquery
DERBY-2051 CachedItem's comments and code are inconsistent wrt. syncronization
DERBY-691 committed deleted row space reclamation may be missed if delete is actually an aborted insert.
DERBY-600 Document that DB is booted in read-only mode if not able to create db.lck file

New in Apache Derby 10.11.1.1 (Oct 7, 2014)

New Features:
MERGE statement - MERGE is a single, join-driven statement which INSERTs, UPDATEs, and DELETEs rows. See the section on this statement in the Derby Reference Manual. See also features F312, F313, and F314 of the SQL Standard.
Deferrable constraints - Constraint enforcement can now be deferred, typically to the end of a transaction. See the section on "constraintCharacteristics" in the Derby Reference Manual. See also features F721 and F492 of the SQL Standard.
WHEN clause in CREATE TRIGGER - An optional WHEN clause has been added which determines which rows fire a trigger. See the section on this clause in the Derby Reference Manual. See also feature T211-05 of the SQL Standard.
Rolling log file - The Derby diagnostic log can now be split across a sequence of files. See the section on the derby.stream.error.style property in the Derby Reference Manual.
Experimental Lucene support - Derby text columns can now be indexed and queried via Apache Lucene. See the section on the optional luceneSupport tool in the Derby Tools and Utilities Guide.
Simple case expression - The "simple" and "extended" syntax for CASE expressions has been added. See the section on the CASE expression in the Derby Reference Manual. See also features F261-01, F262, and F263 of the SQL Standard.
Better concurrency for identity columns - The concurrency of identity columns has been boosted. See the detailed release note for DERBY-6542 below.
New ij HoldForConnection command - A new ij command has been added to change the default cursor holdability to "keep cursors open after commit." See the section on the HoldForConnection command in the Derby Tools and Utilities Guide.
Standard syntax for altering column nullability - Standard syntax has been added for altering the nullability of columns. See the section on ALTER TABLE in the Derby Reference Manual. See also feature F383 of the SQL Standard.
Bug Fixes:
DERBY-6693: Assert failure/ArrayIndexOutOfBoundsException when using COUNT in MERGE matching clause
DERBY-6692: Self-deadlock when inserting row with identity column in soft-upgraded database
DERBY-6691: ROW_NUMBER should not be allowed as argument in a procedure call
DERBY-6690: ROW_NUMBER should not be allowed in generation clause
DERBY-6689: Assert failure/NPE when using ROW_NUMBER in MERGE ... INSERT
DERBY-6688: NPE (or sane: ASSERT failure) with ROW_NUMBER in some subqueries
DERBY-6677: Correct Reference Manual RENAME TABLE topic to remove foreign key prohibition
DERBY-6674: Cleanup brittle code in ValidateCheckConstraintResultSet
DERBY-6672: Allow Derby to rename tables referenced by foreign keys
DERBY-6670: Rollback to savepoint allows violation of deferrable constraints
DERBY-6668: Truncating a table may silently violate a deferred foreign key.
DERBY-6667: Redundant word "referencing" in error message for deferred constraints.
DERBY-6666: Deferred constraint validation fails with "dead statement" when query plan logging is enabled
DERBY-6665: Violation of deferred constraints not detected when conglomerates are erroneously shared
DERBY-6664: Schema 'null' does not exist when trigger inserts into table with deferred foreign key
DERBY-6663: NPE when a trigger tries to insert into a table with a foreign key
DERBY-6661: dblook does not recognize the deferrability of deferrable constraints
DERBY-6659: The Reference Guide should state how long a SET CONSTRAINTS command is good for
DERBY-6658: Update list of tested Lucene versions
DERBY-6657: Need to document the fact that views can't be the source data sets of MERGE statements
DERBY-6653: Data type limitations on indexes should be in Reference Manual
DERBY-6649: Meaningless permissions granted to sysinfo.
DERBY-6647: The ij.driver property is obsolete and need not be documented
DERBY-6644: Support standard syntax for altering column nullability
DERBY-6643: ALTER TABLE columnAlteration syntax needs fixing
DERBY-6638: Remove unnecessary use of reflection in SignatureChecker
DERBY-6633: Remove DOM level 3 XPath requirement from description of XML operators
DERBY-6629: Restrict privileged operation in CreateXMLFile
DERBY-6626: Check type of user-supplied modules before creating instances
DERBY-6624: Use javax.xml.xpath interfaces for XPath support
DERBY-6615: Remove unused newInstance() method in BaseMonitor
DERBY-6611: Broken link in API docs to derby.drda.keepAlive documentation
DERBY-6609: Documentation for SQL features should reflect current standard
DERBY-6605: "Derby support for SQL-92 features" topic in Reference Manual needs updating
DERBY-6602: LuceneQueryVTI handles NULL key values inconsistently
DERBY-6601: Clean up Java EE compliance section of Reference Manual
DERBY-6599: Incorrect quoting of 42ZB4 message
DERBY-6598: Document permissions recommendations for JAR procedures
DERBY-6597: LUCENESUPPORT.LISTINDEXES() fails with FileNotFoundException
DERBY-6596: LUCENESUPPORT routines should check for NULL arguments
DERBY-6595: CheckToursDBTest failed while updating sequence value on disk
DERBY-6594: Typos in "Listing indexes" topic of the tools guide
DERBY-6591: Minor tweaks needed on new ij commands
DERBY-6587: Foreign Key constraint not matched when using UUID in a composite foreign key when using SYSCS_UTIL.SYSCS_IMPORT_TABLE
DERBY-6585: add HoldForConnection ij command to match NoHoldForConnection
DERBY-6581: Document simple case syntax
DERBY-6580: Document the new SYSCS_UTIL.SYSCS_PEEK_AT_IDENTITY function
DERBY-6577: Quantified comparison returns wrong result in CASE, COALESCE, IN and BETWEEN
DERBY-6576: A immediate Fk constraint blows up iff its referenced PK is deferred and we modify a duplicate key column
DERBY-6571: Document deferrable constraints
DERBY-6567: Incorrect nullability for CASE expression with parameter
DERBY-6566: Simplify handling of untyped nulls in CASE and NULLIF expressions
DERBY-6565: ROW_NUMBER function throws NullPointerException in UPDATE statement
DERBY-6564: Document the experimental, optional LuceneSupport tool.
DERBY-6563: NOT elimination for CASE expressions is broken
DERBY-6561: Organization topics of some manuals need updating
DERBY-6560: Reference manual says ELSE clause is required in CASE expressions
DERBY-6559: A immediate Fk constraint blows up iff its referenced PK is deferred and we delete a duplicate
DERBY-6554: Too much contention followed by assert failure when accessing sequence in transaction that created it
DERBY-6553: Sequence generator makes CREATE TRIGGER fail with internal error
DERBY-6552: The public api includes methods inherited from superclasses which aren't in the public api and so have no javadoc comments
DERBY-6545: Should not be able to add a default to an identity column
DERBY-6543: Syntax error when reference to transition variable has whitespace around it
DERBY-6542: Improve the concurrency of identity columns by using SYS.SYSSEQUENCES
DERBY-6540: Schema-qualified table names could be mistaken for transition tables
DERBY-6537: StringUtil.fromHexString is used to convert encryptionKey to byte()
DERBY-6535: Remove storageFactory field from subclasses of InputStreamFile
DERBY-6534: Remove StorageFile.getURL() and its implementations
DERBY-6527: Fix errors in foreign keys documentation
DERBY-6526: Document the MERGE statement
DERBY-6505: Clean up dead code in FileUtil
DERBY-6504: change AllocPage.ReadContainerInfo to catch ArrayIndexOutOfBoundsException and turn it into Derby error.
DERBY-6503: Starting network server on a network drive fails with JDK 7 on Windows
DERBY-6496: Optional tool registration may fail because the CompilerContext is not always available at execution time.
DERBY-6493: Improve reporting of exceptions wrapped in InvocationTargetException
DERBY-6488: Get rid of the EmbedSQLException class
DERBY-6484: Include SQLState in client exception messages
DERBY-6480: Oracle Java documentation URLs need updating
DERBY-6478: Fix language about supported DataSources for Compact Profiles
DERBY-6469: Change the documentation to reflect new RDBNAM limit of 1024 bytes
DERBY-6467: Document context-aware table functions.
DERBY-6464: Improve the encapsulation of various compiler classes
DERBY-6462: Provide more information about database name and path syntax
DERBY-6459: Remove Class.forName calls that load JDBC driver from Derby samples/demos
DERBY-6458: The Reference Manual should state that the year, month, and day components of a timestamp must be positive integers.
DERBY-6454: DROP TABLE documentation could clarify how triggers are handled
DERBY-6453: Remove dead code in InsertResultSet and flag skipCheckConstraints
DERBY-6447: Use StrictMath for more functions in SYSFUN
DERBY-6440: Connections opened by ForeignTableVTI never get released
DERBY-6434: Incorrect privileges may be required for INSERT and DELETE statements.
DERBY-6432: INSERT/UPDATE incorrectly require user to have privilege to execute CHECK constraints on the target table.
DERBY-6431: Update Developer's Guide topic to include generated columns
DERBY-6429: Privilege checks for UPDATE statements are wrong.
DERBY-6424: Document thenExpression
DERBY-6423: The expression syntax in CASE's THEN clause doesn't accept boolean value expression
DERBY-6421: Cast to UDT in CHECK constraint causes NPE or assert failure
DERBY-6420: Clarify how DROP statements work on trigger dependencies
DERBY-6419: Make BTree scan honor OPENMODE_LOCK_NOWAIT for row locks.
DERBY-6410: ClassCastException when launching derby from windows subst drive
DERBY-6390: Document the WHEN clause in the CREATE TRIGGER statement
DERBY-6386: Errors in jdbc4.LobStreamTest if derbyclient.jar is first in the classpath
DERBY-6379: Manuals are inconsistent in their use of the element
DERBY-6378: OFFSET/FETCH NEXT ignored when query is enclosed in parentheses
DERBY-6370: dblook doesn't schema-qualify identifiers in trigger actions
DERBY-6362: CHECK constraint uses wrong schema for unqualified routine invocations
DERBY-6359: Document rolling derby.log file feature
DERBY-6350: Provide a rolling file implementation of derby.log
DERBY-6330: Simplify StringBuffer use, as they are mutable
DERBY-6322: Remove erreoneous warning in NetBeans: superfluous use of super to access inherited member variable
DERBY-6321: NetBeans project file: add XML api to source classpath
DERBY-6318: Simplify setting of possibly null parameters in XPLAIN descriptors
DERBY-6315: Improve test coverage of org.apache.derby.impl.io.InputStreamFile
DERBY-6304: Remove unused methods in Predicate
DERBY-6296: Simplify PropertyUtil using Properties.stringPropertyNames()
DERBY-6292: Use Arrays.copyOf() in FormatableArrayHolder.getArray()
DERBY-6291: Improve code coverage of org.apache.derby.iapi.jdbc.BrokeredCallableStatement
DERBY-6287: Don't use reflection to call Java 6 methods in FileUtil
DERBY-6285: Use factory method to create thread pool for timed login
DERBY-6284: Improve test coverage of org.apache.derby.iapi.db.ConnectionInfo
DERBY-6276: Convert lang/DB2IsolationLevels.sql to JUnit
DERBY-6266: Add ability to print a Derby execution ResultSet as xml.
DERBY-6262: Simplify message-generating methods using varargs
DERBY-6259: Collapse the level 2 optimizer into its parent module.
DERBY-6254: Reduce number of factory methods in StandardException
DERBY-6253: Collapse SQLException factories
DERBY-6248: nightly regression test failure: testDerby966(org.apache.derbyTesting.functionTests.tests.jdbcapi.XATest)java.sql.SQLFeatureNotSupportedException: The DDM object 0x2408 is not supported. The connection has been terminated.
DERBY-6243: Fold Java5ClassFactory into ReflectClassesJava2
DERBY-6242: Merge ConcurrentXactFactory into XactFactory
DERBY-6241: Remove SinglePool from trunk
DERBY-6240: Remove Clock cache manager from trunk
DERBY-6236: Remove references to old JVMs (pre-Java 6) from the user guides
DERBY-6234: Remove references to BUILTIN authentication from the user guides
DERBY-6231: Remove unnecessary checks for UnsupportedEncodingException in the client
DERBY-6230: Use the JVM's cache of Number instances in ReuseFactory
DERBY-6227: Distinct aggregates don't work well with territory-based collation
DERBY-6217: Put all of the security documentation in a single, separate user guide
DERBY-6213: Deprecate support for Java 5 and CDC
DERBY-6207: Update policy files in java/drda/org/apache/derby/drda
DERBY-6206: Cleanup suspect coding practices in misc Derby packages
DERBY-6202: Cleanup suspect coding practices in the org.apache.derby.iapi.sql.dictionary package
DERBY-6201: Cleanup suspect coding practices in the org.apache.derby.impl.sql.execute.rts package
DERBY-6200: Cleanup suspect coding practices in the org.apache.derby.iapi.types package
DERBY-6199: Cleanup suspect coding practices in the org.apache.derby.vti package
DERBY-6198: Cleanup suspect coding practices in the org.apache.derby.tools package
DERBY-6197: Cleanup suspect coding practices in the org.apache.derby.impl.tools.planexporter package
DERBY-6195: Cleanup suspect coding practices in the org.apache.derby.impl.tools.ij package.
DERBY-6192: Cleanup suspect coding practices in org.apache.derby.iapi.services.property package
DERBY-6188: Cleanup suspect coding practices in org.apache.derby.iapi.services.io package
DERBY-6186: SYSTRIGGERSRowFactory should use DataDescriptorGenerator to build descriptor
DERBY-6184: Clean up warnings in XA transaction id classes
DERBY-6182: Cleanup suspect coding practices in org.apache.derby.iapi.error package
DERBY-6177: Cleanup suspect coding practices in org.apache.derby.catalog.types
DERBY-6169: Reduce visibility of classes and methods under impl/sql
DERBY-6168: Clean up registered format ids
DERBY-6163: Reduce visibility of methods in subclasses of PageBasicOperation
DERBY-6161: Simplify code that handles LOB files
DERBY-6138: org.apache.derbyTesting.functionTests.tests.store.ClassLoaderBootTest fails with sealing violation: package org.apache.derby.iapi.services.sanity is sealed depending on classpath order
DERBY-6133: simple array index typo
DERBY-6128: Examine Derby classes to determine if we need to add serialVersionUID to any of them
DERBY-6125: Code clean up in client driver.
DERBY-6096: OutOfMemoryError with Clob or Blob hash join: DataTypeDescriptor.estimatedMemoryUsage() has no case for BLOB or CLOB so would underestimate memory usage for those types at zero
DERBY-6075: Use modern collections in impl/sql/compile
DERBY-5840: Clean up compiler warnings introduced by using Java 5 language features
DERBY-5615: NPE in Store when running SELECT in a read-only database accessed via the classpath subprotocol when authentication, authorization, and Java security are turned on
DERBY-5317: NullPointerException in org.apache.derby.client.net.Request.sendBytes() with client
DERBY-5313: Assert failure with CASE expression in GROUP BY clause
DERBY-5196: Correct the layout of log.ctrl as described on the Derby web site
DERBY-5111: NullPointerException on unique constraint violation with unique index
DERBY-4805: Increase the length of the RDBNAM field in the DRDA implementation
DERBY-4750: add documentation to declare global temporary tables to explain expected behavior when used with XA transactions.
DERBY-4478: Use AtomicLong for XactFactory.tranId
DERBY-4403: Assert failure (sane) or NullPointerException (insane) when attempting to GROUP BY expression containing scalar subquery
DERBY-4381: Connection to Derby database using jar subprotocol doesn't work if the path has round bracket in it
DERBY-3573: Argument checking for ResultSet.setFetchSize(int) is incorrect
DERBY-3476: Permissions and Principal objects added by this feature need to be final and have serialization identifiers
DERBY-3155: Support for SQL:2003 MERGE statement
DERBY-2438: Remove JDBC20Translation and JDBC30Translation classes
DERBY-2423: Embedded and client differ on ResultSetMetaData.isCurrency() value for DECIMAL and NUMERIC columns
DERBY-2041: Trigger should register a dependency on tables and columns used in its body
DERBY-2002: Case expression allows NULL in all parts of
DERBY-1997: Misleading text in WwdEmbedded demo source file for Working With Derby
DERBY-1984: Re-factor JDBC classes to remove support for JDBC 2
DERBY-1576: Extend the CASE expression syntax for "simple case"
DERBY-1028: Change constructors in NetConnection classes to use LogWriter instead of NetLogWriter
DERBY-673: Get rid of the NodeFactory
DERBY-534: Support use of the WHEN clause in CREATE TRIGGER statements
DERBY-532: Support deferrable constraints

New in Apache Derby 10.10.2.0 (Oct 7, 2014)

Bug Fixes:
DERBY-6513: Warnings when building 10.10 branch with Java 8
DERBY-6477: OutOfMemoryError selecting from SYS.SYSALIASES
DERBY-6463: localcal demo seems to be obsolete and should be removed
DERBY-6457: NetworkServerControl API breaks when username or password contains non-ascii characters
DERBY-6456: Infinite loop in NetworkServerControlImpl when reply >= 32k
DERBY-6455: Infinite loop in NetworkServerControlImpl.ensureDataInBuffer
DERBY-6443: ArrayIndexOutOfBoundsException when calling function from trigger
DERBY-6438: Explicitly grant SocketPermission "listen" in default server policy
DERBY-6426: Fix isLoginException
DERBY-6411: Minimal select privilege should be checked in subqueries
DERBY-6408: EXISTS returns NULL instead of FALSE
DERBY-6396: NullPointerException in DirFile
DERBY-6387: Incorrect ordering of triggers in dblook
DERBY-6383: Update trigger defined on one column fires on update of other columns
DERBY-6374: Bulk insert of data with nullable UNIQUE constraint fails to detect duplicates
DERBY-6373: NPE in Statement.getWarnings()
DERBY-6371: DROP COLUMN looks in wrong schema when checking trigger dependencies
DERBY-6363: Incorrect evaluation of logical expressions in CASE
DERBY-6361: Valid statements rejected if Derby has not implicitly created the current user's schema.
DERBY-6357: CREATE TRIGGER doesn't detect all illegal references to SESSION schema
DERBY-6351: Syntax error on equal transition table name and correlation name in statement trigger
DERBY-6348: NPE or assert failure in recursive trigger
DERBY-6346: NPE in left join whose inner table has a generated column
DERBY-6338: Remove Profile attribute from jar file manifests
DERBY-6324: DatabaseMetaData.getJDBCMinorVersion() should return 2 now that we've implemented JDBC 4.2
DERBY-6323: Fix incorrect @throws and @exception tags in javadoc
DERBY-6320: Log a page dump to derby.log if ERROR nospc: nospc.U is returned to the user
DERBY-6317: Optmizer can choose the wrong path when BTreeCostController.java returns an estimate cost and row count of 0.0
DERBY-6314: Upgrade from 10.10 fails with ClassCastException
DERBY-6297: Intermittent failures in XplainStatisticsTest.testSimpleXplainOnly
DERBY-6283: indexStat daemon processing tables over and over even when there are no changes in the tables in soft upgraded database.
DERBY-6273: NullPointerException when using more than one parameter in COALESCE
DERBY-6270: Run Java API Documentation Updater Tool on the published javadocs
DERBY-6268: Run-time statistics not collected if query contains always false predicate
DERBY-6258: Restrict permissions on BACKUP.HISTORY
DERBY-6224: Issues with latest JDK 8 EA build because of missing SQLPermission
DERBY-6221: Can't select from SYS.SYSUSERS if you use a WHERE clause in the query
DERBY-6216: XPLAIN feature does not work and gives ERROR XCL16: ResultSet not open
DERBY-6212: NullPointerException when calling a procedure with sub-query as argument
DERBY-6209: Add release note omitted with 10.9 for new required Security Manager permissions after DERBY-5363
DERBY-6189: NPE involving temporary table and rollback
DERBY-6187: Add a release note for metadata datatype changes introduced by JDBC 4.2
DERBY-6185: Query against view with "where name LIKE 'Col1' ESCAPE '\' " failed
DERBY-6167: Interrupt restarts clock for login timeout
DERBY-6157: text for message XSLA4 might encouraging people to delete part of the transaction log
DERBY-6151: Derby does not report warnings raised by table functions
DERBY-6148: Wrong sort elimination when using permuted join order
DERBY-6137: update/delete statement on table with trigger fails randomly with ERROR XSTA2
DERBY-6131: select from view with "upper" and "in" list throws a ClassCastException
DERBY-6114: OOME in XAMemTest.testDerby4137_TransactionTimeoutSpecifiedNotExceeded
DERBY-6092: testPositionAgressive(org.apache.derbyTesting.functionTests.tests.jdbcapi.BlobClob4BlobTest)j fails with : 'The handle is invalid.: java.io.IOException'.
DERBY-6047: NPE in StaticCallMethod#coerceMethodParameter with a constant argument to INOUT parameter
DERBY-6045: in list multi-probe by primary key not chosen on tables with >256 rows
DERBY-5979: ant release target creates a release.properties that has conflicting line endings so automatic checkin fails
DERBY-5886: FILE_CANNOT_REMOVE_FILE exception prints garbage.
DERBY-5866: testFiringConstraintOrder(org.apache.derbyTesting.functionTests.tests.lang.TriggerTest)junit.framework.AssertionFailedError: matching triggers need to be fired in order creation:1,NO CASCADE BEFORE,DELETE,ROW
DERBY-5865: On IBM 1.7 TestDurabilityProperty fails with FAIL -- derby.system.durability=test mode seems to be broken.
DERBY-5823: Multi-row insert fails on table without generated keys with RETURN_GENERATED_KEYS
DERBY-5610: ServerPropertiesTest prints .java.net.SocketException: Connection reset to console but test passes
DERBY-5560: Java deadlock between LogicalConnection40 and ClientXAConnection40 (patch attached)
DERBY-5553: System property for client tracing -Dderby.client.traceDirectory does not work with XADataSource
DERBY-5416: SYSCS_COMPRESS_TABLE causes an OutOfMemoryError when the heap is full at call time and then gets mostly garbage collected later on
DERBY-4923: update of a long row can fail with ERROR nospc: nospc.U exception.
DERBY-4753: "ERROR 42X01: Syntax error: FALSE." during call to java.sql.DatabaseMetaData.getIndexInfo
DERBY-4729: add more information to the XACT_PROTOCOL_VIOLATION returned from store.
DERBY-4160: getMetaData().getIndexInfo crashes with "ERROR X0Y68: Column 'PARAM1' already exists."
DERBY-3940: Dropping a column does not drop triggers which mention that column
DERBY-2130: Optimizer performance slowdown from 10.1 to 10.2
DERBY-896: Cast date to timestamp results in "ERROR 42846: Cannot convert types 'DATE' to 'TIMESTAMP'."

New in Apache Derby 10.10.1.1 (Apr 17, 2013)

New Features:
SYSCS_UTIL.SYSCS_INVALIDATE_STORED_STATEMENTS - Derby has a new system procedure for invalidating stored prepared statements when you think that your metadata queries or triggers are misbehaving--for example if they throw a NoSuchMethodError on execution. See the section on this new system procedure in the Derby Reference Manual.
Unencrypting databases - Encryption can be turned off on existing databases. See the section on the decryptDatabase attribute in the Derby Reference Manual.
Small device profile - Derby runs on the small CP2 profile of Java 8.
JDBC 4.2 - Derby supports the Java 8 enhancements to JDBC.
User-defined aggregates - Applications can create their own aggregate operators. See the "CREATE DERBY AGGREGATE" section in the Derby Reference Manual.
Varargs routines - SQL routines can be bound to user-written Java methods which have variable length argument lists.
Optional tools - Derby has new, optional tools to support data migration and metadata queries. See the "Optional tools" section in the Derby Tools and Utilities Guide.
Bug Fixes:
DERBY-6106: Remove the outdated Japanese and Portuguese docs
DERBY-6100: Upgrade tests fail on compact2
DERBY-6098: Skip compatibility testing of old servers on compact profile 2
DERBY-6097: Management test suite fails when JMX is not supported
DERBY-6094: Derby ignores DriverManager.setLoginTimeout()
DERBY-6089: CallableStatement#registerOutParameter on client lacks check of legal types.
DERBY-6088: PreparedStatementTest42 lacks "fail" call when operation unexpectedly succeeds
DERBY-6087: Can't build Javadoc with JDK 1.8 if explicit j15lib, j16lib and j17lib paths are set
DERBY-6086: Factor out logic for creating custom connection in jdbcapi.StatementPoolingTest
DERBY-6085: Improve error reporting when server port is unavailable
DERBY-6083: Update minimum/maximum floating-point values to align with DERBY-3398 fixes
DERBY-6081: JDBC 4.2 setObject() and updateObject() methods throw NPE when type is null
DERBY-6079: 100's of errors in nightly test run on weme after jacoco property/priviledges checkin
DERBY-6078: Propagate a set of properties to the junit tasks in build.xml
DERBY-6077: web site needs updating on a few points
DERBY-6076: Folder.gif icon missing from derby documentation website
DERBY-6073: Test ordering instability in StatementPoolingTest
DERBY-6072: Move lang/reopenScan.sql to LangScripts
DERBY-6071: trunk javadoc build fails with Javadoc failed: java.io.IOException: Cannot run program \bin\javadoc.exe": CreateProcess error=206, The filename or extension is too long.
DERBY-6070: Document Derby's JDBC 4.2 implementation
DERBY-6065: LockTable API link in the documentation is broken
DERBY-6064: Failures in upgradeTests.Changes10_9 related to index cardinality statistics
DERBY-6063: Access static variables by class name in TabInfoImpl, InsertResultSet and ControlRow
DERBY-6061: Upgrade language is inconsistent
DERBY-6060: Fix Javadoc for UpgradeTrajectoryTest dangling reference
DERBY-6059: Document Derby usage running on Java 8 JEP 161 Compact Profiles
DERBY-6058: 2 ClassNotFoundException failures on trunk with ibm's weme6.2 since build 1433263
DERBY-6053: Client should use a prepared statement rather than regular statement for Connection.setTransactionIsolation
DERBY-6052: Text files under build/site do not have svn:eol-style=native
DERBY-6050: Make all topics visible in ToCs
DERBY-6044: Fix poor word breaking in table on download page(s)
DERBY-6043: Make JQL default query mode for 'ant genrelnotes'
DERBY-6042: Document the syscs_util.syscs_register_tool procedure added by DERBY-6022.
DERBY-6041: Remove unused parameters from the BTreeLockingPolicy interface
DERBY-6039: Intermittent failure in LangProcedureTest.testDynamicResultSets: Table/View 'T1' does not exist.
DERBY-6038: Intermittent failure in LangProcedureTest: cannot drop table because of open ResultSet
DERBY-6034: Fix documentation on procedure argument limits
DERBY-6033: Lift the arbitrary limit on the number of routine parameters.
DERBY-6030: Length of escape string in LIKE ... ESCAPE not properly checked with territory based collation
DERBY-6027: ORDER BY a cast expression gives NPE
DERBY-6018: Document varargs routines.
DERBY-6017: IN lists with mixed types may return wrong results
DERBY-6010: Reference Manual should clarify what ALTER TABLE ADD COLUMN does
DERBY-6009: Need stricter checking of ORDER BY clause in VALUES expressions
DERBY-6008: Allow ORDER BY and FETCH/OFFSET in set operands
DERBY-6006: NullPointerException in INSERT INTO ... SELECT FROM ... ORDER BY
DERBY-6003: Create row templates outside of the generated code
DERBY-6002: Reference manual is unclear on when territory can be set
DERBY-6001: ErrorMessageTest assert failure: Only one of the waiters should be aborted
DERBY-6000: Implement support for JDBC 4.2
DERBY-5999: Improve documentation on index key lengths
DERBY-5998: Replication tests fail on CDC platforms without optional JSSE package
DERBY-5996: Create readme files (cautioning users against modifying database files) at database hard upgrade time
DERBY-5995: Add a test case to check the 3 readme files get created even when log directory has been changed with jdbc url attribute logDevice
DERBY-5993: The Reference Manual shows an embedded url in its example for the client-side-only retrieveMessageText attribute.
DERBY-5992: Use BaseTestCase.execJavaCmd() to start process from NetworkServerTestSetup
DERBY-5989: Stop producing byte code for non-existent qualifiers
DERBY-5986: Make ArithmeticTest test DECIMAL data type
DERBY-5977: Run storemore and possibly other store .sql tests in junit harness using ScriptTest mechanism.
DERBY-5976: Document the new SQLWarning raised when trying to change the encryption state of an already booted database.
DERBY-5972: Grammar doesn't accept OR operator without parentheses
DERBY-5971: Improve test coverage for SQLBoolean class
DERBY-5969: Encryption, re-encryption, and un-encryption silently fail if the database is already booted.
DERBY-5966: NativeAuthenticationServiceTest.testAll() failure: ( FILE, NATIVE authentication on, LOCAL authentication ON, Authentication/Authorization turned OFF, SecurityManager ON, Embedded ): Connection to fifthDB unexpectedly failed.
DERBY-5964: Timestamp comparison failure in AutomaticIndexStatisticsTest.testStatisticsCorrectness
DERBY-5962: Internationalize error messages for database decryption
DERBY-5961: Developer's guide mentions SQL state 40XL2 which is no longer used
DERBY-5960: VirtualRandomAccessFile.close() is not idempotent
DERBY-5955: Prepare Derby to run with Compact Profiles (JEP 161)
DERBY-5954: NPE in SELECT involving subselects and windows functions
DERBY-5951: Missing method exception raised when using Clobs with territory based collation
DERBY-5948: Update JVMInfo.java to include JDK 8
DERBY-5947: Factor out common code from generated classes
DERBY-5945: Inappropriate error message when calling a procedure as a function (as if it had a return value)
DERBY-5940: Disable securityMechanism=8 in NSSecurityMechanismTest on ARM platforms
DERBY-5939: Document URL attribute for database decryption
DERBY-5938: Documentation says Derby works with Java 1.4.2
DERBY-5937: File handle is leaked when a Slave replication is shutdown with failover=true
DERBY-5935: Remove unused code for factory classes in the reflection service
DERBY-5934: Convert store.ReEncryptCrashRecovery
DERBY-5933: SQL sorting error
DERBY-5930: Reformat RawStore.setupEncryptionEngines
DERBY-5929: Release numbers in a few topics need updating
DERBY-5928: Add more task focus to Derby security documentation
DERBY-5927: Add utility methods to query state of URL attributes in EmbedConnection
DERBY-5926: Document user-defined aggregates (DERBY-672)
DERBY-5925: Document derby.log changes resulting from DERBY-5240
DERBY-5918: CREATE TABLE AS SELECT doesn't work on tables with BOOLEAN columns
DERBY-5917: NoClassDefFoundErrors when running tests without derbynet.jar and derbyclient.jar
DERBY-5916: java.lang.NullPointerException org.apache.derby.impl.store.raw.data.BaseDataFileFactory.stop() connecting to network server
DERBY-5914: Incorrect list of compatible JRE versions in client trace #2
DERBY-5913: Remove unused classes (GS)et*Action in client.am
DERBY-5912: testIsValidImplemented fails for NetworkServer in some slow running machines/configurations
DERBY-5911: WHERE condition getting pushed into sub-query with FETCH
DERBY-5910: Document use of Connection.close() with try-with-resources
DERBY-5909: The lang attribute in toc.html always says 'en-us'
DERBY-5906: In the Reference Manual, sin() is used as the example for the sinh() function.
DERBY-5905: Derby html documentation doesn't render properly and prints garbage on Internet Explorer
DERBY-5900: Need to correct Reference Guide description of contents of SYS.SYSPERMS.OBJECTTYPE
DERBY-5898: add ibm18 class to functionTests.harness
DERBY-5897: Broken handling of paths with special characters in compatibility/VersionCombinationConfigurator
DERBY-5896: Change java/drda source code to use spaces instead of tabs and clean up tab creep in java/client
DERBY-5894: NPE in OnlineBackupTest1 while backing up in stubFileToRemoveAfterCheckPoint
DERBY-5885: The order of argument names in messages.xml is sometimes wrong when the arguments occur in the message out of sequence.
DERBY-5883: Simplify JSR-169 implementation class tree
DERBY-5880: Move java.sql.Wrapper implementations to base classes in embedded driver
DERBY-5878: Add message argument names, as comments, to English message file produced by MessageBuilder.
DERBY-5877: Prune the brokered class tree
DERBY-5874: Remove JDBC 3 constants from client.am.Statement
DERBY-5873: Avoid unnecessary allocation of Number instances in client/server
DERBY-5872: Inconsistency between isWrapperFor() and unwrap() in logical statements
DERBY-5871: Invoke logical statements with existing statement tests
DERBY-5868: Move java.sql.Wrapper implementations to base classes on the client
DERBY-5864: weme 6.2 (J2ME) runs fail to start with Failed to invoke class org.apache.derbyTesting.functionTests.tests.derbynet._Suite java.lang.reflect.InvocationTargetException
DERBY-5860: Remove unused methods in DDMReader and DDMWriter
DERBY-5854: Test for methods in BrokeredCallableStatement
DERBY-5851: Inconsistent code coverage shown for LogicalPreparedStatement40
DERBY-5847: Clean up IDE warnings in DRDAConnThread
DERBY-5839: dblook run on toursdb fails on triggers with java.lang.StringIndexOutOfBoundsException in dblook.log
DERBY-5836: Move assertDirectoryDeleted from BaseJDBCTestCase to BaseTestCase
DERBY-5834: Remove unused methods in NetPreparedStatement class
DERBY-5833: Remove unused methods in NetCallableStatement class
DERBY-5831: Update information on BIS EAR (export control)
DERBY-5830: Make DoubleProperties.propertyNames() thread-safe
DERBY-5829: Lift DB2 restriction on the DEFAULT clause
DERBY-5828: Remove unused methods in NetPackageReply class
DERBY-5827: Remove unused methods in NetStatementReply class
DERBY-5826: Remove unused methods in NetConnectionReply class
DERBY-5822: Document the new SQL standard behavior of the SPACE_TABLE vti
DERBY-5821: tools/derbyrunjartest.java doesn't use jvmflags
DERBY-5820: emma-instrumentation target should instrument derbyrun.jar
DERBY-5819: Add logic to BaseTestCase to start subprocesses ready to be attached to from a Java debugger
DERBY-5817: Add support for the JaCoCo code coverage tool
DERBY-5815: Add replicationTests.ReplicationSuite to junit-core ant target
DERBY-5814: Source cleanup in catalogs "impl.sql.catalog" and "impl.sql.compile"
DERBY-5813: Remove unused class ErrorKey
DERBY-5810: Include emma.jar on classpath when running compatibility test with instrumented jars
DERBY-5808: Compatibility test should use BaseTestCase.execJavaCmd()
DERBY-5805: Database encryption topics in Reference Manual need more information
DERBY-5804: Remove unused class GenericClassInfo
DERBY-5803: Make error handling in xaHelper more explicit
DERBY-5802: Remove unused class ExecProcUtil
DERBY-5801: Sub-processes should write EMMA coverage data to separate files
DERBY-5799: add more info on when Derby chooses 32k page size for tables.
DERBY-5798: Disable i18n/JapanCodeConversion.sql on platforms that don't support EUC_JP or SJIS
DERBY-5797: AssertionFailedError in functionTests.tests.lang.UpdateStatisticsTest.testDisposableStatsEagerness
DERBY-5796: Remove unused methods in client.am.DateTime
DERBY-5795: Documentation in release doesn't include stylesheets
DERBY-5793: Document new SYSCS_INVALIDATE_STORED_STATEMENTS procedure
DERBY-5791: Replication tests should use BaseTestCase.execJavaCmd() to run local commands
DERBY-5787: (patch) remove dead allocation
DERBY-5786: Duplicate copies of InputStreamUtil.java and DynamicByteArrayOutputStream.java classes in client.net package
DERBY-5783: Remove duplicated code for starting remote processes in replication tests
DERBY-5779: Table functions should only accept arguments which are constant in their query block.
DERBY-5775: Upgrade tests should print full IOException stack trace when it fails to access old versions
DERBY-5764: Make DatabaseMetaDataTest more robust wrt changes made by other tests
DERBY-5752: LOBStreamControl should materialize less aggressively
DERBY-5750: Sending an empty string as table name to compress table procedure or empty string as index name to update statistics procedure makes the parser throw an exception.
DERBY-5740: Remove unsued code in AlterTableConstantaction.columnDroppedAndTriggerDependencies
DERBY-5632: Logical deadlock happened when freezing/unfreezing the database
DERBY-5622: Reduce the chance for hash collisions when checking bootPassword at boot time and when changing password.
DERBY-5578: Provide a way to invalidate stored prepared statements
DERBY-5546: ResultSet#updateBigDecimal on a REAL column does not do underflow checking
DERBY-5531: Assert failure when inserting NULL into indexed column with territory-based collation
DERBY-5462: ant release needs to accommodate for different ant executables on different systems
DERBY-5460: ant release should allow local.properties to exist
DERBY-5425: Updateable holdable ResultSet terminates early after 65638 updates
DERBY-5407: When run across the network, dblook produces unusable DDL for VARCHAR FOR BIT DATA columns.
DERBY-5359: Missing xmlns attribute for html element in docs
DERBY-5358: SYSCS_COMPRESS_TABLE failed with conglomerate not found exception
DERBY-5340: Comment in demo server policy should follow RFC 2606 convention
DERBY-5240: Log Operating system information to derby.log on boot
DERBY-5232: Put a stern README file in log and seg0 directories to warn users of corrpution they will cause if they touch files there
DERBY-5213: Write tests to verify the interaction of TRUNCATE TABLE and online backup
DERBY-4841: Improve projecthelp for the top level Derby build script
DERBY-4811: Remove unused clean targets from the Derby build.
DERBY-4323: test failure in lang.ErrorMessageTest with IBM iseries IBM 1.5
DERBY-4279: Statement cache deadlock
DERBY-4259: Document database property for determining database format version
DERBY-4229: encryptionKeyLength connection attribute should be documented
DERBY-3399: The automatic compile path property setting for the build system should be expanded to handle Java SE 6 virtual machines.
DERBY-3398: Support min/max values for Java types float/double in real/double columns
DERBY-3371: Strange (and untested) code fragment in RAMTransaction.addColumnToConglomerate()
DERBY-3275: Mismatch between comments and actual use of initialSize parameter in CacheFactory and Clock
DERBY-2920: Share code between readExternal() and readExternalFromArray()
DERBY-2774: Desciption of variable part in error message of XSLAM was not exists in Derby reference manual.
DERBY-2705: Description of error message for X0X61/X0Y59/X0Y69/X0Y70 in SQL error messages and exceptions of Reference manual is not appropriate.
DERBY-2699: performance of like in territory based collation databases may be improved by changing way collation elements are calculated.
DERBY-2601: Server SQLException error codes are not returned to client
DERBY-2572: Write a master script which creates a release branch.
DERBY-2516: Network Client allows execution of callable statement when one of the parameters is not set
DERBY-2461: Convert lang/procedure.java to junit
DERBY-2076: Rewrite junitTests/derbyNet/CompatibilityTest to conform to current JUnit usage
DERBY-1982: Remove support for JDK 1.3 in 10.3 and onwards
DERBY-1721: DOCS - Remove duplicate information in Dev Guide re: Encryption
DERBY-1400: Cleanup code in network server's DRDAStatement class
DERBY-1048: Include run of junitTests/CompatibilitySuite, or converted compatibility test suite with 10.1/trunk combination into suites.All
DERBY-436: clean up imports and static field references in DRDA classes

New in Apache Derby 10.9.1.0 (Jul 17, 2012)

Derby 10.9.1.0 contains the following new features:
NATIVE authentication - Derby now provides better credentials management to replace BUILTIN authentication
JDBC 4.1 escape syntax - Most of Derby's JDBC 4.1 support was provided in release 10.8.1.2. This release supplies the remaining bits object mapping and new escape syntax
Multi-column EXISTS subqueries - Multi-column SELECT lists are now allowed in EXISTS subqueries
Bug fixes:
DERBY-5777 - Update description of Maven artifact for the Derby net servlet to reflect that it is not intended for production use
DERBY-5776 - test failure in iepnegativetests_ES with weme 6.2 (J2ME/CDC) with trunk (10.9 alpha) as of revision 1339441
DERBY-5774 - Failures in UpdateStatisticsTest (order-dependent test cases)
DERBY-5771 - Use TestNullOutputStream where possible
DERBY-5770 - Reduce window of opportunity for queries being compiled without statistics on istat update
DERBY-5769 - Notes deprecating BUILTIN authentication need fixing
DERBY-5768 - Remove references to NATIVE::LOCAL from Derby error messages.
DERBY-5767 - Remove mentions of NATIVE::LOCAL authentication provider setting
DERBY-5763 - Reference Guide should note the new casing rules for the USERNAME arguments to the NATIVE procedures
DERBY-5760 - Missing argument in some XJ022 errors
DERBY-5759 - Add IndexStatsUtil.release(boolean closeConnection)
DERBY-5758 - System procedures in Reference Manual should be alphabetized
DERBY-5756 - Document new SYSCS_DROP_STATISTICS procedure
DERBY-5755 - Minor cleanup of DataDictionaryImpl.getRoutineList()
DERBY-5753 - nighly regression test failure in testLeak(org.apache.derbyTesting.functionTests.tests.memory.Derby5730Test) process failed
DERBY-5751 - Make TriggerTest less hungry on heap space
DERBY-5749 - Implicit cast of variable length values, e.g. as arguments to stored methods and generated columns values, silently truncate if too long
DERBY-5747 - Native user authentication: Docs do not describe what happens to schema and its SQL objects on SYSCS_UTIL.SYSCS_DROP_USER call
DERBY-5746 - Minor refactoring of DataDictionaryImpl.getSetAutoincrementValue
DERBY-5745 - Remove unused local variables from DataDictionaryImpl
DERBY-5737 - Remove GenericDescriptorList.elements and replace Enumerator usage with Iterator
DERBY-5736 - NullPointerException in GenericTriggerExecutor.executeSPS() caused by OutOfMemoryError
DERBY-5734 - End transaction if CleanDatabaseTestSetup.decorateSQL fails
DERBY-5733 - Source file for OrderByAndSortAvoidance contains characters not available in the C locale
DERBY-5732 - ProtocolTest doesn't clean up its test resources
DERBY-5730 - DataDictionaryImpl leaks references to itself via SYSFUN_AD
DERBY-5729 - Replication tests keep references to connections after completion
DERBY-5727 - Update POMs to deploy Maven artifacts to repository.apache.org and use ASF parent POM
DERBY-5726 - Make it more difficult to forget calling super.tearDown() from BaseJDBCTestCase's subclasses
DERBY-5725 - ErrorStreamTest doesn't call super.tearDown()
DERBY-5724 - EncryptionKeyTest sometimes keeps reference to connection
DERBY-5723 - LongColumnTest doesn't call super.tearDown()
DERBY-5722 - InternationalConnectTest forgets to call super.tearDown()
DERBY-5721 - ParameterMappingTest lacks call to super.tearDown()
DERBY-5720 - UngroupedAggregatesNegativeTest doesn't call super.tearDown()
DERBY-5719 - UniqueConstraintMultiThreadedTest doesn't call super.tearDown()
DERBY-5718 - UniqueConstraintSetNullTest calls super.tearDown() too early
DERBY-5717 - TableFunctionTest keeps reference to connection after completion
DERBY-5716 - TimestampArithTest keeps references to statements after completion
DERBY-5715 - InbetweenTest holds on to resources after completion
DERBY-5714 - ColumnDefaultsTest holds on to resources after completion
DERBY-5713 - AlterTableTest holds on to resources after completion
DERBY-5712 - CheckConstraintTest holds on to resources after completion
DERBY-5711 - NullsTest doesn't call super.tearDown()
DERBY-5710 - BigDataTest.tearDown() doesn't call super.tearDown()
DERBY-5709 - ResultSetFromPreparedStatementTest keeps references to non-default connections
DERBY-5708 - simpleThread test doesn't release connection
DERBY-5707 - Clean up statements in CharUTF8Test
DERBY-5706 - Clean up statements in CreateTableFromQueryTest
DERBY-5705 - Authorization decorators don't null out connections when done
DERBY-5704 - Various cleanups in CoalesceTest
DERBY-5701 - Make UpdatableResultSetTest less hungry on heap space
DERBY-5700 - Delete symlinks to the 10.0 manuals from the web site
DERBY-5699 - Disable automatic conversion to star imports in NetBeans project
DERBY-5698 - Document performance issue with 2-arg versions of setXXXStream methods for LOBs
DERBY-5697 - Doc changes to account for correctness fixes for sequences
DERBY-5696 - Documentation on LOBs needs some fixes
DERBY-5695 - Speed up population of tables in OrderByAndSortAvoidance
DERBY-5693 - BUILTIN should say passwords are hashed not encrypted
DERBY-5692 - intermittent test failure in storetests/st_derby715.java
DERBY-5691 - Document that Write Caching must be disabled to avoid possible database corruption
DERBY-5683 - BaseJDBCTestCase.getDatabaseProperty() should close resources before returning
DERBY-5682 - ProtocolTest failures: Unsupported encoding MacGreek
DERBY-5681 - When a foreign key constraint on a table is dropped, the associated statistics row for the conglomerate is not removed
DERBY-5680 - indexStat daemon processing tables over an over even when there are no changes in the tables
DERBY-5678 - LocalizedDisplayScriptTest fails on JVMs that don't support EUC_JP encoding
DERBY-5677 - ClassNotFoundException when running suites.All without derbynet.jar
DERBY-5671 - NsTest does not run on trunk do multiple issues stemming from concurrency improvements
DERBY-5667 - testReadCommitted(org.apache.derbyTesting.functionTests.tests.store.UpdateLocksTest)junit.framework.AssertionFailedError: Missing rows in ResultSet
DERBY-5664 - Include driver tests in jdbcapi suite
DERBY-5657 - Message XCY05 for NATIVE authentication is (too?) complex
DERBY-5655 - Preformatted text should not be used for graphic
DERBY-5653 - We should document that the NetServlet is a testing tool and not appropriate for production use.
DERBY-5649 - make improvements to nstest so it's easier to run/analyze/debug
DERBY-5648 - Unclear password expiry warning when using separate credentials db
DERBY-5647 - NATIVE warns about password expiry for DBO
DERBY-5646 - Get upgrade tests to pass on OJEC 1.1
DERBY-5645 - Reference manual says setBlob()/setClob()/getBlob()/getClob() are not supported on CallableStatement
DERBY-5644 - Typo in error message for NATIVE authentication
DERBY-5643 - Occasional hangs in replication tests on Linux
DERBY-5642 - OutOfMemoryError in OCRecoveryTest on phoneME
DERBY-5641 - Remove unused BaseDataFileFactory methods plus minor cleanups
DERBY-5640 - Use element for table summary
DERBY-5639 - Minor code cleanup for NetServlet
DERBY-5637 - Document Derby's JMX capabilities and how to disable them
DERBY-5636 - Improve the overview of Derby's security mechanisms
DERBY-5635 - Provide implementation for getMetaData() in VTITemplate
DERBY-5633 - Add tests for state transition and behavior with Lock Timeout in XA Transaction (DERBY-5552 testing task)
DERBY-5631 - Extend SecurityManagerSetup to add extra privileges to the set of default privileges (merge two policy files)
DERBY-5628 - Wrong syntax description in DELETE statement doc
DERBY-5627 - Remove unused methods in UUID classes
DERBY-5624 - System can run out of stack space while processing DropOnCommit requests.
DERBY-5623 - Loosen up synchronization in FileMonitor
DERBY-5620 - Replace illegal characters from test name when creating the failure folder
DERBY-5617 - Improve process handling in SpawnedProcess
DERBY-5616 - demo/vtis/sql/demoFileVtis.sql needs to be adjusted: messages_en.properties has moved
DERBY-5614 - NullPointerException with INSERT INTO (global temporary table) SELECT ... FROM (VTI)
DERBY-5612 - Puzzling documentation about the URL to a database on the classpath
DERBY-5609 - Prepare old test harness for running tests on Java 8
DERBY-5608 - BaseTestCase.readProcessOutput should read getInputStream() and getErrorStream() in separate threads
DERBY-5604 - (patch) access static constants with static references
DERBY-5603 - EmbedConnection.clearLOBMapping() incorrectly clears lobFiles causing a ConcurrentModificationException
DERBY-5599 - readlocks.sql fails with extra locks.
DERBY-5598 - testStartWithPrintWriter(org.apache.derbyTesting.functionTests.tests.derbynet.DerbyNetNewServerTest)junit.framework.AssertionFailedError: Num of log item should add
DERBY-5596 - TIMESTAMP doc gives wrong precision limitation
DERBY-5591 - Imprecise wording in documentation in ref man on DROP VIEW
DERBY-5590 - Document optional modifyThreadGroup permssion in java 2 security permissions
DERBY-5587 - Due to licensing issues, fix or remove the monohtml docs posted on Derby's documentation page.
DERBY-5586 - Remove the fo2html.xsl script from the docs repository and fix the docs and release builds so that they don't build monohtml versions of the Derby manuals.
DERBY-5584 - Select statement with subqueries with group by and count distinct statements returns wrong number of results
DERBY-5580 - NativeAuthenticationServiceTest getting multiple errors trying to delete files/directories during teardown
DERBY-5574 - encryption test in encryption nightly suite test fails with ERROR XBM0S: Unable to rename file error
DERBY-5568 - AssertionFailedError: Should not hold locks after commit in ResultSetMiscTest
DERBY-5567 - AlterTableTest#testDropColumn fails: drop view cannot be performed due to dependency
DERBY-5566 - CREATE SCHEMA should state that one cannot create a new schema starting with "SYS" in case normal form
DERBY-5565 - Network Server should reject client connections that are not Derby Network Client
DERBY-5564 - Code does different things depending if derby.locks.deadlockTrace=true is set
DERBY-5562 - An read-only XA transaction that has a timeout never has the timer canceled when the transaction is complete
DERBY-5559 - AssertFailures (7, or 8) with ibm 1.6 and 1.5 on Windows XP in lang.NativeAuthProcs fixture testAll
DERBY-5558 - NullPointerException in store.RecoveryTest launchRecoveryInsert and failure in testBasicRecovery with weme 6.2
DERBY-5557 - NULLIF topic in reference manual should explain NULLIF
DERBY-5552 - Derby threads hanging when using ClientXADataSource and a deadlock or lock timeout occurs
DERBY-5550 - Document derby.authentication.builtin.saltLength and derby.authentication.builtin.iterations
DERBY-5547 - NSSecurityMechanismTest fixture testNetworkServerSecurityMechanism fails intermittentlyt
DERBY-5542 - Remove checks for Java version being greater than or equal to 1.4
DERBY-5541 - Remove unnecessary field rwsOK in DirStorageFactory4
DERBY-5540 - Call initCause() and getCause() without reflection in BaseJDBCTestCase
DERBY-5539 - Harden password hashing in the builtin authentication service
DERBY-5536 - Client's ResultSet#getLong does not range check when converting from a DECIMAL column
DERBY-5535 - Remove unused methods from client's CrossConverters class.
DERBY-5533 - Client differs from embedded when rs.updateInt overflows: 22015 vs 22003
DERBY-5530 - SQLChar.getCollationKey NPE in index-stat-thread
DERBY-5529 - XATransactionTest: Table/View 'DERBY1016' already exists
DERBY-5527 - Documentation problem: 5 - Verifying the copy of the files
DERBY-5526 - on upgrade from 10.5 to 10.8.2 , getting ERROR XBM0A: The database directory 'C:\cygwin\home\debugfat\clientdb' exists. However, it does not contain the expected 'service.properties' file.
DERBY-5524 - Speed up clean-up after StatementJdbc30Test.xtestMaxOpenStatementsWithQueryTimeout
DERBY-5522 - Document the NATIVE authentication scheme.
DERBY-5521 - JDBCMBeanTest#testAttributeDriverLevel uses Java assert in lieu of JUnit assert: no real testing happens
DERBY-5519 - Update code in JVMInfo#derbyVMLevel to give correct results for Java 7 and provisionally for 8.
DERBY-5517 - testReplication_Local_3_p1_StateNegativeTests failed with connection refused
DERBY-5516 - Document the fact that attributes on the connection URL trump attributes specified in a connection Properties object.
DERBY-5515 - Derby mailing lists should be mentioned in documentation
DERBY-5514 - SecureServerTest (and others) don't play nice with EMMA: AccessControlException
DERBY-5512 - emma-single and emma-all don't use the instrumented jars
DERBY-5509 - javadoc for NetServlet and NetworkServerControl are missing a few closing tags
DERBY-5508 - Improve backup/restore documentation visibility and content to encourage proper backups and restore procedures
DERBY-5507 - Orderly shutdown fails if you are using BUILTIN authentication and turn on derby.database.propertiesOnly
DERBY-5506 - Document that EXISTS subquery can now select more then one column
DERBY-5505 - BLOB and CLOB Reference Manual topics could use some fixes
DERBY-5504 - SecureServerTest, Driver40UnbootedTest and replication tests not prepared for space in java.home
DERBY-5502 - RestrictiveFilePermissionsTest and RecoveryTest fail with file permission errors on the OpenJDK 7 preview for Mac OS X
DERBY-5501 - Subquery is only allowed to return a single column - When using derby with hibernate (or JPA) queries are created per JPA spec. For tables with multi-column PK, subqueries are created with two columns in select clause.
DERBY-5499 - Document the new JDBC limit/offset escape syntax
DERBY-5498 - ClosedByInterruptException in AuthenticationTest
DERBY-5496 - The JUnit infrastructure package should be compiled against the small device classpath, not the JDK 1.4 classpath
DERBY-5495 - Master issue to track fixes to sequence generators
DERBY-5494 - Same value returned by successive calls to a sequence generator flanking an unorderly shutdown.
DERBY-5492 - Restrictive file permissions: permissions removed also for owner on NTFS if Acl does not contain explicit entry for owner
DERBY-5491 - (patch) new String("") or new String() is pointless, and just allocates memory needlessly - removed
DERBY-5490 - Lots of error trying to spawn a JVM in the SecureServerTest and Replication tests when running on the preview JDK 7 on Mac OS X
DERBY-5489 - getBinary() returns incorrect data after getObject() call on BLOB column
DERBY-5488 - Add remaining JDBC 4.1 bits which did not appear in the Java 7 javadoc.
DERBY-5485 - Simplify PropertySetter so that it is less brittle and easier to maintain.
DERBY-5482 - Reduce number of jar invocations in the buildjars target
DERBY-5480 - File handle leak in MessageVetter
DERBY-5479 - Don't run MessageVetter unless messages have changed
DERBY-5478 - Speed up creation of bin scripts
DERBY-5477 - Switch from scpexe to scp for Maven deployment
DERBY-5476 - Remove unused parameter in splitmessages
DERBY-5474 - Speed up message splitting in build
DERBY-5472 - Speed up MemoryLeakFixesTest.testRepeatedDatabaseCreationWithAutoStats()
DERBY-5469 - Make it possible to build Derby if you are on Mac OS X and your JDK is JDK 7
DERBY-5467 - Copyright notice in the API documentation (generated by the Javadoc tool) is outdated
DERBY-5465 - Broken null checks in NsTest
DERBY-5464 - Add easier to find links to Derby JavaDoc on the Derby web site
DERBY-5459 - Result set metadata are out of sync on client after underlying table is altered
DERBY-5458 - Add ant target to generate JavaDocs bundle
DERBY-5456 - Problems running SecureServerTest and replication tests on Open JDK 7 for Mac OS X
DERBY-5454 - ERROR 40001 deadlock in nstest on select max(serialkey)
DERBY-5453 - Remove unused methods in Cursor and NetCursor
DERBY-5449 - 10.8 client with 10.5 server gives java.lang.ClassCastException: java.lang.Boolean incompatible with java.lang.Short in NetStatementRequest.buildFDODTA with CursorTest.testCursorParam()
DERBY-5442 - Create documentation for restrictive file permissions feature
DERBY-5440 - test failure in testBTreeForwardScan_fetchRows_resumeAfterWait_nonUnique_split(org.apache.derbyTesting.functionTests.tests.store.IndexSplitDeadlockTest)junit.framework.AssertionFailedError: expected: but was
DERBY-5439 - Remove JRE / JDBC line from sysinfo
DERBY-5437 - Load all toursdb tables in one invocation of ij
DERBY-5436 - Use helper method to add warning in EmbedResultSet.movePosition()
DERBY-5434 - On linux with IBM JDK 1.7 suites.All does not run at all failing with java.lang.reflect.InvocationTargetException
DERBY-5427 - Unauthorized shutdown should not generate thread dump and javacore. AuthenticationTest dumps over 20 javacores with IBM JVM for normal user errors
DERBY-5420 - Regression suite appears locale sensitive: failed in TableLockBasicTest: bug in RealBasicNoPutResultSetStatistics
DERBY-5406 - Intermittent failures in CompressTableTest and TruncateTableTest
DERBY-5383 - Add articles and blog links to the site's Resources tab
DERBY-5382 - Convert existing harness recovery tests to JUnit tests
DERBY-5379 - testDERBY5120NumRowsInSydependsForTrigger - The number of values assigned is not the same as the number of specified or implied columns.
DERBY-5374 - converted ij5Test fails with weme6.2 (CDC/Foundation): junit.framework.ComparisonFailure: Output at line 1 expected: but was
DERBY-5370 - The toSQL method of the org.apache.derby.vti.Restriction class does not output correct constants for VARCHAR, Timestamp, Date, Time, or CHAR FOR BIT DATA types
DERBY-5368 - Convert tools/ij2.sql to junit
DERBY-5363 - Tighten permissions of DB files to owner with >= JDK7
DERBY-5357 - SQLJ.INSTALL_JAR shouldn't use identifier as file name
DERBY-5355 - Remove *.out from svn:eol-style paragraph in docs environment instructions
DERBY-5349 - Clean docs build fails to pick up customized map2htmtoc.xsl
DERBY-5346 - ij3Test fails on phoneME
DERBY-5345 - URLCheck fails on phoneME
DERBY-5343 - Starting 7/13/2011 weme 6.2 upgrade tests started failing with 213 failures 127 errors with java.lang.IllegalAccessException
DERBY-5342 - make ScriptTestCase support "ij.showNoCountForSelect" and "ij.showNoConnectionsAtStart"
DERBY-5332 - Convert tools/ij3.sql to junit
DERBY-5327 - Convert tools/ij5.sql to junit
DERBY-5326 - Convert tools/ij6.sql to junit
DERBY-5316 - Unload old JDBC drivers when done with them in the upgrade tests
DERBY-5311 - Convert tools/ij4.sql to junit
DERBY-5310 - PropertySetter prints warning when building with JDK 7
DERBY-5308 - Investigate if largeData/LobLimits.java can be run for client
DERBY-5306 - Remove dead methods (June 2011)
DERBY-5305 - Convert store/updatelocks.sql to JUnit
DERBY-5303 - Convert tools/URLCheck.sql to junit
DERBY-5302 - Convert tools/ij(?).sql to junit
DERBY-5301 - Convert store/TableLockBasic.sql to junit
DERBY-5300 - Change derby.tests.trace to print the class as well as fixture name
DERBY-5293 - Replace bubble sort in DataDictionaryImpl and CreateTriggerNode with Collections.sort()
DERBY-5286 - Update tools/ide/netbeans directory
DERBY-5283 - Crash / process termination during SYSCS_DISABLE_LOG_ARCHIVE_MODE can leave service.properties broken
DERBY-5282 - Convert store/RowLockBasic.sql to junit
DERBY-5277 - Intermittent OutOfMemoryErrors in BasicSetup.testTriggersWithLOBcolumns()
DERBY-5275 - Remove empty, unused methods in client/am/Lob.java
DERBY-5269 - Remove unused methods getSocketAndInputOutputStreams and checkAlternateServerHasEqualOrHigherProductLevel in NetConnection
DERBY-5267 - Shut down engine for old versions in upgrade tests to save memory
DERBY-5260 - Remove unused "replace" argument to backup variant of StorageFactoryService#saveServiceProperties
DERBY-5256 - Improve error reporting in common.sanity.AssertFailure
DERBY-5246 - Simplify bytecode generation for concatenation operator
DERBY-5229 - Testing README; tstjardir
DERBY-5227 - Put a link to developers' wiki page
DERBY-5224 - (patch) reduce cohesion by removing overzealous casting
DERBY-5210 - Use java.nio.ByteBuffer in client.net.Request
DERBY-5202 - Add colnum attribute to the colspecs generated by MessageBuilder in order to eliminate some severe warnings while building the pdf version of the Derby user guides.
DERBY-5200 - (patch) embellish build.xml to automatically install junit.jar in the correct directory if it doesn't exist.
DERBY-5189 - PropertySetter should ignore GCJ installations
DERBY-5163 - (patch) fix up sql cleanup handling
DERBY-5156 - convert store/longColumn.sql into junit test case
DERBY-5155 - Make testcases pass in non-English locale
DERBY-5145 - Provide option to limit compatibility test to combinations that include trunk
DERBY-5127 - Convert madhare.sql to JUnit
DERBY-5096 - DisconnectException: "Connection was refused because the database DB was not found" when creating db for first time
DERBY-5090 - Retrieving BLOB fields sometimes fails
DERBY-5083 - Document automatic update and creation of index cardinality statistics (istat)
DERBY-5080 - Utilize JQL to fetch JIRA issue list for release notes generation
DERBY-5077 - (patch) remove non productive instanceof checks
DERBY-5068 - Investigate increased CPU usage on client after introduction of UTF-8 CcsidManager
DERBY-5010 - (patch) bad equivalence check
DERBY-4962 - Create a table function which efficiently migrates data out of foreign databases and which can be used for ongoing data integration
DERBY-4795 - Starting network server with -ssl turns SSL off
DERBY-4533 - Delete old releases from http://www.apache.org/dist
DERBY-4532 - Old download pages should refer to archive.apache.org only
DERBY-4521 - Stream passed out to user does not heed close, allowing reads after next ResultSet#getXXX
DERBY-4466 - Download page does not have link to KEYS file
DERBY-4321 - test nstest generates errors XBM06 re reencryption and 22003 re value outside range for decimal/numeric
DERBY-4291 - Intermittent failure in 'store/updatelocks.sql' on Windows Vista
DERBY-4280 - Property not documented - derby.language.statementCacheSize
DERBY-4249 - Create a simple store recovery test in JUnit
DERBY-4201 - SecureServerTest AssertionFailedError: Timed out waiting for network server to start
DERBY-4115 - Provide a way to drop statistics information
DERBY-4089 - It should be possible to run unit tests right after "ant all"
DERBY-3913 - mismatch between error XCL30 and 22003.S.4 and parameters in usage
DERBY-3823 - NullPointerException in stress.multi test
DERBY-3808 - Convert subquery.sql to junit
DERBY-3790 - Investigate if request for update statistics can be skipped for certain kind of indexes, one instance may be unique indexes based on one column.
DERBY-3740 - BlobClob4BlobTest.testLockingWithLongRowBlob fails with .AssertionFailedError: FAIL - statement should timeout
DERBY-3146 - Adjust length restriction on user identifiers (authorization ids) to same as other identifiers
DERBY-2720 - remove dead code associated with unsupported National Char implementation
DERBY-2687 - store/encryptDatabase.sql fails intermittently with ClassNotFoundException, Log Corrupted
DERBY-2402 - client ResultSetMetaData for select * after alter table does not return added columns
DERBY-2066 - DisconnectException: The DDM object 0x1232 is not supported following shutdown of embedded engine while network server is running
DERBY-2031 - Convert derbynet/testProtocol.java to JUnit
DERBY-1913 - storetests/st_reclaim_longcol.java fails intermittently
DERBY-1888 - Convert LOB tests to Junit
DERBY-1482 - Update triggers on tables with blob columns stream blobs into memory even when the blobs are not referenced/accessed.
DERBY-1256 - Remove usage of non-portable methods in derby code
DERBY-1016 - javax.transaction.xa.forget (Xid) raises XAER_NOTA exception instead of XA_PROTO on a prepared transaction
DERBY-866 - Derby User Management Enhancements
DERBY-129 - Derby should throw a truncation error or warning when CASTing a parameter/constant to char or char for bit datatypes and the data is too large for the datatype.