Re: [Postgres-xc-developers] Query Planning bug ?

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

Hi,

Congratulation on releasing Postgres-XC 1.2 beta!

The problem in this thread has already been fixed at
Postgres-XC 1.1 stable, but unfortunately not been fixed
at Postgres-XC 1.2 beta.

I confirmed the problem was resolved with same fix
to Postgres-XC 1.1 stable.
see attached patch. This patch is for Postgres-XC 1.2 beta(*).
(*)9b6be5b8ba66eb9e083a4a80669e7d41a2cea3dc

I hope you'll fix in formal release of Postgres-XC 1.2.

regards,
-------------------
Tomonari Katsumata

(2013/06/04 10:31), Tomonari Katsumata wrote:
 > 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
 >
 >
 >
 > 
------------------------------------------------------------------------------
 > How ServiceNow helps IT people transform IT departments:
 > 1. A cloud service to automate IT design, transition and operations
 > 2. Dashboards that offer high-level views of enterprise services
 > 3. A single system of record for all IT processes
 > http://p.sf.net/sfu/servicenow-d2d-j
 > _______________________________________________
 > Postgres-xc-developers mailing list
 > Pos...@li...
 > https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
 >