[TAJO-1223] Wrong query verification against asterisk and more expressions in select list

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.10.0
• Assignee: Hyunsik Choi
• Reporter: Hyunsik Choi
• Created: 03/Dec/14 08:31
• Updated: 03/Dec/14 09:52
• Resolved: 03/Dec/14 09:36

Description

Reproduction

create table lineitem_year_month (
 l_orderkey bigint,
 l_partkey bigint,
 l_suppkey bigint,
 l_linenumber int,
 l_quantity float8,
 l_extendedprice float8,
 l_discount float8,
 l_tax float8,
 l_returnflag text,
 l_linestatus text,
 l_shipdate text,
 l_commitdate text,
 l_receiptdate text,
 l_shipinstruct text,
 l_shipmode text,
 l_comment text
) PARTITION BY COLUMN (year TEXT, MONTH TEXT);

$ INSERT INTO lineitem_year_month 
  SELECT *, SUBSTR(l_shipdate, 1,4) as year, SUBSTR(l_shipdate, 6, 2) as month 
  FROM 
  default.lineitem;

ERROR: INSERT has smaller expressions than target columns