[ASTERIXDB-2288] Problems in SQL++ compilation when types "open up"

• 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: triaged
• Assignee: Ali Alsuliman
• Reporter: Michael J. Carey
• Created: 15/Feb/18 23:19
• Updated: 22/May/19 07:29
• Resolved: 22/May/19 07:29

Description

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;