Package org.apache.calcite.sql.fun

Class SqlInOperator

java.lang.Object

org.apache.calcite.sql.SqlOperator

org.apache.calcite.sql.SqlBinaryOperator

org.apache.calcite.sql.fun.SqlInOperator

Direct Known Subclasses:

SqlQuantifyOperator

public class SqlInOperator
extends SqlBinaryOperator

Definition of the SQL IN operator, which tests for a value's membership in a sub-query or a list of values.

Field Summary

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

kind, MDX_PRECEDENCE, NL

Constructor Summary

Constructors

Modifier	Constructor	Description
protected	SqlInOperator(java.lang.String name, SqlKind kind)
(package private)	SqlInOperator(SqlKind kind)	Creates a SqlInOperator.

Method Summary

Modifier and Type	Method	Description
private static boolean	anyNullable(java.util.List<RelDataTypeField> fieldList)
boolean	argumentMustBeScalar(int ordinal)	Returns whether the ordinalth argument to this operator must be scalar (as opposed to a query).
RelDataType	deriveType(SqlValidator validator, SqlValidatorScope scope, SqlCall call)	Derives the type of a call to this operator.
boolean	isNotIn()	Deprecated.
boolean	validRexOperands(int count, Litmus litmus)	Returns whether the given operands are valid.

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

adjustType, getMonotonicity, getSignatureTemplate, getSyntax

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

acceptCall, acceptCall, allowsFraming, checkOperandCount, checkOperandTypes, constructArgNameList, constructArgTypeList, constructOperandList, createCall, createCall, createCall, createCall, equals, getAllowedSignatures, getAllowedSignatures, getKind, getLeftPrec, getMonotonicity, getName, getNameAsId, getOperandCountRange, getOperandTypeChecker, getOperandTypeInference, getReturnTypeInference, getRightPrec, hashCode, inferReturnType, inferReturnType, isAggregator, isDeterministic, isDynamicFunction, isGroup, isGroupAuxiliary, isName, leftPrec, preValidateCall, requiresDecimalExpansion, requiresOrder, requiresOver, rewriteCall, rightPrec, toString, unparse, unparseListClause, unparseListClause, validateCall, validateOperands

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Constructor Detail

SqlInOperator

SqlInOperator(SqlKind kind)

Creates a SqlInOperator.

Parameters:

kind - IN or NOT IN

SqlInOperator

protected SqlInOperator(java.lang.String name,
                        SqlKind kind)

Method Detail

isNotIn

@Deprecated
public boolean isNotIn()

Deprecated.

validRexOperands

public boolean validRexOperands(int count,
                                Litmus litmus)

Description copied from class: SqlOperator

Returns whether the given operands are valid. If not valid and fail, throws an assertion error.

Similar to SqlOperator.checkOperandCount(org.apache.calcite.sql.validate.SqlValidator, org.apache.calcite.sql.type.SqlOperandTypeChecker, org.apache.calcite.sql.SqlCall), but some operators may have different valid operands in SqlNode and RexNode formats (some examples are CAST and AND), and this method throws internal errors, not user errors.

Overrides:

validRexOperands in class SqlBinaryOperator

deriveType

public RelDataType deriveType(SqlValidator validator,
                              SqlValidatorScope scope,
                              SqlCall call)

Description copied from class: SqlOperator

Derives the type of a call to this operator.

This method is an intrinsic part of the validation process so, unlike SqlOperator.inferReturnType(org.apache.calcite.sql.SqlOperatorBinding), specific operators would not typically override this method.

Overrides:

deriveType in class SqlBinaryOperator

Parameters:

validator - Validator

scope - Scope of validation

call - Call to this operator

Returns:

Type of call

anyNullable

private static boolean anyNullable(java.util.List<RelDataTypeField> fieldList)

argumentMustBeScalar

public boolean argumentMustBeScalar(int ordinal)

Description copied from class: SqlOperator

Returns whether the ordinalth argument to this operator must be scalar (as opposed to a query).

If true (the default), the validator will attempt to convert the argument into a scalar sub-query, which must have one column and return at most one row.

Operators such as SELECT and EXISTS override this method.

Overrides:

argumentMustBeScalar in class SqlOperator