[jira] [Commented] (HAWQ-70) INSERT INTO foo SELECT * FROM foo returned successful, but the data of foo was not as expected.

[ASF GitHub Bot (JIRA)]

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

ASF GitHub Bot commented on HAWQ-70:
------------------------------------

Github user yaoj2 commented on the pull request:

    https://github.com/apache/incubator-hawq/pull/235#issuecomment-168112031
  
    +1 


> INSERT INTO foo SELECT * FROM foo returned successful, but the data of foo 
> was not as expected.
> -----------------------------------------------------------------------------------------------
>
>                 Key: HAWQ-70
>                 URL: https://issues.apache.org/jira/browse/HAWQ-70
>             Project: Apache HAWQ
>          Issue Type: Bug
>          Components: Query Execution
>            Reporter: Lirong Jian
>            Assignee: George Caragea
>
> Reproduce steps:
> postgres=# CREATE TABLE foo (a INT);
> CREATE TABLE
> postgres=# INSERT INTO foo VALUES(generate_series(1, 25000000));
> INSERT 0 25000000
> postgres=# SELECT COUNT(*) FROM foo;
>   count   
> ----------
>  25000000
> (1 row)
> postgres=# INSERT INTO foo SELECT * FROM foo;
> INSERT 0 25000000
> postgres=# SELECT COUNT(*) FROM foo;
>   count   
> ----------
>  38402176
> (1 row)
> The expected answer is 50000000.



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