metamodel-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kasper Sørensen (JIRA) <j...@apache.org>
Subject [jira] [Commented] (METAMODEL-135) SQL parsing fails when 'AND' or 'OR' keywords are in caps
Date Sun, 26 Apr 2015 18:30:39 GMT

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

Kasper Sørensen commented on METAMODEL-135:
-------------------------------------------

Oh and If you want the filter item as a string, use toSql()

> SQL parsing fails when 'AND' or 'OR' keywords are in caps
> ---------------------------------------------------------
>
>                 Key: METAMODEL-135
>                 URL: https://issues.apache.org/jira/browse/METAMODEL-135
>             Project: Apache MetaModel
>          Issue Type: Task
>            Reporter: Ashish Mukherjee
>
> This is what my client code is:
>   DataContext dataContext = new SolrDataContext(url, index);
>   DataSet dataSet = dataContext
>                 .executeQuery("SELECT price FROM collection1 WHERE (((manu = 'Samsung')
AND name = 'hard'))");
> In my SolrDataContext class:
> FilterClause clause = q.getWhereClause();
>         if (clause != null) {
>             List<FilterItem> filterItemList = clause.getItems();
>             boolean isFirst = true;
>             
>             for (FilterItem filterItem : filterItemList) {
>                 String expr = filterItem.getExpression();
>                 System.out.println(expr);
> ....
> expr is null when 'AND' is in caps but gives the correct expression when it is written
as 'and' in the query. Same is true for 'OR' and 'or'. Looks like the parsing is case-sensitive
somewhere.



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

Mime
View raw message