Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 5.3.12, 5.5.33a, 10.0.6
-
Fix Version/s: 10.0.10
-
Component/s: None
-
Labels: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)
|