[ https://issues.apache.org/jira/browse/HAWQ-1455?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15998012#comment-15998012 ]
Paul Guo commented on HAWQ-1455: -------------------------------- This is a regression which was introduced by https://issues.apache.org/jira/browse/HAWQ-512 It is not accessing the catalog tables of database postgres (in my example) on entrydb QE. We need to re-fix HAWQ-512. It seems that it could be fixed in the lock manager instead. > 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: Paul Guo > > 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)