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

Capture warnings on queries, especially for common mistakes

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Done
    • Major
    • 3.2.0.Final
    • 3.1.3.Final
    • JCR, Query
    • None

    Description

      ModeShape used to validate the columns used in queries, but that actually prevents users from selecting residual columns. For example, this query is now valid:

      SELECT [myprop] FROM [nt:unstructured]
      

      However, this means that some common mistakes are not caught. For example, one common typo is to use a period ('.') rather than a colon (':') in namespaced names:

      SELECT [jcr.uuid] FROM [nt:base]
      

      The above query is technically valid, but is probably a typo.

      ModeShape should do as much as possible to help the user out. For example, we could change QueryResult to have a list of warnings, and we could include in those warnings things like:

      1. columns that are assumed to be residual columns because they do not match property definitions on node types.
      2. columns that don't match but are very similar to defined properties

      (e.g., {{SELECT

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: