[PHOENIX-2934] Checking a coerce expression at top level should not be necessary for Union All query

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.8.0
• Assignee: Alicia Ying Shu
• Reporter: Alicia Ying Shu
• Created: 23/May/16 01:45
• Updated: 11/Aug/16 08:28
• Resolved: 12/Jun/16 23:22

Description

When working on PHOENIX-2886, found that we need special handling of coerce expression. Otherwise the following query would fail.

create table person ( id bigint not null primary key, firstname char(10), lastname varchar(10) );
select id, cast( 'foo' as char(10)) firstname, lastname from person union all select * from person;

Checking a coerce expression at top level should not be necessary. Need to find out root cause on coerceExpression.