Re: [HACKERS] bugfix: xpath encoding issue - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: [HACKERS] bugfix: xpath encoding issue
Date
Msg-id CAFj8pRBcAeNU-bya3DrSqcnHGVb5pQFVTtAO7DPEvB9Wg2_tsA@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] bugfix: xpath encoding issue  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers


2017-04-13 17:19 GMT+02:00 Alvaro Herrera <alvherre@2ndquadrant.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

pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: [HACKERS] tablesync patch broke the assumption that logical repdepends on?
Next
From: Corey Huinker
Date:
Subject: Re: [HACKERS] Undefined psql variables