[jira] [Commented] (CXF-5713) FIQL: the % character is not taken into account in FIQL expression

["Sergey Beryozkin (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CXF-5713?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13982403#comment-13982403 ] 

Sergey Beryozkin commented on CXF-5713:
---------------------------------------

Thanks for the patch, I've applied it locally and then updated JPATypedQueryVisitorFiqlTest#testEqualsAddressQuery3, changed "street==Street2;housenum=lt=5" to "street==Street%2;housenum=lt=5" and also changed "Street2" to "Street%2" in AbstractJPATypedQueryVisitorTest#setUp, and I got:

"...Invalid escape character in statement.." Hibernate error, do you know why ?

Thanks, Sergey

> FIQL: the % character is not taken into account in FIQL expression
> ------------------------------------------------------------------
>
>                 Key: CXF-5713
>                 URL: https://issues.apache.org/jira/browse/CXF-5713
>             Project: CXF
>          Issue Type: Bug
>          Components: JAX-RS
>    Affects Versions: 2.7.11
>            Reporter: Romain Castan
>              Labels: patch
>         Attachments: patch.txt
>
>   Original Estimate: 4h
>  Remaining Estimate: 4h
>
> When there is the character '%' in the expression FIQL the JPA query is not valid.
> Currently, for this following expression FIQL:
> _s=name==apache%software*
> the generated SQL query is:
> ... where name like 'apache%software%'
> while the generated SQL query should be:
> ... where name like 'apache\%sofware%' escape '\' 



--
This message was sent by Atlassian JIRA
(v6.2#6252)