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.
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.