Package com.mckoi.database
Class TableFunctions
- java.lang.Object
-
- com.mckoi.database.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.
-
-
-
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.
-
-