diff options
| author | bar@mysql.com <> | 2006-04-07 14:07:56 +0500 |
|---|---|---|
| committer | bar@mysql.com <> | 2006-04-07 14:07:56 +0500 |
| commit | 334af05334c7bbdd5447b9606d4154098340c262 (patch) | |
| tree | 8d20f849c47112de0d48b8646e94b32180cefeef /mysql-test/t/xml.test | |
| parent | 3c2e84f7f320099d362548eba8856b02fe60bf8a (diff) | |
| download | mariadb-git-334af05334c7bbdd5447b9606d4154098340c262.tar.gz | |
Bug#16319: XML: extractvalue() returns syntax errors for some functions
Diffstat (limited to 'mysql-test/t/xml.test')
| -rw-r--r-- | mysql-test/t/xml.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/xml.test b/mysql-test/t/xml.test index af3ec2d827e..cadbdcb0bb8 100644 --- a/mysql-test/t/xml.test +++ b/mysql-test/t/xml.test @@ -192,6 +192,20 @@ select extractValue(@xml, '/a/@b[substring(.,1,1)="2"]'); select extractValue(@xml, '/a/@b[substring(.,2,1)="1"]'); select extractValue(@xml, '/a/@b[substring(.,2,1)="2"]'); +# +# Bug#16319: XML: extractvalue() returns syntax errors for some functions +# +SET @xml='<a><b>b1</b><b>b2</b></a>'; +SELECT extractValue(@xml, '/a/b[string-length("x")=1]'); +SELECT extractValue(@xml, '/a/b[string-length("xx")=2]'); +SELECT extractValue(@xml, '/a/b[string-length("xxx")=2]'); +SELECT extractValue(@xml, '/a/b[string-length("x")]'); +SELECT extractValue(@xml, '/a/b[string-length("xx")]'); +SELECT extractValue(@xml, '/a/b[string-length()]'); +--error 1105 +SELECT extractValue(@xml, 'string-length()'); +SELECT extractValue(@xml, 'string-length("x")'); + SET @xml='<a b="b11" b="b12" b="b21" b="22"/>'; select extractValue(@xml,'/a/@b'); select extractValue(@xml,'/a/@b[contains(.,"1")]'); |