Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.3.12, 5.5.33a, 10.0.6
-
None
-
None
Description
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)
|
