org.apache.calcite.sql.dialect

Class SybaseSqlDialect

java.lang.Object

org.apache.calcite.sql.SqlDialect

org.apache.calcite.sql.dialect.SybaseSqlDialect

public class SybaseSqlDialect
extends SqlDialect

A SqlDialect implementation for the Sybase database.

Nested Class Summary

Nested classes/interfaces inherited from class org.apache.calcite.sql.SqlDialect

SqlDialect.CalendarPolicy, SqlDialect.Context, SqlDialect.DatabaseProduct, SqlDialect.FakeUtil

Field Summary

Fields

Modifier and Type	Field and Description
static SqlDialect	DEFAULT
static SqlDialect.Context	DEFAULT_CONTEXT

Fields inherited from class org.apache.calcite.sql.SqlDialect

BUILT_IN_OPERATORS_LIST, EMPTY_CONTEXT, identifierEndQuoteString, identifierEscapedQuote, identifierQuoteString, literalEndQuoteString, literalEscapedQuote, literalQuoteString, LOGGER, nullCollation

Constructor Summary

Constructors

Constructor and Description
SybaseSqlDialect(SqlDialect.Context context) Creates a SybaseSqlDialect.

Method Summary

Modifier and Type	Method and Description
void	unparseOffsetFetch(SqlWriter writer, SqlNode offset, SqlNode fetch) Converts an offset and fetch into SQL.
void	unparseTopN(SqlWriter writer, SqlNode offset, SqlNode fetch) Converts a fetch into a "SELECT TOP(fetch)".

Methods inherited from class org.apache.calcite.sql.SqlDialect

allowsAs, configureParser, configureParser, containsNonAscii, create, defaultNullDirection, emulateJoinTypeForCrossJoin, emulateNullDirection, emulateNullDirectionWithIsNull, getCalendarPolicy, getCastSpec, getConformance, getDatabaseProduct, getNullCollation, getProduct, getQuotedCasing, getQuoting, getSingleRowTableName, getTypeSystem, getUnquotedCasing, hasImplicitTableAlias, identifierNeedsQuote, isCaseSensitive, quoteIdentifier, quoteIdentifier, quoteIdentifier, quoteStringLiteral, quoteStringLiteral, quoteStringLiteralUnicode, quoteTimestampLiteral, requiresAliasForFromItems, rewriteSingleValueExpr, supportsAggregateFunction, supportsAliasedValues, supportsCharSet, supportsDataType, supportsFunction, supportsGroupByWithCube, supportsGroupByWithRollup, supportsImplicitTypeCoercion, supportsNestedAggregations, supportsOffsetFetch, supportsWindowFunctions, unparseCall, unparseDateTimeLiteral, unparseFetchUsingAnsi, unparseFetchUsingLimit, unparseLimit, unparseOffset, unparseSqlDatetimeArithmetic, unparseSqlIntervalLiteral, unparseSqlIntervalQualifier, unquoteStringLiteral

Methods inherited from class java.lang.Object

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

Field Detail

DEFAULT_CONTEXT

public static final SqlDialect.Context DEFAULT_CONTEXT

DEFAULT

public static final SqlDialect DEFAULT

Constructor Detail

SybaseSqlDialect

public SybaseSqlDialect(SqlDialect.Context context)

Creates a SybaseSqlDialect.

Method Detail

unparseOffsetFetch

public void unparseOffsetFetch(SqlWriter writer,
                               SqlNode offset,
                               SqlNode fetch)

Description copied from class: SqlDialect

Converts an offset and fetch into SQL.

At least one of offset and fetch must be provided.

Common options:

• OFFSET offset ROWS FETCH NEXT fetch ROWS ONLY (ANSI standard SQL, Oracle, PostgreSQL, and the default)
• LIMIT fetch OFFSET offset (Apache Hive, MySQL, Redshift)

Overrides:

unparseOffsetFetch in class SqlDialect

Parameters:

writer - Writer

offset - Number of rows to skip before emitting, or null

fetch - Number of rows to fetch, or null

See Also:

SqlDialect.unparseFetchUsingAnsi(SqlWriter, SqlNode, SqlNode), SqlDialect.unparseFetchUsingLimit(SqlWriter, SqlNode, SqlNode)

unparseTopN

public void unparseTopN(SqlWriter writer,
                        SqlNode offset,
                        SqlNode fetch)

Description copied from class: SqlDialect

Converts a fetch into a "SELECT TOP(fetch)".

A dialect that uses "TOP" syntax should override this method to print "TOP(fetch)", and override SqlDialect.unparseOffsetFetch(org.apache.calcite.sql.SqlWriter, org.apache.calcite.sql.SqlNode, org.apache.calcite.sql.SqlNode) to no-op.

The default implementation of this method is no-op.

Overrides:

unparseTopN in class SqlDialect

Parameters:

writer - Writer

offset - Number of rows to skip before emitting, or null

fetch - Number of rows to fetch, or null