DERBY-6438: Explicitly grant SocketPermission "listen" in default server policy

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1553081 13f79535-47bb-0310-9956-ffa450edef68
DERBY-6429: Bring privilege checks on UPDATE statements into closer alignment with the SQL Standard; tests passed cleanly on derby-6429-01-af-privilegeFilters.diff.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1553197 13f79535-47bb-0310-9956-ffa450edef68
DERBY-6440: Drop connection to foreign database when foreignViews optional tool is unloaded.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1553269 13f79535-47bb-0310-9956-ffa450edef68
DERBY-6441: Add ORDER BY clauses to a number of queries in GrantRevokeDDLTest in order to force deterministic results; checks in derby-6441-01-addOrderByClauses.diff.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1553280 13f79535-47bb-0310-9956-ffa450edef68
DERBY-532 Support deferrable constraints

Patch derby-532-allow-pk-unique-1, which opens up for using deferrable
constraints for primary key and unique constraints, i.e. it is no
longer required that the special property "derby.constraintsTesting"
be used for those constraints, since the implementation is complete
modulo bugs. Upgrade tests still remain to be built, though.

For foreign key and check constraints as well as for "not enforced",
the property will still required till the implementation for those is
completed.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1555006 13f79535-47bb-0310-9956-ffa450edef68
DERBY-5866: Triggers fire out of order

Make sure the creation timestamp of a newly created trigger is higher
than the timestamps of the existing triggers on the same table. If it
is not higher, the triggers may fire in the wrong order. If the
current timestamp is not higher than the timestamp of the previous
trigger defined on the table, the new trigger now gets a creation
timestamp that is one millisecond higher than the creation timestamp
of the previous trigger.

git-svn-id: https://svn.apache.org/repos/asf/db/derby/code/trunk@1555702 13f79535-47bb-0310-9956-ffa450edef68
DERBY-5866: Triggers fire out of order

In order to avoid ambiguities around switch from daylight saving time
to standard time, and other time zone changes, store the trigger
creation timestamps in Coordinated Universal Time (UTC) instead of the
local time zone.

Only use UTC if the database has been upgraded to 10.11 format, so
that the change won't cause problems on downgrade.

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