List of allowsCountDistinct() Examples

Examples of allowsCountDistinct()

mondrian.spi.Dialect.allowsCountDistinct()
Returns whether this Dialect supports distinct aggregations.
For example, Access does not allow
select count(distinct x) from t
@return whether Dialect allows COUNT DISTINCT

Examples of mondrian.spi.Dialect.allowsCountDistinct()

    public String generateSqlQuery() {
        SqlQuery sqlQuery = newSqlQuery();


        int k = getDistinctMeasureCount();
        final Dialect dialect = sqlQuery.getDialect();
        if (!dialect.allowsCountDistinct() && k > 0
            || !dialect.allowsMultipleCountDistinct() && k > 1)
        {
            distinctGenerateSql(sqlQuery, countOnly);
        } else {
            nonDistinctGenerateSql(sqlQuery);

View Full Code Here

Examples of mondrian.spi.Dialect.allowsCountDistinct()

            final Dialect dialect = getDialect();


            int distinctMeasureCount = getDistinctMeasureCount(measuresList);
            boolean tooManyDistinctMeasures =
                distinctMeasureCount > 0
                && !dialect.allowsCountDistinct()
                || distinctMeasureCount > 1
                   && !dialect.allowsMultipleCountDistinct();


            if (tooManyDistinctMeasures) {
                doSpecialHandlingOfDistinctCountMeasures(

View Full Code Here

Examples of mondrian.spi.Dialect.allowsCountDistinct()

        SqlQuery sqlQuery = newSqlQuery();


        int k = getDistinctMeasureCount();
        final Dialect dialect = sqlQuery.getDialect();
        final Map<String, String> groupingSetsAliases;
        if (!dialect.allowsCountDistinct() && k > 0
            || !dialect.allowsMultipleCountDistinct() && k > 1)
        {
            groupingSetsAliases =
                distinctGenerateSql(sqlQuery, countOnly);
        } else {

View Full Code Here

TOP

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.