[HAWQ-1195] Synchrony:Union not working on external tables ERROR:"Two or more external tables use the same error table ""xxxxxxx"" in a statement (execMain.c:274)"

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: backlog
• Component/s: External Tables
• Assignee: Ming Li
• Reporter: Ming Li
• Created: 06/Dec/16 09:13
• Updated: 21/Dec/16 00:52
• Resolved: 16/Dec/16 03:20

Description

Hello,

User create an external table and define the error table. Then he do the union on the same external table with different where condition. Then return the error:ERROR: Two or more external tables use the same error table "err_ext_pdr_cdci_pivotal_request_43448" in a statement (execMain.c:274)

Below is the master log when I reproduce: （the whole log file attached in attachement）

2016-11-29 22:49:51.976864 PST,"gpadmin","postgres",p769199,th-2123704032,"[local]",,2016-11-29 22:46:14 PST,1260,con72,cmd10,seg-1,,,x1260,sx1,"ERROR","XX000","Two or more external tables use the same error table ""err_ext_pdr_cdci_pivotal_request_43448"" in a statement (execMain.c:274)",,,,,,"select current_account_nbr,yearmonthint, bank_name, first_date_open, max_cr_limit, care_credit_flag, cc1_flag, partition_value, 'US' as loc from pdr_cdci_pivotal_request_43448 where care_credit_flag<1
union
select current_account_nbr,yearmonthint, bank_name, first_date_open, max_cr_limit, care_credit_flag, cc1_flag, partition_value, 'Non-US' as loc from pdr_cdci_pivotal_request_43448 where care_credit_flag=1;",0,,"execMain.c",274,"Stack trace:
1    0x8c5858 postgres errstart (??:0)
2    0x8c75db postgres elog_finish (??:0)
3    0x65f669 postgres <symbol not found> (??:0)
4    0x77d06a postgres walk_plan_node_fields (??:0)
5    0x77e3ee postgres plan_tree_walker (??:0)
6    0x77c70a postgres expression_tree_walker (??:0)
7    0x77e35d postgres plan_tree_walker (??:0)
8    0x77d06a postgres walk_plan_node_fields (??:0)
9    0x77dfe6 postgres plan_tree_walker (??:0)
10   0x77d06a postgres walk_plan_node_fields (??:0)
11   0x77e1e5 postgres plan_tree_walker (??:0)
12   0x77d06a postgres walk_plan_node_fields (??:0)
13   0x77dfe6 postgres plan_tree_walker (??:0)
14   0x77d06a postgres walk_plan_node_fields (??:0)
15   0x77e1e5 postgres plan_tree_walker (??:0)
16   0x66079b postgres ExecutorStart (??:0)
17   0x7ebf1d postgres PortalStart (??:0)
18   0x7e4288 postgres <symbol not found> (??:0)
19   0x7e54c2 postgres PostgresMain (??:0)
20   0x797d50 postgres <symbol not found> (??:0)
21   0x79ab19 postgres PostmasterMain (??:0)
22   0x4a4069 postgres main (??:0)
23   0x7fd97d486d5d libc.so.6 __libc_start_main (??:0)
24   0x4a40e9 postgres <symbol not found> (??:0)
"

Issue Links

• links to: GitHub Pull Request #1040