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/03/02 20:30:56 UTC
[jira] Created: (DERBY-4078) Document the SQL Standard routine
matching rules which Derby now supports
Document the SQL Standard routine matching rules which Derby now supports
-------------------------------------------------------------------------
Key: DERBY-4078
URL: https://issues.apache.org/jira/browse/DERBY-4078
Project: Derby
Issue Type: Improvement
Components: Documentation
Affects Versions: 10.5.0.0
Reporter: Rick Hillegas
Fix For: 10.5.0.0
The Reference Guide should explain the method resolution rules for functions and procedures. The full rules are described in the SignatureMapping.html webpage attached to DERBY-3652. At this point, Derby implements those rules for the datatypes which Derby supports, except for LOB arguments. That exception may be largely lifted as a result of the work being done on DERBY-4066.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-4078) Document the SQL Standard routine
matching rules which Derby now supports
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4078?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas updated DERBY-4078:
---------------------------------
Attachment: derby-4078-01-ab-refGuide.tar
derby-4078-01-ab-refGuide.diff
Thanks for the quick feedback, Kim. I have addressed all of your comments in the next rev of the patch, which I am attaching: derby-4078-01-ab-refGuide
> Document the SQL Standard routine matching rules which Derby now supports
> -------------------------------------------------------------------------
>
> Key: DERBY-4078
> URL: https://issues.apache.org/jira/browse/DERBY-4078
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.5.0.0
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Fix For: 10.5.0.0
>
> Attachments: derby-4078-01-aa-refGuide.diff, derby-4078-01-aa-refGuide.tar, derby-4078-01-ab-refGuide.diff, derby-4078-01-ab-refGuide.tar
>
>
> The Reference Guide should explain the method resolution rules for functions and procedures. The full rules are described in the SignatureMapping.html webpage attached to DERBY-3652. At this point, Derby implements those rules for the datatypes which Derby supports, except for LOB arguments. That exception may be largely lifted as a result of the work being done on DERBY-4066.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-4078) Document the SQL Standard routine
matching rules which Derby now supports
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12678969#action_12678969 ]
Kim Haase commented on DERBY-4078:
----------------------------------
Thanks -- the changes look fine. Looks like you moved the topic outside the "SQL language reference" section to the top level along with "SQL reserved words" and "Derby support for SQL-92 features" -- which probably makes sense. It is sort of on the borderline.
> Document the SQL Standard routine matching rules which Derby now supports
> -------------------------------------------------------------------------
>
> Key: DERBY-4078
> URL: https://issues.apache.org/jira/browse/DERBY-4078
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.5.0.0
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Fix For: 10.5.0.0
>
> Attachments: derby-4078-01-aa-refGuide.diff, derby-4078-01-aa-refGuide.tar, derby-4078-01-ab-refGuide.diff, derby-4078-01-ab-refGuide.tar
>
>
> The Reference Guide should explain the method resolution rules for functions and procedures. The full rules are described in the SignatureMapping.html webpage attached to DERBY-3652. At this point, Derby implements those rules for the datatypes which Derby supports, except for LOB arguments. That exception may be largely lifted as a result of the work being done on DERBY-4066.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-4078) Document the SQL Standard routine
matching rules which Derby now supports
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12680508#action_12680508 ]
Kim Haase commented on DERBY-4078:
----------------------------------
I think the Ref Guide location you chose is just fine, Rick.
+1 to resolve and close this issue.
> Document the SQL Standard routine matching rules which Derby now supports
> -------------------------------------------------------------------------
>
> Key: DERBY-4078
> URL: https://issues.apache.org/jira/browse/DERBY-4078
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.5.0.0
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Fix For: 10.5.0.0
>
> Attachments: derby-4078-01-aa-refGuide.diff, derby-4078-01-aa-refGuide.tar, derby-4078-01-ab-refGuide.diff, derby-4078-01-ab-refGuide.tar
>
>
> The Reference Guide should explain the method resolution rules for functions and procedures. The full rules are described in the SignatureMapping.html webpage attached to DERBY-3652. At this point, Derby implements those rules for the datatypes which Derby supports, except for LOB arguments. That exception may be largely lifted as a result of the work being done on DERBY-4066.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-4078) Document the SQL Standard routine
matching rules which Derby now supports
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12678766#action_12678766 ]
Kim Haase commented on DERBY-4078:
----------------------------------
This is an excellent writeup, Rick. It's very clearly written. Just a few comments/questions --
In the last bullet item in second bullet list, you might wrap the occurrences of "n" in italics, since they are placeholders.
Example of argument matching: My first thought is, if the created function matches all of those methods, does that mean that such a declaration would cause an error when the function is invoked? Or maybe you could say "would match" instead of "matches", and then note that java.lang.Math provides only the first form of the method and therefore there's no ambiguity?
Is there a particular rationale for the order of types in the table? Just for consistency you might want to use the order in http://db.apache.org/derby/docs/dev/ref/rrefsqlj58560.html, which groups the types similarly but in a slightly different order.
I can see that it is a little hard to figure out where to place the new topic. I was thinking that it would make sense either to put it after the "Statements" section (where CREATE PROCEDURE and CREATE FUNCTION are introduced) or after the "Data types" section. But you probably have a reason for placing it where you did (between "JOIN operations" and "Queries").
> Document the SQL Standard routine matching rules which Derby now supports
> -------------------------------------------------------------------------
>
> Key: DERBY-4078
> URL: https://issues.apache.org/jira/browse/DERBY-4078
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.5.0.0
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Fix For: 10.5.0.0
>
> Attachments: derby-4078-01-aa-refGuide.diff, derby-4078-01-aa-refGuide.tar
>
>
> The Reference Guide should explain the method resolution rules for functions and procedures. The full rules are described in the SignatureMapping.html webpage attached to DERBY-3652. At this point, Derby implements those rules for the datatypes which Derby supports, except for LOB arguments. That exception may be largely lifted as a result of the work being done on DERBY-4066.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-4078) Document the SQL Standard routine
matching rules which Derby now supports
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4078?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas updated DERBY-4078:
---------------------------------
Attachment: derby-4078-01-aa-refGuide.tar
derby-4078-01-aa-refGuide.diff
Attaching derby-4078-01-aa-refGuide.diff and a corresponding tarball of generated html pages: derby-4078-01-aa-refGuide.tar. This patch adds a new section to the Reference Guide, explaining how Derby matches SQL routines to Java methods.
Touches the following files:
A src/ref/rrefsqljargmatching.dita
This new section explains how Derby matches SQL signatures to Java signatures.
M src/ref/rrefcreateprocedurestatement.dita
M src/ref/rrefcreatefunctionstatement.dita
These pages now refer the reader to the signature matching section.
M src/ref/refderby.ditamap
Adds the new section to the table of contents.
> Document the SQL Standard routine matching rules which Derby now supports
> -------------------------------------------------------------------------
>
> Key: DERBY-4078
> URL: https://issues.apache.org/jira/browse/DERBY-4078
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.5.0.0
> Reporter: Rick Hillegas
> Fix For: 10.5.0.0
>
> Attachments: derby-4078-01-aa-refGuide.diff, derby-4078-01-aa-refGuide.tar
>
>
> The Reference Guide should explain the method resolution rules for functions and procedures. The full rules are described in the SignatureMapping.html webpage attached to DERBY-3652. At this point, Derby implements those rules for the datatypes which Derby supports, except for LOB arguments. That exception may be largely lifted as a result of the work being done on DERBY-4066.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-4078) Document the SQL Standard routine
matching rules which Derby now supports
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12679255#action_12679255 ]
Rick Hillegas commented on DERBY-4078:
--------------------------------------
Thanks for the review, Kim. I have committed derby-4078-01-ab-refGuide at subversion revision 750519.
I don't have any clear theory about the best place to put this material in the Reference Guide. Feel free to move this section around if you have even a mild preference for some better location. Thanks.
> Document the SQL Standard routine matching rules which Derby now supports
> -------------------------------------------------------------------------
>
> Key: DERBY-4078
> URL: https://issues.apache.org/jira/browse/DERBY-4078
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.5.0.0
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Fix For: 10.5.0.0
>
> Attachments: derby-4078-01-aa-refGuide.diff, derby-4078-01-aa-refGuide.tar, derby-4078-01-ab-refGuide.diff, derby-4078-01-ab-refGuide.tar
>
>
> The Reference Guide should explain the method resolution rules for functions and procedures. The full rules are described in the SignatureMapping.html webpage attached to DERBY-3652. At this point, Derby implements those rules for the datatypes which Derby supports, except for LOB arguments. That exception may be largely lifted as a result of the work being done on DERBY-4066.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (DERBY-4078) Document the SQL Standard routine
matching rules which Derby now supports
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4078?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas resolved DERBY-4078.
----------------------------------
Resolution: Fixed
Thanks, Kim.
> Document the SQL Standard routine matching rules which Derby now supports
> -------------------------------------------------------------------------
>
> Key: DERBY-4078
> URL: https://issues.apache.org/jira/browse/DERBY-4078
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.5.0.0
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Fix For: 10.5.0.0
>
> Attachments: derby-4078-01-aa-refGuide.diff, derby-4078-01-aa-refGuide.tar, derby-4078-01-ab-refGuide.diff, derby-4078-01-ab-refGuide.tar
>
>
> The Reference Guide should explain the method resolution rules for functions and procedures. The full rules are described in the SignatureMapping.html webpage attached to DERBY-3652. At this point, Derby implements those rules for the datatypes which Derby supports, except for LOB arguments. That exception may be largely lifted as a result of the work being done on DERBY-4066.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-4078) Document the SQL Standard routine
matching rules which Derby now supports
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4078?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas updated DERBY-4078:
---------------------------------
Derby Info: [Patch Available]
> Document the SQL Standard routine matching rules which Derby now supports
> -------------------------------------------------------------------------
>
> Key: DERBY-4078
> URL: https://issues.apache.org/jira/browse/DERBY-4078
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.5.0.0
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Fix For: 10.5.0.0
>
> Attachments: derby-4078-01-aa-refGuide.diff, derby-4078-01-aa-refGuide.tar
>
>
> The Reference Guide should explain the method resolution rules for functions and procedures. The full rules are described in the SignatureMapping.html webpage attached to DERBY-3652. At this point, Derby implements those rules for the datatypes which Derby supports, except for LOB arguments. That exception may be largely lifted as a result of the work being done on DERBY-4066.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Assigned: (DERBY-4078) Document the SQL Standard routine
matching rules which Derby now supports
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4078?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas reassigned DERBY-4078:
------------------------------------
Assignee: Rick Hillegas
> Document the SQL Standard routine matching rules which Derby now supports
> -------------------------------------------------------------------------
>
> Key: DERBY-4078
> URL: https://issues.apache.org/jira/browse/DERBY-4078
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.5.0.0
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Fix For: 10.5.0.0
>
> Attachments: derby-4078-01-aa-refGuide.diff, derby-4078-01-aa-refGuide.tar
>
>
> The Reference Guide should explain the method resolution rules for functions and procedures. The full rules are described in the SignatureMapping.html webpage attached to DERBY-3652. At this point, Derby implements those rules for the datatypes which Derby supports, except for LOB arguments. That exception may be largely lifted as a result of the work being done on DERBY-4066.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (DERBY-4078) Document the SQL Standard routine
matching rules which Derby now supports
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4078?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas closed DERBY-4078.
--------------------------------
> Document the SQL Standard routine matching rules which Derby now supports
> -------------------------------------------------------------------------
>
> Key: DERBY-4078
> URL: https://issues.apache.org/jira/browse/DERBY-4078
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.5.1.1
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Fix For: 10.5.1.1
>
> Attachments: derby-4078-01-aa-refGuide.diff, derby-4078-01-aa-refGuide.tar, derby-4078-01-ab-refGuide.diff, derby-4078-01-ab-refGuide.tar
>
>
> The Reference Guide should explain the method resolution rules for functions and procedures. The full rules are described in the SignatureMapping.html webpage attached to DERBY-3652. At this point, Derby implements those rules for the datatypes which Derby supports, except for LOB arguments. That exception may be largely lifted as a result of the work being done on DERBY-4066.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.