Enum SemiJoinType

  • All Implemented Interfaces:
    java.io.Serializable, java.lang.Comparable<SemiJoinType>

    public enum SemiJoinType
    extends java.lang.Enum<SemiJoinType>
    Enumeration representing different join types used in correlation relations.
    • Enum Constant Summary

      Enum Constants 
      Enum Constant Description
      ANTI
      Anti-join
      INNER
      Inner join
      LEFT
      Left-outer join
      SEMI
      Semi-join
    • Field Summary

      Fields 
      Modifier and Type Field Description
      java.lang.String lowerName
      Lower-case name.
    • Constructor Summary

      Constructors 
      Modifier Constructor Description
      private SemiJoinType()  
    • Enum Constant Detail

      • LEFT

        public static final SemiJoinType LEFT
        Left-outer join
      • SEMI

        public static final SemiJoinType SEMI
        Semi-join

        Similar to from A ... where a in (select b from B ...)

      • ANTI

        public static final SemiJoinType ANTI
        Anti-join

        Similar to from A ... where a NOT in (select b from B ...)

        Note: if B.b is nullable and B has nulls, no rows must be returned

    • Field Detail

      • lowerName

        public final java.lang.String lowerName
        Lower-case name.
    • Constructor Detail

      • SemiJoinType

        private SemiJoinType()
    • Method Detail

      • values

        public static SemiJoinType[] values()
        Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows:
        for (SemiJoinType c : SemiJoinType.values())
            System.out.println(c);
        
        Returns:
        an array containing the constants of this enum type, in the order they are declared
      • valueOf

        public static SemiJoinType valueOf​(java.lang.String name)
        Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)
        Parameters:
        name - the name of the enum constant to be returned.
        Returns:
        the enum constant with the specified name
        Throws:
        java.lang.IllegalArgumentException - if this enum type has no constant with the specified name
        java.lang.NullPointerException - if the argument is null
      • symbol

        public SqlLiteral symbol​(SqlParserPos pos)
        Creates a parse-tree node representing an occurrence of this condition type keyword at a particular position in the parsed text.
      • returnsJustFirstInput

        public boolean returnsJustFirstInput()