Ashish Mukherjee created METAMODEL-135:
------------------------------------------
Summary: 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)
