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

[Ashutosh B. <ash...@en...>]

Hi Tomonari,

Thanks for the bug report.

I am curious to know, what's the purpose of using EXECUTE DIRECT? We
discourage using Execute Direct in the applications. It's only for
debugging purposes.


On Tue, Jun 4, 2013 at 7:28 AM, Koichi Suzuki <koi...@gm...>wrote:

> Thank you Katsumata-san for the report.
>
> Could you provide CREATE TABLE statement for each table involved with some
> of the data?
>
> I will ad this to the bug tracker after I recreate the issue.
>
> Best Regards;
>
> ----------
> Koichi Suzuki
>
>
> 2013/6/4 Tomonari Katsumata <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
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> 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
>>
>
>
>
> ------------------------------------------------------------------------------
> 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
>
>


-- 
Best Wishes,
Ashutosh Bapat
EntepriseDB Corporation
The Postgres Database Company