Class SqlOverlapsOperator


public class SqlOverlapsOperator extends SqlBinaryOperator
SqlOverlapsOperator represents the SQL:1999 standard OVERLAPS function. Determines whether two anchored time intervals overlap.
  • Method Details

    • unparse

      public void unparse(SqlWriter writer, SqlCall call, int leftPrec, int rightPrec)
      Description copied from class: SqlOperator
      Writes a SQL representation of a call to this operator to a writer, including parentheses if the operators on either side are of greater precedence.

      The default implementation of this method delegates to SqlSyntax.unparse(org.apache.calcite.sql.SqlWriter, org.apache.calcite.sql.SqlOperator, org.apache.calcite.sql.SqlCall, int, int).

      Overrides:
      unparse in class SqlOperator
    • getOperandCountRange

      public SqlOperandCountRange getOperandCountRange()
      Description copied from class: SqlOperator
      Returns a constraint on the number of operands expected by this operator. Subclasses may override this method; when they don't, the range is derived from the SqlOperandTypeChecker associated with this operator.
      Overrides:
      getOperandCountRange in class SqlOperator
      Returns:
      acceptable range
    • getSignatureTemplate

      public @Nullable String getSignatureTemplate(int operandsCount)
      Returns a template describing how the operator signature is to be built.
      Overrides:
      getSignatureTemplate in class SqlBinaryOperator
      Parameters:
      operandsCount - is used with functions that can take a variable number of operands
      Returns:
      signature template, where {0} is the operator name and {1}, {2}, etc are operands
    • getAllowedSignatures

      public String getAllowedSignatures(String opName)
      Description copied from class: SqlOperator
      Returns a string describing the expected operand types of a call, e.g. "SUBSTRING(VARCHAR, INTEGER, INTEGER)" where the name (SUBSTRING in this example) can be replaced by a specified name.
      Overrides:
      getAllowedSignatures in class SqlOperator
    • checkOperandTypes

      public boolean checkOperandTypes(SqlCallBinding callBinding, boolean throwOnFailure)
      Description copied from class: SqlOperator
      Checks that the operand values in a SqlCall to this operator are valid. Subclasses must either override this method or supply an instance of SqlOperandTypeChecker to the constructor.
      Overrides:
      checkOperandTypes in class SqlOperator
      Parameters:
      callBinding - description of call
      throwOnFailure - whether to throw an exception if check fails (otherwise returns false in that case)
      Returns:
      whether check succeeded