Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

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 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.