Bug #71704 ExtractValue: fn:concat does not handle more than two arguments

• Submitted: 13 Feb 2014 13:40
• Modified: 11 Aug 2015 16:56
• Reporter: Aaron Spetner (OCA)
• Status: Verified
• Category: MySQL Server: XML functions
• Severity: S3 (Non-critical)
• Version: 5.6.13, 5.6.16
• OS: Any
• CPU Architecture: Any
• Tags: concat, ExtractValue, XPath

[13 Feb 2014 13:40] Aaron Spetner

Description:
According to http://www.w3.org/TR/xpath-functions/#func-concat, fn:concat is supposed to concatenate the values of all parameters passed to it. However, when using it in ExtractValue, only the first two parameters are passed.

How to repeat:
SELECT EXTRACTVALUE("<a><b>d</b><c>o</c><d>g</d></a>", "concat(/a/b,/a/c,/a/d)");

^It *should* return "dog", but instead it returns "do".

[17 Feb 2014 6:07] MySQL Verification Team

Hello Aaron,

Thank you for the bug report.
Verified as described.

Thanks,
Umesh

[11 Aug 2015 16:56] Aaron Spetner

Any update on this?