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

H2 Database Engine does support cross join

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 1.2.1, 2.0.0-M1, 2.0.0-M2, 2.0.0-M3, 2.0.0-beta
    • 1.3.0, 2.0.0-beta2
    • docs, jdbc, sql
    • 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

            milosz Milosz Tylenda
            thomasm Thomas Mueller
            Votes:
            1 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: