Class TableFunctions


  • public class TableFunctions
    extends java.lang.Object
    A number of functions that are table set functions such as simple select operations, joins, unions, sub-query operations, etc.
    • Constructor Summary

      Constructors 
      Constructor Description
      TableFunctions()  
    • Method Summary

      All Methods Static Methods Concrete Methods 
      Modifier and Type Method Description
      (package private) static Table anyAllNonCorrelated​(Table left_table, Variable[] left_vars, Operator op, Table right_table)
      The function for a non-correlated ANY or ALL sub-query operation between a left and right branch.
      • Methods inherited from class java.lang.Object

        clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
    • Constructor Detail

      • TableFunctions

        public TableFunctions()
    • Method Detail

      • anyAllNonCorrelated

        static Table anyAllNonCorrelated​(Table left_table,
                                         Variable[] left_vars,
                                         Operator op,
                                         Table right_table)
        The function for a non-correlated ANY or ALL sub-query operation between a left and right branch. An example of an SQL query that generates such a query is;

           Table.col > ANY ( SELECT .... )
         

        This function only works non-correlated sub-queries.

        A non-correlated sub-query, or a correlated sub-query where the correlated variables are references to a parent plan branch, the plan only need be evaluated once and optimizations on the query present themselves.