Re: [Postgres-xc-developers] bug!

[Mason S. <mas...@en...>]

Benny,

Thanks for reporting this. It turns out this is working in the 
PGXC-sqlmed branch in the git repository.  This branch will be merged 
into HEAD sometime soon and the issue will no longer occur.

In general there are some improvements we should do for cartesian products.

Thanks,

Mason



On 10/19/10 9:49 PM, Koichi Suzuki wrote:
> Hi,
>
> I'm afraid "from tt1, tt2" causes curtesian product of two tables, which
> may not be supported at present version.
> I suppose "select count(*) from tt1;" and "select count(*) from tt2;"
> will run without problems.
>
> Cheers;
> ---
> Koichi
>
> (2010年10月20日 10:37), mei le wrote:
>    
>> Dears,
>> steps:
>> 1.create table tt1(a int);
>> 2.create table tt2(a int);
>> 3.insert into tt1 values(1);insert into tt2 values(1);
>> 4.select count(*) from tt1,tt2;
>> template1=# select count(*) from tt1,tt2;
>> server closed the connection unexpectedly
>> This probably means the server terminated abnormally
>> before or while processing the request.
>> The connection to the server was lost. Attempting reset: LOG: server
>> process (PID 2239) was terminated by signal 11: Segmentation fault
>> LOG: terminating any other active server processes
>> LOG: all server processes terminated; reinitializing
>> LOG: database system was interrupted; last known up at 2010-10-20
>> 09:36:17 CST
>> LOG: database system was not properly shut down; automatic recovery in
>> progress
>> FATAL: failed to connect to pool manager: Connection refused
>> Failed.
>> !>  LOG: record with zero length at 0/4DA980
>> LOG: redo is not required
>> Using aggregate functions on mutiple tables join will all cause such a
>> problem.
>> Benny
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Download new Adobe(R) Flash(R) Builder(TM) 4
>> The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly
>> Flex(R) Builder(TM)) enable the development of rich applications that run
>> across multiple browsers and platforms. Download your free trials today!
>> http://p.sf.net/sfu/adobe-dev2dev
>>
>>
>>
>> _______________________________________________
>> Postgres-xc-developers mailing list
>> Pos...@li...
>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>>      
>
> ------------------------------------------------------------------------------
> Download new Adobe(R) Flash(R) Builder(TM) 4
> The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly
> Flex(R) Builder(TM)) enable the development of rich applications that run
> across multiple browsers and platforms. Download your free trials today!
> http://p.sf.net/sfu/adobe-dev2dev
> _______________________________________________
> 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.