DERBY-3155: Propagate RowLocations out of index probes as necessary for the driving left join of a MERGE statement; commits derby-3155-26-aa-copyRowLocationForIndexScans.diff.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1569396 13f79535-47bb-0310-9956-ffa450edef68
DERBY-6459  Remove Class.forName calls that load JDBC driver from Derby samples/demos

Modified 9 Java files and 7 documentation files, and replaced 2 documentation text files with HTML files.

Patch: DERBY-6459-2.diff


git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1569470 13f79535-47bb-0310-9956-ffa450edef68
DERBY-3155: Point matching refinement clauses into the row returned by the driving left join of the MERGE statement; commit derby-3155-27-aa-adjustMatchingRefinements.diff.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1569521 13f79535-47bb-0310-9956-ffa450edef68
DERBY-6482: Revamp the VTI demo to behave more like the other demos; commit derby-6482-01-aa-moveResources.diff.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1569611 13f79535-47bb-0310-9956-ffa450edef68
DERBY-6459: Fix SimpleApp test failures

Update canon to match the changed demo.

Make the simpledemo suite use old-style JDBC driver autoloading (by
setting the jdbc.drivers property) so that it succeeds when running
from classes without reintroducing Class.forName() in SimpleApp.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1569662 13f79535-47bb-0310-9956-ffa450edef68
DERBY-4160: getMetaData().getIndexInfo crashes with "ERROR X0Y68: Column 'PARAM1' already exists."

Clear out any existing parameters for the SPS before attempting to
store the parameters in SYS.SYSCOLUMNS. Existing parameters could be
there if the first attempt to store the SPS failed midway due to a
lock conflict. Ideally, any changes made by the failed attempt should
have been rolled back, but Derby doesn't currently allow rolling back
nested transactions without also rolling back the parent transaction.
Don't use initiallyCompilable to separate between first and subsequent compilation
Roll back nested tx to savepoint so that it doesn't leave a partial SPS