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

[Koichi S. <koi...@gm...>]

Actually, revised patch worked and I've already committed it.

Thank you.
---
Koichi Suzuki


2014-02-13 18:42 GMT+09:00 Tomonari Katsumata
<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
>>
>>
>>
>
>
> ------------------------------------------------------------------------------
> 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
>