OpenJPA
  1. OpenJPA
  2. OPENJPA-1367

H2 Database Engine does support cross join

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor 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.

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

        Activity

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development