Re: bugfix: xpath encoding issue

2017-04-13 17:19 GMT+02:00 Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>:

> Pavel Stehule wrote:
> > Hi
> >
> > When I tested XMLTABLE function I found a bug of XPATH function -
> > xpath_internal
> >
> > There xmltype is not correctly encoded to xmlChar due possible invalid
> > encoding info in header. It is possible when XML was loaded with recv
> > function and has not UTF8 encoding.
>
> Hmm ... is it possible to create a test that verifies this? I suppose
> we could have a non-utf8 value as bytea.
>

I have not any idea. The problem is in utf8 encoded xml with bad header.
There is dependency to database encoding and supported locales.

Maybe I can simulate it with cast without function from bytea to xml - but
it looks more than little bit dirty

Regards

Pavel

>
> --
> Álvaro Herrera https://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
>