glassfish
  1. glassfish
  2. GLASSFISH-189

EJBQL: SQL misses outer join for EJBQL OUTER JOIN identification variable

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 9.0pe
    • Fix Version/s: 9.0pe
    • Component/s: entity-persistence
    • Labels:
      None
    • Environment:

      Operating System: All
      Platform: All

    • Issuezilla Id:
      189

      Description

      The following EJBQL query uses an identification variable in the SELECT clause
      that is defined in an OUTER JOIN clause. The generated SQL misses an outer join,
      but uses an inner join instead.
      EJBQL: SELECT c FROM Order o JOIN o.customer c
      SQL: SELECT t0.ID, ... FROM CUSTOMER_TABLE t0, ORDER_TABLE t1
      WHERE (t1.CUST_ID = t0.ID)

        Activity

        Hide
        mb124283 added a comment -

        I'm sorry. I included the wrong EJBQL in the description. The correct EJBQL is
        SELECT c FROM Order o LEFT OUTER JOIN o.customer c

        Show
        mb124283 added a comment - I'm sorry. I included the wrong EJBQL in the description. The correct EJBQL is SELECT c FROM Order o LEFT OUTER JOIN o.customer c
        Hide
        pkrogh added a comment -

        Reassigning to Michael

        Show
        pkrogh added a comment - Reassigning to Michael
        Hide
        jielin added a comment -

        assign to jielin

        Show
        jielin added a comment - assign to jielin
        Hide
        jielin added a comment -

        assign to tom for further investigation

        Show
        jielin added a comment - assign to tom for further investigation
        Hide
        tware added a comment -

        Will be fixed in next entity-persistence drop

        Show
        tware added a comment - Will be fixed in next entity-persistence drop
        Hide
        tware added a comment -

        Fixed in latest drop

        Show
        tware added a comment - Fixed in latest drop
        Hide
        tware added a comment -

        Fixed in latest drop

        Show
        tware added a comment - Fixed in latest drop
        Hide
        marina vatkina added a comment -

        Added build #

        Show
        marina vatkina added a comment - Added build #

          People

          • Assignee:
            tware
            Reporter:
            mb124283
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: