826245 - Unable to do a grouped search for comments specifying date and substring matches

Status: RESOLVED FIXED

(Bugzilla :: Query/Bug List, defect)

Description

[:glob ✱]

if you use custom search on the landfill database:

Match ALL of the following against the same field:
Comment: (changed after) 2012-07-01
Comment: SomebodythatlivesinBrazil 

the generated query doesn't actually link these two condition together, so you get bugs with comments matching either condition.

sql contains:

    LEFT JOIN bugs AS bugs_g2 ON bugs.bug_id = bugs_g2.bug_id
    LEFT JOIN longdescs AS longdescs_2 ON
        bugs_g2.bug_id = longdescs_2.bug_id
        AND longdescs_2.bug_when >= '2012-07-01 00:00:00'
...
    AND longdescs_2.bug_when IS NOT NULL
    AND bugs_g2.bug_id IN (
        SELECT DISTINCT
            bug_id
        FROM
            longdescs
        WHERE
            instr(
                thetext,
                'SomebodythatlivesinBrazil'
            )
            > 0
    )

Comment 1

[Frédéric Buclin]

Does this problem only affect comments, or also other fields?

Comment 2

[:glob ✱]

(In reply to Frédéric Buclin from comment #1)
> Does this problem only affect comments, or also other fields?

as far as i can tell, comments only.

Comment 3

[Frédéric Buclin]

I forgot: will bug 828344 fix this bug too? If yes, please set dependencies between them.

Comment 4

[Frédéric Buclin]

Bug 828344 has been fixed in 4.4 + trunk, and I cannot reproduce the issue.