OraFAQ Forum: Text & interMedia » contains query not returning expected results

Home » Server Options » Text & interMedia » contains query not returning expected results (11.2.0.2 , Redhat 2.6.18-194.el5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

contains query not returning expected results [message #646185]

Mon, 21 December 2015 08:33

jxxx
Messages: 1
Registered: December 2015

Junior Member

running a select on a columns with a CTXSYS.CONTEXT index (11.2.0.2, redhat 6). the column has 5 entries but for some reason the last two are not being returned by a contains query even though values in the column match. so in the example below, queries using "contains" returns values if i use EXAM.COL1,EXAM.COL2,EXAM.COL3 but not if i select either of the last two entries in the field, EXAM.COL4,EXAM.COL5

s_s_a column entries
EXAM.COL1,EXAM.COL2,EXAM.COL3,EXAM.COL4,EXAM.COL5

Select * from example_table where (contains(s_s_a, 'EXAM.COL2') > 0 ) - returns values
Select * from example_table where (contains(s_s_a, 'EXAM.COL5') > 0 ) - doesnt return values

i have tried

ctx_ddl.sync_index & rebuilding the index

any ideas?

Report message to a moderator

Previous Topic:	matching names from two tables
Next Topic:	PDF to HTML convert using ctxsys.auto_filter different result db 11.2 and 12.1

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 08:43:35 CST 2025