MySQL Bugs: #13728: add XML parsing like MSSQLServer does

Bug #13728	add XML parsing like MSSQLServer does
Submitted:	4 Oct 2005 0:38	Modified:	29 Oct 2009 12:28
Reporter:	Anatoliy Savchak	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S4 (Feature request)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
It's good to use somth like this:
CERATE PROCEDURE spUpdateMyRows(RowsXML varchar(1000))
BEGIN
  DECLARE ixml;
  CALL xml=xml_prepare(RowsXML);
  CREATE TEMPORARY TABLE T(status char(1), name varchar(45), comments varchar(250));
  INSERT INTO T(name, comments)
    FROM open_xml(ixml, 'dataset/row', 2)
      WITH (status char(1) '@STATUS', name varchar(45) '@NAME', comments varchar(45) '@COMMENTS');
  xml_remove(ixml);

  INSERT INTO MyTable(name, comments) 
  SELECT name, comments
  FROM T WHERE Status = 'I'
   
  UPDATE MyTable My
    set comments = t.comments
  FROM T WHERE Status = 'U' and My.Name = T.Name;

  DELETE MyTable My
  FROM T WHERE Status = 'U' and My.Name = T.Name;

end;

How to repeat:
FEATURE REQUEST

During Winter Semester 2005 I attended a class where one group of students implemented C code to parse XML and store it in MySQL tables.  I'm not sure whether they implemented it as an external program,  as user-defined functions,  or as a modification to the MySQL source-code,  but I did see it in operation.  One of the students was David Post;  I believe his e-mail address is ae4933@wayne.edu.

Thank you for the feature request. Please, check if XML functions of MySQL 5.1 are enough to implement a kind of processing you need. Check http://dev.mysql.com/doc/refman/5.1/en/xml-functions.html for the details.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".