Can you open a JIRA issue and provide a patch?
It would be better to provide the patch by creating translators specific for
the Derby DBAdaptor rather than applying it against the file shared by all
DBAdaptors. You can reference the OpenBase adaptor as an example of how to
provide custom SQL for performing LIKE operations, as it also has custom
LIKE sql.
-Mike
Valentin Bosilkov <vbosilko..cygen.com> wrote:
> so ... I find this solution ....
>
>
> ASTLikeIgnoreCase.java
>
> public ASTLikeIgnoreCase(ASTPath path, Object pattern) {
> super(ExpressionParserTreeConstants.JJTLIKEIGNORECASE, false);
> jjtAddChild(path, 0);
> jjtAddChild(wrapChild(((String)pattern).toUpperCase()), 1);
> }
>
> QualifierTranslator
>
>
> public void finishedChild(Expression node, int childIndex, boolean
hasMoreChildren) {
>
> line : 271 :
>
> case Expression.LIKE_IGNORE_CASE :
> buf.append(") LIKE UPPER(");
> break;
>
> becomes :
> case Expression.LIKE_IGNORE_CASE :
> buf.append(") LIKE (");
> break;
>
>
>
>
> is it correct OR you can give me other "smarter" solution?
>
>
> P.S.
> probably there is same mistake with notLikeIgnoreCase
This archive was generated by hypermail 2.0.0 : Tue Aug 09 2005 - 17:50:23 EDT