DERBY-5610 ServerPropertiesTest prints .java.net.SocketException: Connection reset to console but test passes 

Remove e.printStackTrace() of error if log writer is null, unless derby.drda.debug is true



git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1526172 13f79535-47bb-0310-9956-ffa450edef68
DERBY-6351: Syntax error on equal transition table name and correlation name in statement trigger

Change how CreateTriggerNode.bindReferencesClause() checks for the
lack of a correlation name. Instead of checking it indirectly (and
unreliably) by seeing if the table name matches the base table name,
check directly if the correlation name is null.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1526406 13f79535-47bb-0310-9956-ffa450edef68
DERBY-6146 testMultipleLastKeyWaitsInMaxScan(org.apache.derbyTesting.functionTests.tests.store.IndexSplitDeadlockTest)junit.framework.AssertionFailedError: Column value mismatch @ column '1',

Check that locks have been taken as expected instead of always just waiting one second to avoid intermittent failure



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

Allow references to transition variables and transition tables in the
WHEN clause. To support this, a new column WHENCLAUSETEXT is added to
the SYS.SYSTRIGGERS table, and a corresponding field is added to the
TriggerDescriptor class.

The logic that transforms triggered SQL statements to internal syntax
for accessing the transition variables and transition tables (via Java
method calls and VTIs) is reused on the WHEN clause text so that the
same transformation happens there.

Upgrade logic is added so that the new column in SYS.SYSTRIGGERS will
be created when a database is upgraded from an older version. The WHEN
clause is now disabled in the parser when running in soft upgrade
mode. An upgrade test case checks that the WHEN clause can only be
used in a hard-upgraded database, and that a reasonable error is
raised otherwise.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1526831 13f79535-47bb-0310-9956-ffa450edef68
DERBY-6356; java.security.AccessControlException in i18n.LocalizedDisplayScriptTest
  switching the test to use TimeZoneTestSetup which already has the required privilege blocks.


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

Reject references to generated columns in the NEW transition variables
of BEFORE triggers, as required by the SQL standard. See also
DERBY-3948.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1527489 13f79535-47bb-0310-9956-ffa450edef68
DERBY-6357: CREATE TRIGGER doesn't detect all illegal references to SESSION schema

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

Disallow references to tables in the SESSION schema in the WHEN clause.

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

Forbid CREATE TRIGGER statements whose WHEN clause contains a
parameter marker or returns a non-BOOLEAN value.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1528401 13f79535-47bb-0310-9956-ffa450edef68
DERBY-6363: Incorrect evaluation of logical expressions in CASE

Skip conversion of OR nodes to IN lists if the OR node is not on
conjunctive normal form.

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

Add a test case to verify that the WHEN clause SPS is invalidated and
recompiled if one of its dependencies requests a recompilation.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1529145 13f79535-47bb-0310-9956-ffa450edef68
DERBY-6371: DROP COLUMN looks in wrong schema when checking trigger dependencies

Use the same schema during dependency checking as during compilation
of the trigger action.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1530517 13f79535-47bb-0310-9956-ffa450edef68
DERBY-3624 testfailure in storetests/st_derby715 with ibm 1.5 on iseries machine; one deadlock message missing

Change test to check locks rather than sleep for synchronization.



git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1530696 13f79535-47bb-0310-9956-ffa450edef68
DERBY-5317: Detect attempts to reuse a connection that in the middle of sending a request to the server. Use this to provide a better error message and avoid the NPE.

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

Reuse code for dependency checking of the triggered SQL statement for
checking dependencies in the WHEN clause.

Add test to verify that attempts to drop columns referenced in the WHEN
clause detect that the trigger is dependent on the columns.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1530887 13f79535-47bb-0310-9956-ffa450edef68
DERBY-6371: DROP COLUMN looks in wrong schema when checking trigger dependencies

Fix another occurrence where the wrong schema is used. This occurrence
doesn't cause any problems currently, since it's only used for
parsing, and the problems wouldn't appear until one attempt to do
binding with the incorrect schema. Fix it anyway for consistency.

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

Make the code in TriggerDescriptor.getActionSPS() reusable for
TriggerDescriptor.getWhenClauseSPS() so that the fixes for DERBY-4874
and Cloudscape bug 4821 also get applied to the WHEN clause.

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

Add tests to verify that the when clause operates with the privileges
of the user that created the trigger, and that exceptions thrown in
the WHEN clause are handled gracefully.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1531279 13f79535-47bb-0310-9956-ffa450edef68
DERBY-6352; Access denied ("java.lang.RuntimePermission" "modifyThread") in store.RecoveryAfterBackup test
  adding try/catch code to provide more information when this happens


git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1531721 13f79535-47bb-0310-9956-ffa450edef68
DERBY-2446; Remove notion of the old test harness from TestConfiguration
  Removing remaining references, and also removing remaining files from tests/junitTests


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