Uploaded image for project: 'Hibernate ORM'
  1. HHH-11499

Add a new DB2 dialect that uses "cross join" for cross joins instead of ","

    Details

    • backPortable:
      Backport?
    • Last commented by a user?:
      true
    • backportDecision:
      Approved

      Description

      Currently DB2Dialect uses ", " for cross joins because 9.1 does not support "cross join" syntax. DB2 has problems combining ", " with "join" syntax, so the fix for HHH-11337 Closed does not work on DB2.

      Although DB2 9.1 reached its end of life April 30, 2015, some applications may still be using that version, so I will create a new DB2 dialect that extends DB2Dialect and overrides getCrossJoinSeparator() to return " cross join ".

      The question is what to call the new dialect.

      According to DB2 9.5 and 9.7 documentation, "cross join" syntax is supported in those versions. I am able to confirm this on 9.7, but I do not have access to DB2 9.5 to try it out.

      If someone can confirm this will work on DB2 9.5 by the time Hibernate 5.2.9 is released, then I'll name the new dialect DB295Dialect; otherwise, I'll name it DB297Dialect.

        Attachments

          Issue links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: