Package org.h2.command.query
Class SelectUnion
java.lang.Object
org.h2.command.Prepared
org.h2.command.query.Query
org.h2.command.query.SelectUnion
Represents a union SELECT statement.
-
Nested Class Summary
Nested ClassesModifier and TypeClassDescriptionprivate final class
Lazy execution for this union.static enum
Nested classes/interfaces inherited from class org.h2.command.query.Query
Query.OffsetFetch
-
Field Summary
FieldsModifier and TypeFieldDescriptionprivate boolean
(package private) final Query
The left hand side of the union (the first subquery).(package private) final Query
The right hand side of the union (the second subquery).private final SelectUnion.UnionType
Fields inherited from class org.h2.command.query.Query
checkInit, distinct, expressionArray, expressions, fetchExpr, fetchPercent, isPrepared, offsetExpr, orderList, randomAccessResult, resultColumnCount, sort, visibleColumnCount, withTies
Fields inherited from class org.h2.command.Prepared
create, parameters, prepareAlways, session, sqlStatement, sqlTokens
-
Constructor Summary
ConstructorsConstructorDescriptionSelectUnion
(SessionLocal session, SelectUnion.UnionType unionType, Query query, Query right) -
Method Summary
Modifier and TypeMethodDescriptionvoid
addGlobalCondition
(Parameter param, int columnId, int comparisonType) Add a condition to the query.boolean
Check whether adding condition to the query is allowed.private Value[]
private LocalResult
createLocalResult
(int columnCount) void
Call the before triggers on all tables.double
getCost()
Calculate the cost to execute this query.getLeft()
getPlanSQL
(int sqlFlags) Get the SQL statement with the execution plan.getRight()
Get all tables that are involved in this query.void
init()
Initialize the query.boolean
Check if this query will always return the same value and has no side effects.boolean
isEverything
(ExpressionVisitor visitor) Check if this expression and all sub-expressions can fulfill a criteria.boolean
isUnion()
Check if this is a UNION query.void
mapColumns
(ColumnResolver resolver, int level) Map the columns to the given column resolver.void
prepare()
Prepare this statement.protected ResultInterface
queryWithoutCache
(long 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
updateAggregate
(SessionLocal s, int stage) Update all aggregate function values.Methods inherited from class org.h2.command.query.Query
addParameter, appendEndOfQueryToSQL, cleanupOrder, collectDependencies, convertToDistinct, disableCache, exists, finishResult, getColumnCount, getCostAsExpression, getExpressions, getFetch, getIfSingleRow, getMaxDataModificationId, getOffset, getOffsetFetch, getRowDataType, getType, hasOrder, initExpression, initOrder, isAnyDistinct, isFetchPercent, isNeverLazy, isQuery, isRandomAccessResult, isReadOnly, isStandardDistinct, isTransactional, isWithTies, prepareOrder, query, query, queryMeta, setDistinctIfPossible, setFetch, setFetchPercent, setNeverLazy, setOffset, setOrder, setRandomAccessResult, setWithTies, toTable
Methods inherited from class org.h2.command.Prepared
checkCanceled, checkParameters, getCteCleanups, getCurrentRowNumber, getObjectId, getParameters, getPersistedObjectId, getSession, getSimpleSQL, getSQL, getSQLTokens, isCacheable, needRecompile, setCommand, setCteCleanups, setCurrentRowNumber, setParameterList, setPersistedObjectId, setPrepareAlways, setRow, setSession, setSQL, toString, update
-
Field Details
-
unionType
-
left
The left hand side of the union (the first subquery). -
right
The right hand side of the union (the second subquery). -
isForUpdate
private boolean isForUpdate
-
-
Constructor Details
-
SelectUnion
-
-
Method Details
-
isUnion
public boolean isUnion()Description copied from class:Query
Check if this is a UNION query. -
getUnionType
-
getLeft
-
getRight
-
convert
-
getEmptyResult
-
queryWithoutCache
Description copied from class:Query
Execute the query without checking the cache. If a target is specified, the results are written to it, and the method returns null. If no target is specified, a new LocalResult is created and returned.- Specified by:
queryWithoutCache
in classQuery
- Parameters:
maxRows
- the limit as specified in the JDBC method calltarget
- the target to write results to- Returns:
- the result
-
createLocalResult
-
init
public void init()Description copied from class:Query
Initialize the query. -
prepare
public void prepare()Description copied from class:Prepared
Prepare this statement. -
getCost
public double getCost()Description copied from class:Query
Calculate the cost to execute this query. -
getTables
Description copied from class:Query
Get all tables that are involved in this query. -
setForUpdate
public void setForUpdate(boolean forUpdate) Description copied from class:Query
Set the 'for update' flag.- Specified by:
setForUpdate
in classQuery
- Parameters:
forUpdate
- the new setting
-
mapColumns
Description copied from class:Query
Map the columns to the given column resolver.- Specified by:
mapColumns
in classQuery
- Parameters:
resolver
- the resolverlevel
- the subquery level (0 is the top level query, 1 is the first subquery level)
-
setEvaluatable
Description copied from class:Query
Change the evaluatable flag. This is used when building the execution plan.- Specified by:
setEvaluatable
in classQuery
- Parameters:
tableFilter
- the table filterb
- the new value
-
addGlobalCondition
Description copied from class:Query
Add a condition to the query. This is used for views.- Specified by:
addGlobalCondition
in classQuery
- Parameters:
param
- the parametercolumnId
- the column index (0 meaning the first column)comparisonType
- the comparison type
-
getPlanSQL
Description copied from class:Prepared
Get the SQL statement with the execution plan.- Overrides:
getPlanSQL
in classPrepared
- Parameters:
sqlFlags
- formatting flags- Returns:
- the execution plan
-
isEverything
Description copied from class:Query
Check if this expression and all sub-expressions can fulfill a criteria. If any part returns false, the result is false.- Specified by:
isEverything
in classQuery
- Parameters:
visitor
- the visitor- Returns:
- if the criteria can be fulfilled
-
updateAggregate
Description copied from class:Query
Update all aggregate function values.- Specified by:
updateAggregate
in classQuery
- Parameters:
s
- the sessionstage
- select stage
-
fireBeforeSelectTriggers
public void fireBeforeSelectTriggers()Description copied from class:Query
Call the before triggers on all tables.- Specified by:
fireBeforeSelectTriggers
in classQuery
-
allowGlobalConditions
public boolean allowGlobalConditions()Description copied from class:Query
Check whether adding condition to the query is allowed. This is not allowed for views that have an order by and a limit, as it would affect the returned results.- Specified by:
allowGlobalConditions
in classQuery
- Returns:
- true if adding global conditions is allowed
-
isConstantQuery
public boolean isConstantQuery()Description copied from class:Query
Check if this query will always return the same value and has no side effects.- Overrides:
isConstantQuery
in classQuery
- Returns:
- if this query will always return the same value and has no side effects.
-