[jira] Created: (OPENJPA-1367) H2 Database Engine does support cross join

1 message Options
Embed this post
Permalink
JIRA jira@apache.org

[jira] Created: (OPENJPA-1367) H2 Database Engine does support cross join

Reply Threaded More More options
Print post
Permalink
H2 Database Engine does support cross join
------------------------------------------

                 Key: OPENJPA-1367
                 URL: https://issues.apache.org/jira/browse/OPENJPA-1367
             Project: OpenJPA
          Issue Type: Bug
          Components: docs, jpa
    Affects Versions: 2.0.0-M1, 1.2.1
            Reporter: Thomas Mueller
            Priority: Minor


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;).




--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.