DERBY-5832: Fix some test canons to align them with the new translations which were just checked in.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1421972 13f79535-47bb-0310-9956-ffa450edef68
DERBY-6008 Allow ORDER BY and FETCH/OFFSET in set operands

Patch derby-6008-e; adds this feature as well as accompanying new tests.


git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1422164 13f79535-47bb-0310-9956-ffa450edef68
DERBY-5894: NPE in OnlineBackupTest1 while backing up in stubFileToRemoveAfterCheckPoint

Stop using the shared run() method from RAFContainer.backupContainer(),
as it is not safe to use without synchronization (which is why the
NullPointerException happened).

Also, use doPrivileged() only to execute those parts of the code that
need to run with privileges, as most of the code called from
backupContainer() does not need privileges.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1422845 13f79535-47bb-0310-9956-ffa450edef68
DERBY-5832; Localize messages introduced or changed in 10.9.1 
  adjusting one j9 canon to match the changes for the master


git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1423209 13f79535-47bb-0310-9956-ffa450edef68
DERBY-3069: Add datatype and coercion tests for varargs arguments and prevent table functions from being created with parameter style DERBY.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1423714 13f79535-47bb-0310-9956-ffa450edef68
DERBY-6012 (Print thread dump and dump javacore if NetworkServerTestSetup has to kill off the Network Server start up process due to timeout)

Simple code change to dump threads and javacore



git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1423985 13f79535-47bb-0310-9956-ffa450edef68
DERBY-6017: IN lists with mixed types may return wrong results

Fix the case where all the constant values in an IN list get reduced
to a single constant after conversion to the dominant type. In such
cases, the remaining constant should be converted to the dominant type.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1424889 13f79535-47bb-0310-9956-ffa450edef68
DERBY-6003: Create row templates outside of the generated code

Make IndexRowToBaseRowResultSet use an ExecRowBuilder instead of a
generated method to produce row templates.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1426151 13f79535-47bb-0310-9956-ffa450edef68
DERBY-3275: Mismatch between comments and actual use of initialSize parameter in CacheFactory and Clock

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1426360 13f79535-47bb-0310-9956-ffa450edef68
DERBY-5955 Prepare Derby to run with Compact Profiles (JEP 161)

Patch derby-5955-embed-restructure-04. This restructures the class
hierarchy for embedded data sources to prepare for introduction of the
non-JNDI dependent ones for JEP 161.



git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1427045 13f79535-47bb-0310-9956-ffa450edef68
DERBY-4955 Prepare Derby to run with Compact Profiles (JEP 161) 

Patch derby-5955-embed-restructure-followup, some white space changes
plus a missed fix to EmbeddedDataSource40 which was in the original
proff-of-concept patch but fell through the cracks in the committed
patch derby-5955-embed-restructure-04.



git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1427047 13f79535-47bb-0310-9956-ffa450edef68
DERBY-5988 Instability in DataSourceTest: some test fixture orderings makes test_jdbc4_1 fail 

Patch derby-5988: temporary measure to avoid tests failing
intermittently.  Could be removed when the issue is fixed, but IMHO
running fixtures in in a predicatable order is good anyway.



git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1427660 13f79535-47bb-0310-9956-ffa450edef68
DERBY-6022: Add a system procedure for (un)registering optional packages of tools.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1427859 13f79535-47bb-0310-9956-ffa450edef68
DERBY-5955 Prepare Derby to run with Compact Profiles (JEP 161) 

Trivial Javadoc fix.


git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1428130 13f79535-47bb-0310-9956-ffa450edef68
DERBY-6009 Need stricter checking of ORDER BY clause in VALUES expressions

This patch, derby-6009c, improves on the restriction that ORDER BY for
VALUES be limited to column numbers (SQL-92 style) only. It should now
give an understandable error message if anything else is tried. It
adds a new error message, "4287B" and test cases.



git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1428160 13f79535-47bb-0310-9956-ffa450edef68
DERBY-2516: Network Client allows execution of callable statement when one of the parameters is not set

Check that INOUT parameters are set, not only registered with registerOutParam().

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1428256 13f79535-47bb-0310-9956-ffa450edef68
DERBY-2699: Change how collation elements for ESCAPE clause are calculated

Since we only need to know whether or not there is a single collation
element, just look at the first two elements to see if we have none, one
or many.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1428305 13f79535-47bb-0310-9956-ffa450edef68
DERBY-6022: Add optional dbmd tool which creates wrapper routines for the DatabaseMetaData methods so that they can be invoked in queries.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1428506 13f79535-47bb-0310-9956-ffa450edef68
DERBY-6033: Remove the arbitrary limit on the number of parameters allowed for a Derby routine.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1428567 13f79535-47bb-0310-9956-ffa450edef68
DERBY-6033: Lift the arbitrary limit on the number of routine parameters

Test that stored procedures can have as many parameters as the Java
specification allows.

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