[ASTERIXDB-3415] Compilation error: Could not infer type for variable error for valid query

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: COMP - Compiler
• Labels: triaged
• Assignee: Unassigned
• Reporter: Peeyush Gupta
• Created: 31/May/24 00:22
• Updated: 14/Aug/24 16:04
• Resolved: 28/Jun/24 22:26

Description

The following query fails with compilation error

 

SELECT (
  SELECT c1.field1
  FROM collection1 AS c1
  WHERE c1.id IN c3.items
  UNION ALL
  SELECT c2.field2
  FROM collection2 c2 )
FROM collection3 AS c3

org.apache.asterix.common.exceptions.CompilationException: ASX1079: Compilation error: Could not infer type for variable '$$69'. (in line 2, at column 3)   
 at
org.apache.asterix.optimizer.rules.SetClosedRecordConstructorsRule$SettingClosedRecordVisitor.visitVariableReferenceExpression(SetClosedRecordConstructorsRule.java:175) ~[classes/:?]    
at org.apache.asterix.optimizer.rules.SetClosedRecordConstructorsRule$SettingClosedRecordVisitor.visitVariableReferenceExpression(SetClosedRecordConstructorsRule.java:80) ~[classes/:?]