[jira] [Created] (OPENJPA-2729) problem with ToUperCase and ToLowerCase

["Patrice DUROUX (JIRA)" <ji...@apache.org>]

Patrice DUROUX created OPENJPA-2729:
---------------------------------------

             Summary: problem with ToUperCase and ToLowerCase
                 Key: OPENJPA-2729
                 URL: https://issues.apache.org/jira/browse/OPENJPA-2729
             Project: OpenJPA
          Issue Type: Bug
          Components: query
    Affects Versions: 2.4.2
         Environment: MySQL
            Reporter: Patrice DUROUX


Hi,

An exception is thrown in the following method (here the one of ToLowerCase):

when the getValue() is a PCPath and ((PCPath) getValue()).getFieldMapping(state).getColumns()[0])

throws:

{{java.lang.ArrayIndexOutOfBoundsException: 0}}{{ org.apache.openjpa.jdbc.kernel.exps.ToLowerCase.appendTo(ToLowerCase.java:47) org.apache.openjpa.jdbc.kernel.exps.MatchesExpression.appendTo(MatchesExpression.java:97) org.apache.openjpa.jdbc.kernel.exps.AndExpression.appendTo(AndExpression.java:59)}}

 

 

{{    public void appendTo(Select sel, ExpContext ctx, ExpState state, }}
{{        SQLBuffer buf, int index) {}}

{{        DBDictionary dict = ctx.store.getDBDictionary();}}
{{        String func = dict.toLowerCaseFunction;}}
{{        dict.assertSupport(func != null, "ToLowerCaseFunction");}}
{{        if (getValue() instanceof PCPath) {}}
{{            func = dict.getCastFunction(getValue(), func, ((PCPath) getValue()).getFieldMapping(state).getColumns()[0]);}}
{{        } else {}}
{{            func = dict.getCastFunction(getValue(), func);}}
{{        }}}

{{        int idx = func.indexOf("\{0}");}}
{{        buf.append(func.substring(0, idx));}}
{{        getValue().appendTo(sel, ctx, state, buf, index);}}
{{        buf.append(func.substring(idx + 3));}}
{{    }}}

The part of code that generate the exception is:

        Path<String> authorPath = from.join("references").join("authors");
        predicateList.add(cb.like(cb.lower(authorPath), cb.literal('%' + value + '%')));

If I change this code to use another string function like trim(), it works (ie. the SQL query is correctly generated).

 

Regards,

Patrice

ps: remark that the only uses of DBDictionary.getCastFunction(Val val, String func, Column col) are for those classes.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)