Horton

Re: XML/XPath issues: text/CDATA in XMLTABLE, XPath evaluated with wrong context

Alvaro Herrera <alvherre@2ndquadrant.com>

View thread View on postgr.es
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Markus Winand <markus.winand@winand.at>
Cc: pgsql-hackers@postgresql.org
Date: 2018-06-19T20:21:32Z
Lists: pgsql-hackers 
Hello hackers,

Any objections fixing this on Pg11?  My opinion is that it's better to
fix it now rather than waiting for pg12.  It's already broken in pg10
(xmltable) and older (rest of the xml stuff).  As Markus advised, I'd
not backpatch fixes for fear of breaking stuff, but I'd rather release
pg11 with the correct behavior.

I intend to get it done this week if there are no serious objections.

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

Commits

  1. Fix minor deficiencies in XMLTABLE, xpath(), xmlexists()

  2. Set correct context for XPath evaluation

  3. Accept TEXT and CDATA nodes in XMLTABLE's column_expression.