DERBY-2446; Remove notion of the old test harness from TestConfiguration
  removing a now unnecessary line from the test policy file


git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1532613 13f79535-47bb-0310-9956-ffa450edef68
DERBY-6377; Add Derby Nature doesn't work wirh Eclipse Kepler 4.3, only with Juno 4.2
  Adding a note to the top of the Readme to indicate this is no longer being maintained.


git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1532636 13f79535-47bb-0310-9956-ffa450edef68
DERBY-534: Support use of the WHEN clause in CREATE TRIGGER statements

Fix incorrect null check when merging subqueryTrackingArray and
materializedSubqueries in GenericStatementContext.setTopResultSet().
Used to cause NullPointerException in some cases when a WHEN clause
contained a subquery.

Add more tests for scalar subqueries in WHEN clauses.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1532666 13f79535-47bb-0310-9956-ffa450edef68
DERBY-6361: Valid statements rejected if Derby has not implicitly
created the current user's schema.

Make compilation of the generation clause accept that the original
compilation schema does not exist.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1532997 13f79535-47bb-0310-9956-ffa450edef68
DERBY-6350 (Provide a rolling file implementation of derby.log)

Committing patch submitted by Brett Bergquist



git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1533320 13f79535-47bb-0310-9956-ffa450edef68
DERBY-6386 - Errors in jdbc4.LobStreamTest if derbyclient.jar is first in the classpath


git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1534425 13f79535-47bb-0310-9956-ffa450edef68
DERBY-2130 - Optimizer performance slowdown from 10.1 to 10.2

Patch contributed by Army Brown



git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1534465 13f79535-47bb-0310-9956-ffa450edef68
DERBY-6373: NPE in Statement.getWarnings()

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1534523 13f79535-47bb-0310-9956-ffa450edef68
DERBY-534: Support use of the WHEN clause in CREATE TRIGGER statements

Add dblook support for triggers with a WHEN clause.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1534988 13f79535-47bb-0310-9956-ffa450edef68
DERBY-3155: Add (optional) row locations to backing hash tables: derby-3155-03-ag-backingStoreHashtableWithRowLocation.diff.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1535001 13f79535-47bb-0310-9956-ffa450edef68
DERBY-6320 Log a page dump to derby.log if ERROR nospc: nospc.U is returned to the user
This patch adds the ability to dump a page in an insane build, and adds 2 calls to do so in 2 outstanding nospc error cases. In those two cases a new user
level error is thrown and nests the nospc.U error so that we still know the
original stack trace where the lowest error was thrown.  
The patch passes all tests and the specific errors were hand tested, one of 
them using the test case filed in DERBY-4923 and in the other case just by hand forcing the codepath.



git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1535075 13f79535-47bb-0310-9956-ffa450edef68
DERBY-3155: Add support for DELETE action of MERGE statement; checking in derby-3155-04-af-deleteAction.diff.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1535360 13f79535-47bb-0310-9956-ffa450edef68
DERBY-3155: Uncomment a test verifying that trigger transition tables cannot be used as the target tables of MERGE statements: derby-3155-05-aa-triggerTransitionTableAsTarget.diff.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1535397 13f79535-47bb-0310-9956-ffa450edef68
DERBY-4923 update of a long row can fail with ERROR nospc: nospc.U exception.

This checkin fixes the problem repro'd by the included new test, which shows
an update of an existing row in db failing with a nosp.U exception. 
The problem was an off by 1 error in checking for enough space to update a row
on an overflow page to just an overflow pointer. The intent of the code is to 
always reserve enough space in every overflow row to allow for this update. 
In this case there was exactly enough space, but the code mistaken thought it 
needed 1 more byte.



git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1535413 13f79535-47bb-0310-9956-ffa450edef68
DERBY-3155: Fix some serialization bugs in the MERGE ConstantActions and add test cases for using trigger transition tables as the source tables of MERGE statements; check in derby-3155-06-aa-triggerTransitionTableAsSource.diff.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1535447 13f79535-47bb-0310-9956-ffa450edef68
DERBY-2813 store/ClassLoaderBootTest fixture testBootingAnAlreadyBootedDatabase fails indicating derby booted a database that was already booted by another CLR if security manager is on

This patch just improves the assertion with security manager on to show that we are picking up the wrong class loader. It does not fix the issue.



git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1535536 13f79535-47bb-0310-9956-ffa450edef68
DERBY-534: Support use of the WHEN clause in CREATE TRIGGER statements

Remove logic in the readExternal() and writeExternal() methods of
TriggerInfo and TriggerDescriptor that was originally put there for
compatibility between different Derby versions. Since these objects
are only persisted as part of a stored prepared statement, and Derby
always clears all stored prepared statements on version change, there
is no requirement that TriggerInfo and TriggerDescriptor instances
written by one Derby version must be possible to read by other Derby
versions.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1535654 13f79535-47bb-0310-9956-ffa450edef68
DERBY-6378 OFFSET/FETCH NEXT ignored when query is enclosed in parentheses

Patch derby-6378-4.

To address the required generality of several layers of nested
multiple clauses allowed by SQL, this patch introduces a stack
mechanism for order by and offset/fetch clauses, factored out into
ResultSetNode#QueryExpressionClause (nested class). From the javadoc
for that class:

For ease of handling order by clause, offset clause and fetch
first/next clauses in subclasses. Clauses on the same nesting level
have the same index in the lists, so at any level, any of the lists'
elements may be empty. For example, (select * from t order by a fetch
next 5 rows only) order by b would have

            obl[0] = "order by a",
            offset[0] = null,
            fetchFirst[0] = "next 5 rows"
and
            obl[1] = "order by b",
            offset[1] = null
            fetchFirst[1] = null

When starting a new level, always remember to do a push() before
adding clauses via
setOffset(org.apache.derby.impl.sql.compile.ValueNode),
setFetchFirst(org.apache.derby.impl.sql.compile.ValueNode),
setOrderByList(org.apache.derby.impl.sql.compile.OrderByList) and
setHasJDBCLimitClause(java.lang.Boolean).

Added tests to OrderByAndOffsetFetchInSubqueries in #testDerby6378,
running regressions.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1536507 13f79535-47bb-0310-9956-ffa450edef68
DERBY-6350

Committing the test cleanup provided by Brett



git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1536808 13f79535-47bb-0310-9956-ffa450edef68
DERBY-6348: NPE or assert failure in recursive trigger

Reset the activation in the statement context before setting up the
activation for the next trigger, so that the nested trigger activation
is a child of the top-level activation, and not a child of the
previous trigger's activation.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1537393 13f79535-47bb-0310-9956-ffa450edef68