Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-38564

mariadb --xml option doesn't work well with xmltype

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • Data types
    • 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">&lt;students&gt;
       &lt;student&gt;
         &lt;name&gt;Rick Grimes&lt;/name&gt;
         &lt;age&gt;35&lt;/age&gt;
         &lt;subject&gt;Maths&lt;/subject&gt;
         &lt;gender&gt;Male&lt;/gender&gt;
       &lt;/student&gt;
       &lt;student&gt;
         &lt;name&gt;Daryl Dixon &lt;/name&gt;
         &lt;age&gt;33&lt;/age&gt;
         &lt;subject&gt;Science&lt;/subject&gt;
         &lt;gender&gt;Male&lt;/gender&gt;
       &lt;/student&gt;
       &lt;student&gt;
         &lt;name&gt;Maggie&lt;/name&gt;
         &lt;age&gt;36&lt;/age&gt;
         &lt;subject&gt;Arts&lt;/subject&gt;
         &lt;gender&gt;Female&lt;/gender&gt;
       &lt;/student&gt;
      &lt;/students&gt;</field>
        </row>
      </resultset>
      

      Attachments

        Issue Links

          Activity

            People

              holyfoot Alexey Botchkov
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.