Ignore XML declaration in xpath_internal(), for UTF8 databases.
authorNoah Misch <noah@leadboat.com>
Sat, 11 Nov 2017 19:10:53 +0000 (11:10 -0800)
committerNoah Misch <noah@leadboat.com>
Sat, 11 Nov 2017 19:10:53 +0000 (11:10 -0800)
commit2918fcedbf2b2adab688a7849ecce4556ef912ac
tree9dbd6aa811f50aedac8a4a637cdcca162d50cee4
parent5edc63bda68a77c4d38f0cbeae1c4271f9ef4100
Ignore XML declaration in xpath_internal(), for UTF8 databases.

When a value contained an XML declaration naming some other encoding,
this function interpreted UTF8 bytes as the named encoding, yielding
mojibake.  xml_parse() already has similar logic.  This would be
necessary but not sufficient for non-UTF8 databases, so preserve
behavior there until the xpath facility can support such databases
comprehensively.  Back-patch to 9.3 (all supported versions).

Pavel Stehule and Noah Misch

Discussion: https://postgr.es/m/CAFj8pRC-dM=tT=QkGi+Achkm+gwPmjyOayGuUfXVumCxkDgYWg@mail.gmail.com
src/backend/utils/adt/xml.c
src/test/regress/expected/xml.out
src/test/regress/expected/xml_1.out
src/test/regress/expected/xml_2.out
src/test/regress/sql/xml.sql