Обсуждение: New bug

I haven't looked into what's causing it yet but...

postgres=# SELECT res, * FROM (       SELECT 'foo'||i AS test, i AS res          FROM (VALUES (1)) AS x(i)
UNIONALL        SELECT 'foo'||i, i          FROM (VALUES (2)) AS x(i)      ) AS x;
 
server closed the connection unexpectedlyThis probably means the server terminated abnormallybefore or while processing
therequest.
 
The connection to the server was lost. Attempting reset: Failed.

TRAP: FailedAssertion("!(child_attr <= new_max_attr)", File: "prepunion.c", Line: 1726)


Works fine on 8.3 so even though that section of code in prepunion.c hasn't
changed:

postgres=# SELECT res, * FROM (SELECT 'foo'||i AS test, i AS res FROM (VALUES (1)) AS x(i) UNION ALL SELECT 'foo'||i, i
FROM(VALUES (2)) AS x(i)) AS x ;res | test | res 
 
-----+------+-----  1 | foo1 |   1  2 | foo2 |   2
(2 rows)



--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support!

Hi,

It works fine on my machine

ibrar@ibrar-laptop:/usr/local/pgsql/bin$ ./psql postgres
psql (8.4devel)
Type "help" for help.

postgres=# SELECT res, * FROM (                                                           SELECT
'foo'||i AS test, i AS res        FROM (VALUES (1)) AS x(i)       UNION ALL      SELECT 'foo'||i, i        FROM (VALUES
(2))AS x(i)     ) AS x;res | test | res
 
-----+------+-----  1 | foo1 |   1  2 | foo2 |   2
(2 rows)

postgres=#


On Wed, Nov 19, 2008 at 8:38 PM, Gregory Stark <stark@enterprisedb.com> wrote:
>
> I haven't looked into what's causing it yet but...
>
> postgres=# SELECT res, * FROM (
>        SELECT 'foo'||i AS test, i AS res
>          FROM (VALUES (1)) AS x(i)
>         UNION ALL
>        SELECT 'foo'||i, i
>          FROM (VALUES (2)) AS x(i)
>       ) AS x;
> 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: Failed.
>
> TRAP: FailedAssertion("!(child_attr <= new_max_attr)", File: "prepunion.c", Line: 1726)
>
>
> Works fine on 8.3 so even though that section of code in prepunion.c hasn't
> changed:
>
> postgres=# SELECT res, * FROM (SELECT 'foo'||i AS test, i AS res FROM (VALUES (1)) AS x(i) UNION ALL SELECT 'foo'||i,
iFROM (VALUES (2)) AS x(i)) AS x ;
 
>  res | test | res
> -----+------+-----
>   1 | foo1 |   1
>   2 | foo2 |   2
> (2 rows)
>
>
>
> --
>  Gregory Stark
>  EnterpriseDB          http://www.enterprisedb.com
>  Ask me about EnterpriseDB's PostGIS support!
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>



--   Ibrar Ahmed  EnterpriseDB   http://www.enterprisedb.com

"Ibrar Ahmed" <ibrar.ahmad@gmail.com> writes:

> Hi,
>
> It works fine on my machine

Hm, a fresh checkout doesn't crash for me either any more.

Hopefully it didn't just hide the problem because I stupidly just trashed the
install that was exhibiting the problem.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support!

Gregory Stark <stark@enterprisedb.com> writes:
> "Ibrar Ahmed" <ibrar.ahmad@gmail.com> writes:
>> It works fine on my machine

> Hm, a fresh checkout doesn't crash for me either any more.

It looks like a bug I fixed a week or so back.
        regards, tom lane