[
https://issues.apache.org/jira/browse/ASTERIXDB-2288?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16845082#comment-16845082
]
Ali Alsuliman commented on ASTERIXDB-2288:
------------------------------------------
[~dtabass]
2nd query should work now.
3rd query, isn't that supposed to be the behaviour or am I missing something?
"alias" field does not exist in ChirpUsers. The empty records are coming from
ChirpUsers dataset where "alias" field is missing.
> Problems in SQL++ compilation when types "open up"
> --------------------------------------------------
>
> Key: ASTERIXDB-2288
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-2288
> 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;
> -- This works based on the TinySocial tutorial schema
> SELECT VALUE a FROM (SELECT VALUE c FROM ChirpUsers c UNION ALL SELECT VALUE
> g FROM GleambookUsers g) AS a;
> -- This doesn't work properly (field accesses broken)
> SELECT name FROM (SELECT VALUE c FROM ChirpUsers c UNION ALL SELECT VALUE g
> FROM GleambookUsers g) AS a;
> -- This one is weird (returns some empty records)
> SELECT alias FROM (SELECT VALUE c FROM ChirpUsers c UNION ALL SELECT VALUE g
> FROM GleambookUsers g) AS a;
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
