Hi Milosz
The requiresCastForMathFunctions was true. When set to false, I get the same
error, without the CASTs:
Function requires argument to be numeric. {SELECT t0.id, t1.id, t1.city,
t1.phoneNumber, t1.postalCode, t1.state, t1.streetAddress, t0.NAME0 FROM
IDC_Company t0 INNER JOIN IDC_Address t1 ON t0.ADDRESS_ID = t1.id WHERE
(((POSITION((t1.city) IN (SUBSTRING(?, ((? - ?) + 1)))) - 1 + (? - ?)) + ?) >
?)} [code=330897, state=42000]"
I guess that's why I set the "requiresCast..." property, but it doesn't seem to
be working!
Alan
-----Original Message-----
From: Milosz Tylenda [mailto:[email protected]]
Sent: 10 June 2009 13:18
To: [email protected]
Subject: Re: SUBSTRING() arguments
Hi Alan,
What is the value of requiresCastForMathFunctions in your dictionary? Have you
tried running it with requiresCastForMathFunctions=false?
Greetings,
Milosz
> Hi All
>
> While testing the Ingres OpenJPA dictionary that I have been developing, I
> encountered a few test failures relating to arguments to the substring
> function.
>
> Ingres currently doesn't have a substring function that accepts a BIGINT as
> the index argument. This seems reasonable, since VARCHARs are limited to
> 2000 characters anyway.
>
> The following tests fail as they are trying to use a BIGINT argument to
> SUBSTRING.
>
> *) org.apache.openjpa.persistence.jpql.functions.TestEJBQLFunction
> .testConcatSubStringFunc
> *) org.apache.openjpa.persistence.models.company.CompanyModelTest
> .testBasicQueries
> (This is an abstract class implemented 4 times by various models)
>
> I looked at the code and I couldn't figure out why the framework was sending
> the index as a BIGINT. Can anyone advise?
>
> Here is the error returned, although I think it is really coming from the
> Ingres Database.
>
> Function requires argument to be numeric. {SELECT t0.id, t0.DTYPE,
> t0.firstName, t2.id, t2.city, t2.phoneNumber, t2.postalCode, t2.state,
> t2.streetAddress, t0.lastName, t1.id, t3.id, t3.city, t3.phoneNumber,
> t3.postalCode, t3.state, t3.streetAddress, t1.name, t0.hireDate, t4.id,
> t4.DTYPE, t4.firstName, t4.HOMEADDRESS_ID, t4.lastName, t4.COMPANY_ID,
> t4.hireDate, t4.title, t4.salary, t0.title, t0.wage, t0.weeklyHours FROM
> BAS_Person t0 INNER JOIN BAS_Company t1 ON t0.COMPANY_ID = t1.id LEFT OUTER
> JOIN BAS_Address t2 ON t0.HOMEADDRESS_ID = t2.id LEFT OUTER JOIN BAS_Person
> t4 ON t0.MANAGER_ID = t4.id LEFT OUTER JOIN BAS_Address t3 ON t1.ADDRESS_ID
> = t3.id WHERE (((POSITION((t1.name) IN (SUBSTRING(?, ((CAST(? AS BIGINT) -
> CAST(? AS BIGINT)) + 1)))) - 1 + (CAST(? AS BIGINT) - CAST(? AS BIGINT))) +
> ?) > ?) AND t0.DTYPE = ?} [code=330897, state=42000]
>
> Alan
>
>
