|
Problem IC70559
|
Status: Closed |
INCORRECT RESULTS USEING CONTAINS IN THE SAME SENTENCE |
| product: |
DB2 NET SEARCH / 5765F3800 / 910 - DB2 |
| Problem description: |
Here is the corrected recreate
DB2 "CREATE TABLE DOCVIEWR ( DOCKEY VARCHAR(200) FOR BIT DATA
NOT NULL , DOCTEXT CLOB(51200) LOGGED NOT COMPACT ) DISTRIBUTE
BY HASH(DOCKEY) IN DOCVIEWR_TS"
DB2 "ALTER TABLE DOCVIEWR ADD CONSTRAINT PK PRIMARY KEY
(DOCKEY)"
db2text "create index TEXT02R.CNINX_DOCVIEWER_DOC for text on
docviewr (doctext) format TEXT connect to sample"
db2 "Insert Into DocViewr Values('DocData_data://Clinical
Notes/Clinical Note+3656405:264907976:4', 'This is a sentence
mentioning both Remicade and never.')"
db2text Update Index Text02R.CNInx_DocViewer_Doc For Text
connect to sample
/* This won't match on the document inserted above. */
db2 "SELECT * FROM DOCVIEWR TEXTTABLE where CONTAINS(DOCTEXT,
'((\"never\" IN SAME SENTENCE AS \"Remicade\" ) |
((\"infliximab\", \"Remicade\") IN SAME SENTENCE AS \"decision\"
))') = 1"
/* But just swapping the order of the arguments to the ?|?
operator in the search argument it will then match on that
document. */
db2 "SELECT * FROM DOCVIEWR TEXTTABLE where CONTAINS(DOCTEXT,
'(((\"infliximab\", \"Remicade\") IN SAME SENTENCE AS
\"decision\" ) | (\"never\" IN SAME SENTENCE AS \"Remicade\"
))') = 1" |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
****************************************************************
* PROBLEM DESCRIPTION: *
* INCORRECT RESULTS USEING CONTAINS IN THE SAME SENTENCE *
****************************************************************
* RECOMMENDATION: *
* Upgrade to V91fp10 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
|
| Solution |
INCORRECT RESULTS USEING CONTAINS IN THE SAME SENTENCE |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC72132 IC72133
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.08.2010
02.02.2011
02.02.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.1.FP10
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.10
|
 |
