Uploaded image for project: 'JBoss Enterprise Application Platform'
  1. JBoss Enterprise Application Platform
  2. JBEAP-10776

Incorrect SQL generated when use both left join with unrelated entity and implicit join to another entity in select-clause -- still broken on Sybase

    Details

    • Type: Bug
    • Status: New (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 7.1.0.DR11
    • Fix Version/s: None
    • Component/s: Hibernate
    • Labels:
      None

      Description

      This issue is to track the fact that even though https://hibernate.atlassian.net/browse/HHH-11337 was fixed in Hibernate 5.1.4, the affected queries still fail on Sybase and DB2 (and possibly other databases) - see comment https://hibernate.atlassian.net/browse/HHH-11337?focusedCommentId=88106&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#comment-88106

      This issue is specifically for fixing on Sybase.

      This can be reproduced by running EntityJoinTest.testLeftOuterEntityJoinsWithImplicitInnerJoinInSelectClause against an affected database.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  gbadner Gail Badner
                  Reporter:
                  gbadner Gail Badner
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated: