[
https://issues.apache.org/jira/browse/DERBY-651?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rick Hillegas updated DERBY-651:
--------------------------------
Attachment: derby-651-10-aa-usageTriggers.diff
Attaching derby-651-10-aa-usageTriggers.diff. This patch adds regression tests
to verify that you can't drop a UDT or revoke USAGE on it if that would orphan
a trigger. Committed at subversion revision 892354.
Touches the following files:
M
java/testing/org/apache/derbyTesting/functionTests/tests/lang/UDTTest.java
Factored out some common code into method verifyDropRestrictions() and added
test case for triggers.
M
java/testing/org/apache/derbyTesting/functionTests/tests/lang/UDTPermsTest.java
Added test case for revoking USAGE privilege on a type needed by a trigger.
> Re-enable the storing of java objects in the database
> -----------------------------------------------------
>
> Key: DERBY-651
> URL: https://issues.apache.org/jira/browse/DERBY-651
> Project: Derby
> Issue Type: Improvement
> Components: SQL
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Attachments: derby-651-01-aa-basicCreateDropType.diff,
> derby-651-02-af-udtColumnsRetvalsParams.diff,
> derby-651-03-aa-udttestInstability.diff, derby-651-04-aa-javadoc.diff,
> derby-651-05-ac-dependencyTable.diff, derby-651-06-aa-dropTable.diff,
> derby-651-07-aa-dependencyView.diff, derby-651-08-aa-dependencyRoutines.diff,
> derby-651-09-ac-usagePrivilege.diff, derby-651-10-aa-usageTriggers.diff,
> UserDefinedTypes.html, UserDefinedTypes.html, UserDefinedTypes.html,
> UserDefinedTypes.html
>
>
> Islay Symonette, in an email thread called "Storing Java Objects in a table"
> on October 26, 2005 requests the ability to store java objects in the
> database.
> Old releases of Cloudscape allow users to declare a column's type to be a
> Serializable class. This feature was removed from Derby because the syntax
> was non-standard. However, most of the machinery to support objects
> serialized to columns is still in Derby and is even used in system tables. We
> need to agree on some standard syntax here and re-expose this useful feature.
> Some subset of the ANSI adt syntax, cumbersome as it is, would do.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
