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 | c76459aca9beae24b3c2d1e9fea7c3a9c386328c (patch) | |
| tree | a185767393ca9510ccfdb625027e6474bcababea /mysql-test/t/xml.test | |
| parent | c32514244897cc000d103f17f883bf8b8c26898e (diff) | |
| download | mariadb-git-c76459aca9beae24b3c2d1e9fea7c3a9c386328c.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/t/xml.test')
| -rw-r--r-- | mysql-test/t/xml.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/xml.test b/mysql-test/t/xml.test index 6a91d785d4e..f7ce987f29d 100644 --- a/mysql-test/t/xml.test +++ b/mysql-test/t/xml.test @@ -254,3 +254,11 @@ select extractvalue('<a>A<b>B<c>C</c></b></a>','/a/descendant-or-self::*'); # Bug #16320 XML: extractvalue() won't accept names containing underscores # select extractvalue('<A_B>A</A_B>','/A_B'); + +# +# Bug#16316: XML: extractvalue() is case-sensitive with contains() +# +select extractvalue('<a>Jack</a>','/a[contains(../a,"J")]'); +select extractvalue('<a>Jack</a>','/a[contains(../a,"j")]'); +select extractvalue('<a>Jack</a>','/a[contains(../a,"j")]' collate latin1_bin); +select extractvalue('<a>Jack</a>' collate latin1_bin,'/a[contains(../a,"j")]'); |