[
https://issues.apache.org/jira/browse/ASTERIXDB-2289?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Till updated ASTERIXDB-2289:
----------------------------
Fix Version/s: 0.9.4.2
> Problem in SQL++ with CASE processing and field access
> ------------------------------------------------------
>
> Key: ASTERIXDB-2289
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-2289
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: COMP - Compiler
> Affects Versions: 0.9.4
> Reporter: Michael J. Carey
> Assignee: Dmitry Lychagin
> Priority: Major
> Labels: triaged
> Fix For: 0.9.4.2
>
>
> USE TinySocial;
> SELECT
> (CASE WHEN g.id = 6 THEN g ELSE u END).name
> FROM ChirpUsers u JOIN GleambookUsers g ON u.name < g.name WHERE u.screenName
> = "ChangEwing_573";
> --> This returns a low-level error:
> Field access switch-case(TRUE, eq($$g.getField("id"), 6), $$g,
> $$u).getField("name") does not correspond to any input of operator
> org.apache.hyracks.algebricks.core.algebra.operators.logical.InnerJoinOperator@495bf56a
> [AlgebricksException]
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
