|
Problem IC65947
|
Status: Geschlossen |
DB2 Text Search: SCORE against XPATH always returns 1 |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problembeschreibung: |
The scoring function of a full-text search query on XML data
always scores documents with score value 1,
no matter how well the document matches the search criteria
compared to others.
For example, given the following data
1, <test><title>The forest garden</title><chapter1>The Old
Forest. Once upon a time the forest spread across all the lands
south of the mountain, and only few travelers dared to take a
short cut through the forest. There was no proper road and a
traveler would </chapter1></test>
2, <test><title>A squirrel in the tuila
tree</title><chapter1>Xiri quickly went down the tree to get a
better look: What was this strange creature doing in the forest?
It crashed through the bushes and seemed to be oblivious to
where it was going - it had left a long line of
</chapter1></test>
3, <test><title>North and South</title><chapter1>A forest here,
a forest there, a forest everywhere. The northern forest is dark
and dense, the southern forest light and</chapter1></test>
db2 "select score(content,
'@xpath:''/test/chapter1[.contains(\"forest\")]''') from
testtable where contains(content,
'@xpath:"/test/chapter1[.contains(\"forest\")]''') = 1"
will result in the same score output for all documents, even
though the search term frequency is different in each document:
1
------------------------
+1.00000000000000E+000
+1.00000000000000E+000
+1.00000000000000E+000
3 record(s) selected. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All Users *
****************************************************************
* PROBLEM DESCRIPTION: *
* DB2 Text Search: SCORE against XPATH always returns 1 *
* *
* The scoring function of a full-text search query on XML data *
* always scores documents with score value 1, no matter how *
* well the document matches the search criteria compared to *
* others. *
* *
* *
* *
* For example, given the following data *
* *
* 1, <test><title>The forest garden</title><chapter1>The Old *
* *
* Forest. Once upon a time the forest spread across all the *
* lands *
* south of the mountain, and only few travelers dared to take *
* a *
* short cut through the forest. There was no proper road and a *
* *
* traveler would </chapter1></test> *
* *
* 2, <test><title>A squirrel in the tuila *
* *
* tree</title><chapter1>Xiri quickly went down the tree to get *
* a *
* better look: What was this strange creature doing in the *
* forest? *
* It crashed through the bushes and seemed to be oblivious to *
* *
* where it was going - it had left a long line of *
* *
* </chapter1></test> *
* *
* 3, <test><title>North and South</title><chapter1>A forest *
* here, *
* a forest there, a forest everywhere. The northern forest is *
* dark *
* and dense, the southern forest light and</chapter1></test> *
* *
* *
* *
* *
* *
* db2 "select score(content, *
* *
* '@xpath:''/test/chapter1[.contains(\"forest\")]''') from *
* *
* testtable where contains(content, *
* *
* '@xpath:"/test/chapter1[.contains(\"forest\")]''') = 1" *
* *
* *
* *
* will result in the same score output for all documents, even *
* *
* though the search term frequency is different in each *
* document: *
* *
* *
* 1 *
* *
* ------------------------ *
* *
* +1.00000000000000E+000 *
* *
* +1.00000000000000E+000 *
* *
* +1.00000000000000E+000 *
* *
* *
* *
* 3 record(s) selected. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 9.5 Fix Pack 6 or later. *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
Product is fixed starting with DB2 version 9.5 Fix Pack 6 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 28.01.2010
14.06.2010
14.06.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.5.FP6
|
| Problem behoben lt. FixList in der Version |
