Re: [Postgres-xc-developers] bug!

[Koichi S. <ko...@in...>]

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