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

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

Hi,

I'm sorry.
master has the same trouble too.
Here is the patch for the master(*).
(*)0b4543953f32ac3d8d3b7ba1983a19f14c8c091e

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

(2014/02/13 17:59), 鈴木 幸市 wrote:
 > I’m afraid the patch is not committed to the master either. Could you 
provide the patch for the master if needed?
 >
 > Regards;
 > ---
 > 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
 >
 >
 >