From: | "Ibrar Ahmed" <ibrar(dot)ahmad(at)gmail(dot)com> |
---|---|
To: | "Gregory Stark" <stark(at)enterprisedb(dot)com> |
Cc: | Postgres <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: New bug |
Date: | 2008-11-19 17:11:45 |
Message-ID: | 8494ccf60811190911vc116cc4ma6e7047187c6ab94@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
It works fine on my machine
ibrar(at)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(at)enterprisedb(dot)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, 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!
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>
--
Ibrar Ahmed
EnterpriseDB http://www.enterprisedb.com
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2008-11-19 17:12:51 | TODO list request: FK to unique expression indexes |
Previous Message | Alex Hunsaker | 2008-11-19 17:10:44 | Re: patch: Client certificate requirements |