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 "Holger Rehn (JIRA)" <ji...@apache.org> on 2012/10/11 20:01:04 UTC
[jira] [Created] (DERBY-5945) Inappropriate error message when
calling an existing procedure with non-matching parameters
Holger Rehn created DERBY-5945:
----------------------------------
Summary: Inappropriate error message when calling an existing procedure with non-matching parameters
Key: DERBY-5945
URL: https://issues.apache.org/jira/browse/DERBY-5945
Project: Derby
Issue Type: Bug
Reporter: Holger Rehn
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (DERBY-5945) Inappropriate error message when
calling an existing procedure with non-matching parameters
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5945?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13478918#comment-13478918 ]
Dag H. Wanvik commented on DERBY-5945:
--------------------------------------
For discussion of patches up and including derby-2927-5945-diag-3, see DERBY-2927.
> Inappropriate error message when calling an existing procedure with non-matching parameters
> -------------------------------------------------------------------------------------------
>
> Key: DERBY-5945
> URL: https://issues.apache.org/jira/browse/DERBY-5945
> Project: Derby
> Issue Type: Bug
> Reporter: Holger Rehn
> Attachments: derby-2927-5945-diag-2.diff, derby-2927-5945-diag-2.stat, derby-2927-5945-diag-3.diff, derby-2927-5945-diag-3.stat, derby-2927-5945-diag.diff, derby-2927-5945-diag.stat
>
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (DERBY-5945) Inappropriate error message when
calling an existing procedure with non-matching parameters
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5945?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dag H. Wanvik updated DERBY-5945:
---------------------------------
Attachment: derby-2927-5945-diag-3.stat
derby-2927-5945-diag-3.diff
derby-2927-5945-diag-2.stat
derby-2927-5945-diag-2.diff
derby-2927-5945-diag.stat
derby-2927-5945-diag.diff
Moved diagnostic patches over from DERBY-2927.
> Inappropriate error message when calling an existing procedure with non-matching parameters
> -------------------------------------------------------------------------------------------
>
> Key: DERBY-5945
> URL: https://issues.apache.org/jira/browse/DERBY-5945
> Project: Derby
> Issue Type: Bug
> Reporter: Holger Rehn
> Attachments: derby-2927-5945-diag-2.diff, derby-2927-5945-diag-2.stat, derby-2927-5945-diag-3.diff, derby-2927-5945-diag-3.stat, derby-2927-5945-diag.diff, derby-2927-5945-diag.stat
>
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (DERBY-5945) Inappropriate error message when
calling an existing procedure with non-matching parameters
Posted by "Holger Rehn (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5945?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13474382#comment-13474382 ]
Holger Rehn commented on DERBY-5945:
------------------------------------
When a procedure is created and later called with non-matching parameters (namely with a return value), Derby raises an error like
'PROC' is not recognized as a function or procedure.
But the procedure exists. If trying to re-create the procedure, Derby correctly throws an error "PROCEDURE 'PROC' already exists.", and the procedure can be dropped via "drop procedure PROC".
to reproduce just execute...
"CREATE PROCEDURE PROC( inout ret in ) parameter style java modifies sql data language java external name 'DBProcs.PROC'"
"{?=call PROC(1)}"
The error message should point out, that either the procedure cannot return a value or that no matching procedure can be found.
Cheers,
momo
> Inappropriate error message when calling an existing procedure with non-matching parameters
> -------------------------------------------------------------------------------------------
>
> Key: DERBY-5945
> URL: https://issues.apache.org/jira/browse/DERBY-5945
> Project: Derby
> Issue Type: Bug
> Reporter: Holger Rehn
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Assigned] (DERBY-5945) Inappropriate error message when
calling a procedure as a function (as if it had a return value)
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5945?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dag H. Wanvik reassigned DERBY-5945:
------------------------------------
Assignee: Dag H. Wanvik
> Inappropriate error message when calling a procedure as a function (as if it had a return value)
> ------------------------------------------------------------------------------------------------
>
> Key: DERBY-5945
> URL: https://issues.apache.org/jira/browse/DERBY-5945
> Project: Derby
> Issue Type: Improvement
> Components: JDBC, SQL
> Reporter: Holger Rehn
> Assignee: Dag H. Wanvik
> Priority: Minor
> Attachments: derby-2927-5945-diag-2.diff, derby-2927-5945-diag-2.stat, derby-2927-5945-diag-3.diff, derby-2927-5945-diag-3.stat, derby-2927-5945-diag.diff, derby-2927-5945-diag.stat
>
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (DERBY-5945) Inappropriate error message when
calling a procedure as a function (as if it had a return value)
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5945?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dag H. Wanvik updated DERBY-5945:
---------------------------------
Component/s: SQL
JDBC
Priority: Minor (was: Major)
Issue & fix info: Patch Available
Bug behavior facts: Seen in production
Issue Type: Improvement (was: Bug)
Summary: Inappropriate error message when calling a procedure as a function (as if it had a return value) (was: Inappropriate error message when calling an existing procedure with non-matching parameters)
> Inappropriate error message when calling a procedure as a function (as if it had a return value)
> ------------------------------------------------------------------------------------------------
>
> Key: DERBY-5945
> URL: https://issues.apache.org/jira/browse/DERBY-5945
> Project: Derby
> Issue Type: Improvement
> Components: JDBC, SQL
> Reporter: Holger Rehn
> Priority: Minor
> Attachments: derby-2927-5945-diag-2.diff, derby-2927-5945-diag-2.stat, derby-2927-5945-diag-3.diff, derby-2927-5945-diag-3.stat, derby-2927-5945-diag.diff, derby-2927-5945-diag.stat
>
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira