Uploaded image for project: 'Documentation'
  1. Documentation
  2. DOCS-7338

MongoDB full text search negation broken no ignore for special characters

    XMLWordPrintableJSON

Details

    • Icon: Bug Bug
    • Resolution: Won't Fix
    • Icon: Major - P3 Major - P3
    • Server_Docs_20231030
    • None
    • Server

    Description

      i am searching for codes such as "250.00" in a rather large database. the phrasing controls are working properly here so "\"250.00\"" in the execution stats is 250.00 which is exactly what i want to search for.

      The problem here is that terms is showing "[250, 00 ]" the term "00" is breaking the mongodb and causing it to search all records. In my database which is upwards of 1.5 million records its not responding for over a minute with results. I tested a "control" situation and searched just by "00" which took over a minute to respond. Then I searched by "250" and got the expected under 1/2 second response.

      I even took the time to do "250.00 -00" but the negation does not seem to be working either and it still searches by "00" in the table.

      I also tries "250\.00" as well as "250
      .00" such that the escape would exist in the string when it reached mongo through the driver, and continues to produce the same results.

      This is very alarming when developing in a windows environment. It does not seem to be broken in *nix environments.

      Please take a look at how to implement possibly escaping punctuation, or marking search terms as exact string matches.

      Also look into the negation list not negating terms.

      Let me know any useful information you can provide about this or if it is in the road-map to be fixed. If you can't reproduce the result, please feel free to contact me.

      Attachments

        Activity

          People

            Unassigned Unassigned
            xgen-internal-docs Docs Collector User (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              1 year, 14 weeks, 1 day ago