[PHOENIX-2886] Union ALL with Char column not present in the table in Query 1 but in Query 2 throw exception

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

Description

To reproduce:

create table person ( id bigint not null primary key, firstname char(10), lastname varchar(10) );
upsert into person values( 1, 'john', 'doe');
upsert into person values( 2, 'jane', 'doe');

– fixed value for char(10)
select id, 'foo' firstname, lastname from person union all select * from person;
java.lang.RuntimeException: java.sql.SQLException: ERROR 201 (22000): Illegal data. Expected length of at least 106 bytes, but had 13

– fixed value for bigint
select cast( 10 AS bigint) id, 'foo' firstname, lastname from person union all select * from person;
java.lang.RuntimeException: java.sql.SQLException: ERROR 201 (22000): Illegal data. Expected length of at least 106 bytes, but had 13