Package org.eigenbase.sql.fun

Defines the set of standard SQL row-level functions and operators.

See: Description

Class Summary

Class	Description
SqlAbstractTimeFunction	Base class for time functions such as "LOCALTIME", "LOCALTIME(n)".
SqlArrayQueryConstructor	Definition of the SQL:2003 standard ARRAY query constructor, ARRAY (<query>).
SqlArrayValueConstructor	Definition of the SQL:2003 standard ARRAY constructor, MULTISET [<expr>, ...].
SqlAvgAggFunction	Avg is an aggregator which returns the average of the values which go into it.
SqlBetweenOperator	Defines the BETWEEN operator.
SqlCase	A SqlCase is a node of a parse tree which represents a case statement.
SqlCaseOperator	An operator describing a CASE, NULLIF or COALESCE expression.
SqlCastFunction	SqlCastFunction.
SqlCeilFunction	Support for the CEIL/CEILING builtin function.
SqlCoalesceFunction	The COALESCE function.
SqlCollectionTableOperator	SqlCollectionTableOperator is the "table function derived table" operator.
SqlColumnListConstructor	SqlColumnListConstructor defines the non-standard constructor used to pass a COLUMN_LIST parameter to a UDX.
SqlConvertFunction	Common base for the CONVERT and TRANSLATE functions.
SqlCountAggFunction	Definition of the SQL COUNT aggregation function.
SqlCovarAggFunction	Covar is an aggregator which returns the Covariance of the values which go into it.
SqlCurrentDateFunction	The CURRENT_DATE function.
SqlCursorConstructor	SqlCursorConstructor defines the non-standard CURSOR(<query>) constructor.
SqlDatetimeSubtractionOperator	A special operator for the subtraction of two DATETIMEs.
SqlExtractFunction	The SQL EXTRACT operator.
SqlFirstLastValueAggFunction	FIRST_VALUE and LAST_VALUE aggregate functions return the first or the last value in a list of values that are input to the function.
SqlFloorFunction	Definition of the "FLOOR" builtin SQL function.
SqlHistogramAggFunction	HistogramAgg is base operator which supports the Histogram MIN/MAX aggregatoin functions.
SqlInOperator	Definition of the SQL IN operator, which tests for a value's membership in a subquery or a list of values.
SqlLeadLagAggFunction	LEAD and LAG aggregate functions return the value of given expression evaluated at given offset.
SqlLikeOperator	An operator describing the LIKE and SIMILAR operators.
SqlLiteralChainOperator	Internal operator, by which the parser represents a continued string literal.
SqlMapQueryConstructor	Definition of the MAP query constructor, MAP (<query>).
SqlMapValueConstructor	Definition of the MAP constructor, MAP [<key>, <value>, ...].
SqlMinMaxAggFunction	Definition of the MIN and MAX aggregate functions, returning the returns the smallest/largest of the values which go into it.
SqlMonotonicBinaryOperator	Base class for binary operators such as addition, subtraction, and multiplication which are monotonic for the patterns m op c and c op m where m is any monotonic expression and c is a constant.
SqlMonotonicUnaryFunction	Base class for unary operators such as FLOOR/CEIL which are monotonic for monotonic inputs.
SqlMultisetMemberOfOperator	Multiset MEMBER OF.
SqlMultisetQueryConstructor	Definition of the SQL:2003 standard MULTISET query constructor, MULTISET (<query>).
SqlMultisetSetOperator	An operator which performs set operations on multisets, such as "MULTISET UNION ALL".
SqlMultisetValueConstructor	Definition of the SQL:2003 standard MULTISET constructor, MULTISET [<expr>, ...].
SqlNewOperator	SqlNewOperator represents an SQL new specification such as NEW UDT(1, 2).
SqlNtileAggFunction	NTILE aggregate function return the value of given expression evaluated at given offset.
SqlNullifFunction	The NULLIF function.
SqlOverlapsOperator	SqlOverlapsOperator represents the SQL:1999 standard OVERLAPS function.
SqlOverlayFunction	The OVERLAY function.
SqlPositionFunction	The POSITION function.
SqlRowOperator	SqlRowOperator represents the special ROW constructor.
SqlSingleValueAggFunction	SINGLE_VALUE aggregate function returns the input value if there is only one value in the input; Otherwise it triggers a run-time error.
SqlStdOperatorTable	Implementation of SqlOperatorTable containing the standard operators and functions.
SqlStringContextVariable	Base class for functions such as "USER", "CURRENT_ROLE", and "CURRENT_PATH".
SqlSubstringFunction	Definition of the "SUBSTRING" builtin SQL function.
SqlSumAggFunction	Sum is an aggregator which returns the sum of the values which go into it.
SqlSumEmptyIsZeroAggFunction	Sum0 is an aggregator which returns the sum of the values which go into it like Sum.
SqlThrowOperator	An internal operator that throws an exception.
SqlTrimFunction	Definition of the "TRIM" builtin SQL function.

Enum Summary

Enum	Description
SqlAvgAggFunction.Subtype
SqlBetweenOperator.Flag	Defines the "SYMMETRIC" and "ASYMMETRIC" keywords.
SqlCovarAggFunction.Subtype	Enum for defining specific types.
SqlTrimFunction.Flag	Defines the enumerated values "LEADING", "TRAILING", "BOTH".

Package org.eigenbase.sql.fun Description

Defines the set of standard SQL row-level functions and operators.

The standard set of row-level functions and operators are declared in class SqlStdOperatorTable. Anonymous inner classes within that table are allowed only for specifying an operator's test function; if other custom code is needed for an operator, it should be implemented in a top-level class within this package instead. Operators which are not row-level (e.g. select and join) should be defined in package org.eigenbase.sql instead.