diff options
| author | unknown <bar@mysql.com> | 2006-03-02 14:05:38 +0400 |
|---|---|---|
| committer | unknown <bar@mysql.com> | 2006-03-02 14:05:38 +0400 |
| commit | c4f390df7eace94a9dabd62642e6ade30f0632dc (patch) | |
| tree | a185767393ca9510ccfdb625027e6474bcababea /mysql-test/r/xml.result | |
| parent | 4ccd535abe1e8771c85afab1b85b798e69290e55 (diff) | |
| download | mariadb-git-c4f390df7eace94a9dabd62642e6ade30f0632dc.tar.gz | |
Bug#16316: XML: extractvalue() is case-sensitive with contains()
xml.result, xml.test:
Adding test case.
item_xmlfunc.cc:
Fixed that Item_nodeset_func derived classes
didn't take into account charset of the XML value
and always worked using "binary" charset.
sql/item_xmlfunc.cc:
Bug#16316: XML: extractvalue() is case-sensitive with contains()
Fixed that Item_nodeset_func derived classes
didn't take into account charset of the XML value
and always worked using "binary" charset.
mysql-test/t/xml.test:
Adding test case.
mysql-test/r/xml.result:
Adding test case.
Diffstat (limited to 'mysql-test/r/xml.result')
| -rw-r--r-- | mysql-test/r/xml.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/xml.result b/mysql-test/r/xml.result index 0b75b50f754..18516277c3c 100644 --- a/mysql-test/r/xml.result +++ b/mysql-test/r/xml.result @@ -561,3 +561,15 @@ A B C select extractvalue('<A_B>A</A_B>','/A_B'); extractvalue('<A_B>A</A_B>','/A_B') A +select extractvalue('<a>Jack</a>','/a[contains(../a,"J")]'); +extractvalue('<a>Jack</a>','/a[contains(../a,"J")]') +Jack +select extractvalue('<a>Jack</a>','/a[contains(../a,"j")]'); +extractvalue('<a>Jack</a>','/a[contains(../a,"j")]') +Jack +select extractvalue('<a>Jack</a>','/a[contains(../a,"j")]' collate latin1_bin); +extractvalue('<a>Jack</a>','/a[contains(../a,"j")]' collate latin1_bin) + +select extractvalue('<a>Jack</a>' collate latin1_bin,'/a[contains(../a,"j")]'); +extractvalue('<a>Jack</a>' collate latin1_bin,'/a[contains(../a,"j")]') + |