Patrick,
The VARCHAR(1000) was added in the AbstractDB2Dictionary. See the following
constants:
toUpperCaseFunction = "UPPER(CAST({0} AS VARCHAR(1000)))";
toLowerCaseFunction = "LOWER(CAST({0} AS VARCHAR(1000)))";
stringLengthFunction = "LENGTH({0})";
concatenateFunction = "(CAST({0} AS VARCHAR(1000)))||"
+ "(CAST({1} AS VARCHAR(1000)))";
The code may miss something outside these functions. Please send your test
case to me so I can understand the missing. Your change looks good.
Thanks,
Teresa
On 9/6/07, Patrick Linskey (JIRA) <[EMAIL PROTECTED]> wrote:
>
>
> [
> https://issues.apache.org/jira/browse/OPENJPA-354?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel]
>
> Patrick Linskey updated OPENJPA-354:
> ------------------------------------
>
> Attachment: OPENJPA-354.patch
>
> > DB2 casts might not incorporate VARCHAR lengths often enough
> > ------------------------------------------------------------
> >
> > Key: OPENJPA-354
> > URL: https://issues.apache.org/jira/browse/OPENJPA-354
> > Project: OpenJPA
> > Issue Type: Bug
> > Affects Versions: 0.9.0, 0.9.6, 0.9.7, 1.0.0
> > Reporter: Patrick Linskey
> > Attachments: OPENJPA-354.patch
> >
> >
> > Based on code inspection, it looks like OpenJPA might not be including
> VARCHAR lengths often enough.
>
> --
> This message is automatically generated by JIRA.
> -
> You can reply to this email to add a comment to the issue online.
>
>
