Current Position:Home > Incorrect/duplicate result set

Incorrect/duplicate result set

Update:11-30Source: network consolidation
Advertisement
In my context index, each document_id is unique. However, when I do a search on one specific document_id, the exact same document is returned to me twice:
select document_id from books
where contains(user_dummy, '402039968');
document_id
402039968
402039968
When I look at the respective partition $I table for this token, I see that:
select token_text, token_type, token_first, token_last, token_count from DR#BOOK_NDX0103$I
where token_text = '402039968';
token_text = 402039968
token_type = 0
token_first = 32035
token_last = 313648
token_count = 2
This double result return does not occur for all documents. Most documents act as expected, and return only once. A correctly working document:
select document_id from books
where contains(user_dummy, '402034806');
document_id
402034806
select token_text, token_type, token_first, token_last, token_count from DR#BOOK_NDX0103$I
where token_text = '402034806';
token_text = 40203480
token_type = 0
token_first = 250153
token_last = 250153
token_count = 1
I do notice a difference in the $I token_count, however do not know what is causing certain documents to be returned twice.
I have also verified that there is a 1:1 relationship in the $K table for this rowid. Does this indicate something was indexed incorrectly? I have run the optimization on this partition. Any ideas/leads would be appreciated!

The Best Answer

Advertisement
(if relevant to this situation, Oracle support has not provided a known bug number to me yet)
In DR#BOOK_NDX0103$I, I notice 2 things that do not look correct:
token_text = 402039968
token_type = 0
token_first = 32035
token_last = 313648
token_count = 2
token_first = 32035, however, when I run:
select * from DR#BOOK_NDX0103$K where docid =32035
I get 0 results back, which means that there is no corresponding row in the base table for this docid.
Furthermore, as I indicated before, the token_count, which indicates 2 is incorrect, as there should only be 1 document in this row.
Anybody see this before?
  • Incorrect/duplicate result set Update:11-30

    In my context index, each document_id is unique. However, when I do a search on one specific document_id, the exact same document is returned to me twice: select document_id from books where contains(user_dummy, '402039968'); document_id 402039968 40

  • Avoid duplicate results after a Catalog search Update:11-30

    Hello, I tried implementing note  Note 811194 - Avoid duplicate results after a Catalog search - but unfortunately, the code in my version of WebCatItemList is quite different. Is there another note for newer versions of eCommerce? Or is code modific

  • Incorrect duplicate entires Update:11-30

    Using: Nano iCal iTunes to sync up everything (iCal, etc) Issue: Incorrect duplicate entries in iCal on nano but not in iCal on PowerBook What I did: I originally had it iCal set up with Sunday as first day of week. Everything in nano was just peachy

  • How to correct SQL about duplicate results Update:11-30

    Dear all, I'm Michel. I want to correct Oracle 11g SQL Statement about view the table is locked. The current SQL that can be created, as follows. SELECT 'view the table is locked', V.INSTANCE_NAME, UE.SEGMENT_NAME FROM SYS.V_$SESSION SE, SYS.V_$LOCK

  • Issue with Duplicate Results and Summary Fields Update:10-11

    My report is based on an Access Database. For the purposes of this current issue, there is the Master Table called u201CCnu201D and then a related u201CTable Au201D which includes multiple records related to the Master and also a related u201CTable B

  • Incorrect Search results number Update:10-11

    Hi! I'm currently working at search center and recently I've noticed that the number of search results in "About xx results" can vary a a lot. I've found the similar question here: http://community.office365.com/en-us/f/154/t/204676.aspx - the g

  • Incorrect Search Results Update:11-30

    We have a PDF file of 1 page created through SAP (ERP Application). The PDF has a name "AD" which is displayed and printed. When we search the PDF using search option for name "ZZ", it gives the search results by selecting name "A

  • Incorrect query result with Top N condition and two structures Update:11-30

    Hi, I have created a query on a FI-GL infocube with the characteristic 0BUS_AREA in rows and two structures in columns. The first structure has two items / selections (each item is a selection of several GL accounts). The second structure has two ite

  • Defining Working Times - Incorrect Scheduling Result for non-Working Date Update:11-30

    Hi All, We are on SAP R/3 46C and in the process of implementing 'Route Schedules' for our outbound delivery processing. One of the pre-requisite customising requirements for 'Route Schedules' is to maintain 'Working Times' for the Shipping Point for

  • Search in Mail (exchange account) gives duplicate results Update:11-30

    ok - so assume that I know a bit about what I am asking - not a POP issue - not a corrupt exchange account, etc. When looking into the inbox for the account - ONLY one copy exists. When going to the accounts and then inbox - ONLY one copy exists When