[jira] [Created] (CXF-6769) Underscores in values of FIQL search expressions are incorrectly escaped

["Torsten Römer (JIRA)" <ji...@apache.org>]

Torsten Römer created CXF-6769:
----------------------------------

             Summary: Underscores in values of FIQL search expressions are incorrectly escaped
                 Key: CXF-6769
                 URL: https://issues.apache.org/jira/browse/CXF-6769
             Project: CXF
          Issue Type: Bug
          Components: JAX-RS
    Affects Versions: 3.1.2
         Environment: Webapp deployed to WildFly 10
            Reporter: Torsten Römer
            Priority: Minor


We are basically "just" using FIQLParser and SQLPrinterVisitor like this:

final FiqlParser<SearchBean> fiqlParser = new FiqlParser<>(SearchBean.class);
final SearchCondition<SearchBean> searchCondition = fiqlParser.parse(search);
final SQLPrinterVisitor<SearchBean> visitor = new SQLPrinterVisitor<SearchBean>(table);
        searchCondition.accept(visitor);
final String sql = visitor.getQuery();

A search expression like this:

text==VAL_UE

yields an SQL query like this:

SELECT * FROM some_table WHERE text = 'VAL\_UE'

If the table contains a row with text "VAL_UE", the query returns no results because the underscore in the value was escaped.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)