[ 
https://issues.apache.org/jira/browse/TAJO-1223?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14232829#comment-14232829
 ] 

Hudson commented on TAJO-1223:
------------------------------

SUCCESS: Integrated in Tajo-master-build #478 (See 
[https://builds.apache.org/job/Tajo-master-build/478/])
TAJO-1223: Wrong query verification against asterisk and more expressions in 
select list. (hyunsik: rev 20d1f0145b47e6c478bb55c79d670926e66f137c)
* 
tajo-core/src/test/resources/queries/TestInsertQuery/lineitem_year_month_ddl.sql
* 
tajo-core/src/test/resources/results/TestInsertQuery/testInsertOverwriteWithAsteriskAndMore.result
* 
tajo-core/src/test/resources/queries/TestInsertQuery/testInsertOverwriteWithAsteriskAndMore.sql
* 
tajo-core/src/test/resources/queries/TestInsertQuery/load_to_lineitem_year_month.sql
* 
tajo-plan/src/main/java/org/apache/tajo/plan/verifier/PreLogicalPlanVerifier.java
* tajo-core/src/test/java/org/apache/tajo/engine/query/TestInsertQuery.java


> 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
>
>         Attachments: TAJO-1223.patch
>
>
> *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)

Reply via email to