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

["Lei Chang (JIRA)" <ji...@apache.org>]

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

Lei Chang closed HAWQ-70.
-------------------------

> 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
>             Fix For: 2.0.0-beta-incubating
>
>
> 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)