List of requiresUnionOrderByExprToBeInSelectClause() Examples

Examples of requiresUnionOrderByExprToBeInSelectClause()

mondrian.spi.Dialect.requiresUnionOrderByExprToBeInSelectClause()

Returns true if this dialect allows an expression in the ORDER BY clause of a UNION (or other set operation) query only if it occurs in the SELECT clause.

For example, SELECT x, y + z FROM t UNION ALL SELECT x, y + z FROM t ORDER BY y + z is allowed but SELECT x, y, z FROM t UNION ALL SELECT x, y, z FROM t ORDER BY y + z SELECT x, y, z FROM t ORDER BY y + z is not.

Access is an example of a dialect with this restriction. @return whether this dialect allows an expression in the ORDER BYclause of a UNION (or other set operation) query only if it occurs in the SELECT clause

            // not column name strings or expressions.
            switch (whichSelect) {
            case LAST:
                boolean nullable = true;
                final Dialect dialect = sqlQuery.getDialect();
                if (dialect.requiresUnionOrderByExprToBeInSelectClause()
                    || dialect.requiresUnionOrderByOrdinal())
                {
                    // If the expression is nullable and the dialect
                    // sorts NULL values first, the dialect will try to
                    // add an expression 'Iif(expr IS NULL, 1, 0)' into

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 requiresUnionOrderByExprToBeInSelectClause()

Examples of mondrian.spi.Dialect.requiresUnionOrderByExprToBeInSelectClause()