diff options
| author | unknown <bar@mysql.com> | 2006-03-09 11:53:56 +0400 |
|---|---|---|
| committer | unknown <bar@mysql.com> | 2006-03-09 11:53:56 +0400 |
| commit | a6a6d43a5b8d17d1e679fc46f64f90fed120a910 (patch) | |
| tree | d112af938f97483403d7e55fadd1bb01f3c65407 /mysql-test/r/xml.result | |
| parent | ac84e6e696e4455cc81e59e89499481cc090a2d1 (diff) | |
| parent | 1b0b5617b975df2bb91f749605eec26b5067ad84 (diff) | |
| download | mariadb-git-a6a6d43a5b8d17d1e679fc46f64f90fed120a910.tar.gz | |
Merge abarkov@bk-internal.mysql.com:/home/bk/mysql-5.1-new/
into mysql.com:/usr/home/bar/mysql-5.1-new.b16318
sql/item_xmlfunc.cc:
Auto merged
mysql-test/r/xml.result:
After merge fix
mysql-test/t/xml.test:
After merge fix
Diffstat (limited to 'mysql-test/r/xml.result')
| -rw-r--r-- | mysql-test/r/xml.result | 36 |
1 files changed, 36 insertions, 0 deletions
diff --git a/mysql-test/r/xml.result b/mysql-test/r/xml.result index 18516277c3c..bb7a158593c 100644 --- a/mysql-test/r/xml.result +++ b/mysql-test/r/xml.result @@ -561,6 +561,42 @@ A B C select extractvalue('<A_B>A</A_B>','/A_B'); extractvalue('<A_B>A</A_B>','/A_B') A +select extractvalue('<a>A<b>B1</b><b>B2</b></a>','/a/b[position()]'); +extractvalue('<a>A<b>B1</b><b>B2</b></a>','/a/b[position()]') +B1 B2 +select extractvalue('<a>A<b>B1</b><b>B2</b></a>','/a/b[count(.)=last()]'); +extractvalue('<a>A<b>B1</b><b>B2</b></a>','/a/b[count(.)=last()]') +B1 B2 +select extractvalue('<a>A<b>B1</b><b>B2</b></a>','/a/b[last()]'); +extractvalue('<a>A<b>B1</b><b>B2</b></a>','/a/b[last()]') +B2 +select extractvalue('<a>A<b>B1</b><b>B2</b></a>','/a/b[last()-1]'); +extractvalue('<a>A<b>B1</b><b>B2</b></a>','/a/b[last()-1]') +B1 +select extractvalue('<a>A<b>B1</b><b>B2</b></a>','/a/b[last()=1]'); +extractvalue('<a>A<b>B1</b><b>B2</b></a>','/a/b[last()=1]') + +select extractvalue('<a>A<b>B1</b><b>B2</b></a>','/a/b[last()=2]'); +extractvalue('<a>A<b>B1</b><b>B2</b></a>','/a/b[last()=2]') +B1 B2 +select extractvalue('<a>A<b>B1</b><b>B2</b></a>','/a/b[last()=position()]'); +extractvalue('<a>A<b>B1</b><b>B2</b></a>','/a/b[last()=position()]') +B2 +select extractvalue('<a>A<b>B1</b><b>B2</b></a>','/a/b[count(.)]'); +extractvalue('<a>A<b>B1</b><b>B2</b></a>','/a/b[count(.)]') +B2 +select extractvalue('<a>A<b>B1</b><b>B2</b></a>','/a/b[count(.)-1]'); +extractvalue('<a>A<b>B1</b><b>B2</b></a>','/a/b[count(.)-1]') +B1 +select extractvalue('<a>A<b>B1</b><b>B2</b></a>','/a/b[count(.)=1]'); +extractvalue('<a>A<b>B1</b><b>B2</b></a>','/a/b[count(.)=1]') + +select extractvalue('<a>A<b>B1</b><b>B2</b></a>','/a/b[count(.)=2]'); +extractvalue('<a>A<b>B1</b><b>B2</b></a>','/a/b[count(.)=2]') +B1 B2 +select extractvalue('<a>A<b>B1</b><b>B2</b></a>','/a/b[count(.)=position()]'); +extractvalue('<a>A<b>B1</b><b>B2</b></a>','/a/b[count(.)=position()]') +B2 select extractvalue('<a>Jack</a>','/a[contains(../a,"J")]'); extractvalue('<a>Jack</a>','/a[contains(../a,"J")]') Jack |