|
||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||
java.lang.Objectorg.h2.command.Prepared
org.h2.command.dml.Query
org.h2.command.dml.SelectUnion
public class SelectUnion
Represents a union SELECT statement.
| Field Summary | |
|---|---|
static int |
EXCEPT
The type of an EXCEPT statement. |
static int |
INTERSECT
The type of an INTERSECT statement. |
static int |
UNION
The type of a UNION statement. |
static int |
UNION_ALL
The type of a UNION ALL statement. |
| Fields inherited from class org.h2.command.dml.Query |
|---|
distinct, limitExpr, offsetExpr, randomAccessResult, sampleSize |
| Fields inherited from class org.h2.command.Prepared |
|---|
create, parameters, prepareAlways, session, sqlStatement |
| Constructor Summary | |
|---|---|
SelectUnion(Session session,
Query query)
|
|
| Method Summary | |
|---|---|
void |
addGlobalCondition(Parameter param,
int columnId,
int comparisonType)
Add a condition to the query. |
void |
fireBeforeSelectTriggers()
Call the before triggers on all tables. |
int |
getColumnCount()
Get the column count of this query. |
double |
getCost()
Calculate the cost to execute this query. |
LocalResult |
getEmptyResult()
|
java.util.ArrayList<Expression> |
getExpressions()
The the list of select expressions. |
Query |
getLeft()
|
java.lang.String |
getPlanSQL()
Get the SQL statement with the execution plan. |
Query |
getRight()
|
java.util.HashSet<Table> |
getTables()
Get all tables that are involved in this query. |
int |
getType()
Get the command type as defined in CommandInterface |
int |
getUnionType()
|
void |
init()
Initialize the query. |
boolean |
isEverything(ExpressionVisitor visitor)
Check if this expression and all sub-expressions can fulfill a criteria. |
boolean |
isReadOnly()
Check if this command is read only. |
void |
mapColumns(ColumnResolver resolver,
int level)
Map the columns to the given column resolver. |
void |
prepare()
Prepare this statement. |
LocalResult |
query(int limit,
ResultTarget target)
Execute the query, writing the result to the target result. |
ResultInterface |
queryMeta()
Get an empty result set containing the meta data. |
protected LocalResult |
queryWithoutCache(int maxRows,
ResultTarget target)
Execute the query without checking the cache. |
void |
setEvaluatable(TableFilter tableFilter,
boolean b)
Change the evaluatable flag. |
void |
setForUpdate(boolean forUpdate)
Set the 'for update' flag. |
void |
setOrder(java.util.ArrayList<SelectOrderBy> order)
Set the order by list. |
void |
setRight(Query select)
|
void |
setSQL(java.lang.String sql)
Set the SQL statement. |
void |
setUnionType(int type)
|
void |
updateAggregate(Session s)
Update all aggregate function values. |
| Methods inherited from class org.h2.command.dml.Query |
|---|
disableCache, getCostAsExpression, getMaxDataModificationId, getParameterValues, isQuery, isTransactional, prepareOrder, query, setDistinct, setLimit, setOffset, setRandomAccessResult, setSampleSize |
| Methods inherited from class org.h2.command.Prepared |
|---|
checkCanceled, checkParameters, getCurrentObjectId, getCurrentRowNumber, getObjectId, getParameters, getSQL, getSQL, getSQL, isCacheable, needRecompile, setCommand, setCurrentRowNumber, setObjectId, setParameterList, setPrepareAlways, setRow, setSession, toString, update |
| Methods inherited from class java.lang.Object |
|---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait |
| Field Detail |
|---|
public static final int UNION
public static final int UNION_ALL
public static final int EXCEPT
public static final int INTERSECT
| Constructor Detail |
|---|
public SelectUnion(Session session,
Query query)
| Method Detail |
|---|
public void setUnionType(int type)
public int getUnionType()
public void setRight(Query select)
public Query getLeft()
public Query getRight()
public void setSQL(java.lang.String sql)
Prepared
setSQL in class Preparedsql - the SQL statementpublic void setOrder(java.util.ArrayList<SelectOrderBy> order)
Query
setOrder in class Queryorder - the order by listpublic ResultInterface queryMeta()
Prepared
queryMeta in class Preparedpublic LocalResult getEmptyResult()
protected LocalResult queryWithoutCache(int maxRows,
ResultTarget target)
Query
queryWithoutCache in class QuerymaxRows - the limit as specified in the JDBC method calltarget - the target to write results to
public void init()
Query
init in class Querypublic void prepare()
Prepared
prepare in class Preparedpublic double getCost()
Query
getCost in class Querypublic java.util.HashSet<Table> getTables()
Query
getTables in class Querypublic java.util.ArrayList<Expression> getExpressions()
Query
getExpressions in class Querypublic void setForUpdate(boolean forUpdate)
Query
setForUpdate in class QueryforUpdate - the new settingpublic int getColumnCount()
Query
getColumnCount in class Query
public void mapColumns(ColumnResolver resolver,
int level)
Query
mapColumns in class Queryresolver - the resolverlevel - the subquery level (0 is the top level query, 1 is the first
subquery level)
public void setEvaluatable(TableFilter tableFilter,
boolean b)
Query
setEvaluatable in class QuerytableFilter - the table filterb - the new value
public void addGlobalCondition(Parameter param,
int columnId,
int comparisonType)
Query
addGlobalCondition in class Queryparam - the parametercolumnId - the column index (0 meaning the first column)comparisonType - the comparison typepublic java.lang.String getPlanSQL()
Prepared
getPlanSQL in class Prepared
public LocalResult query(int limit,
ResultTarget target)
Query
limit - the maximum number of rows to returntarget - the target result (null will return the result)
public boolean isEverything(ExpressionVisitor visitor)
Query
isEverything in class Queryvisitor - the visitor
public boolean isReadOnly()
Prepared
isReadOnly in class Preparedpublic void updateAggregate(Session s)
Query
updateAggregate in class Querys - the sessionpublic void fireBeforeSelectTriggers()
Query
fireBeforeSelectTriggers in class Querypublic int getType()
Prepared
getType in class Prepared
|
||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||