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-1367.patch
        4 kB
        Prashant Bhat
      2. openjpa-h2-test-results.txt
        8 kB
        Prashant Bhat

        Activity

        Thomas Mueller created issue -
        Prashant Bhat made changes -
        Field Original Value New Value
        Attachment OPENJPA-1367.patch [ 12431097 ]
        Attachment openjpa-h2-test-results.txt [ 12431098 ]
        Milosz Tylenda made changes -
        Assignee Milosz Tylenda [ milosz ]
        Milosz Tylenda made changes -
        Status Open [ 1 ] In Progress [ 3 ]
        Milosz Tylenda made changes -
        Fix Version/s 2.0.0 [ 12314019 ]
        Milosz Tylenda made changes -
        Component/s jdbc [ 12311300 ]
        Component/s sql [ 12311310 ]
        Component/s jpa [ 12311304 ]
        Milosz Tylenda made changes -
        Status In Progress [ 3 ] Resolved [ 5 ]
        Fix Version/s 1.3.0 [ 12313326 ]
        Resolution Fixed [ 1 ]
        Donald Woods made changes -
        Fix Version/s 2.0.0-beta2 [ 12314802 ]
        Fix Version/s 2.0.0 [ 12314019 ]
        Affects Version/s 2.0.0-beta [ 12314149 ]
        Affects Version/s 2.0.0-M3 [ 12314148 ]
        Affects Version/s 2.0.0-M2 [ 12313483 ]
        Donald Woods made changes -
        Status Resolved [ 5 ] Closed [ 6 ]

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development