# UnionAll

class UnionAll(firstStatement: AbstractQuery<*>, secondStatement: AbstractQuery<*>) : SetOperation

Represents an SQL operation that combines all results from two queries, with duplicates included.

## Constructors

UnionAll
Link copied to clipboard
constructor(firstStatement: AbstractQuery<*>, secondStatement: AbstractQuery<*>)

## Properties

comments
Link copied to clipboard
var comments: Map<AbstractQuery.CommentPosition, String>
distinct
Link copied to clipboard
var distinct: Boolean
distinctOn
Link copied to clipboard
var distinctOn: List<Column<*>>?
fetchSize
Link copied to clipboard
var fetchSize: Int?
firstStatement
Link copied to clipboard
val firstStatement: AbstractQuery<*>

The SQL statement on the left-hand side of the set operator.

groupedByColumns
Link copied to clipboard
var groupedByColumns: List<Expression<*>>
having
Link copied to clipboard
var having: Op<Boolean>?
isAlwaysBatch
Link copied to clipboard
open val isAlwaysBatch: Boolean

Whether the SQL statement is meant to be performed as part of a batch execution.

limit
Link copied to clipboard
var limit: Int?
offset
Link copied to clipboard
var offset: Long
operationName
Link copied to clipboard
open val operationName: String

The SQL keyword representing the set operation.

orderByExpressions
Link copied to clipboard
var orderByExpressions: List<Pair<Expression<*>, SortOrder>>
secondStatement
Link copied to clipboard
val secondStatement: AbstractQuery<*>
set
Link copied to clipboard
open override val set: FieldSet
statement
Link copied to clipboard
open override val statement: SetOperation

The actual Exposed Statement on which the specific execution logic should be used.

targets
Link copied to clipboard
val targets: List<Table>
type
Link copied to clipboard
val type: StatementType
where
Link copied to clipboard
var where: Op<Boolean>?

## Functions

adjustComments
Link copied to clipboard
fun adjustComments(position: AbstractQuery.CommentPosition, content: String?): SetOperation
adjustHaving
Link copied to clipboard
fun adjustHaving(body: Op<Boolean>?.() -> Op<Boolean>): SetOperation
arguments
Link copied to clipboard
open override fun arguments(): List<List<Pair<IColumnType<*>, Any?>>>
collect
Link copied to clipboard
open suspend override fun collect(collector: FlowCollector<ResultRow>)
comment
Link copied to clipboard
fun comment(content: String, position: AbstractQuery.CommentPosition): SetOperation
copy
Link copied to clipboard
open override fun copy(): UnionAll

Returns a new SizedIterable that is a copy of the original.

copyTo
Link copied to clipboard
open fun copyTo(other: SetOperation)
count
Link copied to clipboard
open suspend override fun count(): Long

Returns the number of results retrieved after query execution.

empty
Link copied to clipboard
open suspend override fun empty(): Boolean

Returns whether any results were retrieved by query execution.

except
Link copied to clipboard
fun AbstractQuery<*>.except(other: Query): Except

Returns only distinct results from this query that are NOT common to the results of other.

execute
Link copied to clipboard
open suspend fun execute(transaction: R2dbcTransaction): ResultApi?

Executes the SQL statement directly in the provided transaction and returns the generated result, or `null` if either no result was retrieved or if the transaction blocked statement execution.

executeInternal
Link copied to clipboard
open suspend override fun R2dbcPreparedStatementApi.executeInternal(transaction: R2dbcTransaction): R2dbcResult

Determines the exact way that an SQL statement is executed in a transaction and applies any necessary logic before returning the result generated by the executed statement.

fetchSize
Link copied to clipboard
fun fetchSize(n: Int): SetOperation
forUpdate
Link copied to clipboard
open fun forUpdate(option: ForUpdateOption = ForUpdateOption.ForUpdate): SizedIterable<ResultRow>

Returns a new SizedIterable with a locking read for the elements according to the rules specified by option.

groupBy
Link copied to clipboard
fun groupBy(vararg columns: Expression<*>): SetOperation
hasCustomForUpdateState
Link copied to clipboard
fun hasCustomForUpdateState(): Boolean
having
Link copied to clipboard
fun having(op: () -> Op<Boolean>): SetOperation
intersect
Link copied to clipboard
fun AbstractQuery<*>.intersect(other: Query): Intersect

Returns only results from this query that are common to the results of other, WITHOUT including any duplicates.

isForUpdate
Link copied to clipboard
fun isForUpdate(): Boolean
limit
Link copied to clipboard
open override fun limit(count: Int): SetOperation

Returns a new SizedIterable containing only count elements.

mapLazy
Link copied to clipboard
infix fun <T, R> SizedIterable<T>.mapLazy(f: (T) -> R): SizedIterable<R>

Returns a SizedIterable containing the lazily evaluated results of applying the function f to each original element.

notForUpdate
Link copied to clipboard
open fun notForUpdate(): SizedIterable<ResultRow>

Returns a new SizedIterable without any locking read for the elements.

offset
Link copied to clipboard
open override fun offset(start: Long): SetOperation

Returns a new SizedIterable containing only elements starting from the specified start.

orderBy
Link copied to clipboard
open override fun orderBy(vararg order: Pair<Expression<*>, SortOrder>): SetOperation

Returns a new SizedIterable with the elements sorted according to the specified expression order.

fun orderBy(column: Expression<*>, order: SortOrder = SortOrder.ASC): SetOperation
prepared
Link copied to clipboard
open suspend fun prepared(transaction: R2dbcTransaction, sql: String): R2dbcPreparedStatementApi

Uses a transaction connection and an sql string representation to return a precompiled SQL statement, stored as an implementation of R2dbcPreparedStatementApi.

prepareSQL
Link copied to clipboard
open override fun prepareSQL(transaction: Transaction, prepared: Boolean): String
open override fun prepareSQL(builder: QueryBuilder): String
union
Link copied to clipboard
fun AbstractQuery<*>.union(other: Query): Union

Combines all results from this query with the results of other, WITHOUT including duplicates.

unionAll
Link copied to clipboard
fun AbstractQuery<*>.unionAll(other: Query): UnionAll

Combines all results from this query with the results of other, WITH duplicates included.

withDistinct
Link copied to clipboard
open override fun withDistinct(value: Boolean): SetOperation
withDistinctOn
Link copied to clipboard
fun withDistinctOn(vararg columns: Column<*>): SetOperation