Uploaded image for project: 'ModeShape'
  1. ModeShape
  2. MODE-2027

CONTAINS function in JCR-SQL2 should behave as selector.* when first parameter is '.'

    XMLWordPrintable

Details

    Description

      The following query should fail to parse because the '.' supplied as the first parameter of the CONTAINS function is not valid:

      SELECT * FROM [nt:base] WHERE  CONTAINS(., '*') order by [jcr:title] desc
      

      The query will incorrectly parse and will execute, but it will never find any results.

      Attachments

        Activity

          People

            hchiorean Horia Chiorean (Inactive)
            rhauch Randall Hauch (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: