List of requiresHavingAlias() Examples

Examples of requiresHavingAlias()

mondrian.spi.Dialect.requiresHavingAlias()

Returns true if this Dialect can include expressions in the HAVING clause only by adding an expression to the SELECT clause and using its alias.

For example, in such a dialect,

SELECT CONCAT(x) as foo FROM t HAVING CONCAT(x) LIKE "%"

would be illegal, but

SELECT CONCAT(x) as foo FROM t HAVING foo LIKE "%"

would be legal.

MySQL is an example of such dialects.

@return Whether this Dialect can include expressions in the HAVINGclause only by adding an expression to the SELECT clause and using its alias

                + dialect.quoteIdentifier("customer", "fname")
                + " having "
                + dialect.quoteIdentifier("customer", "fname")
                + " LIKE ");
        dialect.quoteStringLiteral(sb, "%");
        if (!dialect.requiresHavingAlias()) {
            final ResultSet resultSet =
                getConnection().createStatement().executeQuery(sb.toString());
            assertTrue(resultSet.next());
            resultSet.close();
        } else {

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.

Examples of requiresHavingAlias()

Examples of mondrian.spi.Dialect.requiresHavingAlias()