Class PlainSelect

All Implemented Interfaces:
Serializable, Expression, Model, ASTNodeAccess, Statement

public class PlainSelect extends Select
See Also:
  • Field Details

    • distinct

      private Distinct distinct
    • selectItems

      private List<SelectItem<?>> selectItems
    • intoTables

      private List<Table> intoTables
    • fromItem

      private FromItem fromItem
    • lateralViews

      private List<LateralView> lateralViews
    • joins

      private List<Join> joins
    • where

      private Expression where
    • groupBy

      private GroupByElement groupBy
    • having

      private Expression having
    • qualify

      private Expression qualify
    • optimizeFor

      private OptimizeFor optimizeFor
    • skip

      private Skip skip
    • mySqlHintStraightJoin

      private boolean mySqlHintStraightJoin
    • first

      private First first
    • top

      private Top top
    • oracleHierarchical

      private OracleHierarchicalExpression oracleHierarchical
    • oracleHint

      private OracleHint oracleHint
    • forMode

      private ForMode forMode
    • forUpdateTable

      private Table forUpdateTable
    • skipLocked

      private boolean skipLocked
    • wait

      private Wait wait
    • mySqlSqlCalcFoundRows

      private boolean mySqlSqlCalcFoundRows
    • mySqlCacheFlag

      private MySqlSqlCacheFlags mySqlCacheFlag
    • forXmlPath

      private String forXmlPath
    • ksqlWindow

      private KSQLWindow ksqlWindow
    • noWait

      private boolean noWait
    • emitChanges

      private boolean emitChanges
    • windowDefinitions

      private List<WindowDefinition> windowDefinitions
    • isUsingFinal

      private boolean isUsingFinal
      See Also:
    • isUsingOnly

      private boolean isUsingOnly
    • useWithNoLog

      private boolean useWithNoLog
    • intoTempTable

      private Table intoTempTable
  • Constructor Details

    • PlainSelect

      public PlainSelect()
  • Method Details

    • isUseBrackets

      @Deprecated public boolean isUseBrackets()
      Deprecated.
    • getFromItem

      public FromItem getFromItem()
    • getIntoTables

      public List<Table> getIntoTables()
    • getSelectItems

      public List<SelectItem<?>> getSelectItems()
    • getSelectItem

      public SelectItem<?> getSelectItem(int index)
    • getWhere

      public Expression getWhere()
    • withFromItem

      public PlainSelect withFromItem(FromItem item)
    • setFromItem

      public void setFromItem(FromItem item)
    • setIntoTables

      public void setIntoTables(List<Table> intoTables)
    • withSelectItems

      public PlainSelect withSelectItems(List<SelectItem<?>> list)
    • setSelectItems

      public void setSelectItems(List<SelectItem<?>> list)
    • addSelectItems

      public PlainSelect addSelectItems(SelectItem<?>... items)
    • addSelectItems

      public PlainSelect addSelectItems(Expression... expressions)
    • addSelectItem

      public PlainSelect addSelectItem(Expression expression, Alias alias)
    • addSelectItem

      public PlainSelect addSelectItem(Expression expression)
    • setWhere

      public void setWhere(Expression where)
    • getLateralViews

      public List<LateralView> getLateralViews()
    • setLateralViews

      public void setLateralViews(Collection<LateralView> lateralViews)
    • addLateralView

      public PlainSelect addLateralView(LateralView lateralView)
    • withLateralViews

      public PlainSelect withLateralViews(Collection<LateralView> lateralViews)
    • getJoins

      public List<Join> getJoins()
      The list of Joins
      Returns:
      the list of Joins
    • getJoin

      public Join getJoin(int index)
    • addJoins

      public PlainSelect addJoins(Join... joins)
    • withJoins

      public PlainSelect withJoins(List<Join> joins)
    • setJoins

      public void setJoins(List<Join> list)
    • isUsingFinal

      public boolean isUsingFinal()
    • setUsingFinal

      public void setUsingFinal(boolean usingFinal)
    • withUsingFinal

      public PlainSelect withUsingFinal(boolean usingFinal)
    • isUsingOnly

      public boolean isUsingOnly()
    • setUsingOnly

      public void setUsingOnly(boolean usingOnly)
    • withUsingOnly

      public PlainSelect withUsingOnly(boolean usingOnly)
    • isUseWithNoLog

      public boolean isUseWithNoLog()
    • setUseWithNoLog

      public void setUseWithNoLog(boolean useWithNoLog)
    • withUseWithNoLog

      public PlainSelect withUseWithNoLog(boolean useWithNoLog)
    • getIntoTempTable

      public Table getIntoTempTable()
    • setIntoTempTable

      public void setIntoTempTable(Table intoTempTable)
    • withIntoTempTable

      public PlainSelect withIntoTempTable(Table intoTempTable)
    • accept

      public void accept(SelectVisitor selectVisitor)
      Specified by:
      accept in class Select
    • getOptimizeFor

      public OptimizeFor getOptimizeFor()
    • setOptimizeFor

      public void setOptimizeFor(OptimizeFor optimizeFor)
    • getTop

      public Top getTop()
    • setTop

      public void setTop(Top top)
    • getSkip

      public Skip getSkip()
    • setSkip

      public void setSkip(Skip skip)
    • getMySqlHintStraightJoin

      public boolean getMySqlHintStraightJoin()
    • setMySqlHintStraightJoin

      public void setMySqlHintStraightJoin(boolean mySqlHintStraightJoin)
    • getFirst

      public First getFirst()
    • setFirst

      public void setFirst(First first)
    • getDistinct

      public Distinct getDistinct()
    • setDistinct

      public void setDistinct(Distinct distinct)
    • getHaving

      public Expression getHaving()
    • setHaving

      public void setHaving(Expression expression)
    • getQualify

      public Expression getQualify()
    • setQualify

      public PlainSelect setQualify(Expression qualify)
    • getGroupBy

      public GroupByElement getGroupBy()
      A list of Expressions of the GROUP BY clause. It is null in case there is no GROUP BY clause
      Returns:
      a list of Expressions
    • setGroupByElement

      public void setGroupByElement(GroupByElement groupBy)
    • addGroupByColumnReference

      public PlainSelect addGroupByColumnReference(Expression expr)
    • getOracleHierarchical

      public OracleHierarchicalExpression getOracleHierarchical()
    • setOracleHierarchical

      public void setOracleHierarchical(OracleHierarchicalExpression oracleHierarchical)
    • getForMode

      public ForMode getForMode()
    • setForMode

      public void setForMode(ForMode forMode)
    • getForUpdateTable

      public Table getForUpdateTable()
    • setForUpdateTable

      public void setForUpdateTable(Table forUpdateTable)
    • getOracleHint

      public OracleHint getOracleHint()
    • setOracleHint

      public void setOracleHint(OracleHint oracleHint)
    • setWait

      public void setWait(Wait wait)
      Sets the Wait for this SELECT
      Parameters:
      wait - the Wait for this SELECT
    • getWait

      public Wait getWait()
      Returns the value of the Wait set for this SELECT
      Returns:
      the value of the Wait set for this SELECT
    • getForXmlPath

      public String getForXmlPath()
    • setForXmlPath

      public void setForXmlPath(String forXmlPath)
    • getKsqlWindow

      public KSQLWindow getKsqlWindow()
    • setKsqlWindow

      public void setKsqlWindow(KSQLWindow ksqlWindow)
    • setEmitChanges

      public void setEmitChanges(boolean emitChanges)
    • isEmitChanges

      public boolean isEmitChanges()
    • getWindowDefinitions

      public List<WindowDefinition> getWindowDefinitions()
    • setWindowDefinitions

      public void setWindowDefinitions(List<WindowDefinition> windowDefinitions)
    • isSkipLocked

      public boolean isSkipLocked()
    • setSkipLocked

      public void setSkipLocked(boolean skipLocked)
    • appendSelectBodyTo

      public StringBuilder appendSelectBodyTo(StringBuilder builder)
      Specified by:
      appendSelectBodyTo in class Select
    • toString

      public String toString()
      Overrides:
      toString in class Select
    • withMySqlSqlCalcFoundRows

      public PlainSelect withMySqlSqlCalcFoundRows(boolean mySqlCalcFoundRows)
    • withMySqlSqlNoCache

      public PlainSelect withMySqlSqlNoCache(MySqlSqlCacheFlags mySqlCacheFlag)
    • setMySqlSqlCalcFoundRows

      public void setMySqlSqlCalcFoundRows(boolean mySqlCalcFoundRows)
    • setMySqlSqlCacheFlag

      public void setMySqlSqlCacheFlag(MySqlSqlCacheFlags sqlCacheFlag)
    • getMySqlSqlCalcFoundRows

      public boolean getMySqlSqlCalcFoundRows()
    • getMySqlSqlCacheFlag

      public MySqlSqlCacheFlags getMySqlSqlCacheFlag()
    • setNoWait

      public void setNoWait(boolean noWait)
    • isNoWait

      public boolean isNoWait()
    • withDistinct

      public PlainSelect withDistinct(Distinct distinct)
    • withIntoTables

      public PlainSelect withIntoTables(List<Table> intoTables)
    • withWhere

      public PlainSelect withWhere(Expression where)
    • withOptimizeFor

      public PlainSelect withOptimizeFor(OptimizeFor optimizeFor)
    • withSkip

      public PlainSelect withSkip(Skip skip)
    • withMySqlHintStraightJoin

      public PlainSelect withMySqlHintStraightJoin(boolean mySqlHintStraightJoin)
    • withFirst

      public PlainSelect withFirst(First first)
    • withTop

      public PlainSelect withTop(Top top)
    • withOracleHierarchical

      public PlainSelect withOracleHierarchical(OracleHierarchicalExpression oracleHierarchical)
    • withOracleHint

      public PlainSelect withOracleHint(OracleHint oracleHint)
    • withOracleSiblings

      public PlainSelect withOracleSiblings(boolean oracleSiblings)
      Overrides:
      withOracleSiblings in class Select
    • withForMode

      public PlainSelect withForMode(ForMode forMode)
    • withForUpdateTable

      public PlainSelect withForUpdateTable(Table forUpdateTable)
    • withForXmlPath

      public PlainSelect withForXmlPath(String forXmlPath)
    • withKsqlWindow

      public PlainSelect withKsqlWindow(KSQLWindow ksqlWindow)
    • withNoWait

      public PlainSelect withNoWait(boolean noWait)
    • withSkipLocked

      public PlainSelect withSkipLocked(boolean skipLocked)
    • withHaving

      public PlainSelect withHaving(Expression having)
    • withWait

      public PlainSelect withWait(Wait wait)
    • addSelectItems

      public PlainSelect addSelectItems(Collection<? extends SelectItem<?>> selectItems)
    • addIntoTables

      public PlainSelect addIntoTables(Table... intoTables)
    • addIntoTables

      public PlainSelect addIntoTables(Collection<? extends Table> intoTables)
    • addJoins

      public PlainSelect addJoins(Collection<? extends Join> joins)
    • getFromItem

      public <E extends FromItem> E getFromItem(Class<E> type)
    • getWhere

      public <E extends Expression> E getWhere(Class<E> type)
    • getHaving

      public <E extends Expression> E getHaving(Class<E> type)