From c4f390df7eace94a9dabd62642e6ade30f0632dc Mon Sep 17 00:00:00 2001 From: unknown Date: Thu, 2 Mar 2006 14:05:38 +0400 Subject: 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. --- mysql-test/r/xml.result | 12 ++++++++++++ 1 file changed, 12 insertions(+) (limited to 'mysql-test/r/xml.result') 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','/A_B'); extractvalue('A','/A_B') A +select extractvalue('Jack','/a[contains(../a,"J")]'); +extractvalue('Jack','/a[contains(../a,"J")]') +Jack +select extractvalue('Jack','/a[contains(../a,"j")]'); +extractvalue('Jack','/a[contains(../a,"j")]') +Jack +select extractvalue('Jack','/a[contains(../a,"j")]' collate latin1_bin); +extractvalue('Jack','/a[contains(../a,"j")]' collate latin1_bin) + +select extractvalue('Jack' collate latin1_bin,'/a[contains(../a,"j")]'); +extractvalue('Jack' collate latin1_bin,'/a[contains(../a,"j")]') + -- cgit v1.2.1