Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
      None

      Description

      affects version 2.3.7

      running a query that joins on the same node type against 2.3.6 returns 1 result, while running it against 2.3.7 returns the same node 3 times. if i join two different node types, i get only one result row...

      to reproduce: in my repository, i have 2 unstructured nodes with the same jcr:mimeType and one of them having the field zeronumber with value 0.

      QueryManager qm = s.getWorkspace().getQueryManager();
      Query q = qm.createQuery("SELECT data.zeronumber FROM [nt:unstructured] AS data INNER JOIN [nt:unstructured] AS second ON data.[jcr:mimeType] = second.[jcr:mimeType] WHERE data.zeronumber = 0", Query.JCR_JQOM);
      QueryResult r = q.execute();
      RowIterator i = r.getRows();
      while (i.hasNext())

      { Row n = i.nextRow(); System.out.println(n.getPath("data")); }

      jukka suspects this could be introduced by JCR-3198

      1. JCR-3219-test.patch
        3 kB
        Alex Parvulescu

        Activity

        No work has yet been logged on this issue.

          People

          • Assignee:
            Unassigned
            Reporter:
            David Buchmann
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development