- java.lang.Object
-
- java.lang.Enum<Feature>
-
- net.sf.jsqlparser.parser.feature.Feature
-
-
Enum Constant Summary
Enum Constants Enum Constant Description allowBackslashEscapeCharacter
allows Backslash '\' as Escape CharacterallowComplexParsing
allows complex expression parameters or named parameters for functions will be switched off, when deep nesting of functions is detectedallowPostgresSpecificSyntax
allow parsing of RDBMS specific syntax by switching off SQL Standard Compliant SyntaxallowSquareBracketQuotation
allows square brackets for names, disabled by defaultallowUnsupportedStatements
allows passing through Unsupported Statements as a plain List of Tokens needs to be switched off, when VALIDATING statements or parsing blocksalterIndex
SQL "ALTER INDEX" statement is allowedalterSequence
SQL "ALTER SEQUENCE" statement is allowedalterTable
SQL "ALTER" statement is allowedalterView
SQL "ALTER VIEW" statement is allowedalterViewReplace
SQL "REPLACE VIEW" statement is allowedanalyze
SQL "ANALYZE" statement is allowedblock
SQL block starting with "BEGIN" and ends with "END" statement is allowedcomment
SQL "COMMENT ON" statement is allowedcommentOnColumn
"COMMENT ON column"commentOnTable
"COMMENT ON table"commentOnView
"COMMENT ON view"commit
SQL "COMMIT" statement is allowedcreateFunction
createIndex
SQL "CREATE INDEX" statement is allowedcreateOrReplaceView
"CREATE OR REPLACE VIEW"createProcedure
createSchema
SQL "CREATE SCHEMA" statement is allowedcreateSequence
SQL "CREATE SEQUENCE" statement is allowedcreateSynonym
SQL "CREATE SYNONYM" statement is allowedcreateTable
SQL "CREATE TABLE" statement is allowedcreateTableCreateOptionStrings
i.e.createTableFromSelect
"CREATE TABLE (colspec) SELECT ...createTableIfNotExists
"CREATE TABLE IF NOT EXISTS table"createTableRowMovement
" ROW MOVEMENT"createTableTableOptionStrings
i.e.createTableUnlogged
"CREATE GLOBAL UNLOGGED"createTrigger
SQL "CREATE TRIGGER" statement is allowedcreateView
SQL "CREATE VIEW" statement is allowedcreateViewForce
"CREATE FORCE VIEW"createViewMaterialized
SQL "CREATE MATERIALIZED VIEW" statement is allowedcreateViewTemporary
"CREATE TEMPORARAY VIEW"createViewWithComment
SQL "CREATE VIEW(x comment 'x', y comment 'y') comment 'view'" statement is alloweddeclare
delete
SQL "DELETE" statement is alloweddeleteJoin
"DELETE FROM table1, table1 ..."deleteLimit
"LIMIT row_count"deleteOrderBy
"ORDER BY ..."deleteReturningExpressionList
"RETURNING expr(, expr)*"deleteTables
"DELETE table1, table1 FROM table ..."desc
SQL "DESC" statement is alloweddescribe
SQL "DESCRIBE" statement is alloweddistinct
"DISTINCT" keyworddistinctOn
"DISTINCT ON (col1, ...)"drop
SQL "DROP" statement is alloweddropIndex
dropIndexIfExists
dropSchema
dropSchemaIfExists
dropSequence
dropSequenceIfExists
dropTable
dropTableIfExists
dropView
dropViewIfExists
execute
SQL "CALL|EXEC|EXECUTE" stored procedure is allowedexecuteCall
executeExec
executeExecute
executeStatement
SQL "EXECUTE" statement is allowedexecuteStatementImmediate
SQL "EXECUTE IMMEDIATE" statement is allowedexecuteUsing
explain
SQL "EXPLAIN" statement is allowedexprLike
"LIKE"exprSimilarTo
"SIMILAR TO"fetch
fetchFirst
"FETCH FIRST row_count (ROW | ROWS) ONLY"fetchNext
"FETCH NEXT row_count (ROW | ROWS) ONLY" if notfetchFirst
first
"FIRST" \?|[0-9]+|variable or "LIMIT" \?|[0-9]+|variablefunction
functionalStatement
grant
insert
SQL "INSERT" statement is allowedinsertFromSelect
"INSERT ..insertModifierIgnore
"IGNORE"insertModifierPriority
"LOW_PRIORITY | DELAYED | HIGH_PRIORITY | IGNORE"insertReturningAll
"RETURNING *"insertReturningExpressionList
"RETURNING expr(, expr)*"insertUseDuplicateKeyUpdate
"ON DUPLICATE KEY UPDATE"insertUseSet
"INSERT ..insertValues
"VALUES"jdbcNamedParameter
jdbcParameter
join
"JOIN"joinApply
"APPLY" joinjoinCross
"CROSS" joinjoinFull
"FULL" joinjoinInner
"INNER" joinjoinLeft
"LEFT" joinjoinNatural
"NATURAL" joinjoinOuter
"OUTER" joinjoinOuterSimple
join tables by ", OUTER" placing the join specification in WHERE-clausejoinRight
"RIGHT" joinjoinSemi
"SEMI" joinjoinSimple
join tables by "," placing the join specification in WHERE-clausejoinStraight
"STRAIGHT_JOIN" joinjoinUsingColumns
joinWindow
kSqlWindow
lateralSubSelect
limit
limitAll
"LIMIT ALL"limitNull
"LIMIT NULL"limitOffset
"LIMIT offset, limit"merge
SQL "MERGE" statement is allowedmysqlCalcFoundRows
mySqlHintStraightJoin
mysqlSqlCacheFlag
offset
"OFFSET offset"offsetParam
"OFFSET offset param" where param is ROW | ROWSoptimizeFor
"OPTIMIZE FOR rowCount ROWS"oracleHierarchicalExpression
oracle SQL "CONNECT BY"oracleHint
oracleOldJoinSyntax
allows old oracle join syntax (+)oracleOrderBySiblings
oraclePriorPosition
allows oracle prior positionorderBy
"ORDER BY"orderByNullOrdering
"ORDER BY expression [ NULLS { FIRST | LAST } ]"pivot
pivotXml
refreshMaterializedView
SQL "REFRESH MATERIALIZED VIEW" statement is allowedrefreshMaterializedWithDataView
refreshMaterializedWithNoDataView
replace
Deprecated.reset
select
"SELECT"selectForKeyShare
"FOR KEY SHARE"selectForNoKeyUpdate
"NO KEY UPDATE"selectForShare
"FOR SHARE"selectForUpdate
"FOR UPDATE"selectForUpdateNoWait
"FOR UPDATE NOWAIT"selectForUpdateOfTable
"FOR UPDATE OF table"selectForUpdateSkipLocked
"FOR UPDATE SKIP LOCKED"selectForUpdateWait
"FOR UPDATE WAIT timeout"selectForXmlPath
"FOR XML PATH(...)"selectGroupBy
"GROUP BY"selectGroupByGroupingSets
"GROUPING SETS"selectHaving
"HAVING"selectInto
"INTO table(, table)*"selectUnique
"UNIQUE" keywordset
setOperation
setOperationExcept
setOperationIntersect
setOperationMinus
setOperationUnion
show
showColumns
showIndex
showTables
skip
"SKIP variable" | "SKIP ?" | "SKIP rowCount"tableFunction
tableStatement
SQL "TABLE table_name [ORDER BY column_name] [LIMIT number [OFFSET number]]“timeOut
top
"TOP" ? "PERCENT"truncate
SQL "TRUNCATE" statement is allowedunpivot
update
SQL "UPDATE" statement is allowedupdateFrom
"UPDATE table1 SET ...updateJoins
"UPDATE table1, table2 ..."updateLimit
updateOrderBy
updateReturning
"RETURNING expr(, expr)*"updateUseSelect
UPDATE table SET (col, ...) = (SELECT col, ...upsert
SQL "UPSERT" statement is alloweduse
values
valuesList
withItem
"WITH name query"withItemRecursive
-
Field Summary
Fields Modifier and Type Field Description private boolean
configurable
private java.lang.Object
value
-
Constructor Summary
Constructors Modifier Constructor Description private
Feature()
a feature which can't configured within the parserprivate
Feature(java.lang.Object value)
a feature which can be configured byFeatureConfiguration
-
Method Summary
All Methods Static Methods Instance Methods Concrete Methods Modifier and Type Method Description java.lang.Object
getDefaultValue()
boolean
isConfigurable()
static Feature
valueOf(java.lang.String name)
Returns the enum constant of this type with the specified name.static Feature[]
values()
Returns an array containing the constants of this enum type, in the order they are declared.
-
-
-
Enum Constant Detail
-
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)*"
-
limitNull
public static final Feature limitNull
"LIMIT NULL"- See Also:
Limit.isLimitNull()
-
limitAll
public static final Feature limitAll
"LIMIT ALL"- See Also:
Limit.isLimitAll()
-
limitOffset
public static final Feature limitOffset
"LIMIT offset, limit"- See Also:
Limit.getOffset()
-
offsetParam
public static final Feature offsetParam
"OFFSET offset param" where param is ROW | ROWS- See Also:
Offset.getOffsetParam()
-
fetchFirst
public static final Feature fetchFirst
"FETCH FIRST row_count (ROW | ROWS) ONLY"- See Also:
Fetch.isFetchParamFirst()
-
fetchNext
public static final Feature fetchNext
"FETCH NEXT row_count (ROW | ROWS) ONLY" if notfetchFirst
- See Also:
Fetch.isFetchParamFirst()
-
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
-
first
public static final Feature first
"FIRST" \?|[0-9]+|variable or "LIMIT" \?|[0-9]+|variable- See Also:
First
-
optimizeFor
public static final Feature optimizeFor
"OPTIMIZE FOR rowCount ROWS"- See Also:
OptimizeFor
-
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:
ExpressionList
-
insertValues
public static final Feature insertValues
"VALUES"
-
tableStatement
public static final Feature tableStatement
SQL "TABLE table_name [ORDER BY column_name] [LIMIT number [OFFSET number]]“
-
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:
SelectItem
-
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:
SelectItem
-
upsert
public static final Feature upsert
SQL "UPSERT" statement is allowed- See Also:
Upsert
, https://wiki.postgresql.org/wiki/UPSERT
-
alterSequence
public static final Feature alterSequence
SQL "ALTER SEQUENCE" statement is allowed- See Also:
AlterSequence
-
alterView
public static final Feature alterView
SQL "ALTER VIEW" statement is allowed- See Also:
AlterView
-
refreshMaterializedView
public static final Feature refreshMaterializedView
SQL "REFRESH MATERIALIZED VIEW" statement is allowed- See Also:
RefreshMaterializedViewStatement
-
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:
AlterView
-
alterIndex
public static final Feature alterIndex
SQL "ALTER INDEX" statement is allowed
-
truncate
public static final Feature truncate
SQL "TRUNCATE" statement is allowed- See Also:
Truncate
-
execute
public static final Feature execute
SQL "CALL|EXEC|EXECUTE" stored procedure is allowed- See Also:
Execute
-
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
-
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:
CreateSchema
-
createView
public static final Feature createView
SQL "CREATE VIEW" statement is allowed- See Also:
CreateView
-
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:
CreateTable
-
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:
CreateIndex
-
createSequence
public static final Feature createSequence
SQL "CREATE SEQUENCE" statement is allowed- See Also:
CreateSequence
-
createSynonym
public static final Feature createSynonym
SQL "CREATE SYNONYM" statement is allowed- See Also:
CreateSynonym
-
createTrigger
public static final Feature createTrigger
SQL "CREATE TRIGGER" statement is allowed
-
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:
DescribeStatement
-
desc
public static final Feature desc
SQL "DESC" statement is allowed- See Also:
DescribeStatement
-
explain
public static final Feature explain
SQL "EXPLAIN" statement is allowed- See Also:
ExplainStatement
-
show
public static final Feature show
- See Also:
ShowStatement
-
showTables
public static final Feature showTables
- See Also:
ShowTablesStatement
-
showColumns
public static final Feature showColumns
- See Also:
ShowColumnsStatement
-
showIndex
public static final Feature showIndex
- See Also:
ShowIndexStatement
-
use
public static final Feature use
- See Also:
UseStatement
-
createFunction
public static final Feature createFunction
- See Also:
CreateFunction
-
createProcedure
public static final Feature createProcedure
- See Also:
CreateProcedure
-
functionalStatement
public static final Feature functionalStatement
- See Also:
CreateFunctionalStatement
-
block
public static final Feature block
SQL block starting with "BEGIN" and ends with "END" statement is allowed- See Also:
Block
-
declare
public static final Feature declare
- See Also:
DeclareStatement
-
set
public static final Feature set
- See Also:
SetStatement
-
reset
public static final Feature reset
- See Also:
ResetStatement
-
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
-
tableFunction
public static final Feature tableFunction
- See Also:
TableFunction
-
jdbcParameter
public static final Feature jdbcParameter
- See Also:
JdbcParameter
-
jdbcNamedParameter
public static final Feature jdbcNamedParameter
- See Also:
JdbcNamedParameter
-
exprLike
public static final Feature exprLike
"LIKE"
-
exprSimilarTo
public static final Feature exprSimilarTo
"SIMILAR TO"
-
kSqlWindow
public static final Feature kSqlWindow
- See Also:
KSQLWindow
-
oracleOldJoinSyntax
public static final Feature oracleOldJoinSyntax
allows old oracle join syntax (+)- See Also:
SupportsOldOracleJoinSyntax
-
oraclePriorPosition
public static final Feature oraclePriorPosition
allows oracle prior position- See Also:
SupportsOldOracleJoinSyntax
-
oracleHint
public static final Feature oracleHint
- See Also:
OracleHint
-
oracleHierarchicalExpression
public static final Feature oracleHierarchicalExpression
oracle SQL "CONNECT BY"- See Also:
OracleHierarchicalExpression
-
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
-
-
Constructor Detail
-
Feature
private Feature()
a feature which can't configured within the parser
-
Feature
private Feature(java.lang.Object value)
a feature which can be configured byFeatureConfiguration
- Parameters:
value
- The Value Object of the Parameter.
-
-
Method Detail
-
values
public static Feature[] values()
Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows:for (Feature c : Feature.values()) System.out.println(c);
- Returns:
- an array containing the constants of this enum type, in the order they are declared
-
valueOf
public static Feature valueOf(java.lang.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:
java.lang.IllegalArgumentException
- if this enum type has no constant with the specified namejava.lang.NullPointerException
- if the argument is null
-
getDefaultValue
public java.lang.Object getDefaultValue()
-
isConfigurable
public boolean isConfigurable()
-
-