java.lang.Object
- com.alibaba.druid.sql.ast.SQLObjectImpl
- - com.alibaba.druid.sql.ast.statement.SQLSelectQueryBase
  - - com.alibaba.druid.sql.ast.statement.SQLSelectQueryBlock

All Implemented Interfaces:

SQLDbTypedObject, SQLObject, SQLReplaceable, SQLSelectQuery

Direct Known Subclasses:

BigQuerySelectQueryBlock, CKSelectQueryBlock, DB2SelectQueryBlock, MySqlSelectQueryBlock, OdpsSelectQueryBlock, OracleSelectQueryBlock, OscarSelectQueryBlock, PGSelectQueryBlock, RedshiftSelectQueryBlock, SQLServerSelectQueryBlock, TDSelectQueryBlock
```
public class SQLSelectQueryBlock
extends SQLSelectQueryBase
implements SQLReplaceable, SQLDbTypedObject
```

Field Summary

Fields
Modifier and Type	Field	Description
`protected String`	`cachedSelectList`
`protected long`	`cachedSelectListHash`
`protected List<SQLSelectOrderByItem>`	`clusterBy`
`protected List<String>`	`commentsAfterFrom`
`protected SQLExpr`	`connectBy`
`protected DbType`	`dbType`
`protected int`	`distionOption`
`protected List<SQLSelectOrderByItem>`	`distributeBy`
`protected boolean`	`forShare`
`protected boolean`	`forUpdate`
`protected List<SQLExpr>`	`forUpdateOf`
`protected SQLTableSource`	`from`
`protected SQLSelectGroupByClause`	`groupBy`
`protected List<SQLCommentHint>`	`hints`
`protected SQLExprTableSource`	`into`
`protected SQLLimit`	`limit`
`protected boolean`	`noCycle`
`protected boolean`	`noWait`
`protected SQLOrderBy`	`orderBy`
`protected SQLOrderBy`	`orderBySiblings`
`protected boolean`	`prior`
`protected SQLExpr`	`qualify`
`protected List<SQLSelectItem>`	`selectList`
`protected boolean`	`skipLocked`
`protected List<SQLSelectOrderByItem>`	`sortBy`
`protected SQLExpr`	`startWith`
`protected SQLExpr`	`waitTime`
`protected SQLExpr`	`where`
`protected List<SQLWindow>`	`windows`
`protected SQLWithSubqueryClause`	`with`

Fields inherited from class com.alibaba.druid.sql.ast.statement.SQLSelectQueryBase
parenthesized

Fields inherited from class com.alibaba.druid.sql.ast.SQLObjectImpl
attributes, hint, parent, sourceColumn, sourceLine

Constructor Summary

Constructors
Constructor Description

SQLSelectQueryBlock()

SQLSelectQueryBlock(DbType dbType)

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`protected void`	`accept0(SQLASTVisitor visitor)`
`protected void`	`acceptChild(SQLASTVisitor v)`
`void`	`addClusterBy(SQLSelectOrderByItem item)`
`void`	`addCondition(SQLExpr expr)`
`void`	`addCondition(String conditionSql)`
`void`	`addDistributeBy(SQLExpr x)`
`void`	`addDistributeBy(SQLSelectOrderByItem item)`
`void`	`addHaving(SQLExpr condition)`
`void`	`addOrderBy(SQLExpr orderBy)`
`void`	`addOrderBy(SQLExpr orderBy, SQLOrderingSpecification type)`
`void`	`addOrderBy(SQLOrderBy orderBy)`
`void`	`addOrderBy(SQLSelectOrderByItem orderByItem)`
`SQLSelectItem`	`addSelectItem(SQLExpr expr)`
`void`	`addSelectItem(SQLExpr expr, String alias)`
`void`	`addSelectItem(SQLSelectItem item)`
`void`	`addSelectItem(String selectItemExpr, String alias)`
`void`	`addSortBy(SQLSelectOrderByItem item)`
`void`	`addWhere(SQLExpr condition)`
`void`	`addWhereForDynamicFilter(SQLExpr condition)`
`void`	`addWindow(SQLWindow x)`
`boolean`	`clearMapJoinHint()`
`SQLSelectQueryBlock`	`clone()`
`void`	`cloneSelectListTo(SQLSelectQueryBlock x)`
`void`	`cloneTo(SQLSelectQueryBlock x)`
`List<String>`	`computeSelecteListAlias()`
`boolean`	`containsOrderBy(SQLSelectOrderByItem orderByItem)`
`boolean`	`equals(Object o)`
`boolean`	`equalsForMergeJoin(SQLSelectQueryBlock that)`
`SQLSelectItem`	`findAllColumnSelectItem()`
`SQLColumnDefinition`	`findColumn(long columnNameHash)`
`SQLColumnDefinition`	`findColumn(String columnName)`
`SQLSelectItem`	`findSelectItem(long identHash)`
`SQLSelectItem`	`findSelectItem(String ident)`
`SQLDataType`	`findSelectItemAndComputeDataType(long identHash)`
`SQLDataType`	`findSelectItemAndComputeDataType(String ident)`
`SQLTableSource`	`findTableSource(String alias)`
`SQLTableSource`	`findTableSourceWithColumn(long columnHash)`
`SQLTableSource`	`findTableSourceWithColumn(String column)`
`String`	`getCachedSelectList()`
`long`	`getCachedSelectListHash()`
`List<SQLSelectOrderByItem>`	`getClusterBy()`
`List<SQLSelectOrderByItem>`	`getClusterByDirect()`
`List<String>`	`getCommentsAfterFrom()`
`SQLExpr`	`getConnectBy()`
`DbType`	`getDbType()`
`int`	`getDistionOption()`
`List<SQLSelectOrderByItem>`	`getDistributeBy()`
`List<SQLSelectOrderByItem>`	`getDistributeByDirect()`
`SQLExpr`	`getFirst()`
`List<SQLExpr>`	`getForUpdateOf()`
`int`	`getForUpdateOfSize()`
`SQLTableSource`	`getFrom()`
`SQLSelectGroupByClause`	`getGroupBy()`
`List<SQLCommentHint>`	`getHints()`
`List<SQLCommentHint>`	`getHintsDirect()`
`int`	`getHintsSize()`
`SQLExprTableSource`	`getInto()`
`SQLLimit`	`getLimit()`
`List<SQLTableSource>`	`getMappJoinTableSources()`
`SQLExpr`	`getOffset()`
`SQLOrderBy`	`getOrderBy()`
`SQLOrderBy`	`getOrderBySiblings()`
`SQLExpr`	`getQualify()`
`SQLSelectItem`	`getSelectItem(int i)`
`List<SQLSelectItem>`	`getSelectList()`
`List<SQLSelectOrderByItem>`	`getSortBy()`
`List<SQLSelectOrderByItem>`	`getSortByDirect()`
`SQLExpr`	`getStartWith()`
`SQLExpr`	`getWaitTime()`
`SQLExpr`	`getWhere()`
`List<SQLWindow>`	`getWindows()`
`SQLWithSubqueryClause`	`getWith()`
`boolean`	`hasAllColumnSelectItem()`
`int`	`hashCode()`
`boolean`	`hasSelectAggregation()`
`boolean`	`isDistinct()`
`boolean`	`isForShare()`
`boolean`	`isForUpdate()`
`boolean`	`isNoCycle()`
`boolean`	`isNoWait()`
`boolean`	`isPrior()`
`boolean`	`isSkipLocked()`
`void`	`limit(int rowCount, int offset)`
`void`	`mergeLimit(SQLLimit limit)`
`boolean`	`removeCondition(SQLExpr condition)`
`boolean`	`removeCondition(String conditionSql)`
`boolean`	`replace(SQLExpr expr, SQLExpr target)`
`boolean`	`replaceInParent(SQLSelectQuery x)`
`protected <T extends SQLObject> boolean`	`replaceList(List<T> exprList, T expr, T target)`
`SQLObject`	`resolveColum(long columnNameHash)`
`boolean`	`selectItemHasAllColumn()`
`boolean`	`selectItemHasAllColumn(boolean recursive)`
`void`	`setCachedSelectList(String cachedSelectList, long cachedSelectListHash)`
`void`	`setCommentsAfterFrom(List<String> commentsAfterFrom)`
`void`	`setConnectBy(SQLExpr connectBy)`
`void`	`setDbType(DbType dbType)`
`void`	`setDistinct()`
`void`	`setDistinct(boolean distinct)`
`void`	`setDistionOption(int distionOption)`
`void`	`setFirst(SQLExpr first)`
`void`	`setForShare(boolean forShare)`
`void`	`setForUpdate(boolean forUpdate)`
`void`	`setFrom(SQLExpr from)`
`void`	`setFrom(SQLSelectQueryBlock queryBlock, String alias)`
`void`	`setFrom(SQLSelect select, String alias)`
`void`	`setFrom(SQLTableSource from)`
`void`	`setFrom(String tableName, String alias)`
`void`	`setGroupBy(SQLSelectGroupByClause x)`
`void`	`setHints(List<SQLCommentHint> hints)`
`void`	`setInto(SQLExpr into)`
`void`	`setInto(SQLExprTableSource into)`
`void`	`setLimit(SQLLimit limit)`
`void`	`setNoCycle(boolean noCycle)`
`void`	`setNoWait(boolean noWait)`
`void`	`setOffset(SQLExpr offset)`
`void`	`setOrderBy(SQLOrderBy orderBy)`
`void`	`setOrderBySiblings(SQLOrderBy orderBySiblings)`
`void`	`setPrior(boolean prior)`
`void`	`setQualify(SQLExpr x)`
`void`	`setSkipLocked(boolean skipLocked)`
`void`	`setStartWith(SQLExpr startWith)`
`void`	`setWaitTime(SQLExpr waitTime)`
`void`	`setWhere(SQLExpr x)`
`void`	`setWith(SQLWithSubqueryClause x)`
`void`	`whereOr(SQLExpr condition)`

Methods inherited from class com.alibaba.druid.sql.ast.statement.SQLSelectQueryBase
cloneTo, isParenthesized, setParenthesized

Methods inherited from class com.alibaba.druid.sql.ast.SQLObjectImpl
accept, acceptChild, acceptChild, addAfterComment, addAfterComment, addBeforeComment, addBeforeComment, cloneTo, computeDataType, containsAttribute, getAfterCommentsDirect, getAttribute, getAttributes, getAttributesDirect, getBeforeCommentsDirect, getHint, getParent, getParent, getSourceColumn, getSourceLine, hasAfterComment, hasBeforeComment, output, putAttribute, setHint, setParent, setSource, setSourceLine, toString

Methods inherited from class java.lang.Object
finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface com.alibaba.druid.sql.ast.SQLObject
accept, addAfterComment, addAfterComment, addBeforeComment, addBeforeComment, containsAttribute, getAfterCommentsDirect, getAttribute, getAttributes, getAttributesDirect, getBeforeCommentsDirect, getParent, getParent, getSourceColumn, getSourceLine, hasAfterComment, hasBeforeComment, output, putAttribute, setParent, setSource

Field Detail

with
```
protected SQLWithSubqueryClause with
```

distionOption
```
protected int distionOption
```

selectList

protected final List<SQLSelectItem> selectList

from
```
protected SQLTableSource from
```

commentsAfterFrom

protected List<String> commentsAfterFrom

into
```
protected SQLExprTableSource into
```

where
```
protected SQLExpr where
```

startWith
```
protected SQLExpr startWith
```

connectBy
```
protected SQLExpr connectBy
```

prior
```
protected boolean prior
```

noCycle
```
protected boolean noCycle
```

orderBySiblings
```
protected SQLOrderBy orderBySiblings
```

groupBy

protected SQLSelectGroupByClause groupBy

windows
```
protected List<SQLWindow> windows
```

qualify
```
protected SQLExpr qualify
```

orderBy
```
protected SQLOrderBy orderBy
```

forUpdate
```
protected boolean forUpdate
```

noWait
```
protected boolean noWait
```

skipLocked
```
protected boolean skipLocked
```

forShare
```
protected boolean forShare
```

waitTime
```
protected SQLExpr waitTime
```

limit
```
protected SQLLimit limit
```

forUpdateOf
```
protected List<SQLExpr> forUpdateOf
```

distributeBy

protected List<SQLSelectOrderByItem> distributeBy

sortBy

protected List<SQLSelectOrderByItem> sortBy

clusterBy

protected List<SQLSelectOrderByItem> clusterBy

cachedSelectList
```
protected String cachedSelectList
```

cachedSelectListHash
```
protected long cachedSelectListHash
```

dbType
```
protected DbType dbType
```

hints
```
protected List<SQLCommentHint> hints
```

Constructor Detail

SQLSelectQueryBlock
```
public SQLSelectQueryBlock()
```

SQLSelectQueryBlock

public SQLSelectQueryBlock(DbType dbType)

Method Detail

getInto
```
public SQLExprTableSource getInto()
```

setInto
```
public void setInto(SQLExpr into)
```

setInto

public void setInto(SQLExprTableSource into)

getGroupBy

public SQLSelectGroupByClause getGroupBy()

setGroupBy

public void setGroupBy(SQLSelectGroupByClause x)

getWindows
```
public List<SQLWindow> getWindows()
```

addWindow

public void addWindow(SQLWindow x)

getQualify
```
public SQLExpr getQualify()
```

setQualify
```
public void setQualify(SQLExpr x)
```

getWhere
```
public SQLExpr getWhere()
```

setWhere
```
public void setWhere(SQLExpr x)
```

addWhere

public void addWhere(SQLExpr condition)

addWhereForDynamicFilter

public void addWhereForDynamicFilter(SQLExpr condition)

whereOr

public void whereOr(SQLExpr condition)

addHaving

public void addHaving(SQLExpr condition)

getOrderBy
```
public SQLOrderBy getOrderBy()
```

setOrderBy

public void setOrderBy(SQLOrderBy orderBy)

addOrderBy

public void addOrderBy(SQLOrderBy orderBy)

addOrderBy

public void addOrderBy(SQLSelectOrderByItem orderByItem)

containsOrderBy

public boolean containsOrderBy(SQLSelectOrderByItem orderByItem)

addOrderBy

public void addOrderBy(SQLExpr orderBy,
                       SQLOrderingSpecification type)

addOrderBy

public void addOrderBy(SQLExpr orderBy)

getOrderBySiblings

public SQLOrderBy getOrderBySiblings()

setOrderBySiblings

public void setOrderBySiblings(SQLOrderBy orderBySiblings)

getDistionOption
```
public int getDistionOption()
```

setDistionOption

public void setDistionOption(int distionOption)

setDistinct
```
public void setDistinct()
```

isDistinct
```
public boolean isDistinct()
```

setDistinct

public void setDistinct(boolean distinct)

getSelectList

public List<SQLSelectItem> getSelectList()

getSelectItem

public SQLSelectItem getSelectItem(int i)

addSelectItem

public void addSelectItem(SQLSelectItem item)

addSelectItem

public SQLSelectItem addSelectItem(SQLExpr expr)

addSelectItem

public void addSelectItem(String selectItemExpr,
                          String alias)

addSelectItem

public void addSelectItem(SQLExpr expr,
                          String alias)

hasSelectAggregation
```
public boolean hasSelectAggregation()
```

getFrom
```
public SQLTableSource getFrom()
```

setFrom
```
public void setFrom(SQLExpr from)
```

setFrom

public void setFrom(SQLTableSource from)

setFrom

public void setFrom(SQLSelectQueryBlock queryBlock,
                    String alias)

getCommentsAfterFrom

public List<String> getCommentsAfterFrom()

setCommentsAfterFrom

public void setCommentsAfterFrom(List<String> commentsAfterFrom)

setFrom

public void setFrom(SQLSelect select,
                    String alias)

setFrom

public void setFrom(String tableName,
                    String alias)

isForUpdate
```
public boolean isForUpdate()
```

setForUpdate

public void setForUpdate(boolean forUpdate)

isNoWait
```
public boolean isNoWait()
```

setNoWait

public void setNoWait(boolean noWait)

isSkipLocked
```
public boolean isSkipLocked()
```

setSkipLocked

public void setSkipLocked(boolean skipLocked)

isForShare
```
public boolean isForShare()
```

setForShare

public void setForShare(boolean forShare)

getWaitTime
```
public SQLExpr getWaitTime()
```

setWaitTime

public void setWaitTime(SQLExpr waitTime)

getLimit
```
public SQLLimit getLimit()
```

setLimit

public void setLimit(SQLLimit limit)

mergeLimit

public void mergeLimit(SQLLimit limit)

getFirst
```
public SQLExpr getFirst()
```

setFirst

public void setFirst(SQLExpr first)

getOffset
```
public SQLExpr getOffset()
```

setOffset

public void setOffset(SQLExpr offset)

isPrior
```
public boolean isPrior()
```

setPrior

public void setPrior(boolean prior)

getStartWith
```
public SQLExpr getStartWith()
```

setStartWith

public void setStartWith(SQLExpr startWith)

getConnectBy
```
public SQLExpr getConnectBy()
```

setConnectBy

public void setConnectBy(SQLExpr connectBy)

isNoCycle
```
public boolean isNoCycle()
```

setNoCycle

public void setNoCycle(boolean noCycle)

getDistributeBy

public List<SQLSelectOrderByItem> getDistributeBy()

getDistributeByDirect

public List<SQLSelectOrderByItem> getDistributeByDirect()

addDistributeBy

public void addDistributeBy(SQLExpr x)

addDistributeBy

public void addDistributeBy(SQLSelectOrderByItem item)

getSortBy

public List<SQLSelectOrderByItem> getSortBy()

getSortByDirect

public List<SQLSelectOrderByItem> getSortByDirect()

addSortBy

public void addSortBy(SQLSelectOrderByItem item)

accept0

protected void accept0(SQLASTVisitor visitor)

Specified by:: accept0 in class SQLObjectImpl

acceptChild

protected void acceptChild(SQLASTVisitor v)

equals
```
public boolean equals(Object o)
```
Overrides:

equals in class Object

hashCode
```
public int hashCode()
```
Overrides:

hashCode in class Object

equalsForMergeJoin

public boolean equalsForMergeJoin(SQLSelectQueryBlock that)

clone
```
public SQLSelectQueryBlock clone()
```
Specified by:

clone in interface SQLObject

Specified by:

clone in interface SQLSelectQuery

Specified by:

clone in class SQLSelectQueryBase

getForUpdateOf
```
public List<SQLExpr> getForUpdateOf()
```

getForUpdateOfSize
```
public int getForUpdateOfSize()
```

cloneSelectListTo

public void cloneSelectListTo(SQLSelectQueryBlock x)

cloneTo

public void cloneTo(SQLSelectQueryBlock x)

findTableSource

public SQLTableSource findTableSource(String alias)

findTableSourceWithColumn

public SQLTableSource findTableSourceWithColumn(String column)

findTableSourceWithColumn

public SQLTableSource findTableSourceWithColumn(long columnHash)

replace

public boolean replace(SQLExpr expr,
                       SQLExpr target)

Specified by:: replace in interface SQLReplaceable

replaceList

protected <T extends SQLObject> boolean replaceList(List<T> exprList,
                                                    T expr,
                                                    T target)

findSelectItem

public SQLSelectItem findSelectItem(String ident)

findSelectItemAndComputeDataType

public SQLDataType findSelectItemAndComputeDataType(String ident)

