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/07/15 18:03:04 UTC

[jira] [Updated] (TAJO-948) 'INSERT INTO' statement to non existence table casuses NPE.

     [ https://issues.apache.org/jira/browse/TAJO-948?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Hyunsik Choi updated TAJO-948:
------------------------------

    Description: 
See the title. In the following example, lineitem_8 does not exist in catalog. In this case, if we use INSERT INTO statement, NPE will be caused. This is a logical verifier bug

{noformat}
default> insert into lineitem_8 SELECT L_ORDERKEY, L_PARTKEY, L_SUPPKEY, L_LINENUMBER, L_QUANTITY, L_EXTENDEDPRICE, L_DISCOUNT, L_TAX, L_LINESTATUS, L_SHIPDATE, L_COMMITDATE, L_RECEIPTDATE, L_SHIPINSTRUCT, L_SHIPMODE, L_COMMENT, L_RETURNFLAG FROM LINEITEM;
ERROR: java.lang.NullPointerException
{noformat}

  was:
{noformat}
Progress: 95%, response time: 65.348 sec
Progress: 95%, response time: 66.35 sec
Progress: 98%, response time: 67.351 sec
Progress: 98%, response time: 68.353 sec
Progress: 98%, response time: 69.355 sec
Progress: 99%, response time: 70.357 sec
Progress: 100%, response time: 71.29 sec
(6001216 rows, 71.29 sec, 1.4 GiB inserted)
default> \set tajo.query.output.perfile-size-bytes 32000000
default> insert into lineitem_8 SELECT L_ORDERKEY, L_PARTKEY, L_SUPPKEY, L_LINENUMBER, L_QUANTITY, L_EXTENDEDPRICE, L_DISCOUNT, L_TAX, L_LINESTATUS, L_SHIPDATE, L_COMMITDATE, L_RECEIPTDATE, L_SHIPINSTRUCT, L_SHIPMODE, L_COMMENT, L_RETURNFLAG FROM LINEITEM;
ERROR: java.lang.NullPointerException
{noformat}


> 'INSERT INTO' statement to non existence table casuses NPE.
> -----------------------------------------------------------
>
>                 Key: TAJO-948
>                 URL: https://issues.apache.org/jira/browse/TAJO-948
>             Project: Tajo
>          Issue Type: Bug
>          Components: planner/optimizer
>            Reporter: Hyunsik Choi
>            Priority: Minor
>              Labels: newbie
>             Fix For: 0.9.0
>
>
> See the title. In the following example, lineitem_8 does not exist in catalog. In this case, if we use INSERT INTO statement, NPE will be caused. This is a logical verifier bug
> {noformat}
> default> insert into lineitem_8 SELECT L_ORDERKEY, L_PARTKEY, L_SUPPKEY, L_LINENUMBER, L_QUANTITY, L_EXTENDEDPRICE, L_DISCOUNT, L_TAX, L_LINESTATUS, L_SHIPDATE, L_COMMITDATE, L_RECEIPTDATE, L_SHIPINSTRUCT, L_SHIPMODE, L_COMMENT, L_RETURNFLAG FROM LINEITEM;
> ERROR: java.lang.NullPointerException
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.2#6252)