Michael J. Carey created ASTERIXDB-2289:
-------------------------------------------
Summary: 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
Reporter: Michael J. Carey
Assignee: Dmitry Lychagin
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)
