You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@asterixdb.apache.org by "Till (JIRA)" <ji...@apache.org> on 2018/03/08 22:32:00 UTC

[jira] [Updated] (ASTERIXDB-2289) Problem in SQL++ with CASE processing and field access

     [ https://issues.apache.org/jira/browse/ASTERIXDB-2289?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Till updated ASTERIXDB-2289:
----------------------------
    Component/s: SQL - Translator SQL++

> 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
>            Reporter: Michael J. Carey
>            Assignee: Dmitry Lychagin
>            Priority: Major
>              Labels: triaged
>
> 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)