Uploaded image for project: 'Apache AsterixDB'
  1. Apache AsterixDB
  2. ASTERIXDB-2289

Problem in SQL++ with CASE processing and field access

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.9.4
    • Fix Version/s: 0.9.4.2
    • Component/s: COMP - Compiler
    • Labels:

      Description

      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]
       

        Attachments

          Activity

            People

            • Assignee:
              alsuliman Ali Alsuliman
              Reporter:
              dtabass Michael J. Carey
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: