[Postgres-xc-developers] Fix for test case xc_misc

[Abbas B. <abb...@en...>]

Hi,
The test case fails if there is no primary node in the cluster. The
following test case was producing error.

CREATE TABLE tt_22 (a int, b int) distribute by replication;
INSERT INTO tt_22 VALUES (10);

In a four datanode cluster the following query plan was being produced.

explain verbose SELECT * FROM tt_22 FOR UPDATE;
                                 QUERY PLAN
----------------------------------------------------------------------------
 Data Node Scan on "__REMOTE_FQS_QUERY__"  (cost=0.00..0.00 rows=0 width=0)
   Output: tt_22.a, tt_22.b
   Node/s: data_node_1, data_node_2, data_node_3, data_node_4
   Remote query: SELECT a, b FROM tt_22 FOR UPDATE OF tt_22
(4 rows)

The reason was a missing else case in GetRelationNodes.


-- 
*Abbas*
 Architect

Ph: 92.334.5100153
 Skype ID: gabbasb
www.enterprisedb.co
<http://www.enterprisedb.com/>m<http://www.enterprisedb.com/>
*
Follow us on Twitter*
@EnterpriseDB

Visit EnterpriseDB for tutorials, webinars,
whitepapers<http://www.enterprisedb.com/resources-community>and
more<http://www.enterprisedb.com/resources-community>