Paul Guo created HAWQ-1455:
------------------------------
Summary: Wrong results on CTAS query over catalog
Key: HAWQ-1455
URL: https://issues.apache.org/jira/browse/HAWQ-1455
Project: Apache HAWQ
Issue Type: Bug
Components: Core
Reporter: Paul Guo
Assignee: Ed Espino
The last ctas sql returns 0 tuple. This is wrong.
$ cat catalog.sql
create temp table t1 (tta varchar, ttb varchar);
create temp table t2 (tta varchar, ttb varchar);
insert into t1 values('a', '1');
insert into t1 values('a', '2');
insert into t1 values('tta', '3');
insert into t1 values('ttb', '4');
insert into t2 select pg_attribute.attname,t1.ttb from pg_attribute join t1 on
pg_attribute.attname = t1.tta;
$ psql -f catalog.sql -d postgres
CREATE TABLE
CREATE TABLE
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 0
The join result should be as below for a new database.
INSERT 0 4
tta | ttb
-----+-----
tta | 3
ttb | 4
tta | 3
ttb | 4
(4 rows)
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
