[Postgres-xc-developers] Query Planning bug ?

[Tomonari K. <kat...@po...>]

Hi, I have a problem with query executing.

I cant't have any response when I execute a query.
This problem occurs when some conditions are met.

The conditions are below.
---------------------------------------------------------------------
1. Issuing "EXECUTE DIRECT" to Datanode(ofcourse, via Coordinator).

2. The Query Executing on Datanode has subquery on its FROM-clause.

3. In the subquery, it has a JOIN clause.

4. The Join clause is consisted with another subquery.
---------------------------------------------------------------------


Simple example query is below.
---------------------------------------------------------------
EXECUTE DIRECT ON (data1) $$
SELECT
count(*)
FROM
(SELECT * FROM pg_locks l LEFT JOIN
(SELECT * FROM pg_stat_activity) s ON l.database = s.datid) a
$$
---------------------------------------------------------------

FYI:
This query works fine with Postgres-XC 1.0.3.
Is this already known bug ?


How can I avoid this problem ?
And what kind of info do you need to investigate it ?

----------
NTT Software Corporation
Tomonari Katsumata