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

Pseudo-columns should be included when expanding SELECT *

    Details

    • Type: Feature Request
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 2.3.0.Final, 2.2.1.GA
    • Fix Version/s: 2.3.0.Final, 2.2.1.GA
    • Component/s: JCR, Query
    • Labels:
      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.

        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: