You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@tajo.apache.org by "Hyunsik Choi (JIRA)" <ji...@apache.org> on 2014/12/03 09:32:12 UTC

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

Hyunsik Choi created TAJO-1223:
----------------------------------

             Summary: Wrong query verification against asterisk and more expressions in select list
                 Key: TAJO-1223
                 URL: https://issues.apache.org/jira/browse/TAJO-1223
             Project: Tajo
          Issue Type: Bug
            Reporter: Hyunsik Choi
            Assignee: Hyunsik Choi
             Fix For: 0.9.1


*Reproduction*
{code:sql}
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);
{code}

{noformat}
$ 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
{noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)