 45 | (builder.asc(upperPath)) I would have expected the alias to be used in the ORDER BY clause, something like
SELECT $1, UPPER($1.someStringProperty) AS TEST FROM T ORDER BY TEST However what I actually get as query string is
SELECT $1, UPPER($1.someStringProperty) AS TEST FROM T ORDER BY UPPER($1 |
38 | javax.persistence.criteria Interface Order An object that defines an ordering over the query results. Since: JPA 2.0 Learn how to use JPA Criteria API's Order in Chapter 4 of the ObjectDB/JPA manual. Expression getExpression() Return the expression that is used for ordering. Return |
38 | javax.jdo.annotations Annotation Order Target: Fields (including property get methods) Annotation for the ordering component of an ordered container member, such as Java Collections Framework Array and List types and Java native array types. Corresponds to the xml element "order". Since: JDO 2.1 |
37 | Method javax.persistence.criteria.Order Order reverse() Switch the ordering. Returns: a new Order instance with the reversed ordering Since: JPA 2.0 |
37 | Method javax.persistence.criteria.Order Expression getExpression() Return the expression that is used for ordering. Returns: expression used for ordering Since: JPA 2.0 |
37 | Method javax.persistence.criteria.Order boolean isAscending() Whether ascending ordering is in effect. Returns: boolean indicating whether ordering is ascending Since: JPA 2.0 |
37 | Annotation Element javax.jdo.annotations.Order String column The name of the column to use for ordering the elements of the member. Returns: the name of the ordering column Default value: "" Since: JDO 2.1 |
37 | Annotation Element javax.jdo.annotations.Order Column[] columns The definition of the column(s) to use for ordering. Returns: the columns to use for ordering Default value: {} Since: JDO 2.1 |
37 | Annotation Element javax.jdo.annotations.Order String mappedBy Name of a field or property in the target class that acts as the ordering field or property for this member. Return the name of the field or property in the target class Default value: "" Since: JDO 2.1 |
25 | will affect the way strings are sorted in queries (with ORDER BY). Currently strings are always ordered by Unicode order, and a workaround that enables controlling the order is to use normalizing, as discussed ... , DMS and other systems requires correct collation when using order by clause. +1 for this ... lwalkowski dmarko Arne |