MM result vs MMINFO discrepency

Post Reply
barry.marcus
Posts: 288
Joined: Thu Nov 16, 2006 1:05 pm

MM result vs MMINFO discrepency

Post by barry.marcus »

Not sure what this means... I am running two queries against my DB. The first returns nothing, although it should, since the phrase "back surgery" IS in the ABST_PAx column of the row where PATN_WKU = '7290302'. And in fact, the second query, which requests an MMINFO on the ABST_PAx column using the same criteria DOES return the PATN_WKU value for the row. Seems like there may be something fouled up in my index. Any thoughts?

BTW, PATN_ISD is a string holding a date in the form yyymmdd, and is part of the index on ABST_PAx.

Here are the two queries:


set indexwithin = 7;
set withinmode = 'word';
SELECT PATN_WKU, PATN_ISD, ABST_PAx FROM PATN WHERE ABST_PAx LIKE '+surger* @0 back* w/2' AND PATN_WKU = '7290302';

set indexwithin = 7;
set withinmode = 'word';
SELECT PATN_WKU, PATN_ISD, MMINFO('+surger* @0 back* w/2', ABST_PAx, 0, 0, 0) FROM PATN WHERE PATN_WKU = '7290302';

Thanks in advance.
barry.marcus
Posts: 288
Joined: Thu Nov 16, 2006 1:05 pm

MM result vs MMINFO discrepency

Post by barry.marcus »

I rebuilt the metamorph index on the ABST_PAx to no avail. Same result. Weird.
User avatar
John
Site Admin
Posts: 2597
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

MM result vs MMINFO discrepency

Post by John »

Depending on your index expressions then the definition of 2 words may be slightly different. What text does mminfo() return as the match? What are the index expressions?
John Turnbull
Thunderstone Software
barry.marcus
Posts: 288
Joined: Thu Nov 16, 2006 1:05 pm

MM result vs MMINFO discrepency

Post by barry.marcus »

Here is the text that MMINFO returned:

"lying facedown) for back surgery or other medical proceduresinto a dedicated back surgery. The apparatus also eliminates"

Not sure what you mean by "index expressions", but here are the statements used to create the index:

set delexp=0;
set addexp = '\alnum{1,99}';
create METAMORPH INVERTED index PATN_ABST_PAx_MI on PATN(ABST_PAx,PATN_ISD);

Thanks
User avatar
John
Site Admin
Posts: 2597
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

MM result vs MMINFO discrepency

Post by John »

Which version of Texis? A quick attempt at replicating here seems to work OK.
John Turnbull
Thunderstone Software
barry.marcus
Posts: 288
Joined: Thu Nov 16, 2006 1:05 pm

MM result vs MMINFO discrepency

Post by barry.marcus »

Commercial Version 5.00.1090358162 20040720 (i686-unknown-linux2.4.2-64-32)
Post Reply