Package mondrian.spi.impl

Class SybaseDialect

java.lang.Object

mondrian.spi.impl.JdbcDialectImpl

mondrian.spi.impl.SybaseDialect

All Implemented Interfaces:

Dialect

public class SybaseDialect
extends JdbcDialectImpl

Implementation of Dialect for the Sybase database.

Since:

Nov 23, 2008

Author:

jhyde

Nested Class Summary

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

Dialect.DatabaseProduct, Dialect.Datatype

Field Summary

Fields

Modifier and Type	Field	Description
static final JdbcDialectFactory	FACTORY

Fields inherited from class mondrian.spi.impl.JdbcDialectImpl

databaseProduct, permitsSelectNotInGroupBy, productVersion

Constructor Summary

Constructors

Constructor	Description
SybaseDialect(Connection connection)	Creates a SybaseDialect.

Method Summary

Modifier and Type	Method	Description
boolean	allowsAs()	Returns whether the SQL dialect allows "AS" in the FROM clause.
boolean	allowsFromQuery()	Returns whether this Dialect allows a subquery in the from clause, for example SELECT * FROM (SELECT * FROM t) AS x
protected void	quoteDateLiteral(StringBuilder buf, String value, Date date)	Helper method for JdbcDialectImpl.quoteDateLiteral(StringBuilder, String).
boolean	requiresAliasForFromQuery()	Returns whether this Dialect requires subqueries in the FROM clause to have an alias.

Methods inherited from class mondrian.spi.impl.JdbcDialectImpl

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

Methods inherited from class java.lang.Object

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

Field Details

FACTORY

public static final JdbcDialectFactory FACTORY

Constructor Details

SybaseDialect

public SybaseDialect(Connection connection)
              throws SQLException

Creates a SybaseDialect.

Parameters:

connection - Connection

Throws:

SQLException

Method Details

allowsAs

public boolean allowsAs()

Description copied from interface: Dialect

Returns whether the SQL dialect allows "AS" in the FROM clause. If so, "SELECT * FROM t AS alias" is a valid query.

Specified by:

allowsAs in interface Dialect

Overrides:

allowsAs in class JdbcDialectImpl

Returns:

whether dialect allows AS in FROM clause

allowsFromQuery

public boolean allowsFromQuery()

Description copied from interface: Dialect

Returns whether this Dialect allows a subquery in the from clause, for example

SELECT * FROM (SELECT * FROM t) AS x

Specified by:

allowsFromQuery in interface Dialect

Overrides:

allowsFromQuery in class JdbcDialectImpl

Returns:

whether Dialect allows subquery in FROM clause

See Also:

• Dialect.requiresAliasForFromQuery()

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

quoteDateLiteral

protected void quoteDateLiteral(StringBuilder buf,
 String value,
 Date date)

Description copied from class: JdbcDialectImpl

Helper method for JdbcDialectImpl.quoteDateLiteral(StringBuilder, String).

Overrides:

quoteDateLiteral in class JdbcDialectImpl

Parameters:

buf - Buffer to append to

value - Value as string

date - Value as date