hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Paul Guo (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HAWQ-1455) Wrong results on CTAS query over catalog
Date Fri, 05 May 2017 09:44:04 GMT
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)

Mime
View raw message