Home » Server Options » Text & interMedia » contains query not returning expected results (11.2.0.2 , Redhat 2.6.18-194.el5)
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?
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:
  


Current Time: Fri Nov 24 04:53:17 CST 2017

Total time taken to generate the page: 0.01796 seconds