Enum Feature

java.lang.Object
java.lang.Enum<Feature>
net.sf.jsqlparser.parser.feature.Feature
All Implemented Interfaces:
Serializable, Comparable<Feature>

public enum Feature extends Enum<Feature>
  • Enum Constant Details

    • select

      public static final Feature select
      "SELECT"
    • selectGroupBy

      public static final Feature selectGroupBy
      "GROUP BY"
    • selectGroupByGroupingSets

      public static final Feature selectGroupByGroupingSets
      "GROUPING SETS"
    • selectHaving

      public static final Feature selectHaving
      "HAVING"
    • selectInto

      public static final Feature selectInto
      "INTO table(, table)*"
    • limit

      public static final Feature limit
      See Also:
    • limitNull

      public static final Feature limitNull
      "LIMIT NULL"
      See Also:
    • limitAll

      public static final Feature limitAll
      "LIMIT ALL"
      See Also:
    • limitOffset

      public static final Feature limitOffset
      "LIMIT offset, limit"
      See Also:
    • offset

      public static final Feature offset
      "OFFSET offset"
      See Also:
    • offsetParam

      public static final Feature offsetParam
      "OFFSET offset param" where param is ROW | ROWS
      See Also:
    • fetch

      public static final Feature fetch
      See Also:
    • fetchFirst

      public static final Feature fetchFirst
      "FETCH FIRST row_count (ROW | ROWS) ONLY"
      See Also:
    • fetchNext

      public static final Feature fetchNext
      "FETCH NEXT row_count (ROW | ROWS) ONLY" if not fetchFirst
      See Also:
    • join

      public static final Feature join
      "JOIN"
    • joinOuterSimple

      public static final Feature joinOuterSimple
      join tables by ", OUTER" placing the join specification in WHERE-clause
    • joinSimple

      public static final Feature joinSimple
      join tables by "," placing the join specification in WHERE-clause
    • joinRight

      public static final Feature joinRight
      "RIGHT" join
    • joinNatural

      public static final Feature joinNatural
      "NATURAL" join
    • joinFull

      public static final Feature joinFull
      "FULL" join
    • joinLeft

      public static final Feature joinLeft
      "LEFT" join
    • joinCross

      public static final Feature joinCross
      "CROSS" join
    • joinOuter

      public static final Feature joinOuter
      "OUTER" join
    • joinSemi

      public static final Feature joinSemi
      "SEMI" join
    • joinInner

      public static final Feature joinInner
      "INNER" join
    • joinStraight

      public static final Feature joinStraight
      "STRAIGHT_JOIN" join
    • joinApply

      public static final Feature joinApply
      "APPLY" join
    • joinWindow

      public static final Feature joinWindow
    • joinUsingColumns

      public static final Feature joinUsingColumns
    • skip

      public static final Feature skip
      "SKIP variable" | "SKIP ?" | "SKIP rowCount"
      See Also:
    • first

      public static final Feature first
      "FIRST" \?|[0-9]+|variable or "LIMIT" \?|[0-9]+|variable
      See Also:
    • top

      public static final Feature top
      "TOP" ? "PERCENT"
      See Also:
    • optimizeFor

      public static final Feature optimizeFor
      "OPTIMIZE FOR rowCount ROWS"
      See Also:
    • selectUnique

      public static final Feature selectUnique
      "UNIQUE" keyword
    • distinct

      public static final Feature distinct
      "DISTINCT" keyword
    • distinctOn

      public static final Feature distinctOn
      "DISTINCT ON (col1, ...)"
    • orderBy

      public static final Feature orderBy
      "ORDER BY"
    • orderByNullOrdering

      public static final Feature orderByNullOrdering
      "ORDER BY expression [ NULLS { FIRST | LAST } ]"
    • selectForUpdate

      public static final Feature selectForUpdate
      "FOR UPDATE"
    • selectForShare

      public static final Feature selectForShare
      "FOR SHARE"
    • selectForKeyShare

      public static final Feature selectForKeyShare
      "FOR KEY SHARE"
    • selectForNoKeyUpdate

      public static final Feature selectForNoKeyUpdate
      "NO KEY UPDATE"
    • selectForUpdateOfTable

      public static final Feature selectForUpdateOfTable
      "FOR UPDATE OF table"
    • selectForUpdateWait

      public static final Feature selectForUpdateWait
      "FOR UPDATE WAIT timeout"
    • selectForUpdateNoWait

      public static final Feature selectForUpdateNoWait
      "FOR UPDATE NOWAIT"
    • selectForUpdateSkipLocked

      public static final Feature selectForUpdateSkipLocked
      "FOR UPDATE SKIP LOCKED"
    • insert

      public static final Feature insert
      SQL "INSERT" statement is allowed
    • insertFromSelect

      public static final Feature insertFromSelect
      "INSERT .. SELECT"
    • insertModifierPriority

      public static final Feature insertModifierPriority
      "LOW_PRIORITY | DELAYED | HIGH_PRIORITY | IGNORE"
    • insertModifierIgnore

      public static final Feature insertModifierIgnore
      "IGNORE"
    • insertUseSet

      public static final Feature insertUseSet
      "INSERT .. SET"
    • insertUseDuplicateKeyUpdate

      public static final Feature insertUseDuplicateKeyUpdate
      "ON DUPLICATE KEY UPDATE"
    • insertReturningAll

      public static final Feature insertReturningAll
      "RETURNING *"
    • insertReturningExpressionList

      public static final Feature insertReturningExpressionList
      "RETURNING expr(, expr)*"
      See Also:
    • insertValues

      public static final Feature insertValues
      "VALUES"
    • values

      public static final Feature values
      See Also:
    • tableStatement

      public static final Feature tableStatement
      SQL "TABLE table_name [ORDER BY column_name] [LIMIT number [OFFSET number]]“
    • update

      public static final Feature update
      SQL "UPDATE" statement is allowed
      See Also:
    • updateFrom

      public static final Feature updateFrom
      "UPDATE table1 SET ... FROM table2
    • updateJoins

      public static final Feature updateJoins
      "UPDATE table1, table2 ..."
    • updateUseSelect

      public static final Feature updateUseSelect
      UPDATE table SET (col, ...) = (SELECT col, ... )"
    • updateOrderBy

      public static final Feature updateOrderBy
    • updateLimit

      public static final Feature updateLimit
    • updateReturning

      public static final Feature updateReturning
      "RETURNING expr(, expr)*"
      See Also:
    • delete

      public static final Feature delete
      SQL "DELETE" statement is allowed
      See Also:
    • deleteJoin

      public static final Feature deleteJoin
      "DELETE FROM table1, table1 ..."
    • deleteTables

      public static final Feature deleteTables
      "DELETE table1, table1 FROM table ..."
    • deleteLimit

      public static final Feature deleteLimit
      "LIMIT row_count"
    • deleteOrderBy

      public static final Feature deleteOrderBy
      "ORDER BY ..."
    • deleteReturningExpressionList

      public static final Feature deleteReturningExpressionList
      "RETURNING expr(, expr)*"
      See Also:
    • upsert

      public static final Feature upsert
      SQL "UPSERT" statement is allowed
      See Also:
    • merge

      public static final Feature merge
      SQL "MERGE" statement is allowed
      See Also:
    • alterTable

      public static final Feature alterTable
      SQL "ALTER" statement is allowed
      See Also:
    • alterSequence

      public static final Feature alterSequence
      SQL "ALTER SEQUENCE" statement is allowed
      See Also:
    • alterView

      public static final Feature alterView
      SQL "ALTER VIEW" statement is allowed
      See Also:
    • refreshMaterializedView

      public static final Feature refreshMaterializedView
      SQL "REFRESH MATERIALIZED VIEW" statement is allowed
      See Also:
    • refreshMaterializedWithDataView

      public static final Feature refreshMaterializedWithDataView
    • refreshMaterializedWithNoDataView

      public static final Feature refreshMaterializedWithNoDataView
    • alterViewReplace

      public static final Feature alterViewReplace
      SQL "REPLACE VIEW" statement is allowed
      See Also:
    • alterIndex

      public static final Feature alterIndex
      SQL "ALTER INDEX" statement is allowed
    • analyze

      public static final Feature analyze
      SQL "ANALYZE" statement is allowed
      See Also:
    • truncate

      public static final Feature truncate
      SQL "TRUNCATE" statement is allowed
      See Also:
    • execute

      public static final Feature execute
      SQL "CALL|EXEC|EXECUTE" stored procedure is allowed
      See Also:
    • executeExec

      public static final Feature executeExec
    • executeCall

      public static final Feature executeCall
    • executeExecute

      public static final Feature executeExecute
    • executeStatement

      public static final Feature executeStatement
      SQL "EXECUTE" statement is allowed
    • executeStatementImmediate

      public static final Feature executeStatementImmediate
      SQL "EXECUTE IMMEDIATE" statement is allowed
    • executeUsing

      public static final Feature executeUsing
    • replace

      @Deprecated public static final Feature replace
      Deprecated.
      SQL "REPLACE" statement is allowed
    • drop

      public static final Feature drop
      SQL "DROP" statement is allowed
      See Also:
    • dropTable

      public static final Feature dropTable
    • dropIndex

      public static final Feature dropIndex
    • dropView

      public static final Feature dropView
    • dropSchema

      public static final Feature dropSchema
    • dropSequence

      public static final Feature dropSequence
    • dropTableIfExists

      public static final Feature dropTableIfExists
    • dropIndexIfExists

      public static final Feature dropIndexIfExists
    • dropViewIfExists

      public static final Feature dropViewIfExists
    • dropSchemaIfExists

      public static final Feature dropSchemaIfExists
    • dropSequenceIfExists

      public static final Feature dropSequenceIfExists
    • createSchema

      public static final Feature createSchema
      SQL "CREATE SCHEMA" statement is allowed
      See Also:
    • createView

      public static final Feature createView
      SQL "CREATE VIEW" statement is allowed
      See Also:
    • createViewForce

      public static final Feature createViewForce
      "CREATE FORCE VIEW"
    • createViewTemporary

      public static final Feature createViewTemporary
      "CREATE TEMPORARAY VIEW"
    • createOrReplaceView

      public static final Feature createOrReplaceView
      "CREATE OR REPLACE VIEW"
    • createViewMaterialized

      public static final Feature createViewMaterialized
      SQL "CREATE MATERIALIZED VIEW" statement is allowed
    • createViewWithComment

      public static final Feature createViewWithComment
      SQL "CREATE VIEW(x comment 'x', y comment 'y') comment 'view'" statement is allowed
    • createTable

      public static final Feature createTable
      SQL "CREATE TABLE" statement is allowed
      See Also:
    • createTableUnlogged

      public static final Feature createTableUnlogged
      "CREATE GLOBAL UNLOGGED"
    • createTableCreateOptionStrings

      public static final Feature createTableCreateOptionStrings
      i.e. "CREATE GLOBAL TEMPORARY TABLE", "CREATE SHARDED TABLE"
    • createTableTableOptionStrings

      public static final Feature createTableTableOptionStrings
      i.e. "ENGINE = InnoDB AUTO_INCREMENT = 8761 DEFAULT CHARSET = utf8"
    • createTableIfNotExists

      public static final Feature createTableIfNotExists
      "CREATE TABLE IF NOT EXISTS table"
    • createTableRowMovement

      public static final Feature createTableRowMovement
      " ROW MOVEMENT"
    • createTableFromSelect

      public static final Feature createTableFromSelect
      "CREATE TABLE (colspec) SELECT ...
    • createIndex

      public static final Feature createIndex
      SQL "CREATE INDEX" statement is allowed
      See Also:
    • createSequence

      public static final Feature createSequence
      SQL "CREATE SEQUENCE" statement is allowed
      See Also:
    • createSynonym

      public static final Feature createSynonym
      SQL "CREATE SYNONYM" statement is allowed
      See Also:
    • createTrigger

      public static final Feature createTrigger
      SQL "CREATE TRIGGER" statement is allowed
    • commit

      public static final Feature commit
      SQL "COMMIT" statement is allowed
      See Also:
    • comment

      public static final Feature comment
      SQL "COMMENT ON" statement is allowed
      See Also:
    • commentOnTable

      public static final Feature commentOnTable
      "COMMENT ON table"
    • commentOnColumn

      public static final Feature commentOnColumn
      "COMMENT ON column"
    • commentOnView

      public static final Feature commentOnView
      "COMMENT ON view"
    • describe

      public static final Feature describe
      SQL "DESCRIBE" statement is allowed
      See Also:
    • desc

      public static final Feature desc
      SQL "DESC" statement is allowed
      See Also:
    • explain

      public static final Feature explain
      SQL "EXPLAIN" statement is allowed
      See Also:
    • show

      public static final Feature show
      See Also:
    • showTables

      public static final Feature showTables
      See Also:
    • showColumns

      public static final Feature showColumns
      See Also:
    • showIndex

      public static final Feature showIndex
      See Also:
    • use

      public static final Feature use
      See Also:
    • grant

      public static final Feature grant
      See Also:
    • function

      public static final Feature function
      See Also:
    • createFunction

      public static final Feature createFunction
      See Also:
    • createProcedure

      public static final Feature createProcedure
      See Also:
    • functionalStatement

      public static final Feature functionalStatement
      See Also:
    • block

      public static final Feature block
      SQL block starting with "BEGIN" and ends with "END" statement is allowed
      See Also:
    • declare

      public static final Feature declare
      See Also:
    • set

      public static final Feature set
      See Also:
    • reset

      public static final Feature reset
      See Also:
    • pivot

      public static final Feature pivot
      See Also:
    • unpivot

      public static final Feature unpivot
      See Also:
    • pivotXml

      public static final Feature pivotXml
      See Also:
    • setOperation

      public static final Feature setOperation
    • setOperationUnion

      public static final Feature setOperationUnion
    • setOperationIntersect

      public static final Feature setOperationIntersect
    • setOperationExcept

      public static final Feature setOperationExcept
    • setOperationMinus

      public static final Feature setOperationMinus
    • withItem

      public static final Feature withItem
      "WITH name query"
    • withItemRecursive

      public static final Feature withItemRecursive
    • lateralSubSelect

      public static final Feature lateralSubSelect
    • valuesList

      public static final Feature valuesList
      See Also:
    • tableFunction

      public static final Feature tableFunction
      See Also:
    • jdbcParameter

      public static final Feature jdbcParameter
      See Also:
    • jdbcNamedParameter

      public static final Feature jdbcNamedParameter
      See Also:
    • exprLike

      public static final Feature exprLike
      "LIKE"
    • exprSimilarTo

      public static final Feature exprSimilarTo
      "SIMILAR TO"
    • kSqlWindow

      public static final Feature kSqlWindow
      See Also:
    • oracleOldJoinSyntax

      public static final Feature oracleOldJoinSyntax
      allows old oracle join syntax (+)
      See Also:
    • oraclePriorPosition

      public static final Feature oraclePriorPosition
      allows oracle prior position
      See Also:
    • oracleHint

      public static final Feature oracleHint
      See Also:
    • oracleHierarchicalExpression

      public static final Feature oracleHierarchicalExpression
      oracle SQL "CONNECT BY"
      See Also:
    • oracleOrderBySiblings

      public static final Feature oracleOrderBySiblings
    • mySqlHintStraightJoin

      public static final Feature mySqlHintStraightJoin
    • mysqlSqlCacheFlag

      public static final Feature mysqlSqlCacheFlag
    • mysqlCalcFoundRows

      public static final Feature mysqlCalcFoundRows
    • selectForXmlPath

      public static final Feature selectForXmlPath
      "FOR XML PATH(...)"
    • allowSquareBracketQuotation

      public static final Feature allowSquareBracketQuotation
      allows square brackets for names, disabled by default
    • allowPostgresSpecificSyntax

      public static final Feature allowPostgresSpecificSyntax
      allow parsing of RDBMS specific syntax by switching off SQL Standard Compliant Syntax
    • allowComplexParsing

      public static final Feature allowComplexParsing
      allows complex expression parameters or named parameters for functions will be switched off, when deep nesting of functions is detected
    • allowUnsupportedStatements

      public static final Feature allowUnsupportedStatements
      allows passing through Unsupported Statements as a plain List of Tokens needs to be switched off, when VALIDATING statements or parsing blocks
    • timeOut

      public static final Feature timeOut
    • allowBackslashEscapeCharacter

      public static final Feature allowBackslashEscapeCharacter
      allows Backslash '\' as Escape Character
  • Field Details

    • value

      private final Object value
    • configurable

      private final boolean configurable
  • Constructor Details

    • Feature

      private Feature()
      a feature which can't configured within the parser
    • Feature

      private Feature(Object value)
      a feature which can be configured by FeatureConfiguration
      Parameters:
      value - The Value Object of the Parameter.
  • Method Details

    • values

      public static Feature[] values()
      Returns an array containing the constants of this enum type, in the order they are declared.
      Returns:
      an array containing the constants of this enum type, in the order they are declared
    • valueOf

      public static Feature valueOf(String name)
      Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)
      Parameters:
      name - the name of the enum constant to be returned.
      Returns:
      the enum constant with the specified name
      Throws:
      IllegalArgumentException - if this enum type has no constant with the specified name
      NullPointerException - if the argument is null
    • getDefaultValue

      public Object getDefaultValue()
    • isConfigurable

      public boolean isConfigurable()