Details

    • Type: Sub-task Sub-task
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 2.0.0-M2
    • Fix Version/s: 2.0.0-M2
    • Component/s: query
    • Labels:
      None

      Activity

      Hide
      Catalina Wei added a comment -

      JPQ2 query updates to allow KEY appear in subquery.
      Code checked in under r776117.

      Sample queries:
      "select i from Item1 i" +
      " where ?1 = any " +
      " (select KEY(e) from Item1 i, in(i.images) e) " +
      " order by i",
      "select i from Item2 i" +
      " where ?1 = any " +
      " (select KEY(e) from Item2 i, in(i.images) e) " +
      " order by i",
      "select i from Item3 i" +
      " where ?1 = any " +
      " (select KEY(e) from Item3 i, in(i.images) e) " +
      " order by i",
      "select i from Item1 i" +
      " where exists " +
      " (select e from Item1 i, in(i.images) e" +
      " where ?1 = KEY(e)) " +
      " order by i",
      "select i from Item2 i" +
      " where exists " +
      " (select e from Item2 i, in(i.images) e" +
      " where ?1 = KEY(e)) " +
      " order by i",
      "select i from Item3 i" +
      " where exists " +
      " (select e from Item3 i, in(i.images) e" +
      " where ?1 = KEY(e)) " +
      " order by i",

      Show
      Catalina Wei added a comment - JPQ2 query updates to allow KEY appear in subquery. Code checked in under r776117. Sample queries: "select i from Item1 i" + " where ?1 = any " + " (select KEY(e) from Item1 i, in(i.images) e) " + " order by i", "select i from Item2 i" + " where ?1 = any " + " (select KEY(e) from Item2 i, in(i.images) e) " + " order by i", "select i from Item3 i" + " where ?1 = any " + " (select KEY(e) from Item3 i, in(i.images) e) " + " order by i", "select i from Item1 i" + " where exists " + " (select e from Item1 i, in(i.images) e" + " where ?1 = KEY(e)) " + " order by i", "select i from Item2 i" + " where exists " + " (select e from Item2 i, in(i.images) e" + " where ?1 = KEY(e)) " + " order by i", "select i from Item3 i" + " where exists " + " (select e from Item3 i, in(i.images) e" + " where ?1 = KEY(e)) " + " order by i",

        People

        • Assignee:
          Catalina Wei
          Reporter:
          Catalina Wei
        • Votes:
          0 Vote for this issue
          Watchers:
          0 Start watching this issue

          Dates

          • Created:
            Updated:
            Resolved:

            Development