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

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

XMLWordPrintable

      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.

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

                Created:
                Updated:
                Resolved: