Re: [Postgres-xc-developers] Fwd: patch for bug#3126459:select error ： (group by .. order by.. )

On 12/16/10 9:00 PM, xiong wang wrote:
> Hi Mason,
>
> I also found some other errors after I submit the patch, which is
> relative with such a bug. I will fix the problems your mentioned and
> we found.

OK. If it involves multiple remote queries (or join reduction) and looks
difficult, it might make more sense to let us know. I think Pavan is
very familiar with that code and might be able to fix it quickly.

Mason


> Regards,
> Benny
>
> 在 2010年12月17日 上午3:05，Mason Sharp <mas...@en...> 写道：
>>
>> ---------- 已转发邮件 ----------
>> 发件人： xiong wang <wan...@gm...>
>> 日期： 2010年12月15日 上午11:02
>> 主题： patch for bug#3126459:select error ： (group by .. order by.. )
>> 收件人： pos...@li...
>> Dears,
>> The enclosure is the patch for bug#3126459:select error ： (group by ..
>> order by.. ).
>> Your advice will be appreiciated.
>> Btw, I modified an error in my view that the variable standardPlan is
>> always a free pointer.
>> Regards,
>> Benny
>>
>> Thanks, Benny.
>>
>> You definitely are addressing a bug that got introduced at some point, but
>> now I get a different error for the case in question:
>>
>> mds=# select t1.q2,
>> count(t2.*)
>> from int8_tbl t1 left join int8_tbl t2 on (t1.q2 =
>> t2.q1)
>> group by t1.q2 order by 1;
>> ERROR:  invalid reference to FROM-clause entry for table "int8_tbl"
>>
>> That is probably due to general RemoteQuery handling and aliasing.
>>
>> Anyway, I can imagine that your fix also addresses other reported issues.
>>
>> Thanks,
>>
>> Mason
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Lotusphere 2011
>> Register now for Lotusphere 2011 and learn how
>> to connect the dots, take your collaborative environment
>> to the next level, and enter the era of Social Business.
>> http://p.sf.net/sfu/lotusphere-d2d
>>
>> _______________________________________________
>> Postgres-xc-developers mailing list
>> Pos...@li...
>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>>
>>
>> --
>> Mason Sharp
>> EnterpriseDB Corporation
>> The Enterprise Postgres Company
>> This e-mail message (and any attachment) is intended for the use of
>> the individual or entity to whom it is addressed. This message
>> contains information from EnterpriseDB Corporation that may be
>> privileged, confidential, or exempt from disclosure under applicable
>> law. If you are not the intended recipient or authorized to receive
>> this for the intended recipient, any use, dissemination, distribution,
>> retention, archiving, or copying of this communication is strictly
>> prohibited. If you have received this e-mail in error, please notify
>> the sender immediately by reply e-mail and delete this message.
>>


-- 
Mason Sharp
EnterpriseDB Corporation
The Enterprise Postgres Company


This e-mail message (and any attachment) is intended for the use of
the individual or entity to whom it is addressed. This message
contains information from EnterpriseDB Corporation that may be
privileged, confidential, or exempt from disclosure under applicable
law. If you are not the intended recipient or authorized to receive
this for the intended recipient, any use, dissemination, distribution,
retention, archiving, or copying of this communication is strictly
prohibited. If you have received this e-mail in error, please notify
the sender immediately by reply e-mail and delete this message.