lancelly opened a new pull request, #28265:
URL: https://github.com/apache/shardingsphere/pull/28265
In this pr, I supported the parsing of basic components of XMLElement and
XMLCdata Function of Oracle.
Now, the HR-5-204 & HR-5-208 can be parsed correcly.
The Example SQL is :
`SELECT XMLELEMENT("PurchaseOrder", XMLAttributes(dummy as "pono"),
XMLCdata('<!DOCTYPE po_dom_group [ <!ELEMENT po_dom_group(student_name)*>
<!ELEMENT po_purch_name (#PCDATA)> <!ATTLIST po_name po_no ID #REQUIRED>
<!ATTLIST po_name trust_1 IDREF #IMPLIED> <!ATTLIST po_name trust_2 IDREF
#IMPLIED>]>')) "XMLCData" FROM DUAL;`
I refered to the offical doc of Oracle:
https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/XMLELEMENT.html#GUID-DEA75423-00EA-4034-A246-4A774ADC988E
https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/XMLCDATA.html#GUID-FB517A52-6F1A-4D8D-B632-F91EFA606691
<img width="773" alt="截屏2023-08-26 16 25 29"
src="https://github.com/apache/shardingsphere/assets/108499334/cbcc4ddf-face-4815-8aeb-4b3297580452";>
<img width="931" alt="截屏2023-08-26 14 22 26"
src="https://github.com/apache/shardingsphere/assets/108499334/8aaafccb-bc82-452e-841e-bd3e9736f967";>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
