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

Pseudo-columns should be included when expanding SELECT *

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Done
    • Major
    • 2.3.0.Final, 2.2.1.GA
    • 2.3.0.Final, 2.2.1.GA
    • JCR, Query
    • None

    Description

      Pseudo-columns were introduced in MODE-934, but as initially implemented they were not automatically included in the SELECT clause when the query engine expands "SELECT *" for each selector. However, it is possible to defined "marker" mixin node types that have no property definitions (because they don't extend 'nt:base'), which means they'd have no columns returned from a "SELECT *" query and thus none of these would ever be queryable through JCR-SQL2.

      Therefore, I think we should include the "jcr:path", "jcr:name", "jcr:score", "mode:localName", and "mode:depth" pseudo-columns when the SELECT * clause is expanded, so that all node types can be queried though JCR-SQL2, JCR-SQL, and XPath.

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: