ktorm-core/org.ktorm.expression/UnionExpression

UnionExpression

data class UnionExpression(val left: QueryExpression, val right: QueryExpression, val isUnionAll: Boolean, val orderBy: List<OrderByExpression> = emptyList(), val offset: Int? = null, val limit: Int? = null, val tableAlias: String? = null, val extraProperties: Map<String, Any> = emptyMap()) : QueryExpression(source)

Union expression, represents a union statement of SQL.

Constructors

UnionExpression

constructor(left: QueryExpression, right: QueryExpression, isUnionAll: Boolean, orderBy: List<OrderByExpression> = emptyList(), offset: Int? = null, limit: Int? = null, tableAlias: String? = null, extraProperties: Map<String, Any> = emptyMap())

Properties

extraProperties

open override val extraProperties: Map<String, Any>

Extra properties of this expression, maybe useful in SqlFormatter to generate some special SQLs.

override val isLeafNode: Boolean = false

Check if this expression is a leaf node in expression trees.

val isUnionAll: Boolean

mark if this union statement is union all.

val left: QueryExpression

the left query of this union expression.

open override val limit: Int? = null

max record numbers returned by the query.

open override val offset: Int? = null

the offset of the first returned record.

open override val orderBy: List<OrderByExpression>

a list of order-by expressions, used in the order by clause of a query.

val right: QueryExpression

the right query of this union expression.

open override val tableAlias: String? = null

the alias when this query is nested in another query's source, e.g. select * from (...) alias.