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

Wierd expectation/interpretation of datasets/names in SQL++ error cases

    XMLWordPrintableJSON

    Details

      Description

      USE TinySocial;

      SELECT ELEMENT user
      FROM FacebookUsers AS user
      WHERE user.name = 'NilaMilliron';

      results in

      { "id": 8, "alias": "Nila", "name": "NilaMilliron", "user-since": datetime("2008-01-01T10:10:00.000Z"), "friend-ids": {{ 3 }}, "employment": [

      { "organization-name": "Plexlane", "start-date": date("2010-02-28"), "end-date": null }

      ] }

      Perfect! However....

      SELECT ELEMENT user
      FROM FacebookUsers AS user
      WHERE user.name = "NilaMilliron"; // or without the quotes at all

      gives

      Could not find dataset NilaMilliron in dataverse TinySocial [AlgebricksException]

      !?!

        Attachments

          Activity

            People

            • Assignee:
              dtabass Michael J. Carey
              Reporter:
              dtabass Michael J. Carey
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: