[OPENJPA-1367] H2 Database Engine does support cross join

• 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
• Assignee: Milosz Tylenda
• Reporter: Thomas Mueller
• Created: 30/Oct/09 13:00
• Updated: 09/Mar/10 18:31
• Resolved: 08/Feb/10 19:30

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.