Package org.apache.calcite.sql.fun

Class OracleSqlOperatorTable

java.lang.Object

org.apache.calcite.sql.util.ReflectiveSqlOperatorTable

org.apache.calcite.sql.fun.OracleSqlOperatorTable

All Implemented Interfaces:

SqlOperatorTable

@Deprecated
public class OracleSqlOperatorTable
extends ReflectiveSqlOperatorTable

Deprecated.

Use SqlLibraryOperatorTableFactory.getOperatorTable(SqlLibrary...) instead, passing SqlLibrary.ORACLE as argument.

Operator table that contains only Oracle-specific functions and operators.

Field Summary

Fields

Modifier and Type	Field	Description
static final SqlFunction	DECODE	Deprecated.
static final SqlFunction	GREATEST	Deprecated.
static final SqlFunction	LEAST	Deprecated.
static final SqlFunction	LTRIM	Deprecated.
static final SqlFunction	NVL	Deprecated.
protected com.google.common.collect.ImmutableMultimap<String,SqlOperator>	operators	Contains all (name, operator) pairs.
static final SqlFunction	RTRIM	Deprecated.
static final SqlFunction	SUBSTR	Deprecated.
static final SqlFunction	TRANSLATE3	Deprecated.

Fields inherited from class org.apache.calcite.sql.util.ReflectiveSqlOperatorTable

IS_NAME

Constructor Summary

Constructors

Constructor	Description
OracleSqlOperatorTable()	Deprecated.

Method Summary

Modifier and Type	Method	Description
protected static com.google.common.collect.ImmutableMultimap<String,SqlOperator>	buildIndex(Iterable<? extends SqlOperator> operators)	Derives a value to be assigned to operators from a given list of operators.
List<SqlOperator>	getOperatorList()	Retrieves a list of all functions and operators in this table.
static OracleSqlOperatorTable	instance()	Deprecated. Returns the Oracle operator table, creating it if necessary.
protected void	lookUpOperators(String name, boolean caseSensitive, Consumer<SqlOperator> consumer)	Looks up operators, optionally matching case-sensitively.
protected void	setOperators(com.google.common.collect.Multimap<String,SqlOperator> operators)

Methods inherited from class org.apache.calcite.sql.util.ReflectiveSqlOperatorTable

init, lookupOperatorOverloads, register

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.apache.calcite.sql.SqlOperatorTable

getOperatorList

Field Details

DECODE

@Deprecated
public static final SqlFunction DECODE

Deprecated.

NVL

@Deprecated
public static final SqlFunction NVL

Deprecated.

LTRIM

@Deprecated
public static final SqlFunction LTRIM

Deprecated.

RTRIM

@Deprecated
public static final SqlFunction RTRIM

Deprecated.

SUBSTR

@Deprecated
public static final SqlFunction SUBSTR

Deprecated.

GREATEST

@Deprecated
public static final SqlFunction GREATEST

Deprecated.

LEAST

@Deprecated
public static final SqlFunction LEAST

Deprecated.

TRANSLATE3

@Deprecated
public static final SqlFunction TRANSLATE3

Deprecated.

operators

protected com.google.common.collect.ImmutableMultimap<String,SqlOperator> operators

Contains all (name, operator) pairs. Effectively a sorted immutable multimap.

There can be several operators with the same name (case-insensitive or case-sensitive) and these operators will lie in a contiguous range which we can find efficiently using binary search.

Constructor Details

OracleSqlOperatorTable

public OracleSqlOperatorTable()

Deprecated.

Method Details

instance

public static OracleSqlOperatorTable instance()

Deprecated.

Returns the Oracle operator table, creating it if necessary.

getOperatorList

public List<SqlOperator> getOperatorList()

Description copied from interface: SqlOperatorTable

Retrieves a list of all functions and operators in this table. Used for automated testing. Depending on the table type, may or may not be mutable.

Specified by:

getOperatorList in interface SqlOperatorTable

Returns:

list of SqlOperator objects

setOperators

protected void setOperators(com.google.common.collect.Multimap<String,SqlOperator> operators)

buildIndex

protected static com.google.common.collect.ImmutableMultimap<String,SqlOperator> buildIndex(Iterable<? extends SqlOperator> operators)

Derives a value to be assigned to operators from a given list of operators.

lookUpOperators

protected void lookUpOperators(String name,
 boolean caseSensitive,
 Consumer<SqlOperator> consumer)

Looks up operators, optionally matching case-sensitively.