466561 - gloda could expose all support fulltext search variants on message objects

Status: RESOLVED FIXED

(MailNews Core :: Database, defect)

Description

[Andrew Sutherland [:asuth] (he/him)]

Attachment: v1 add subject, attachment names, and everybody fulltext searches

Today, you can only fulltext search against the body of a message.  But imagine a world where you could fulltext search against subjects.  And a world where you could fulltext search against attachment names.  And yet another world where you can do all three at once!  But if you were to try and combine those worlds, they would explode, so don't do that[1].

1: The MATCH operator can only be used once per fulltext search table in a query.  I feel like this should be documented or enforced somehow in less of a "surprise, exception!" sort of way.  If we start more explicitly binding UI to constraints, it should probably be integrated into that.

Comment 1

[Andrew Sutherland [:asuth] (he/him)]

Now that I think about it, there will be no explosions.  Our queries are structured in such a way that I find it hard to believe we would run up against the MATCH operator limitations.  Mix and match fulltext searches to your heart's content.

Comment 2

[David :Bienvenu]

fixed