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

["Lirong Jian (JIRA)" <ji...@apache.org>]

Lirong Jian created HAWQ-70:
-------------------------------

             Summary: 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)