Uploaded image for project: 'Jackrabbit Content Repository'
  1. Jackrabbit Content Repository
  2. JCR-3159

LOWER operand with nested LOCALNAME operand not work with SQL2

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.2.8
    • 2.3.5
    • query
    • None
    • Java 6

    Description

      Below query was running successful using Query.SQL languange:
      SELECT * FROM nt:file WHERE (CONTAINS(*, 'Jon') OR LOWER(fn:name()) LIKE '%jon%') AND jcr:path LIKE '/Resources/%' ORDER BY jcr:score()

      But equivalent next query in Query.JCR_SQL2 will fail with exception UnsupportedRepositoryOperationException():
      SELECT * FROM [nt:file] WHERE (CONTAINS([nt:file].*, 'Jon') OR LOWER(LOCALNAME()) LIKE '%jon%') AND ISDESCENDANTNODE('/Resources') ORDER BY SCORE()

      From my investigation seems LOWER function will not work with nested function LOCALNAME. According to section "6.7.32 LowerCase" JCR 2.0 Specs, LOWER operand able to work on DynamicOperand argument.

      Attachments

        Activity

          People

            stillalex Alex Deparvu
            joe.satriani Joe Satriani
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: