[ https://issues.apache.org/jira/browse/ASTERIXDB-2288?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16845486#comment-16845486 ]
Michael J. Carey commented on ASTERIXDB-2288: --------------------------------------------- Ah - interesting - empty records seem weird, so I stand by my classification, but it also seems correct per your explanation. :) > 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)