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:11:15 +0000 (11:11 -0800)
commit30a5e940ac9a96c5fee449223528a1b5555502ed
tree1f2eb22ef3787972c8d207d2db09ffcb0b7b830d
parentf9e2885d51bf585bec2d5ffeda4f9e5e1a723f4d
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