[ https://issues.apache.org/jira/browse/ASTERIXDB-2289?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16841833#comment-16841833 ]
Ali Alsuliman commented on ASTERIXDB-2289: ------------------------------------------ [~dtabass] Should be working now. > 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: Ali Alsuliman > 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)