Oracle迁移到MogDB之XMLPARSE

背景

迁移时，在两个客户的项目中都遇到过XMLPARSE，我们来看下如何迁移。

Oracle

源端代码模拟

with xml_data as
(
select '<bookstore><book><title>Harry Potter</title><author>J.K. Rowling</author></book></bookstore>' as xml_content
from dual
)
SELECT XMLPARSE(DOCUMENT xml_content WELLFORMED).getClobVal() AS extracted_data
FROM xml_data;

该代码目的为解析xml，返回里面的内容，输出结果如下：

SELECT XMLPARSE(DOCUMENT xml_content WELLFORMED).getClobVal() AS extracted_data
  7  FROM xml_data;

EXTRACTED_DATA
--------------------------------------------------------------------------------
<bookstore><book><title>Harry Potter</title><author>J.K. Rowling</author></book>

MogDB

直接在MogDB中运行该语句会报错

ERROR:  syntax error at or near "WELLFORMED"
LINE