Difference between revisions of "EclipseLink/DesignDocs/312146"

From Eclipsepedia

Jump to: navigation, search
Line 27: Line 27:
  
 
Other missing features of SQL could also be added to JPQL, such as sub selects in the SELECT from FROM clauses, and enhanced function support.
 
Other missing features of SQL could also be added to JPQL, such as sub selects in the SELECT from FROM clauses, and enhanced function support.
 +
 +
Other JPQL enhancements:
 +
* [https://bugs.eclipse.org/bugs/show_bug.cgi?id=243698 allow qualified class names in from clause]
 +
* [https://bugs.eclipse.org/bugs/show_bug.cgi?id=293775 allow alias on join fetch]
 +
* [https://bugs.eclipse.org/bugs/show_bug.cgi?id=315087 support for cast function]
 +
* [https://bugs.eclipse.org/bugs/show_bug.cgi?id=333645 group by fails in in]
  
 
Other JPQL bugs:
 
Other JPQL bugs:
 
* [https://bugs.eclipse.org/bugs/show_bug.cgi?id=346729 incorrect SQL for distinct]
 
* [https://bugs.eclipse.org/bugs/show_bug.cgi?id=346729 incorrect SQL for distinct]
 +
* [https://bugs.eclipse.org/bugs/show_bug.cgi?id=331124 join to element collection does not work]
 +
* [https://bugs.eclipse.org/bugs/show_bug.cgi?id=331969 join ignored]
 +
* [https://bugs.eclipse.org/bugs/show_bug.cgi?id=347562 group by ignored]
 +
* [https://bugs.eclipse.org/bugs/show_bug.cgi?id=300625 duplicate join in sub select]
 +
* [https://bugs.eclipse.org/bugs/show_bug.cgi?id=267767 package with order fails to parse]
 +
* [https://bugs.eclipse.org/bugs/show_bug.cgi?id=301905 stack overflow parsing query]
 +
* [https://bugs.eclipse.org/bugs/show_bug.cgi?id=320541 join of map fails]
 +
* [https://bugs.eclipse.org/bugs/show_bug.cgi?id=326848 plus not aliasable]
 +
* [https://bugs.eclipse.org/bugs/show_bug.cgi?id=327848 sub-string fails]
 +
* [https://bugs.eclipse.org/bugs/show_bug.cgi?id=328378 element collection fails with in]
 +
  
 
= Concepts =
 
= Concepts =

Revision as of 12:51, 4 October 2011

Design Specification: Enhanced JPQL

ER 312146

Feedback

Document History

Date Author Version Description & Notes
2011-10-04 James 0.1 Draft

Project overview

JPQL currently offers a sub-set of SQL functionality. Some queries that are possible using SQL cannot be defined using JPQL.

It is desired to make EclipseLink's JPQL support be more complete of what is possible in SQL.

A key requirement from users (#1 voted enhancement) is to have ON clause support in JPQL.

Other missing features of SQL could also be added to JPQL, such as sub selects in the SELECT from FROM clauses, and enhanced function support.

Other JPQL enhancements:

Other JPQL bugs:


Concepts

ON clause : the SQL clause part of the FROM clause that defines how to tables are joined, this can be used for both joins and outer joins, but is required for outer joins.

outer join : A join where if a row in the source table has no joined rows in the target table it is still included in the join result with a null row for the target table.

ANTRL : Third party library currently used in EclipseLink for parsing JPQL.

Hermes : New JPQL parser developed by Dali project for parsing JPQL at design time. Currently included in EclipseLink SVN, but not currently used.

Requirements

  • Support additional ON clause for a relationship join.
  • Support an ON clause on the join for two independent objects.

Design Constraints

  • Outer join capabilities differ in different databases.
  • SQL capabilities differ in different databases.

Functionality

Testing

API

Native API

Config files

Documentation

Open Issues

Issue # Owner Description / Notes
1 Which JPQL parser should be used ANTLR or Hermes?

Decisions

Issue Description / Notes Decision

Future Considerations

  • Other JPQL enhancements.