findSelectItemAndComputeDataType

public SQLDataType findSelectItemAndComputeDataType(long identHash)

hasAllColumnSelectItem

public boolean hasAllColumnSelectItem()

findSelectItem

public SQLSelectItem findSelectItem(long identHash)

selectItemHasAllColumn

public boolean selectItemHasAllColumn()

selectItemHasAllColumn

public boolean selectItemHasAllColumn(boolean recursive)

findAllColumnSelectItem

public SQLSelectItem findAllColumnSelectItem()

findColumn

public SQLColumnDefinition findColumn(String columnName)

findColumn

public SQLColumnDefinition findColumn(long columnNameHash)

resolveColum

public SQLObject resolveColum(long columnNameHash)

addCondition

public void addCondition(String conditionSql)

addCondition

public void addCondition(SQLExpr expr)

removeCondition

public boolean removeCondition(String conditionSql)

removeCondition

public boolean removeCondition(SQLExpr condition)

limit

public void limit(int rowCount,
                  int offset)

getCachedSelectList
```
public String getCachedSelectList()
```

setCachedSelectList

public void setCachedSelectList(String cachedSelectList,
                                long cachedSelectListHash)

getCachedSelectListHash
```
public long getCachedSelectListHash()
```

getDbType
```
public DbType getDbType()
```
Specified by:

getDbType in interface SQLDbTypedObject

setDbType

public void setDbType(DbType dbType)

getHintsDirect

public List<SQLCommentHint> getHintsDirect()

getHints

public List<SQLCommentHint> getHints()

setHints

public void setHints(List<SQLCommentHint> hints)

getHintsSize
```
public int getHintsSize()
```

replaceInParent

public boolean replaceInParent(SQLSelectQuery x)

getClusterBy

public List<SQLSelectOrderByItem> getClusterBy()

getClusterByDirect

public List<SQLSelectOrderByItem> getClusterByDirect()

addClusterBy

public void addClusterBy(SQLSelectOrderByItem item)

computeSelecteListAlias

public List<String> computeSelecteListAlias()

getMappJoinTableSources

public List<SQLTableSource> getMappJoinTableSources()

clearMapJoinHint
```
public boolean clearMapJoinHint()
```

getWith

public SQLWithSubqueryClause getWith()

setWith

public void setWith(SQLWithSubqueryClause x)

Class SQLSelectQueryBlock

Field Summary

Fields inherited from class com.alibaba.druid.sql.ast.statement.SQLSelectQueryBase

Fields inherited from class com.alibaba.druid.sql.ast.SQLObjectImpl

Constructor Summary

Method Summary

Methods inherited from class com.alibaba.druid.sql.ast.statement.SQLSelectQueryBase

Methods inherited from class com.alibaba.druid.sql.ast.SQLObjectImpl

Methods inherited from class java.lang.Object

Methods inherited from interface com.alibaba.druid.sql.ast.SQLObject

Field Detail

with

distionOption

selectList

from

commentsAfterFrom

into

where

startWith

connectBy

prior

noCycle

orderBySiblings

groupBy

windows

qualify

orderBy

forUpdate

noWait

skipLocked

forShare

waitTime

limit

forUpdateOf

distributeBy

sortBy

clusterBy

cachedSelectList

cachedSelectListHash

dbType

hints

Constructor Detail

SQLSelectQueryBlock

SQLSelectQueryBlock

Method Detail

getInto

setInto

setInto

getGroupBy

setGroupBy

getWindows

addWindow

getQualify

setQualify

getWhere

setWhere

addWhere

addWhereForDynamicFilter

whereOr

addHaving

getOrderBy

setOrderBy

addOrderBy

addOrderBy

containsOrderBy

addOrderBy

addOrderBy

getOrderBySiblings

setOrderBySiblings

getDistionOption

setDistionOption

setDistinct

isDistinct

setDistinct

getSelectList

getSelectItem

addSelectItem

addSelectItem

addSelectItem

addSelectItem