[DERBY-6047] NPE in StaticCallMethod#coerceMethodParameter with a constant argument to INOUT parameter

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 10.10.2.0, 10.11.1.1
• Component/s: SQL
• Labels: derby_backport_reject_10_8
• Bug behavior facts: Regression
• Assignee: Richard N. Hillegas
• Reporter: Dag H. Wanvik
• Created: 18/Jan/13 03:38
• Updated: 16/Apr/14 02:40
• Resolved: 14/Jun/13 16:38

Description

The following repro shows the problem (provided by Holger Rehn, cf. issue DERBY-5945).

sta.execute( "create procedure PROC( inout x int ) " +
"parameter style java modifies sql data language java " +
"external name 'DUMMY.PROC'" );
sta.execute( "

{call PROC(1)}

" );

gives NPE on trunk (even before the fixes introduced for DERBY-5945), but not on 10.9, so I believe it's a regression:

:
Caused by: java.lang.NullPointerException
...sql.compile.StaticMethodCallNode.coerceMethodParameter(StaticMethodCallNode.java:702)
...sql.compile.StaticMethodCallNode.resolveRoutine(StaticMethodCallNode.java:620)
...sql.compile.StaticMethodCallNode.bindExpression(StaticMethodCallNode.java:210)
...sql.compile.JavaToSQLValueNode.bindExpression(JavaToSQLValueNode.java:237)
...sql.compile.CallStatementNode.bindStatement(CallStatementNode.java:126)
...sql.GenericStatement.prepMinion(GenericStatement.java:400)
:

Issue Links

• relates to: DERBY-3069 Derby does not resolve functions bound to methods with varargs.