MySQL Forums
Forum List  »  Newbie

Re: To deep XML
Posted by: laptop alias
Date: May 13, 2011 09:03AM

Hm, I'm not sure, but If you're struggling to count them then there's probably too many (from Mysql's POV, anyway)!

Can you show us the result of the following queries. If they error out, then show us the warning message...
SELECT ExtractValue(CONCAT('<root>', repeat('<a>',60), 'b',repeat('</a>',60),'</root>'),'//a');

SELECT ExtractValue(CONCAT('<root>', repeat('<a>',62), 'b',repeat('</a>',62),'</root>'),'//a');

Options: ReplyQuote

Written By
May 12, 2011 11:11PM
May 13, 2011 03:37AM
May 13, 2011 03:50AM
May 13, 2011 08:25AM
May 13, 2011 08:35AM
Re: To deep XML
May 13, 2011 09:03AM
May 13, 2011 09:12AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.