Обсуждение: BUG #4794: server closed the connection unexpectedly

The following bug has been logged online:

Bug reference:      4794
Logged by:          Markus Meyer
Email address:      markus@7val.com
PostgreSQL version: 8.3.3
Operating system:   Debian 2.6.22.19-vs2.2.0.7
Description:        server closed the connection unexpectedly
Details:

If i make an

SELECT xmlconcat(('<datanode>' || NULL || '</datanode>')::xml);

follows

server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.

On Wed, May 6, 2009 at 11:05 AM, Markus Meyer <markus@7val.com> wrote:
> If i make an
>
> SELECT xmlconcat(('<datanode>' || NULL || '</datanode>')::xml);
>
> follows
>
> server closed the connection unexpectedly
> =A0 =A0 =A0 =A0This probably means the server terminated abnormally
> =A0 =A0 =A0 =A0before or while processing the request.

It's fixed in 8.3.7:
wombat=3D> SELECT xmlconcat(('<datanode>' || NULL || '</datanode>')::xml);
 xmlconcat
-----------

(1 ligne)

(More exactly see the release nots of 8.3.6: "Fix crash of
xmlconcat(NULL) (Peter)")

Consider upgrading your installation to the latest minor release of
8.3. It's highly recommended.

--=20
Guillaume

Markus Meyer wrote:
> The following bug has been logged online:
>
> Bug reference:      4794
> Logged by:          Markus Meyer
> Email address:      markus@7val.com
> PostgreSQL version: 8.3.3
> Operating system:   Debian 2.6.22.19-vs2.2.0.7
> Description:        server closed the connection unexpectedly
> Details:
>
> If i make an
>
> SELECT xmlconcat(('<datanode>' || NULL || '</datanode>')::xml);
>
> follows
>
> server closed the connection unexpectedly
>         This probably means the server terminated abnormally
>         before or while processing the request.
>
>

seems to work fine on 8.3.7

that inner expression -is- a NULL, so xmlconcat(NULL)  is itself a
null.  not much use.