BUG #5859: XML result in line and column
От | Alexandre |
---|---|
Тема | BUG #5859: XML result in line and column |
Дата | |
Msg-id | 201102011520.p11FKpLt022295@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #5859: XML result in line and column
Re: BUG #5859: XML result in line and column |
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 5859 Logged by: Alexandre Email address: ultrago@gmail.com PostgreSQL version: 8.4.7 Operating system: Windows 7 Description: XML result in line and column Details: The name of the xml tag is not being updated, becoming the first name registry for all. Here is example: Create table AUDITORIA_ANTERIOR ( SEQUENCIA Serial NOT NULL, SEQUENCIA_AUDITORIA Integer NOT NULL, REGISTRO Text NOT NULL, primary key (SEQUENCIA,SEQUENCIA_AUDITORIA) ); insert into auditoria_anterior (sequencia_auditoria, registro) values (1, '<?xml version="1.0" encoding="iso-8859-1"?><ROOT> <CLIENTES><CGC_CPF_CLIENTE>12345678901</CGC_CPF_CLIENTE><TIPO>1</TIPO><CODIG O_CONVENIO></CODIGO_CONVENIO><PESSOA>F</PESSOA><NOME>JOAO DA SILVA</NOME></CLIENTES> </ROOT>') SELECT * FROM xpath_table('sequencia', 'registro', 'auditoria_anterior', 'name(/ROOT/CLIENTES/*)|/ROOT/CLIENTES/*', 'sequencia = 1') AS t(sequencia integer, coluna text, valor text) --Incorrect result----------------------------------- sequencia coluna valor integer text text -------------------------------------------------- 1 CGC_CPF_CLIENTE 12345678901 1 CGC_CPF_CLIENTE 1 1 CGC_CPF_CLIENTE F 1 CGC_CPF_CLIENTE JOAO DA SILVA --Result that would be right to be presented---------- sequencia coluna valor integer text text -------------------------------------------------- 1 CGC_CPF_CLIENTE 12345678901 1 TIPO 1 1 PESSOA F 1 NOME JOAO DA SILVA
В списке pgsql-bugs по дате отправления: