Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
create table t1 (a xmltype); |
insert into t1 values ("<students> |
<student>
|
<name>Rick Grimes</name>
|
<age>35</age>
|
<subject>Maths</subject>
|
<gender>Male</gender>
|
</student>
|
<student>
|
<name>Daryl Dixon </name>
|
<age>33</age>
|
<subject>Science</subject>
|
<gender>Male</gender>
|
</student>
|
<student>
|
<name>Maggie</name>
|
<age>36</age>
|
<subject>Arts</subject>
|
<gender>Female</gender>
|
</student>
|
</students>"); |
|
|
--exec $MYSQL --xml test -e "select * from t1"
|
--exec $MYSQL_DUMP --xml test t1 |
<?xml version="1.0"?>
|
|
|
<resultset statement="SELECT * FROM t
|
" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
|
<row>
|
<field name="a"><students>
|
<student>
|
<name>Rick Grimes</name>
|
<age>35</age>
|
<subject>Maths</subject>
|
<gender>Male</gender>
|
</student>
|
<student>
|
<name>Daryl Dixon </name>
|
<age>33</age>
|
<subject>Science</subject>
|
<gender>Male</gender>
|
</student>
|
<student>
|
<name>Maggie</name>
|
<age>36</age>
|
<subject>Arts</subject>
|
<gender>Female</gender>
|
</student>
|
</students></field>
|
</row>
|
</resultset>
|
Attachments
Issue Links
- is caused by
-
MDEV-37261 Basic XML data type
-
- In Testing
-