Re: unexpected result in ExtractValue

[Alexander Barkov]

Tag with only digit characters in their names are not valid in XPath.
That was a bug that MySQL tried to interpret this kind of queries.
In later versions of MySQL it was fixed and error is now returned:


Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 5.1.14-beta-debug-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> set @xml='<zot>
'> <tim0>
'> <01>10:39:15</01>
'> <02>140</02>
'> <03>90</03>
'> </tim0>
'> <tim1>
'> <01>12:19:10</01>
'> <02>149</02>
'> <03>100</03>
'> </tim1>
'> </zot>';
Query OK, 0 rows affected (0.00 sec)

mysql> select ExtractValue(@xml,"/zot/tim0/02");
ERROR 1105 (HY000): XPATH syntax error: '02'