Join annotation values into a main item query

[Nicklas Nordborg]

By mapping a few extra associations in the data layer classes it should be possible to join the annotation value tables into the main item query. The main use case is that it would be possible to sort on single-valued annotation values in the web interface (see #1673).

[Nicklas Nordborg]

(In [6022]) Fixes #1672: Join annotation values into a main item query

There is now support for this in the Query API. The main entry point is the Annotations.expression(), Annotations.innerJoin() and Annotations.leftJoin() methods. The implementation is in the AnnotationJoin and AnnotationExpression classes. The expression variant uses an auto-joiner to automatically create the correct join. Otherwise, an explict join can be use together with a regular Hql.alias() expression.

In the data layer, the functionality is provided by the shortcut link defined by AnnotatableData.getAnnotations(). The AnnotationLink provides the mappings that are needed to reach the final ***Values table. To get XDoclet to create the mapping that we needed we have added support for property-ref and mutable.

[Nicklas Nordborg]

(In [6045]) Belong to #1674 (not 1672).

[Nicklas Nordborg]

(In [6106]) References #1672: Join annotation values into a main item query

Fixes an issued with MySQL that didn't create the 'id' column as AUTO_INCREMENT.