Vladimir Dolzhenko created CALCITE-2109:
-------------------------------------------
Summary: Mongo adapter: unable to translate (A AND B) conditional
case
Key: CALCITE-2109
URL: https://issues.apache.org/jira/browse/CALCITE-2109
Project: Calcite
Issue Type: Bug
Reporter: Vladimir Dolzhenko
Assignee: Julian Hyde
Mongo adapter fails on query
{code:sql}
select state, city from zips
where city='MANSFIELD' and state in ('AR', 'TX', 'MA')
order by state
{code}
with
{code}
java.lang.AssertionError: cannot translate OR(=(CAST(ITEM($0,
'state')):VARCHAR(2) CHARACTER SET "ISO-8859-1" COLLATE
"ISO-8859-1$en_US$primary", 'AR'), =(CAST(ITEM($0, 'state')):VARCHAR(2)
CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary", 'TX'),
=(CAST(ITEM($0, 'state')):VARCHAR(2) CHARACTER SET "ISO-8859-1" COLLATE
"ISO-8859-1$en_US$primary", 'MA'))
at
org.apache.calcite.adapter.mongodb.MongoFilter$Translator.translateMatch2(MongoFilter.java:181)
at
org.apache.calcite.adapter.mongodb.MongoFilter$Translator.translateAnd(MongoFilter.java:116)
at
org.apache.calcite.adapter.mongodb.MongoFilter$Translator.translateOr(MongoFilter.java:98)
at
org.apache.calcite.adapter.mongodb.MongoFilter$Translator.translateMatch(MongoFilter.java:91)
{code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
