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 "Oleksandr Alesinskyy (JIRA)" <de...@db.apache.org> on 2006/10/10 12:39:22 UTC
[jira] Created: (DERBY-1950) Invalid 39004 message when function
has primitive type parameter but null is passed into String type parameter
Invalid 39004 message when function has primitive type parameter but null is passed into String type parameter
--------------------------------------------------------------------------------------------------------------
Key: DERBY-1950
URL: http://issues.apache.org/jira/browse/DERBY-1950
Project: Derby
Issue Type: Bug
Affects Versions: 10.1.3.1
Environment: N/A
Reporter: Oleksandr Alesinskyy
Priority: Minor
create function countDelimitersBefore(
str varchar(512),
delimiter char(1),
pos integer)
returns integer
language java parameter style java
external name 'de.ntec.common.util.DBStringUtils.countDelimitersBefore';
select countDelimitersBefore(someColumn,'/',1) from someTable;
where value of SomeColumn is NULL inappropriatly results in
SQL State = 39004 SQL Code = -1 SQL Message = A NULL value cannot be passed to a method which takes a parameter of primitive type 'int'. Exception message = org.apache.derby.client.am.SqlException: A NULL value cannot be passed to a method which takes a parameter of primitive type 'int'.
As far as I can see in 10.2.1.6 this bug is fixed.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Resolved: (DERBY-1950) Invalid 39004 message when function
has primitive type parameter but null is passed into String type parameter
Posted by "Daniel John Debrunner (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1950?page=all ]
Daniel John Debrunner resolved DERBY-1950.
------------------------------------------
Resolution: Invalid
Derby Info: (was: [Regression])
As indicated by reported.
> Invalid 39004 message when function has primitive type parameter but null is passed into String type parameter
> --------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1950
> URL: http://issues.apache.org/jira/browse/DERBY-1950
> Project: Derby
> Issue Type: Bug
> Affects Versions: 10.1.3.1
> Environment: N/A
> Reporter: Oleksandr Alesinskyy
> Priority: Minor
>
> create function countDelimitersBefore(
> str varchar(512),
> delimiter char(1),
> pos integer)
> returns integer
> language java parameter style java
> external name 'de.ntec.common.util.DBStringUtils.countDelimitersBefore';
> select countDelimitersBefore(someColumn,'/',1) from someTable;
> where value of SomeColumn is NULL inappropriatly results in
> SQL State = 39004 SQL Code = -1 SQL Message = A NULL value cannot be passed to a method which takes a parameter of primitive type 'int'. Exception message = org.apache.derby.client.am.SqlException: A NULL value cannot be passed to a method which takes a parameter of primitive type 'int'.
> As far as I can see in 10.2.1.6 this bug is fixed.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira