Uploaded image for project: 'OpenJPA'
  1. OpenJPA
  2. OPENJPA-1367

H2 Database Engine does support cross join

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.2.1, 2.0.0-M1, 2.0.0-M2, 2.0.0-M3, 2.0.0-beta
    • Fix Version/s: 1.3.0, 2.0.0-beta2
    • Component/s: docs, jdbc, sql
    • Labels:
      None

      Description

      The documentation says that the H2 database does not support cross joins:

      http://openjpa.apache.org/builds/1.2.1/apache-openjpa-1.2.1/docs/manual/dbsupport_h2.html
      http://openjpa.apache.org/builds/2.0.0-M3/apache-openjpa-2.0.0-M3/docs/manual/main.html

      H2 does support cross join since a long time (I don't remember what version). See: http://www.h2database.com/html/grammar.html#table_expression (CROSS). A condition is not required for cross join.

      I think the documentation should be changed, and probably the H2Dictionary should be changed as well (crossJoinClause = "CROSS JOIN"; requiresConditionForCrossJoin = false.

        Attachments

        1. openjpa-h2-test-results.txt
          8 kB
          Prashant Bhat
        2. OPENJPA-1367.patch
          4 kB
          Prashant Bhat

          Activity

            People

            • Assignee:
              milosz Milosz Tylenda
              Reporter:
              tmueller Thomas Mueller
            • Votes:
              1 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: