I have doubts I can make GOOD patch ... it'll be better someone else to do
it :PPP
or I can try to fix it my own
From: "Mike Kienenberger" <mkienen..laska.net>
To: <cayenne-use..bjectstyle.org>
Cc: <vbosilko..cygen.com>
Sent: Wednesday, August 10, 2005 12:53 AM
Subject: Re: derby + cayenne (ignoreCase)
> 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 : Thu Aug 11 2005 - 03:49:53 EDT