List of allowsSelectNotInGroupBy() Examples

Examples of allowsSelectNotInGroupBy()

mondrian.spi.Dialect.allowsSelectNotInGroupBy()

Returns whether the database currently permits queries to include in the SELECT clause expressions that are not listed in the GROUP BY clause. The SQL standard allows this if the database can deduce that the expression is functionally dependent on columns in the GROUP BY clause.

For example, {@code SELECT empno, first_name || ' ' || last_name FROMemps GROUP BY empno} is valid because {@code empno} is the primary key ofthe {@code emps} table, and therefore all columns are dependent on it.For a given value of {@code empno}, {@code first_name || ' ' || last_name} has a unique value.

Most databases do not, MySQL is an example of one that does (if the functioality is enabled). @return Whether this Dialect allows SELECT clauses to containcolumns that are not in the GROUP BY clause

        assertQuerySqlOrNot(tc, queryCubeA, sqlPatterns, false, false, true);
    }


    private boolean dialectAllowsSelectNotInGroupBy() {
        final Dialect dialect = getTestContext().getDialect();
        return dialect.allowsSelectNotInGroupBy();
    }
}


// End SelectNotInGroupByTest.java

            + dialect.quoteIdentifier("the_month")
            + " from "
            + dialect.quoteIdentifier("time_by_day")
            + " group by "
            + dialect.quoteIdentifier("time_id");
        if (dialect.allowsSelectNotInGroupBy()) {
            final ResultSet resultSet =
                getConnection().createStatement().executeQuery(sql);
            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 allowsSelectNotInGroupBy()

Examples of mondrian.spi.Dialect.allowsSelectNotInGroupBy()

Examples of mondrian.spi.Dialect.allowsSelectNotInGroupBy()