Alicia Ying Shu created PHOENIX-2886:
----------------------------------------
Summary: Union ALL with Char column not present in the table in
Query 1 but in Query 2 throw exception
Key: PHOENIX-2886
URL: https://issues.apache.org/jira/browse/PHOENIX-2886
Project: Phoenix
Issue Type: Bug
Reporter: Alicia Ying Shu
Assignee: Alicia Ying Shu
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
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
