mondrian.spi.impl

Class MonetDbDialect

java.lang.Object

mondrian.spi.impl.JdbcDialectImpl

mondrian.spi.impl.MonetDbDialect

All Implemented Interfaces:

Dialect

public class MonetDbDialect
extends JdbcDialectImpl

Implementation of Dialect for the MonetDB database.

Since:

Nov 10, 2012

Author:

pstoellberger

Nested Class Summary

Nested classes/interfaces inherited from interface mondrian.spi.Dialect

Dialect.DatabaseProduct, Dialect.Datatype

Field Summary

Fields

Modifier and Type	Field and Description
static JdbcDialectFactory	FACTORY

Fields inherited from class mondrian.spi.impl.JdbcDialectImpl

databaseProduct, permitsSelectNotInGroupBy, productVersion

Constructor Summary

Constructors

Constructor and Description
MonetDbDialect(Connection connection) Creates a MonetDbDialect.

Method Summary

Methods

Modifier and Type	Method and Description
boolean	allowsCompoundCountDistinct() Returns whether this Dialect allows multiple arguments to the COUNT(DISTINCT ...) aggregate function, for example SELECT COUNT(DISTINCT x, y) FROM t
boolean	allowsCountDistinct() Returns whether this Dialect supports distinct aggregations.
boolean	allowsMultipleDistinctSqlMeasures() Returns whether this Dialect has performant support of distinct SQL measures in the same query.
SqlStatement.Type	getType(ResultSetMetaData metaData, int columnIndex) Chooses the most appropriate type for accessing the values of a column in a result set for a dialect.
void	quoteStringLiteral(StringBuilder buf, String s) Appends to a buffer a single-quoted SQL string.
boolean	requiresAliasForFromQuery() Returns whether this Dialect requires subqueries in the FROM clause to have an alias.
boolean	supportsGroupByExpressions() Returns whether this Dialect supports expressions in the GROUP BY clause.

Methods inherited from class mondrian.spi.impl.JdbcDialectImpl

allowsAs, allowsDdl, allowsDialectSharing, allowsFromQuery, allowsJoinOn, allowsMultipleCountDistinct, allowsOrderByAlias, allowsRegularExpressionInWhereClause, allowsSelectNotInGroupBy, appendHintsAfterFromClause, caseWhenElse, computeStatisticsProviders, deduceIdentifierQuoteString, deduceMaxColumnNameLength, deduceProductName, deduceProductVersion, deduceReadOnly, deduceSupportedResultSetStyles, deduceSupportsSelectNotInGroupBy, generateCountExpression, generateInline, generateInlineForAnsi, generateInlineGeneric, generateOrderByNulls, generateOrderByNullsAnsi, generateOrderItem, generateRegularExpression, getDatabaseProduct, getMaxColumnNameLength, getProduct, getQuoteIdentifierString, getStatisticsProviders, isDatabase, logTypeInfo, needsExponent, quote, quoteBooleanLiteral, quoteDateLiteral, quoteDateLiteral, quoteIdentifier, quoteIdentifier, quoteIdentifier, quoteIdentifier, quoteNumericLiteral, quoteTimeLiteral, quoteTimestampLiteral, requiresGroupByAlias, requiresHavingAlias, requiresOrderByAlias, requiresUnionOrderByExprToBeInSelectClause, requiresUnionOrderByOrdinal, supportsGroupingSets, supportsMultiValueInExpr, supportsResultSetConcurrency, supportsUnlimitedValueList, toString, toUpper

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

FACTORY

public static final JdbcDialectFactory FACTORY

Constructor Detail

MonetDbDialect

public MonetDbDialect(Connection connection)
               throws SQLException

Creates a MonetDbDialect.

Parameters:

connection - Connection

Throws:

SQLException - on error

Method Detail

allowsMultipleDistinctSqlMeasures

public boolean allowsMultipleDistinctSqlMeasures()

Description copied from interface: Dialect

Returns whether this Dialect has performant support of distinct SQL measures in the same query.

Specified by:

allowsMultipleDistinctSqlMeasures in interface Dialect

Overrides:

allowsMultipleDistinctSqlMeasures in class JdbcDialectImpl

Returns:

whether this dialect supports multiple count(distinct subquery) measures in one query.

allowsCountDistinct

public boolean allowsCountDistinct()

Description copied from interface: Dialect

Returns whether this Dialect supports distinct aggregations.

For example, Access does not allow

select count(distinct x) from t

Specified by:

allowsCountDistinct in interface Dialect

Overrides:

allowsCountDistinct in class JdbcDialectImpl

Returns:

whether Dialect allows COUNT DISTINCT

requiresAliasForFromQuery

public boolean requiresAliasForFromQuery()

Description copied from interface: Dialect

Returns whether this Dialect requires subqueries in the FROM clause to have an alias.

Specified by:

requiresAliasForFromQuery in interface Dialect

Overrides:

requiresAliasForFromQuery in class JdbcDialectImpl

Returns:

whether dialewct requires subqueries to have an alias

See Also:

Dialect.allowsFromQuery()

allowsCompoundCountDistinct

public boolean allowsCompoundCountDistinct()

Description copied from interface: Dialect

Returns whether this Dialect allows multiple arguments to the COUNT(DISTINCT ...) aggregate function, for example

SELECT COUNT(DISTINCT x, y) FROM t

Specified by:

allowsCompoundCountDistinct in interface Dialect

Overrides:

allowsCompoundCountDistinct in class JdbcDialectImpl

Returns:

whether Dialect allows multiple arguments to COUNT DISTINCT

See Also:

Dialect.allowsCountDistinct(), Dialect.allowsMultipleCountDistinct()

supportsGroupByExpressions

public boolean supportsGroupByExpressions()

Description copied from interface: Dialect

Returns whether this Dialect supports expressions in the GROUP BY clause. Derby/Cloudscape and Infobright do not.

Specified by:

supportsGroupByExpressions in interface Dialect

Overrides:

supportsGroupByExpressions in class JdbcDialectImpl

Returns:

Whether this Dialect allows expressions in the GROUP BY clause

quoteStringLiteral

public void quoteStringLiteral(StringBuilder buf,
                      String s)

Description copied from interface: Dialect

Appends to a buffer a single-quoted SQL string.

For example, in the default dialect, quoteStringLiteral(buf, "Can't") appends "'Can''t'" to buf.

Specified by:

quoteStringLiteral in interface Dialect

Overrides:

quoteStringLiteral in class JdbcDialectImpl

Parameters:

buf - Buffer to append to

s - Literal

getType

public SqlStatement.Type getType(ResultSetMetaData metaData,
                        int columnIndex)
                          throws SQLException

Description copied from interface: Dialect

Chooses the most appropriate type for accessing the values of a column in a result set for a dialect.

Dialect-specific nuances involving type representation should be encapsulated in implementing methods. For example, if a dialect has implicit rules involving scale or precision, they should be handled within this method so the client can simply retrieve the "best fit" SqlStatement.Type for the column.

Specified by:

getType in interface Dialect

Overrides:

getType in class JdbcDialectImpl

Parameters:

metaData - Results set metadata

columnIndex - Column ordinal (0-based)

Returns:

the most appropriate SqlStatement.Type for the column

Throws:

SQLException