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

Posted to notifications@asterixdb.apache.org by "Ali Alsuliman (JIRA)" <ji...@apache.org> on 2019/05/16 23:06:00 UTC

[jira] [Assigned] (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 ]

Ali Alsuliman reassigned ASTERIXDB-2289:
----------------------------------------

    Assignee: Ali Alsuliman  (was: Dmitry Lychagin)

> 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)