BUG #4769: xmlconcat produces invalid xml values -> data corruption

Поиск
Список
Период
Сортировка
От Arjen Nienhuis
Тема BUG #4769: xmlconcat produces invalid xml values -> data corruption
Дата
Msg-id 200904211211.n3LCB09p008988@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #4769: xmlconcat produces invalid xml values -> data corruption
Список pgsql-bugs
Дерево обсуждения 
The following bug has been logged online:

Bug reference:      4769
Logged by:          Arjen Nienhuis
Email address:      a.g.nienhuis@gmail.com
PostgreSQL version: 8.3.7
Operating system:   Ubuntu 8.10 and 9.04
Description:        xmlconcat produces invalid xml values -> data corruption
Details:

'<!DOCTYPE html><html/>' is a valid xml document but not a valid xml
fragment. xmlconcat does not check for this:

SELECT xmlconcat('foo', xmlparse(DOCUMENT '<!DOCTYPE html><html/>'));
         xmlconcat
---------------------------
 foo<!DOCTYPE html><html/>

The result is an invalid xml value that can end up in a table.

==============================================

=> SELECT version();
                                               version

----------------------------------------------------------------------------
-------------------------
 PostgreSQL 8.3.7 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.3.real
(Ubuntu 4.3.3-5ubuntu4) 4.3.3
(1 row)

libxml2 version is 2.6.32.dfsg-5ubuntu4

=============================================

I tried to test this with 8.4 but the ubuntu ppa has depency problems.

В списке pgsql-bugs по дате отправления: