Method some

core/src/main/java/org/apache/calcite/rex/RexSubQuery.java:66–75

Creates a SOME sub-query. There is no ALL. For x comparison ALL (sub-query) use instead NOT (x inverse-comparison SOME (sub-query)). If comparison is > then negated-comparison is <=, and so forth. Also =SOME is rewritten into IN

(RelNode rel, ImmutableList<RexNode> nodes,
      SqlQuantifyOperator op)

   *
   * <p>Also =SOME is rewritten into IN */
  public static RexSubQuery some(RelNode rel, ImmutableList<RexNode> nodes,
      SqlQuantifyOperator op) {
    assert op.kind == SqlKind.SOME;

    if (op == SqlStdOperatorTable.SOME_EQ) {
      return RexSubQuery.in(rel, nodes);
    }
    final RelDataType type = type(rel, nodes);
    return new RexSubQuery(type, op, nodes, rel);
  }

  static RelDataType type(RelNode rel, ImmutableList<RexNode> nodes) {
    assert rel.getRowType().getFieldCount() == nodes.size();