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

[鈴木 幸市 <ko...@in...>]

Thanks.   I was worrying about it.   Will be committed soon.
---
Koichi Suzuki

2014/02/13 15:25、Tomonari Katsumata <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
> >
> 
> 
> <revised_fqs_for12beta.patch>------------------------------------------------------------------------------
> Android apps run on BlackBerry 10
> Introducing the new BlackBerry 10.2.1 Runtime for Android apps.
> Now with support for Jelly Bean, Bluetooth, Mapview and more.
> Get your Android app in front of a whole new audience.  Start now.
> http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk_______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers