[
https://issues.apache.org/jira/browse/OPTIQ-431?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14164457#comment-14164457
]
Julian Hyde commented on OPTIQ-431:
-----------------------------------
Will take a look after 0.9.1.
> Mongo Performance Upgrade Breaks SQL
> -------------------------------------
>
> Key: OPTIQ-431
> URL: https://issues.apache.org/jira/browse/OPTIQ-431
> Project: Optiq
> Issue Type: Bug
> Affects Versions: 0.9.1-incubating
> Reporter: Tom Barber
> Assignee: Julian Hyde
>
> Hi guys
> I've been playing with calcite and Mondrian has been creating SQL like:
> select "store"."store_country" as "c0" from "store" as "store" where
> UPPER("store"."store_country") = UPPER('USA');
> But the
> https://github.com/apache/incubator-optiq/commit/4121916628c5990f93450d5b2e2dbada246c2f7c#diff-6af337d402e219c52e71367604d7b054
> commit (as far as I can tell), broke it.
> Caused by: java.lang.AssertionError: cannot translate op null call
> =(UPPER(CAST(ITEM($0, 'store_country')):VARCHAR(30) CHARACTER SET
> "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"),
> CAST(UPPER('USA')):VARCHAR(30) CHARACTER SET "ISO-8859-1" COLLATE
> "ISO-8859-1$en_US$primary" NOT NULL)
> at
> net.hydromatic.optiq.impl.mongodb.MongoFilterRel$Translator.translateBinary(MongoFilterRel.java:159)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
