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

Add support for path, name, local name, depth, and score pseudo-column in JCR-SQL2

    Details

    • Estimated Difficulty:
      Medium

      Description

      The primary need for this feature comes from MODE-933.

      ModeShape's support for JCR-SQL2 (and perhaps JCR-SQL) should include using pseudo-columns for the path, name, local name, depth and score of a selector. Support should include using these pseudo-columns in the SELECT clause (just as regular properties, and thus would appear in the QueryResult's row values) and in the WHERE clause (where they can be rewritten to use the existing PATH, NAME, LOCALNAME, DEPTH, and SCORE functions). However, they should not be automatically included in the SELECT clause if the query uses "SELECT *"; they must explicitly be specified in order to appear in the results.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  rhauch Randall Hauch
                  Reporter:
                  rhauch Randall Hauch
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  0 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: