You are viewing a plain text version of this content. The canonical link for it is here.

Posted to jdo-dev@db.apache.org by "Craig Russell (JIRA)" <ji...@apache.org> on 2005/10/15 07:16:48 UTC

[jira] Commented: (JDO-176) JPOX fails when a query calls String.matches

    [ http://issues.apache.org/jira/browse/JDO-176?page=comments#action_12332132 ] 

Craig Russell commented on JDO-176:
-----------------------------------

The parameter for "matches" is a regular expression. If '*First' is intended to be a wild card, it should be '.*First' instead. The wild card for regular expressions is dot star.

> JPOX fails when a query calls String.matches
> --------------------------------------------
>
>          Key: JDO-176
>          URL: http://issues.apache.org/jira/browse/JDO-176
>      Project: JDO
>         Type: Bug
>     Reporter: Michael Watzek
>     Assignee: Erik Bengtson

>
> JPOX fails when a query calls String.matches. This bug may be reproduced applying patch JDO-159. The SQL generation of the following query is incorrect:
> SELECT FROM org.apache.jdo.tck.pc.company.Person WHERE firstname.matches('*First') 
> The LIKE clause of the generated SQL statement contains '*First'. This is a bug. It should contain '%First'.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira