Skip to main content

Search

Welcome to Tibero GTS!

Issue of Not Finding Data Without Prefix in Default Namespace (When Using xmlns Feature)

Document Type | Troubleshooting

Category | Patch/Upgrade

Applicable Product Version | 6FS07

Document Number | TPATS003

 

Issue

An issue occurring in Tibero 6, where when using xmlns in XML data, values cannot be found in the default namespace (when there is no prefix).

When running the query below on Tibero 6 (DB 6.0 FS07_CS_2005) (build 194603) binary, the Value is output as Null
Issue Occurring Value: NULL
SELECT extractValue(marc_data, '/collection/record/datafield[@tag="245"][1]/subfield[@code="a"][position()=1]', 'xmlns="http://www.loc.gov/MARC21/slim"') VALUE
FROM CT_MASTER
WHERE existsNode(marc_data, '//collection/record/datafield[@tag="245"]', 'xmlns="http://www.loc.gov/MARC21/slim"') = 1
and controlno = '000000203768';

 

Cause

Data cannot be found in situations where the XML namespace has no prefix, such as extract(xml, '//aaa/bbb/ccc', 'xmlns="url"').
 
 

Solutions

Apply the patch to resolve the issue. (Applied patches: FS07_200601c, FS07_245561f, FS07_246130c, FS07_258897c)
Caution
Apply the patch through technical support provided by Tmax Tibero.
 
 
 

Related to