You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@tajo.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2014/12/03 09:38:13 UTC
[jira] [Commented] (TAJO-1223) Wrong query verification against
asterisk and more expressions in select list
[ https://issues.apache.org/jira/browse/TAJO-1223?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14232777#comment-14232777 ]
ASF GitHub Bot commented on TAJO-1223:
--------------------------------------
GitHub user hyunsik opened a pull request:
https://github.com/apache/tajo/pull/279
TAJO-1223: Wrong query verification against asterisk and more expression...
...s in select list.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/hyunsik/tajo TAJO-1223
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/tajo/pull/279.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #279
----
commit 55151f580cddd597b7d2d8244fc457095c2f514b
Author: Hyunsik Choi <hy...@apache.org>
Date: 2014-12-03T08:34:28Z
TAJO-1223: Wrong query verification against asterisk and more expressions in select list.
----
> 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)