Package net.sf.jsqlparser.parser.feature
Enum Feature
- All Implemented Interfaces:
Serializable
,Comparable<Feature>
-
Enum Constant Summary
Enum ConstantsEnum ConstantDescriptionallows Backslash '\' as Escape Characterallows complex expression parameters or named parameters for functions will be switched off, when deep nesting of functions is detectedallow parsing of RDBMS specific syntax by switching off SQL Standard Compliant Syntaxallows square brackets for names, disabled by defaultallows passing through Unsupported Statements as a plain List of Tokens needs to be switched off, when VALIDATING statements or parsing blocksSQL "ALTER INDEX" statement is allowedSQL "ALTER SEQUENCE" statement is allowedSQL "ALTER" statement is allowedSQL "ALTER VIEW" statement is allowedSQL "REPLACE VIEW" statement is allowedSQL "ANALYZE" statement is allowedSQL block starting with "BEGIN" and ends with "END" statement is allowedSQL "COMMENT ON" statement is allowed"COMMENT ON column""COMMENT ON table""COMMENT ON view"SQL "COMMIT" statement is allowedSQL "CREATE INDEX" statement is allowed"CREATE OR REPLACE VIEW"SQL "CREATE SCHEMA" statement is allowedSQL "CREATE SEQUENCE" statement is allowedSQL "CREATE SYNONYM" statement is allowedSQL "CREATE TABLE" statement is allowedi.e."CREATE TABLE (colspec) SELECT ..."CREATE TABLE IF NOT EXISTS table"" ROW MOVEMENT"i.e."CREATE GLOBAL UNLOGGED"SQL "CREATE TRIGGER" statement is allowedSQL "CREATE VIEW" statement is allowed"CREATE FORCE VIEW"SQL "CREATE MATERIALIZED VIEW" statement is allowed"CREATE TEMPORARAY VIEW"SQL "CREATE VIEW(x comment 'x', y comment 'y') comment 'view'" statement is allowedSQL "DELETE" statement is allowed"DELETE FROM table1, table1 ...""LIMIT row_count""ORDER BY ...""RETURNING expr(, expr)*""DELETE table1, table1 FROM table ..."SQL "DESC" statement is allowedSQL "DESCRIBE" statement is allowed"DISTINCT" keyword"DISTINCT ON (col1, ...)"SQL "DROP" statement is allowedSQL "CALL|EXEC|EXECUTE" stored procedure is allowedSQL "EXECUTE" statement is allowedSQL "EXECUTE IMMEDIATE" statement is allowedSQL "EXPLAIN" statement is allowed"LIKE""SIMILAR TO""FETCH FIRST row_count (ROW | ROWS) ONLY""FETCH NEXT row_count (ROW | ROWS) ONLY" if notfetchFirst
"FIRST" \?|[0-9]+|variable or "LIMIT" \?|[0-9]+|variableSQL "INSERT" statement is allowed"INSERT .."IGNORE""LOW_PRIORITY | DELAYED | HIGH_PRIORITY | IGNORE""RETURNING *""RETURNING expr(, expr)*""ON DUPLICATE KEY UPDATE""INSERT .."VALUES""JOIN""APPLY" join"CROSS" join"FULL" join"INNER" join"LEFT" join"NATURAL" join"OUTER" joinjoin tables by ", OUTER" placing the join specification in WHERE-clause"RIGHT" join"SEMI" joinjoin tables by "," placing the join specification in WHERE-clause"STRAIGHT_JOIN" join"LIMIT ALL""LIMIT NULL""LIMIT offset, limit"SQL "MERGE" statement is allowed"OFFSET offset""OFFSET offset param" where param is ROW | ROWS"OPTIMIZE FOR rowCount ROWS"oracle SQL "CONNECT BY"allows old oracle join syntax (+)allows oracle prior position"ORDER BY""ORDER BY expression [ NULLS { FIRST | LAST } ]"SQL "REFRESH MATERIALIZED VIEW" statement is allowedDeprecated."SELECT""FOR KEY SHARE""NO KEY UPDATE""FOR SHARE""FOR UPDATE""FOR UPDATE NOWAIT""FOR UPDATE OF table""FOR UPDATE SKIP LOCKED""FOR UPDATE WAIT timeout""FOR XML PATH(...)""GROUP BY""GROUPING SETS""HAVING""INTO table(, table)*""UNIQUE" keyword"SKIP variable" | "SKIP ?" | "SKIP rowCount"SQL "TABLE table_name [ORDER BY column_name] [LIMIT number [OFFSET number]]“"TOP" ? "PERCENT"SQL "TRUNCATE" statement is allowedSQL "UPDATE" statement is allowed"UPDATE table1 SET ..."UPDATE table1, table2 ...""RETURNING expr(, expr)*"UPDATE table SET (col, ...) = (SELECT col, ...SQL "UPSERT" statement is allowed"WITH name query" -
Field Summary
Fields -
Constructor Summary
ConstructorsModifierConstructorDescriptionprivate
Feature()
a feature which can't configured within the parserprivate
a feature which can be configured byFeatureConfiguration
-
Method Summary
-
Enum Constant Details
-
select
"SELECT" -
selectGroupBy
"GROUP BY" -
selectGroupByGroupingSets
"GROUPING SETS" -
selectHaving
"HAVING" -
selectInto
"INTO table(, table)*" -
limit
- See Also:
-
limitNull
"LIMIT NULL"- See Also:
-
limitAll
"LIMIT ALL"- See Also:
-
limitOffset
"LIMIT offset, limit"- See Also:
-
offset
"OFFSET offset"- See Also:
-
offsetParam
"OFFSET offset param" where param is ROW | ROWS- See Also:
-
fetch
- See Also:
-
fetchFirst
"FETCH FIRST row_count (ROW | ROWS) ONLY"- See Also:
-
fetchNext
"FETCH NEXT row_count (ROW | ROWS) ONLY" if notfetchFirst
- See Also:
-
join
"JOIN" -
joinOuterSimple
join tables by ", OUTER" placing the join specification in WHERE-clause -
joinSimple
join tables by "," placing the join specification in WHERE-clause -
joinRight
"RIGHT" join -
joinNatural
"NATURAL" join -
joinFull
"FULL" join -
joinLeft
"LEFT" join -
joinCross
"CROSS" join -
joinOuter
"OUTER" join -
joinSemi
"SEMI" join -
joinInner
"INNER" join -
joinStraight
"STRAIGHT_JOIN" join -
joinApply
"APPLY" join -
joinWindow
-
joinUsingColumns
-
skip
"SKIP variable" | "SKIP ?" | "SKIP rowCount"- See Also:
-
first
"FIRST" \?|[0-9]+|variable or "LIMIT" \?|[0-9]+|variable- See Also:
-
top
"TOP" ? "PERCENT"- See Also:
-
optimizeFor
"OPTIMIZE FOR rowCount ROWS"- See Also:
-
selectUnique
"UNIQUE" keyword -
distinct
"DISTINCT" keyword -
distinctOn
"DISTINCT ON (col1, ...)" -
orderBy
"ORDER BY" -
orderByNullOrdering
"ORDER BY expression [ NULLS { FIRST | LAST } ]" -
selectForUpdate
"FOR UPDATE" -
selectForNoKeyUpdate
"NO KEY UPDATE" -
selectForUpdateOfTable
"FOR UPDATE OF table" -
selectForUpdateWait
"FOR UPDATE WAIT timeout" -
selectForUpdateNoWait
"FOR UPDATE NOWAIT" -
selectForUpdateSkipLocked
"FOR UPDATE SKIP LOCKED" -
insert
SQL "INSERT" statement is allowed -
insertFromSelect
"INSERT .. SELECT" -
insertModifierPriority
"LOW_PRIORITY | DELAYED | HIGH_PRIORITY | IGNORE" -
insertModifierIgnore
"IGNORE" -
insertUseSet
"INSERT .. SET" -
insertUseDuplicateKeyUpdate
"ON DUPLICATE KEY UPDATE" -
insertReturningAll
"RETURNING *" -
insertReturningExpressionList
"RETURNING expr(, expr)*"- See Also:
-
insertValues
"VALUES" -
values
- See Also:
-
tableStatement
SQL "TABLE table_name [ORDER BY column_name] [LIMIT number [OFFSET number]]“ -
update
SQL "UPDATE" statement is allowed- See Also:
-
updateFrom
"UPDATE table1 SET ... FROM table2 -
updateJoins
"UPDATE table1, table2 ..." -
updateUseSelect
UPDATE table SET (col, ...) = (SELECT col, ... )" -
updateOrderBy
-
updateLimit
-
updateReturning
"RETURNING expr(, expr)*"- See Also:
-
delete
SQL "DELETE" statement is allowed- See Also:
-
deleteJoin
"DELETE FROM table1, table1 ..." -
deleteTables
"DELETE table1, table1 FROM table ..." -
deleteLimit
"LIMIT row_count" -
deleteOrderBy
"ORDER BY ..." -
deleteReturningExpressionList
"RETURNING expr(, expr)*"- See Also:
-
upsert
SQL "UPSERT" statement is allowed- See Also:
-
merge
SQL "MERGE" statement is allowed- See Also:
-
alterTable
SQL "ALTER" statement is allowed- See Also:
-
alterSequence
SQL "ALTER SEQUENCE" statement is allowed- See Also:
-
alterView
SQL "ALTER VIEW" statement is allowed- See Also:
-
refreshMaterializedView
SQL "REFRESH MATERIALIZED VIEW" statement is allowed- See Also:
-
refreshMaterializedWithDataView
-
refreshMaterializedWithNoDataView
-
alterViewReplace
SQL "REPLACE VIEW" statement is allowed- See Also:
-
alterIndex
SQL "ALTER INDEX" statement is allowed -
analyze
SQL "ANALYZE" statement is allowed- See Also:
-
truncate
SQL "TRUNCATE" statement is allowed- See Also:
-
execute
SQL "CALL|EXEC|EXECUTE" stored procedure is allowed- See Also:
-
executeExec
-
executeCall
-
executeExecute
-
executeStatement
SQL "EXECUTE" statement is allowed -
executeStatementImmediate
SQL "EXECUTE IMMEDIATE" statement is allowed -
executeUsing
-
replace
Deprecated.SQL "REPLACE" statement is allowed -
drop
SQL "DROP" statement is allowed- See Also:
-
dropTable
-
dropIndex
-
dropView
-
dropSchema
-
dropSequence
-
dropTableIfExists
-
dropIndexIfExists
-
dropViewIfExists
-
dropSchemaIfExists
-
dropSequenceIfExists
-
createSchema
SQL "CREATE SCHEMA" statement is allowed- See Also:
-
createView
SQL "CREATE VIEW" statement is allowed- See Also:
-
createViewForce
"CREATE FORCE VIEW" -
createViewTemporary
"CREATE TEMPORARAY VIEW" -
createOrReplaceView
"CREATE OR REPLACE VIEW" -
createViewMaterialized
SQL "CREATE MATERIALIZED VIEW" statement is allowed -
createViewWithComment
SQL "CREATE VIEW(x comment 'x', y comment 'y') comment 'view'" statement is allowed -
createTable
SQL "CREATE TABLE" statement is allowed- See Also:
-
createTableUnlogged
"CREATE GLOBAL UNLOGGED" -
createTableCreateOptionStrings
i.e. "CREATE GLOBAL TEMPORARY TABLE", "CREATE SHARDED TABLE" -
createTableTableOptionStrings
i.e. "ENGINE = InnoDB AUTO_INCREMENT = 8761 DEFAULT CHARSET = utf8" -
createTableIfNotExists
"CREATE TABLE IF NOT EXISTS table" -
createTableRowMovement
" ROW MOVEMENT" -
createTableFromSelect
"CREATE TABLE (colspec) SELECT ... -
createIndex
SQL "CREATE INDEX" statement is allowed- See Also:
-
createSequence
SQL "CREATE SEQUENCE" statement is allowed- See Also:
-
createSynonym
SQL "CREATE SYNONYM" statement is allowed- See Also:
-
createTrigger
SQL "CREATE TRIGGER" statement is allowed -
commit
SQL "COMMIT" statement is allowed- See Also:
-
comment
SQL "COMMENT ON" statement is allowed- See Also:
-
commentOnTable
"COMMENT ON table" -
commentOnColumn
"COMMENT ON column" -
commentOnView
"COMMENT ON view" -
describe
SQL "DESCRIBE" statement is allowed- See Also:
-
desc
SQL "DESC" statement is allowed- See Also:
-
explain
SQL "EXPLAIN" statement is allowed- See Also:
-
show
- See Also:
-
showTables
- See Also:
-
showColumns
- See Also:
-
showIndex
- See Also:
-
use
- See Also:
-
grant
- See Also:
-
function
- See Also:
-
createFunction
- See Also:
-
createProcedure
- See Also:
-
functionalStatement
- See Also:
-
block
SQL block starting with "BEGIN" and ends with "END" statement is allowed- See Also:
-
declare
- See Also:
-
set
- See Also:
-
reset
- See Also:
-
pivot
- See Also:
-
unpivot
- See Also:
-
pivotXml
- See Also:
-
setOperation
-
setOperationUnion
-
setOperationIntersect
-
setOperationExcept
-
setOperationMinus
-
withItem
"WITH name query" -
withItemRecursive
-
lateralSubSelect
-
valuesList
- See Also:
-
tableFunction
- See Also:
-
jdbcParameter
- See Also:
-
jdbcNamedParameter
- See Also:
-
exprLike
"LIKE" -
exprSimilarTo
"SIMILAR TO" -
kSqlWindow
- See Also:
-
oracleOldJoinSyntax
allows old oracle join syntax (+)- See Also:
-
oraclePriorPosition
allows oracle prior position- See Also:
-
oracleHint
- See Also:
-
oracleHierarchicalExpression
oracle SQL "CONNECT BY"- See Also:
-
oracleOrderBySiblings
-
mySqlHintStraightJoin
-
mysqlSqlCacheFlag
-
mysqlCalcFoundRows
-
selectForXmlPath
"FOR XML PATH(...)" -
allowSquareBracketQuotation
allows square brackets for names, disabled by default -
allowPostgresSpecificSyntax
allow parsing of RDBMS specific syntax by switching off SQL Standard Compliant Syntax -
allowComplexParsing
allows complex expression parameters or named parameters for functions will be switched off, when deep nesting of functions is detected -
allowUnsupportedStatements
allows passing through Unsupported Statements as a plain List of Tokens needs to be switched off, when VALIDATING statements or parsing blocks -
timeOut
-
allowBackslashEscapeCharacter
allows Backslash '\' as Escape Character
-
-
Field Details
-
value
-
configurable
private final boolean configurable
-
-
Constructor Details
-
Feature
private Feature()a feature which can't configured within the parser -
Feature
a feature which can be configured byFeatureConfiguration
- Parameters:
value
- The Value Object of the Parameter.
-
-
Method Details
-
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
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 nameNullPointerException
- if the argument is null
-
getDefaultValue
-
isConfigurable
public boolean isConfigurable()
-