|
This query crashes the server:
SELECT ExtractValue('<a><b>abc</b><c>2</c><d>1</d></a>','substring(/a/b,..)');
|
Notice '..' in the 'position' argument to XPath substring() function,
which obviously goes above the root XML element.
If I change the position argument to something inside the XML tree,
it works fine:
mysql> SELECT ExtractValue('<a><b>abc</b><c>2</c><d>1</d></a>','substring(/a/b,/a/c)');
|
+--------------------------------------------------------------------------+
|
| ExtractValue('<a><b>abc</b><c>2</c><d>1</d></a>','substring(/a/b,/a/c)') |
|
+--------------------------------------------------------------------------+
|
| bc |
|
+--------------------------------------------------------------------------+
|
1 row in set (0.00 sec)
|
|