Bug 114491 - Intermedia searching broken for phrases
Summary: Intermedia searching broken for phrases
Keywords:
Status: CLOSED RAWHIDE
Alias: None
Product: Red Hat Enterprise CMS
Classification: Retired
Component: other
Version: nightly
Hardware: All
OS: Linux
medium
medium
Target Milestone: ---
Assignee: Richard Li
QA Contact: Jon Orris
URL:
Whiteboard:
Depends On:
Blocks: 106481
TreeView+ depends on / blocked
 
Reported: 2004-01-28 17:45 UTC by Jon Orris
Modified: 2007-04-18 17:02 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2004-01-28 19:19:41 UTC
Embargoed:


Attachments (Terms of Use)

Description Jon Orris 2004-01-28 17:45:24 UTC
Description of problem:
@39825/oracle-se

Intermedia searching broken for phrases. If I search for 'foo bar
baz', the search will fail. Searching 'foo' or 'bar' or 'baz' works fine.

Looking at the logs, the problem is that the query is improperly
formatted. It is (simplified):
select object_id from search_content c  where (contains(c.xml_content,
'"Foo"and"Bar"and"Baz"', 1) > 0);

no rows selected
                                                                     
                                                       

Instead of:
select object_id from search_content c  where (contains(c.xml_content,
'"Foo" and "Bar" and "Baz"', 1) > 0);

 OBJECT_ID
----------
       706

Comment 1 Richard Li 2004-01-28 18:36:58 UTC
Fixed @39839

Comment 2 Jon Orris 2004-01-28 19:19:41 UTC
verified



Note You need to log in before you can comment on or make changes to this bug.