|
I have found several issues on the webpage https://mariadb.com/kb/en/library/connect-xml-table-type/
Section: Multiple nodes in the XML document
The first query after the paragraph:
"Because the author column does not appear in the query, the corresponding row was not expanded. This is somewhat strange because this would have been different if we had been working on a table of a different type. However, it is closer to the relational model for which there should not be two identical rows (tuples) in a table. Nevertheless, you should be aware of this somewhat erratic behavior. For instance:"
select count(*) from xsamp2; /* Replies 4 */
|
Returns 3 instead of 4
Section: Intermediate multiple node
update xsampall2 set authorfn = 'Simon' where authorln = 'Knab';
|
select subject, language lang, title, authorfn first, authorln last, year from xsampall2;
|
Displays:
SUBJECT LANG TITLE FIRST LAST YEAR
|
applications fr Construire une application XML Jean-Christophe Bernadac 1999
|
applications fr Construire une application XML Simon Knab 1999
|
applications fr XML en Action William J. Pardi 1999
|
général fr XML, Langage et Applications Alain Michard 1998
|
update xsampall2 set year = 2002 where authorln = 'Bernadac';
|
select subject, language lang, title, authorfn first,
|
authorln last, year from xsampall2;
|
Displays:
SUBJECT LANG TITLE FIRST LAST YEAR
|
applications fr Construire une application XML Jean-Christophe Bernadac 2002
|
applications fr Construire une application XML Simon Knab 2002
|
applications fr XML en Action William J. Pardi 1999
|
général fr XML, Langage et Applications Alain Michard 1998
|
update xsampall2 set authorln = 'Mercier' where year = 2002;
|
select subject, language lang, title, authorfn first,
|
authorln last, year from xsampall2;
|
Displays:
SUBJECT LANG TITLE FIRST LAST YEAR
|
applications fr Construire une application XML Jean-Christophe Mercier 2002
|
applications fr Construire une application XML Simon Mercier 2002
|
applications fr XML en Action William J. Pardi 1999
|
général fr XML, Langage et Applications Alain Michard 1998
|
Which differs from what appears on the webpage:
SUBJECT LANG TITLE FIRST LAST YEAR
|
applications fr Construire une application XML Jean-Christophe Mercier 2002
|
applications fr Construire une application XML François Knab 2002
|
applications fr XML en Action William J. Pardi 1999
|
général fr XML, Langage et Applications Alain Michard 1998
|
|