Details

    • Type: New Feature New Feature
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: JCR 2.0
    • Labels:
      None

      Description

      Can we have more jcr-sql2 functions in jcr 2.0 like count() distinct()

        Activity

        Hide
        Randall Hauch added a comment -

        Actually, JBoss DNA was renamed to ModeShape in Jan 2010, and the documentation for the query languages supported by the latest version of ModeShape (currently 2.2) is at http://docs.jboss.org/modeshape/latest/manuals/reference/html/jcr-query-and-search.html.

        In ModeShape, DISTINCT is just added to the SELECT clause as an optional keyword (the same as in SQL-92/99). ModeShape does not currently implement COUNT() or any other aggregate functions.

        Show
        Randall Hauch added a comment - Actually, JBoss DNA was renamed to ModeShape in Jan 2010, and the documentation for the query languages supported by the latest version of ModeShape (currently 2.2) is at http://docs.jboss.org/modeshape/latest/manuals/reference/html/jcr-query-and-search.html . In ModeShape, DISTINCT is just added to the SELECT clause as an optional keyword (the same as in SQL-92/99). ModeShape does not currently implement COUNT() or any other aggregate functions.
        Hide
        Carl Hall added a comment -

        Here's the docs to JBossDNA which list all their functions (spec or out of spec).

        http://docs.jboss.org/jbossdna/0.7/manuals/reference/html/jcr-query-and-search.html

        Show
        Carl Hall added a comment - Here's the docs to JBossDNA which list all their functions (spec or out of spec). http://docs.jboss.org/jbossdna/0.7/manuals/reference/html/jcr-query-and-search.html
        Hide
        Jukka Zitting added a comment -

        JCR-SQL2 doesn't define support for the GROUP BY feature. What's the syntax used by JBoss for this? If we're to implement this feature, it probably makes sense to reuse the syntax from an existing implementation.

        Show
        Jukka Zitting added a comment - JCR-SQL2 doesn't define support for the GROUP BY feature. What's the syntax used by JBoss for this? If we're to implement this feature, it probably makes sense to reuse the syntax from an existing implementation.
        Hide
        Zhendong Chen added a comment -

        Yes, is there any way I can merge the duplicate query results without DISTINCT? JBOSS has DISTINCT beside the JCR Standard.

        Show
        Zhendong Chen added a comment - Yes, is there any way I can merge the duplicate query results without DISTINCT? JBOSS has DISTINCT beside the JCR Standard.

          People

          • Assignee:
            Unassigned
            Reporter:
            kaynezhang
          • Votes:
            3 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

            • Created:
              Updated:

              Development