Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-9114

Some fulltext query badly interpreted by PostgreSQL

    XMLWordPrintable

    Details

      Description

      A fulltext query like:

      foo :
      

      or even a single : is incorrectly passed to the PostgreSQL fulltext query parser and results in an error:

      org.postgresql.util.PSQLException. message: ERROR: syntax error in tsquery: "(foo & :)"
      

        Attachments

          Activity

            People

            • Assignee:
              fguillaume Florent Guillaume
              Reporter:
              fguillaume Florent Guillaume
              Participants:
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 1 hour
                1h
                Remaining:
                Remaining Estimate - 1 hour
                1h
                Logged:
                Time Spent - Not Specified
                Not Specified