Bug #18172 XML: Extractvalue() accepts mallformed XPath without a XPath syntax error

Description:
ExtractValue can be passed a mallformed XPath expression and no syntax error or warning is generated.

How to repeat:
mysql> select extractValue('<e><a>1</a></e>','/e/');
+---------------------------------------+
| extractValue('<e><a>1</a></e>','/e/') |
+---------------------------------------+
|                                       |
+---------------------------------------+
1 row in set (0.00 sec)

(XPath expression should not end with / - )

Suggested fix:
generate an error indicating the xpath expression is mallformed. In this case, a abbreviated axis specifier, axis name or abbreviated step should follow the last /

Thank you for the bug report.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/3972

ok to push

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/4009

Fixed in 5.1.8

Documented:

      <listitem>
        <para>
          The <function>EXTRACTVALUE()</function> function did not
          return an error when passed an invalid XPATH string. (Bug
          #18172)
        </para>
      </listitem>