Shortcut for Expr.as(Path)

[Samppa Saarela]

Instead of

PNumber<Long> countAlias = new PNumber<Long>(Long.class, "rowCount");
// ...use countAlias in e.g. having clause...
query.list(entity.column.count().as(countAlias));

Something like this:

ENumber<Long> count = entity.column.count().as("count");
// ...use count in e.g. having clause...
query.list(count);

In this latter form "count" would be serialized in full form in select and from clauses and through the alias in other query parts.

[Timo Westkämper (timo-westkamper)]

Added shortcut into ESimple and subclasses. Usage examples :

    @Test
    @ExcludeIn({DERBY,HSQLDB})
    public void path_alias(){
        expectedQuery = "select e.LASTNAME, sum(e.SALARY) as salarySum from EMPLOYEE2 e group by e.LASTNAME having salarySum > ?";

        ENumber<BigDecimal> salarySum = employee.salary.sum().as("salarySum");
        query().from(employee)
        .groupBy(employee.lastname)
        .having(salarySum.gt(10000))
        .list(employee.lastname, salarySum);
    }

[Timo Westkämper (timo-westkamper)]

The alias is serialized in full form in select and from parts and in short form everywhere else

[Timo Westkämper (timo-westkamper)]

Released in 1.9.6