You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Rick Hillegas (JIRA)" <ji...@apache.org> on 2009/12/11 14:33:18 UTC
[jira] Created: (DERBY-4470) Forbid ordering operations on UDTs
Forbid ordering operations on UDTs
----------------------------------
Key: DERBY-4470
URL: https://issues.apache.org/jira/browse/DERBY-4470
Project: Derby
Issue Type: Bug
Components: SQL
Affects Versions: 10.6.0.0
Reporter: Rick Hillegas
Knut has provided an example of an ordering operation which succeeds on a UDT in his Dec. 11, 2009 comment on DERBY-651.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-4470) Forbid ordering operations on UDTs
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4470?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas updated DERBY-4470:
---------------------------------
Attachment: derby-4470-01-aa-forbidOrderingOperations.diff
Attaching derby-4470-01-aa-forbidOrderingOperations.diff. This prevents UDTs from being used in contexts which involve ordering operations. Tests passed cleanly for me.
This patch makes a couple changes:
1) Disables the logic which allows ordering operations on user defined types which implement Comparable. At a later date, we may want to support this useful functionality. That is, we may want to implement the SQL Standard syntax for UDT ordering (see part 2 of the Standard, section 11.56 <user-defined ordering definition> and part 13 of the Standard, section 9.11 <user-defined ordering definition>):
CREATE ORDERING FOR typeName ORDER FULL BY RELATIVE WITH COMPARABLE INTERFACE
However, that is an extra chunk of work which will not be included in the first rev of UDTs.
2) Prevents you from binding a UDT to a Java class which is already used to back one of our system-supplied types (e.g., java.lang.Integer). This limitation patches around the problem that various parts of the code assume a tight correspondence between those classes and the system-supplied types. If we want to lift this limitation later, we must be cautious: the assumptions are scattered across the code and it is hard to think up a systematic way to find them all.
Touches the following files:
------------
M java/engine/org/apache/derby/impl/sql/compile/CreateAliasNode.java
Support for (2).
------------
M java/engine/org/apache/derby/iapi/types/TypeId.java
Support for both (1) and (2).
------------
M java/engine/org/apache/derby/iapi/types/DataTypeDescriptor.java
Support for (1).
------------
M java/engine/org/apache/derby/loc/messages.xml
M java/shared/org/apache/derby/shared/common/reference/SQLState.java
New error messages.
------------
M java/testing/org/apache/derbyTesting/functionTests/tests/lang/GeneratedColumnsHelper.java
M java/testing/org/apache/derbyTesting/functionTests/tests/lang/UDTTest.java
New tests.
> Forbid ordering operations on UDTs
> ----------------------------------
>
> Key: DERBY-4470
> URL: https://issues.apache.org/jira/browse/DERBY-4470
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.6.0.0
> Reporter: Rick Hillegas
> Attachments: derby-4470-01-aa-forbidOrderingOperations.diff
>
>
> Knut has provided an example of an ordering operation which succeeds on a UDT in his Dec. 11, 2009 comment on DERBY-651.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-4470) Forbid ordering operations on UDTs
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4470?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12832132#action_12832132 ]
Rick Hillegas commented on DERBY-4470:
--------------------------------------
Committed derby-4470-01-aa-forbidOrderingOperations.diff at subversion revision 908635.
> Forbid ordering operations on UDTs
> ----------------------------------
>
> Key: DERBY-4470
> URL: https://issues.apache.org/jira/browse/DERBY-4470
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.6.0.0
> Reporter: Rick Hillegas
> Attachments: derby-4470-01-aa-forbidOrderingOperations.diff
>
>
> Knut has provided an example of an ordering operation which succeeds on a UDT in his Dec. 11, 2009 comment on DERBY-651.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (DERBY-4470) Forbid ordering operations on UDTs
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4470?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas closed DERBY-4470.
--------------------------------
> Forbid ordering operations on UDTs
> ----------------------------------
>
> Key: DERBY-4470
> URL: https://issues.apache.org/jira/browse/DERBY-4470
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.6.1.0
> Reporter: Rick Hillegas
> Attachments: derby-4470-01-aa-forbidOrderingOperations.diff
>
>
> Knut has provided an example of an ordering operation which succeeds on a UDT in his Dec. 11, 2009 comment on DERBY-651.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-4470) Forbid ordering operations on UDTs
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4470?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas updated DERBY-4470:
---------------------------------
Issue & fix info: [Patch Available]
> Forbid ordering operations on UDTs
> ----------------------------------
>
> Key: DERBY-4470
> URL: https://issues.apache.org/jira/browse/DERBY-4470
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.6.0.0
> Reporter: Rick Hillegas
> Attachments: derby-4470-01-aa-forbidOrderingOperations.diff
>
>
> Knut has provided an example of an ordering operation which succeeds on a UDT in his Dec. 11, 2009 comment on DERBY-651.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (DERBY-4470) Forbid ordering operations on UDTs
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4470?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas resolved DERBY-4470.
----------------------------------
Resolution: Fixed
> Forbid ordering operations on UDTs
> ----------------------------------
>
> Key: DERBY-4470
> URL: https://issues.apache.org/jira/browse/DERBY-4470
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.6.0.0
> Reporter: Rick Hillegas
> Attachments: derby-4470-01-aa-forbidOrderingOperations.diff
>
>
> Knut has provided an example of an ordering operation which succeeds on a UDT in his Dec. 11, 2009 comment on DERBY-651.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.