Uploaded image for project: 'Jackrabbit Oak'
  1. Jackrabbit Oak
  2. OAK-3377

Two spaces in SQL2 fulltext search -> error

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.0.19
    • 1.3.6, 1.4
    • query
    • None

    Description

      Execute the following SQL2 query (eg, in crx/de's query tool)
      SELECT * FROM [nt:unstructured] AS c WHERE (CONTAINS(c.[jcr:title], 'a b') AND ISDESCENDANTNODE(c, '/content'))
      (note there are 2 spaces between "a" and "b")
      Result: java.lang.IllegalArgumentException: Invalid expression: 'a b'

      If there is only 1 space between a and b, there is no error.

      Per jsr-283, fulltext expressions should be able to have strings of whitespace.

      Attachments

        Activity

          People

            thomasm Thomas Mueller
            lbyrum Laurie byrum
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: