You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by li...@apache.org on 2024/09/09 06:27:55 UTC
(shardingsphere) branch master updated: #31892 Refactor: Removed redundant indents from g4 files. (#32779)
This is an automated email from the ASF dual-hosted git repository.
linghengqian pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new 1a0804ed013 #31892 Refactor: Removed redundant indents from g4 files. (#32779)
1a0804ed013 is described below
commit 1a0804ed01306e9fd294148725137e419f59b264
Author: Arshveer439 <ar...@gmail.com>
AuthorDate: Mon Sep 9 03:27:48 2024 -0300
#31892 Refactor: Removed redundant indents from g4 files. (#32779)
---
.../src/main/antlr4/imports/encrypt/BaseRule.g4 | 2 +-
.../src/main/antlr4/imports/encrypt/Literals.g4 | 4 +-
.../src/main/antlr4/imports/mask/BaseRule.g4 | 2 +-
.../src/main/antlr4/imports/mask/Literals.g4 | 4 +-
.../antlr4/imports/readwrite-splitting/BaseRule.g4 | 2 +-
.../antlr4/imports/readwrite-splitting/Keyword.g4 | 2 +-
.../antlr4/imports/readwrite-splitting/Literals.g4 | 2 +-
.../src/main/antlr4/imports/shadow/BaseRule.g4 | 2 +-
.../src/main/antlr4/imports/shadow/Keyword.g4 | 2 +-
.../src/main/antlr4/imports/shadow/Literals.g4 | 2 +-
.../src/main/antlr4/imports/sharding/Keyword.g4 | 2 +-
.../src/main/antlr4/imports/migration/Literals.g4 | 2 +-
.../main/antlr4/imports/migration/RALStatement.g4 | 2 +-
.../src/main/antlr4/imports/clickhouse/BaseRule.g4 | 4 +-
.../antlr4/imports/clickhouse/ClickHouseKeyword.g4 | 6 +-
.../main/antlr4/imports/clickhouse/DMLStatement.g4 | 2 +-
.../src/main/antlr4/imports/clickhouse/Keyword.g4 | 2 +-
.../src/main/antlr4/imports/doris/BaseRule.g4 | 318 ++++++++++-----------
.../src/main/antlr4/imports/doris/DALStatement.g4 | 8 +-
.../src/main/antlr4/imports/doris/DDLStatement.g4 | 60 ++--
.../src/main/antlr4/imports/doris/DMLStatement.g4 | 2 +-
.../doris/src/main/antlr4/imports/doris/Keyword.g4 | 2 +-
.../hive/src/main/antlr4/imports/hive/BaseRule.g4 | 308 ++++++++++----------
.../src/main/antlr4/imports/hive/DMLStatement.g4 | 2 +-
.../hive/src/main/antlr4/imports/hive/Keyword.g4 | 2 +-
.../src/main/antlr4/imports/mysql/BaseRule.g4 | 314 ++++++++++----------
.../src/main/antlr4/imports/mysql/DALStatement.g4 | 8 +-
.../src/main/antlr4/imports/mysql/DDLStatement.g4 | 60 ++--
.../src/main/antlr4/imports/mysql/DMLStatement.g4 | 2 +-
.../mysql/src/main/antlr4/imports/mysql/Keyword.g4 | 2 +-
.../src/main/antlr4/imports/opengauss/BaseRule.g4 | 10 +-
.../main/antlr4/imports/opengauss/DALStatement.g4 | 2 +-
.../main/antlr4/imports/opengauss/DDLStatement.g4 | 18 +-
.../main/antlr4/imports/opengauss/DMLStatement.g4 | 2 +-
.../src/main/antlr4/imports/opengauss/Keyword.g4 | 2 +-
.../src/main/antlr4/imports/opengauss/Literals.g4 | 2 +-
.../antlr4/imports/opengauss/OpenGaussKeyword.g4 | 2 +-
.../src/main/antlr4/imports/oracle/BaseRule.g4 | 8 +-
.../src/main/antlr4/imports/oracle/DCLStatement.g4 | 2 +-
.../src/main/antlr4/imports/oracle/DDLStatement.g4 | 10 +-
.../src/main/antlr4/imports/oracle/Keyword.g4 | 50 ++--
.../main/antlr4/imports/oracle/OracleKeyword.g4 | 2 +-
.../oracle/src/main/antlr4/imports/oracle/PLSQL.g4 | 2 +-
.../src/main/antlr4/imports/postgresql/BaseRule.g4 | 4 +-
.../main/antlr4/imports/postgresql/DALStatement.g4 | 2 +-
.../main/antlr4/imports/postgresql/DDLStatement.g4 | 12 +-
.../main/antlr4/imports/postgresql/DMLStatement.g4 | 2 +-
.../src/main/antlr4/imports/postgresql/Literals.g4 | 6 +-
.../main/antlr4/imports/postgresql/ModeLexer.g4 | 4 +-
.../antlr4/imports/postgresql/PostgreSQLKeyword.g4 | 4 +-
.../src/main/antlr4/imports/presto/BaseRule.g4 | 318 ++++++++++-----------
.../src/main/antlr4/imports/presto/DALStatement.g4 | 2 +-
.../src/main/antlr4/imports/presto/DMLStatement.g4 | 2 +-
.../src/main/antlr4/imports/presto/Keyword.g4 | 2 +-
.../src/main/antlr4/imports/sql92/BaseRule.g4 | 4 +-
.../src/main/antlr4/imports/sql92/DMLStatement.g4 | 2 +-
.../sql92/src/main/antlr4/imports/sql92/Keyword.g4 | 2 +-
57 files changed, 805 insertions(+), 805 deletions(-)
diff --git a/features/encrypt/distsql/parser/src/main/antlr4/imports/encrypt/BaseRule.g4 b/features/encrypt/distsql/parser/src/main/antlr4/imports/encrypt/BaseRule.g4
index 6cb605cd6b5..258645d1eea 100644
--- a/features/encrypt/distsql/parser/src/main/antlr4/imports/encrypt/BaseRule.g4
+++ b/features/encrypt/distsql/parser/src/main/antlr4/imports/encrypt/BaseRule.g4
@@ -14,7 +14,7 @@
* See the License for the specific language governing permissions and
* limitations under the License.
*/
-
+
grammar BaseRule;
import Symbol, Keyword, Literals;
diff --git a/features/encrypt/distsql/parser/src/main/antlr4/imports/encrypt/Literals.g4 b/features/encrypt/distsql/parser/src/main/antlr4/imports/encrypt/Literals.g4
index c6557635906..99e48866856 100644
--- a/features/encrypt/distsql/parser/src/main/antlr4/imports/encrypt/Literals.g4
+++ b/features/encrypt/distsql/parser/src/main/antlr4/imports/encrypt/Literals.g4
@@ -23,7 +23,7 @@ IDENTIFIER_
: [A-Za-z_$0-9]*?[A-Za-z_$]+?[A-Za-z_$0-9]*
| BQ_ ~'`'+ BQ_
;
-
+
STRING_
: (DQ_ ('\\'. | '""' | ~('"' | '\\'))* DQ_)
| (SQ_ ('\\'. | '\'\'' | ~('\'' | '\\'))* SQ_)
@@ -44,7 +44,7 @@ NUMBER_
HEXDIGIT_
: '0x' HEX_+ | 'X' SQ_ HEX_+ SQ_
;
-
+
BITNUM_
: '0b' ('0' | '1')+ | B SQ_ ('0' | '1')+ SQ_
;
diff --git a/features/mask/distsql/parser/src/main/antlr4/imports/mask/BaseRule.g4 b/features/mask/distsql/parser/src/main/antlr4/imports/mask/BaseRule.g4
index 0fa88395181..5143bf4e257 100644
--- a/features/mask/distsql/parser/src/main/antlr4/imports/mask/BaseRule.g4
+++ b/features/mask/distsql/parser/src/main/antlr4/imports/mask/BaseRule.g4
@@ -14,7 +14,7 @@
* See the License for the specific language governing permissions and
* limitations under the License.
*/
-
+
grammar BaseRule;
import Symbol, Keyword, Literals;
diff --git a/features/mask/distsql/parser/src/main/antlr4/imports/mask/Literals.g4 b/features/mask/distsql/parser/src/main/antlr4/imports/mask/Literals.g4
index c6557635906..99e48866856 100644
--- a/features/mask/distsql/parser/src/main/antlr4/imports/mask/Literals.g4
+++ b/features/mask/distsql/parser/src/main/antlr4/imports/mask/Literals.g4
@@ -23,7 +23,7 @@ IDENTIFIER_
: [A-Za-z_$0-9]*?[A-Za-z_$]+?[A-Za-z_$0-9]*
| BQ_ ~'`'+ BQ_
;
-
+
STRING_
: (DQ_ ('\\'. | '""' | ~('"' | '\\'))* DQ_)
| (SQ_ ('\\'. | '\'\'' | ~('\'' | '\\'))* SQ_)
@@ -44,7 +44,7 @@ NUMBER_
HEXDIGIT_
: '0x' HEX_+ | 'X' SQ_ HEX_+ SQ_
;
-
+
BITNUM_
: '0b' ('0' | '1')+ | B SQ_ ('0' | '1')+ SQ_
;
diff --git a/features/readwrite-splitting/distsql/parser/src/main/antlr4/imports/readwrite-splitting/BaseRule.g4 b/features/readwrite-splitting/distsql/parser/src/main/antlr4/imports/readwrite-splitting/BaseRule.g4
index 0551a45949f..9a05c6a487f 100644
--- a/features/readwrite-splitting/distsql/parser/src/main/antlr4/imports/readwrite-splitting/BaseRule.g4
+++ b/features/readwrite-splitting/distsql/parser/src/main/antlr4/imports/readwrite-splitting/BaseRule.g4
@@ -14,7 +14,7 @@
* See the License for the specific language governing permissions and
* limitations under the License.
*/
-
+
grammar BaseRule;
import Symbol, Keyword, Literals;
diff --git a/features/readwrite-splitting/distsql/parser/src/main/antlr4/imports/readwrite-splitting/Keyword.g4 b/features/readwrite-splitting/distsql/parser/src/main/antlr4/imports/readwrite-splitting/Keyword.g4
index 3965f963225..d3b71d7c5cd 100644
--- a/features/readwrite-splitting/distsql/parser/src/main/antlr4/imports/readwrite-splitting/Keyword.g4
+++ b/features/readwrite-splitting/distsql/parser/src/main/antlr4/imports/readwrite-splitting/Keyword.g4
@@ -110,7 +110,7 @@ READ
IF
: I F
;
-
+
EXISTS
: E X I S T S
;
diff --git a/features/readwrite-splitting/distsql/parser/src/main/antlr4/imports/readwrite-splitting/Literals.g4 b/features/readwrite-splitting/distsql/parser/src/main/antlr4/imports/readwrite-splitting/Literals.g4
index 1d13bcc2332..99e48866856 100644
--- a/features/readwrite-splitting/distsql/parser/src/main/antlr4/imports/readwrite-splitting/Literals.g4
+++ b/features/readwrite-splitting/distsql/parser/src/main/antlr4/imports/readwrite-splitting/Literals.g4
@@ -44,7 +44,7 @@ NUMBER_
HEXDIGIT_
: '0x' HEX_+ | 'X' SQ_ HEX_+ SQ_
;
-
+
BITNUM_
: '0b' ('0' | '1')+ | B SQ_ ('0' | '1')+ SQ_
;
diff --git a/features/shadow/distsql/parser/src/main/antlr4/imports/shadow/BaseRule.g4 b/features/shadow/distsql/parser/src/main/antlr4/imports/shadow/BaseRule.g4
index 2369297a291..ff953d01e87 100644
--- a/features/shadow/distsql/parser/src/main/antlr4/imports/shadow/BaseRule.g4
+++ b/features/shadow/distsql/parser/src/main/antlr4/imports/shadow/BaseRule.g4
@@ -14,7 +14,7 @@
* See the License for the specific language governing permissions and
* limitations under the License.
*/
-
+
grammar BaseRule;
import Symbol, Keyword, Literals;
diff --git a/features/shadow/distsql/parser/src/main/antlr4/imports/shadow/Keyword.g4 b/features/shadow/distsql/parser/src/main/antlr4/imports/shadow/Keyword.g4
index ec29d379420..2e706d0e631 100644
--- a/features/shadow/distsql/parser/src/main/antlr4/imports/shadow/Keyword.g4
+++ b/features/shadow/distsql/parser/src/main/antlr4/imports/shadow/Keyword.g4
@@ -126,7 +126,7 @@ DEFAULT
IF
: I F
;
-
+
EXISTS
: E X I S T S
;
diff --git a/features/shadow/distsql/parser/src/main/antlr4/imports/shadow/Literals.g4 b/features/shadow/distsql/parser/src/main/antlr4/imports/shadow/Literals.g4
index 3634476f3d4..cc8d76b3fcb 100644
--- a/features/shadow/distsql/parser/src/main/antlr4/imports/shadow/Literals.g4
+++ b/features/shadow/distsql/parser/src/main/antlr4/imports/shadow/Literals.g4
@@ -44,7 +44,7 @@ NUMBER_
HEXDIGIT_
: '0x' HEX_+ | 'X' SQ_ HEX_+ SQ_
;
-
+
BITNUM_
: '0b' ('0' | '1')+ | B SQ_ ('0' | '1')+ SQ_
;
diff --git a/features/sharding/distsql/parser/src/main/antlr4/imports/sharding/Keyword.g4 b/features/sharding/distsql/parser/src/main/antlr4/imports/sharding/Keyword.g4
index 995708bc4ff..ff549bdf4b9 100644
--- a/features/sharding/distsql/parser/src/main/antlr4/imports/sharding/Keyword.g4
+++ b/features/sharding/distsql/parser/src/main/antlr4/imports/sharding/Keyword.g4
@@ -178,7 +178,7 @@ IF
EXISTS
: E X I S T S
;
-
+
WITH
: W I T H
;
diff --git a/kernel/data-pipeline/distsql/parser/src/main/antlr4/imports/migration/Literals.g4 b/kernel/data-pipeline/distsql/parser/src/main/antlr4/imports/migration/Literals.g4
index 874c0917bcd..68f6a1b07ed 100644
--- a/kernel/data-pipeline/distsql/parser/src/main/antlr4/imports/migration/Literals.g4
+++ b/kernel/data-pipeline/distsql/parser/src/main/antlr4/imports/migration/Literals.g4
@@ -23,7 +23,7 @@ IDENTIFIER_
: [A-Za-z_$0-9]*?[A-Za-z_$]+?[A-Za-z_$0-9]*
| BQ_ ~'`'+ BQ_
;
-
+
STRING_
: (DQ_ ('\\'. | '""' | ~('"' | '\\'))* DQ_)
| (SQ_ ('\\'. | '\'\'' | ~('\'' | '\\'))* SQ_)
diff --git a/kernel/data-pipeline/distsql/parser/src/main/antlr4/imports/migration/RALStatement.g4 b/kernel/data-pipeline/distsql/parser/src/main/antlr4/imports/migration/RALStatement.g4
index 9f4b3a653fe..b85acef07b5 100644
--- a/kernel/data-pipeline/distsql/parser/src/main/antlr4/imports/migration/RALStatement.g4
+++ b/kernel/data-pipeline/distsql/parser/src/main/antlr4/imports/migration/RALStatement.g4
@@ -182,7 +182,7 @@ password
registerMigrationSourceStorageUnit
: REGISTER MIGRATION SOURCE STORAGE UNIT storageUnitDefinition (COMMA_ storageUnitDefinition)*
;
-
+
unregisterMigrationSourceStorageUnit
: UNREGISTER MIGRATION SOURCE STORAGE UNIT storageUnitName (COMMA_ storageUnitName)*
;
diff --git a/parser/sql/dialect/clickhouse/src/main/antlr4/imports/clickhouse/BaseRule.g4 b/parser/sql/dialect/clickhouse/src/main/antlr4/imports/clickhouse/BaseRule.g4
index cde75abda18..c7ae98d9f88 100644
--- a/parser/sql/dialect/clickhouse/src/main/antlr4/imports/clickhouse/BaseRule.g4
+++ b/parser/sql/dialect/clickhouse/src/main/antlr4/imports/clickhouse/BaseRule.g4
@@ -53,7 +53,7 @@ hexadecimalLiterals
bitValueLiterals
: characterSetName? BIT_NUM_ collateClause?
;
-
+
booleanLiterals
: TRUE | FALSE
;
@@ -153,7 +153,7 @@ expr
andOperator
: AND | AND_
;
-
+
orOperator
: OR
;
diff --git a/parser/sql/dialect/clickhouse/src/main/antlr4/imports/clickhouse/ClickHouseKeyword.g4 b/parser/sql/dialect/clickhouse/src/main/antlr4/imports/clickhouse/ClickHouseKeyword.g4
index ded5b339269..447c67cc22c 100644
--- a/parser/sql/dialect/clickhouse/src/main/antlr4/imports/clickhouse/ClickHouseKeyword.g4
+++ b/parser/sql/dialect/clickhouse/src/main/antlr4/imports/clickhouse/ClickHouseKeyword.g4
@@ -226,7 +226,7 @@ ELSE
END
: E N D
;
-
+
ENGINE
: E N G I N E
;
@@ -262,7 +262,7 @@ FINAL
FIRST
: F I R S T
;
-
+
FLUSH
: F L U S H
;
@@ -480,7 +480,7 @@ NOT
NULL_SQL
: N U L L
;
-
+
NULLS
: N U L L S
;
diff --git a/parser/sql/dialect/clickhouse/src/main/antlr4/imports/clickhouse/DMLStatement.g4 b/parser/sql/dialect/clickhouse/src/main/antlr4/imports/clickhouse/DMLStatement.g4
index 4551d6ae1c2..48500a57f70 100644
--- a/parser/sql/dialect/clickhouse/src/main/antlr4/imports/clickhouse/DMLStatement.g4
+++ b/parser/sql/dialect/clickhouse/src/main/antlr4/imports/clickhouse/DMLStatement.g4
@@ -153,7 +153,7 @@ limitClause
limitRowCount
: numberLiterals | parameterMarker
;
-
+
limitOffset
: numberLiterals | parameterMarker
;
diff --git a/parser/sql/dialect/clickhouse/src/main/antlr4/imports/clickhouse/Keyword.g4 b/parser/sql/dialect/clickhouse/src/main/antlr4/imports/clickhouse/Keyword.g4
index 9cd7b9035cf..68694fc391e 100644
--- a/parser/sql/dialect/clickhouse/src/main/antlr4/imports/clickhouse/Keyword.g4
+++ b/parser/sql/dialect/clickhouse/src/main/antlr4/imports/clickhouse/Keyword.g4
@@ -430,7 +430,7 @@ MAX
MIN
: M I N
;
-
+
SUM
: S U M
;
diff --git a/parser/sql/dialect/doris/src/main/antlr4/imports/doris/BaseRule.g4 b/parser/sql/dialect/doris/src/main/antlr4/imports/doris/BaseRule.g4
index 1e397a5dd52..daa6fa0ff4b 100644
--- a/parser/sql/dialect/doris/src/main/antlr4/imports/doris/BaseRule.g4
+++ b/parser/sql/dialect/doris/src/main/antlr4/imports/doris/BaseRule.g4
@@ -22,7 +22,7 @@ import Comments, Symbol, Keyword, DorisKeyword, Literals;
parameterMarker
: QUESTION_
;
-
+
customKeyword
: MAX
| MIN
@@ -67,7 +67,7 @@ customKeyword
| UTC_TIMESTAMP
| UTC_TIMESTAMP
;
-
+
literals
: stringLiterals
| numberLiterals
@@ -77,43 +77,43 @@ literals
| booleanLiterals
| nullValueLiterals
;
-
+
string_
: DOUBLE_QUOTED_TEXT | SINGLE_QUOTED_TEXT
;
-
+
stringLiterals
: (UNDERSCORE_CHARSET | UL_BINARY )? string_ | NCHAR_TEXT
;
-
+
numberLiterals
: (PLUS_ | MINUS_)? NUMBER_
;
-
+
temporalLiterals
: (DATE | TIME | TIMESTAMP) textString
;
-
+
hexadecimalLiterals
: UNDERSCORE_CHARSET? UL_BINARY? HEX_DIGIT_ collateClause?
;
-
+
bitValueLiterals
: UNDERSCORE_CHARSET? BIT_NUM_ collateClause?
;
-
+
booleanLiterals
: TRUE | FALSE
;
-
+
nullValueLiterals
: NULL
;
-
+
collationName
: textOrIdentifier | BINARY
;
-
+
identifier
: IDENTIFIER_
| identifierKeywordsUnambiguous
@@ -126,7 +126,7 @@ identifier
| UNDERSCORE_CHARSET
| BQUOTA_STRING
;
-
+
identifierKeywordsUnambiguous
: ACTION
| ACCOUNT
@@ -525,13 +525,13 @@ identifierKeywordsUnambiguous
| CONDITION
| DESCRIBE
;
-
+
identifierKeywordsAmbiguous1RolesAndLabels
: EXECUTE
| RESTART
| SHUTDOWN
;
-
+
identifierKeywordsAmbiguous2Labels
: ASCII
| BEGIN
@@ -569,7 +569,7 @@ identifierKeywordsAmbiguous2Labels
| UNINSTALL
| XA
;
-
+
identifierKeywordsAmbiguous3Roles
: EVENT
| FILE
@@ -581,7 +581,7 @@ identifierKeywordsAmbiguous3Roles
| RESOURCE
| SUPER
;
-
+
identifierKeywordsAmbiguous4SystemVariables
: GLOBAL
| LOCAL
@@ -601,84 +601,84 @@ ipAddress
variable
: userVariable | systemVariable
;
-
+
userVariable
: AT_ textOrIdentifier
| textOrIdentifier
;
-
+
systemVariable
: AT_ AT_ (systemVariableScope=(GLOBAL | SESSION | LOCAL) DOT_)? rvalueSystemVariable
;
-
+
rvalueSystemVariable
: textOrIdentifier
| textOrIdentifier DOT_ identifier
;
-
+
setSystemVariable
: AT_ AT_ (optionType DOT_)? internalVariableName
;
-
+
optionType
: GLOBAL | PERSIST | PERSIST_ONLY | SESSION | LOCAL
;
-
+
internalVariableName
: identifier
| DEFAULT DOT_ identifier
| identifier DOT_ identifier
;
-
+
setExprOrDefault
: expr | DEFAULT | ALL | ON | BINARY | ROW | SYSTEM
;
-
+
transactionCharacteristics
: transactionAccessMode (COMMA_ isolationLevel)?
| isolationLevel (COMMA_ transactionAccessMode)?
;
-
+
isolationLevel
: ISOLATION LEVEL isolationTypes
;
-
+
isolationTypes
: REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED | SERIALIZABLE
;
-
+
transactionAccessMode
: READ (WRITE | ONLY)
;
-
+
databaseName
: identifier
;
-
+
databaseNames
: databaseName (COMMA_ databaseName)*
;
-
+
charsetName
: textOrIdentifier | BINARY | DEFAULT
;
-
+
databasePairs
: databasePair (COMMA_ databasePair)*
;
-
+
databasePair
: LP_ databaseName COMMA_ databaseName RP_
;
-
+
tableName
: (owner DOT_)? name
;
-
+
columnName
: identifier
;
-
+
indexName
: identifier
;
@@ -702,23 +702,23 @@ delimiterName
userIdentifierOrText
: textOrIdentifier (AT_ textOrIdentifier)?
;
-
+
username
: userIdentifierOrText | CURRENT_USER (LP_ RP_)?
;
-
+
eventName
: (owner DOT_)? identifier
;
-
+
serverName
: textOrIdentifier
;
-
+
wrapperName
: textOrIdentifier
;
-
+
functionName
: (owner DOT_)? identifier
;
@@ -730,123 +730,123 @@ procedureName
viewName
: (owner DOT_)? identifier
;
-
+
owner
: identifier
;
-
+
alias
: textOrIdentifier
;
-
+
name
: identifier
;
-
+
tableList
: tableName (COMMA_ tableName)*
;
-
+
viewNames
: viewName (COMMA_ viewName)*
;
-
+
columnNames
: columnName (COMMA_ columnName)*
;
-
+
groupName
: identifier
;
-
+
routineName
: identifier
;
-
+
shardLibraryName
: stringLiterals
;
-
+
componentName
: string_
;
-
+
pluginName
: textOrIdentifier
;
-
+
hostname
: string_
;
-
+
port
: NUMBER_
;
-
+
cloneInstance
: username AT_ hostname COLON_ port
;
-
+
cloneDir
: string_
;
-
+
channelName
: identifier (DOT_ identifier)?
;
-
+
logName
: stringLiterals
;
-
+
roleName
: roleIdentifierOrText (AT_ textOrIdentifier)?
;
-
+
roleIdentifierOrText
: identifier | string_
;
-
+
engineRef
: textOrIdentifier
;
-
+
triggerName
: identifier (DOT_ identifier)?
;
-
+
triggerTime
: BEFORE | AFTER
;
-
+
tableOrTables
: TABLE | TABLES
;
-
+
userOrRole
: username | roleName
;
-
+
partitionName
: identifier
;
-
+
identifierList
: identifier (COMMA_ identifier)*
;
-
+
allOrPartitionNameList
: ALL | identifierList
;
-
+
triggerEvent
: INSERT | UPDATE | DELETE
;
-
+
triggerOrder
: (FOLLOWS | PRECEDES) triggerName
;
-
+
expr
: booleanPrimary
| expr andOperator expr
@@ -854,19 +854,19 @@ expr
| expr XOR expr
| notOperator expr
;
-
+
andOperator
: AND | AND_
;
-
+
orOperator
: OR | OR_
;
-
+
notOperator
: NOT | NOT_
;
-
+
booleanPrimary
: booleanPrimary IS NOT? (TRUE | FALSE | UNKNOWN | NULL)
| booleanPrimary SAFE_EQ_ predicate
@@ -876,15 +876,15 @@ booleanPrimary
| booleanPrimary assignmentOperator predicate
| predicate
;
-
+
assignmentOperator
: EQ_ | ASSIGNMENT_
;
-
+
comparisonOperator
: EQ_ | GTE_ | GT_ | LTE_ | LT_ | NEQ_
;
-
+
predicate
: bitExpr NOT? IN subquery
| bitExpr NOT? IN LP_ expr (COMMA_ expr)* RP_
@@ -894,7 +894,7 @@ predicate
| bitExpr NOT? (REGEXP | RLIKE) bitExpr
| bitExpr
;
-
+
bitExpr
: bitExpr VERTICAL_BAR_ bitExpr
| bitExpr AMPERSAND_ bitExpr
@@ -912,7 +912,7 @@ bitExpr
| bitExpr MINUS_ intervalExpression
| simpleExpr
;
-
+
simpleExpr
: functionCall
| parameterMarker
@@ -931,7 +931,7 @@ simpleExpr
| caseExpression
| intervalExpression
;
-
+
path
: string_
;
@@ -939,15 +939,15 @@ path
onEmptyError
: (NULL | ERROR | DEFAULT literals) ON (EMPTY | ERROR)
;
-
+
columnRef
: identifier (DOT_ identifier)? (DOT_ identifier)?
;
-
+
columnRefList
: columnRef (COMMA_ columnRef)*
;
-
+
functionCall
: aggregationFunction | specialFunction | jsonFunction | regularFunction | udfFunction
;
@@ -992,35 +992,35 @@ jsonFunctionName
aggregationFunctionName
: MAX | MIN | SUM | COUNT | AVG | BIT_XOR | GROUP_CONCAT
;
-
+
distinct
: DISTINCT
;
-
+
overClause
: OVER (windowSpecification | identifier)
;
-
+
windowSpecification
: LP_ identifier? (PARTITION BY expr (COMMA_ expr)*)? orderByClause? frameClause? RP_
;
-
+
frameClause
: (ROWS | RANGE) (frameStart | frameBetween)
;
-
+
frameStart
: CURRENT ROW | UNBOUNDED PRECEDING | UNBOUNDED FOLLOWING | expr PRECEDING | expr FOLLOWING
;
-
+
frameEnd
: frameStart
;
-
+
frameBetween
: BETWEEN frameStart AND frameEnd
;
-
+
specialFunction
: castFunction
| convertFunction
@@ -1037,11 +1037,11 @@ specialFunction
| groupingFunction
| timeStampDiffFunction
;
-
+
currentUserFunction
: CURRENT_USER (LP_ RP_)?
;
-
+
groupingFunction
: GROUPING LP_ expr (COMMA_ expr)* RP_
;
@@ -1053,7 +1053,7 @@ timeStampDiffFunction
groupConcatFunction
: GROUP_CONCAT LP_ distinct? (expr (COMMA_ expr)* | ASTERISK_)? (orderByClause)? (SEPARATOR expr)? RP_
;
-
+
windowFunction
: funcName = (ROW_NUMBER | RANK | DENSE_RANK | CUME_DIST | PERCENT_RANK) LP_ RP_ windowingClause
| funcName = NTILE (simpleExpr) windowingClause
@@ -1061,27 +1061,27 @@ windowFunction
| funcName = (FIRST_VALUE | LAST_VALUE) LP_ expr RP_ nullTreatment? windowingClause
| funcName = NTH_VALUE LP_ expr COMMA_ simpleExpr RP_ (FROM (FIRST | LAST))? nullTreatment? windowingClause
;
-
+
windowingClause
: OVER (windowName=identifier | windowSpecification)
;
-
+
leadLagInfo
: COMMA_ (NUMBER_ | QUESTION_) (COMMA_ expr)?
;
-
+
nullTreatment
: (RESPECT | IGNORE) NULLS
;
-
+
checkType
: FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED
;
-
+
repairType
: QUICK | EXTENDED | USE_FRM
;
-
+
castFunction
: CAST LP_ expr AS castType ARRAY? RP_
| CAST LP_ expr AT TIME ZONE expr AS DATETIME typeDatetimePrecision? RP_
@@ -1091,7 +1091,7 @@ convertFunction
: CONVERT LP_ expr COMMA_ castType RP_
| CONVERT LP_ expr USING charsetName RP_
;
-
+
castType
: castTypeName = BINARY fieldLength?
| castTypeName = CHAR fieldLength? charsetWithOptBinary?
@@ -1112,54 +1112,54 @@ castType
| castTypeName = BIGINT
// DORIS ADDED END
;
-
+
positionFunction
: POSITION LP_ expr IN expr RP_
;
-
+
substringFunction
: (SUBSTRING | SUBSTR) LP_ expr FROM NUMBER_ (FOR NUMBER_)? RP_
| (SUBSTRING | SUBSTR) LP_ expr COMMA_ NUMBER_ (COMMA_ NUMBER_)? RP_
;
-
+
extractFunction
: EXTRACT LP_ intervalUnit FROM expr RP_
;
-
+
charFunction
: CHAR LP_ expr (COMMA_ expr)* (USING charsetName)? RP_
;
-
+
trimFunction
: TRIM LP_ ((LEADING | BOTH | TRAILING) expr? FROM)? expr RP_
| TRIM LP_ (expr FROM)? expr RP_
;
-
+
valuesFunction
: VALUES LP_ columnRefList RP_
;
-
+
weightStringFunction
: WEIGHT_STRING LP_ expr (AS dataType)? levelClause? RP_
;
-
+
levelClause
: LEVEL (levelInWeightListElement (COMMA_ levelInWeightListElement)* | NUMBER_ MINUS_ NUMBER_)
;
-
+
levelInWeightListElement
: NUMBER_ direction? REVERSE?
;
-
+
regularFunction
: completeRegularFunction
| shorthandRegularFunction
;
-
+
shorthandRegularFunction
: CURRENT_DATE | CURRENT_TIME (LP_ NUMBER_? RP_)? | CURRENT_TIMESTAMP | LAST_DAY | LOCALTIME | LOCALTIMESTAMP
;
-
+
completeRegularFunction
// DORIS CHANGED BEGIN
: regularFunctionName (LP_ (expr (COMMA_ expr)* | ASTERISK_)? RP_) indexAlias?
@@ -1179,61 +1179,61 @@ regularFunctionName
| TIME | TIMESTAMP | TIMESTAMP_ADD | TIMESTAMP_DIFF | DATE | CURRENT_TIMESTAMP
| CURRENT_DATE | CURRENT_TIME | UTC_TIMESTAMP | identifier
;
-
+
matchExpression
: MATCH (columnRefList | LP_ columnRefList RP_ ) AGAINST LP_ expr matchSearchModifier? RP_
;
-
+
matchSearchModifier
: IN NATURAL LANGUAGE MODE | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION | IN BOOLEAN MODE | WITH QUERY EXPANSION
;
-
+
caseExpression
: CASE expr? caseWhen+ caseElse? END
;
-
+
datetimeExpr
: expr
;
-
+
binaryLogFileIndexNumber
: NUMBER_
;
-
+
caseWhen
: WHEN expr THEN expr
;
-
+
caseElse
: ELSE expr
;
-
+
intervalExpression
: INTERVAL intervalValue
;
-
+
intervalValue
: expr intervalUnit
;
-
+
intervalUnit
: MICROSECOND | SECOND | MINUTE | HOUR | DAY | WEEK | MONTH
| QUARTER | YEAR | SECOND_MICROSECOND | MINUTE_MICROSECOND | MINUTE_SECOND | HOUR_MICROSECOND | HOUR_SECOND
| HOUR_MINUTE | DAY_MICROSECOND | DAY_SECOND | DAY_MINUTE | DAY_HOUR | YEAR_MONTH
;
-
+
subquery
: 'refer subquery in DMStement.g4'
;
-
+
orderByClause
: ORDER BY orderByItem (COMMA_ orderByItem)*
;
-
+
orderByItem
: (numberLiterals | expr) direction?
;
-
+
dataType
: dataTypeName = (INTEGER | INT | TINYINT | SMALLINT | MIDDLEINT | MEDIUMINT | BIGINT) fieldLength? fieldOptions?
| (dataTypeName = REAL | dataTypeName = DOUBLE PRECISION?) precision? fieldOptions?
@@ -1269,33 +1269,33 @@ dataType
| dataTypeName = SET stringList charsetWithOptBinary?
| dataTypeName = (SERIAL | JSON | GEOMETRY | GEOMCOLLECTION | GEOMETRYCOLLECTION | POINT | MULTIPOINT | LINESTRING | MULTILINESTRING | POLYGON | MULTIPOLYGON)
;
-
+
stringList
: LP_ textString (COMMA_ textString)* RP_
;
-
+
textString
: string_
| HEX_DIGIT_
| BIT_NUM_
;
-
+
textStringHash
: string_ | HEX_DIGIT_
;
-
+
fieldOptions
: (UNSIGNED | SIGNED | ZEROFILL)+
;
-
+
precision
: LP_ NUMBER_ COMMA_ NUMBER_ RP_
;
-
+
typeDatetimePrecision
: LP_ NUMBER_ RP_
;
-
+
charsetWithOptBinary
: ascii
| unicode
@@ -1303,107 +1303,107 @@ charsetWithOptBinary
| charset charsetName BINARY?
| BINARY (charset charsetName)?
;
-
+
ascii
: ASCII BINARY?
| BINARY ASCII
;
-
+
unicode
: UNICODE BINARY?
| BINARY UNICODE
;
-
+
charset
: (CHAR | CHARACTER) SET
| CHARSET
;
-
+
defaultCollation
: DEFAULT? COLLATE EQ_? collationName
;
-
+
defaultEncryption
: DEFAULT? ENCRYPTION EQ_? string_
;
-
+
defaultCharset
: DEFAULT? charset EQ_? charsetName
;
-
+
now
: (CURRENT_TIMESTAMP | LOCALTIME | LOCALTIMESTAMP) (LP_ NUMBER_? RP_)?
;
-
+
columnFormat
: FIXED
| DYNAMIC
| DEFAULT
;
-
+
storageMedia
: DISK
| MEMORY
| DEFAULT
;
-
+
direction
: ASC | DESC
;
-
+
keyOrIndex
: KEY | INDEX
;
-
+
fieldLength
: LP_ length=NUMBER_ RP_
;
-
+
characterSet
: charset charsetName
;
-
+
collateClause
: COLLATE (collationName | parameterMarker)
;
-
+
fieldOrVarSpec
: LP_ (userVariable (COMMA_ userVariable)*)? RP_
;
-
+
ifNotExists
: IF NOT EXISTS
;
-
+
ifExists
: IF EXISTS
;
-
+
connectionId
: NUMBER_
;
-
+
labelName
: identifier
;
-
+
cursorName
: identifier
;
-
+
conditionName
: identifier
;
-
+
combineOption
: ALL | DISTINCT
;
-
+
noWriteToBinLog
: LOCAL
| NO_WRITE_TO_BINLOG
;
-
+
channelOption
: FOR CHANNEL string_
;
diff --git a/parser/sql/dialect/doris/src/main/antlr4/imports/doris/DALStatement.g4 b/parser/sql/dialect/doris/src/main/antlr4/imports/doris/DALStatement.g4
index a4dba5e2080..aab259b1aed 100644
--- a/parser/sql/dialect/doris/src/main/antlr4/imports/doris/DALStatement.g4
+++ b/parser/sql/dialect/doris/src/main/antlr4/imports/doris/DALStatement.g4
@@ -33,7 +33,7 @@ explain
| explainType? (explainableStatement | FOR CONNECTION connectionId)
| ANALYZE (FORMAT EQ_ TREE)? (select | delete | update | insert))
;
-
+
fromDatabase
: (FROM | IN) databaseName
;
@@ -77,7 +77,7 @@ optionValueNoOptionType
equal
: EQ_ | ASSIGNMENT_
;
-
+
optionValue
: optionType internalVariableName EQ_ setExprOrDefault | optionValueNoOptionType
;
@@ -418,7 +418,7 @@ shutdown
explainType
: (FORMAT EQ_ formatName | EXTENDED | PARTITIONS)
;
-
+
explainableStatement
: select | delete | insert | replace | update
;
@@ -430,7 +430,7 @@ formatName
delimiter
: DELIMITER delimiterName
;
-
+
show
: showDatabases
| showTables
diff --git a/parser/sql/dialect/doris/src/main/antlr4/imports/doris/DDLStatement.g4 b/parser/sql/dialect/doris/src/main/antlr4/imports/doris/DDLStatement.g4
index 4b7a27c04e3..e3670c24407 100644
--- a/parser/sql/dialect/doris/src/main/antlr4/imports/doris/DDLStatement.g4
+++ b/parser/sql/dialect/doris/src/main/antlr4/imports/doris/DDLStatement.g4
@@ -256,7 +256,7 @@ createDatabaseSpecification_
| defaultCollation
| defaultEncryption
;
-
+
alterDatabaseSpecification_
: createDatabaseSpecification_
| READ ONLY EQ_? (DEFAULT | NUMBER_)
@@ -698,11 +698,11 @@ procedureParameter
fileSizeLiteral
: FILESIZE_LITERAL | numberLiterals
;
-
+
simpleStatement
: validStatement
;
-
+
compoundStatement
: beginStatement
;
@@ -725,21 +725,21 @@ declareStatement
flowControlStatement
: caseStatement | ifStatement | iterateStatement | leaveStatement | loopStatement | repeatStatement | returnStatement | whileStatement
;
-
+
caseStatement
: CASE expr?
(WHEN expr THEN validStatement+)+
(ELSE validStatement+)?
END CASE
;
-
+
ifStatement
: IF expr THEN validStatement+
(ELSEIF expr THEN validStatement+)*
(ELSE validStatement+)?
END IF
;
-
+
iterateStatement
: ITERATE labelName
;
@@ -747,58 +747,58 @@ iterateStatement
leaveStatement
: LEAVE labelName
;
-
+
loopStatement
: (labelName COLON_)? LOOP
validStatement+
END LOOP labelName?
;
-
+
repeatStatement
: (labelName COLON_)? REPEAT
validStatement+
UNTIL expr
END REPEAT labelName?
;
-
+
returnStatement
: RETURN expr
;
-
+
whileStatement
: (labelName COLON_)? WHILE expr DO
validStatement+
END WHILE labelName?
;
-
+
cursorStatement
: cursorCloseStatement | cursorDeclareStatement | cursorFetchStatement | cursorOpenStatement
;
-
+
cursorCloseStatement
: CLOSE cursorName
;
-
+
cursorDeclareStatement
: DECLARE cursorName CURSOR FOR select
;
-
+
cursorFetchStatement
: FETCH ((NEXT)? FROM)? cursorName INTO variable (COMMA_ variable)*
;
-
+
cursorOpenStatement
: OPEN cursorName
;
-
+
conditionHandlingStatement
: declareConditionStatement | declareHandlerStatement | getDiagnosticsStatement | resignalStatement | signalStatement
;
-
+
declareConditionStatement
: DECLARE conditionName CONDITION FOR conditionValue
;
-
+
declareHandlerStatement
: DECLARE handlerAction HANDLER FOR conditionValue (COMMA_ conditionValue)* validStatement
;
@@ -813,11 +813,11 @@ getDiagnosticsStatement
statementInformationItem
: variable EQ_ statementInformationItemName
;
-
+
conditionInformationItem
: variable EQ_ conditionInformationItemName
;
-
+
conditionNumber
: variable | numberLiterals
;
@@ -826,7 +826,7 @@ statementInformationItemName
: NUMBER
| ROW_COUNT
;
-
+
conditionInformationItemName
: CLASS_ORIGIN
| SUBCLASS_ORIGIN
@@ -842,41 +842,41 @@ conditionInformationItemName
| COLUMN_NAME
| CURSOR_NAME
;
-
+
handlerAction
: CONTINUE | EXIT | UNDO
;
-
+
conditionValue
: numberLiterals | SQLSTATE (VALUE)? stringLiterals | conditionName | SQLWARNING | NOT FOUND | SQLEXCEPTION
;
-
+
resignalStatement
: RESIGNAL conditionValue?
(SET signalInformationItem (COMMA_ signalInformationItem)*)?
;
-
+
signalStatement
: SIGNAL conditionValue
(SET signalInformationItem (COMMA_ signalInformationItem)*)?
;
-
+
signalInformationItem
: conditionInformationItemName EQ_ expr
;
-
+
prepare
: PREPARE identifier FROM (stringLiterals | userVariable)
;
-
+
executeStmt
: EXECUTE identifier (USING executeVarList)?
;
-
+
executeVarList
: userVariable (COMMA_ userVariable)*
;
-
+
deallocate
: (DEALLOCATE | DROP) PREPARE identifier
;
diff --git a/parser/sql/dialect/doris/src/main/antlr4/imports/doris/DMLStatement.g4 b/parser/sql/dialect/doris/src/main/antlr4/imports/doris/DMLStatement.g4
index c2a91e66ec6..e662a1a8599 100644
--- a/parser/sql/dialect/doris/src/main/antlr4/imports/doris/DMLStatement.g4
+++ b/parser/sql/dialect/doris/src/main/antlr4/imports/doris/DMLStatement.g4
@@ -361,7 +361,7 @@ limitClause
limitRowCount
: numberLiterals | parameterMarker
;
-
+
limitOffset
: numberLiterals | parameterMarker
;
diff --git a/parser/sql/dialect/doris/src/main/antlr4/imports/doris/Keyword.g4 b/parser/sql/dialect/doris/src/main/antlr4/imports/doris/Keyword.g4
index 97e3ee98029..d568a99bf55 100644
--- a/parser/sql/dialect/doris/src/main/antlr4/imports/doris/Keyword.g4
+++ b/parser/sql/dialect/doris/src/main/antlr4/imports/doris/Keyword.g4
@@ -110,7 +110,7 @@ AUTOCOMMIT
REDO_LOG
: 'REDO_LOG'
;
-
+
DELIMITER
: D E L I M I T E R
;
diff --git a/parser/sql/dialect/hive/src/main/antlr4/imports/hive/BaseRule.g4 b/parser/sql/dialect/hive/src/main/antlr4/imports/hive/BaseRule.g4
index 5cc8a20267f..91dd474eb4d 100644
--- a/parser/sql/dialect/hive/src/main/antlr4/imports/hive/BaseRule.g4
+++ b/parser/sql/dialect/hive/src/main/antlr4/imports/hive/BaseRule.g4
@@ -22,7 +22,7 @@ import Symbol, Keyword, HiveKeyword, Literals;
parameterMarker
: QUESTION_
;
-
+
customKeyword
: MAX
| MIN
@@ -56,7 +56,7 @@ customKeyword
| UTC_TIMESTAMP
| UTC_TIMESTAMP
;
-
+
literals
: stringLiterals
| numberLiterals
@@ -66,43 +66,43 @@ literals
| booleanLiterals
| nullValueLiterals
;
-
+
string_
: DOUBLE_QUOTED_TEXT | SINGLE_QUOTED_TEXT
;
-
+
stringLiterals
: (UNDERSCORE_CHARSET | UL_BINARY )? string_ | NCHAR_TEXT
;
-
+
numberLiterals
: (PLUS_ | MINUS_)? NUMBER_
;
-
+
temporalLiterals
: (DATE | TIME | TIMESTAMP) SINGLE_QUOTED_TEXT
;
-
+
hexadecimalLiterals
: UNDERSCORE_CHARSET? HEX_DIGIT_ collateClause?
;
-
+
bitValueLiterals
: UNDERSCORE_CHARSET? BIT_NUM_ collateClause?
;
-
+
booleanLiterals
: TRUE | FALSE
;
-
+
nullValueLiterals
: NULL
;
-
+
collationName
: textOrIdentifier | BINARY
;
-
+
identifier
: IDENTIFIER_
| identifierKeywordsUnambiguous
@@ -115,7 +115,7 @@ identifier
| UNDERSCORE_CHARSET
| BQUOTA_STRING
;
-
+
identifierKeywordsUnambiguous
: ACTION
| ACCOUNT
@@ -506,13 +506,13 @@ identifierKeywordsUnambiguous
| YEAR
| YEAR_MONTH
;
-
+
identifierKeywordsAmbiguous1RolesAndLabels
: EXECUTE
| RESTART
| SHUTDOWN
;
-
+
identifierKeywordsAmbiguous2Labels
: ASCII
| BEGIN
@@ -550,7 +550,7 @@ identifierKeywordsAmbiguous2Labels
| UNINSTALL
| XA
;
-
+
identifierKeywordsAmbiguous3Roles
: EVENT
| FILE
@@ -562,7 +562,7 @@ identifierKeywordsAmbiguous3Roles
| RESOURCE
| SUPER
;
-
+
identifierKeywordsAmbiguous4SystemVariables
: GLOBAL
| LOCAL
@@ -582,52 +582,52 @@ ipAddress
variable
: userVariable | systemVariable
;
-
+
userVariable
: AT_ textOrIdentifier
| textOrIdentifier
;
-
+
systemVariable
: AT_ AT_ (systemVariableScope=(GLOBAL | SESSION | LOCAL) DOT_)? rvalueSystemVariable
;
-
+
rvalueSystemVariable
: textOrIdentifier
| textOrIdentifier DOT_ identifier
;
-
+
setSystemVariable
: AT_ AT_ (optionType DOT_)? internalVariableName
;
-
+
optionType
: GLOBAL | PERSIST | PERSIST_ONLY | SESSION | LOCAL
;
-
+
internalVariableName
: identifier
| DEFAULT DOT_ identifier
| identifier DOT_ identifier
;
-
+
setExprOrDefault
: expr | DEFAULT | ALL | ON | BINARY | ROW | SYSTEM
;
-
+
transactionCharacteristics
: transactionAccessMode (COMMA_ isolationLevel)?
| isolationLevel (COMMA_ transactionAccessMode)?
;
-
+
isolationLevel
: ISOLATION LEVEL isolationTypes
;
-
+
isolationTypes
: REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED | SERIALIZABLE
;
-
+
transactionAccessMode
: READ (WRITE | ONLY)
;
@@ -639,11 +639,11 @@ charsetName
tableName
: (owner DOT_)? name
;
-
+
columnName
: identifier
;
-
+
indexName
: identifier
;
@@ -667,23 +667,23 @@ delimiterName
userIdentifierOrText
: textOrIdentifier (AT_ textOrIdentifier)?
;
-
+
username
: userIdentifierOrText | CURRENT_USER (LP_ RP_)?
;
-
+
eventName
: (owner DOT_)? identifier
;
-
+
serverName
: textOrIdentifier
;
-
+
wrapperName
: textOrIdentifier
;
-
+
functionName
: (owner DOT_)? identifier
;
@@ -695,123 +695,123 @@ procedureName
viewName
: (owner DOT_)? identifier
;
-
+
owner
: identifier
;
-
+
alias
: textOrIdentifier
;
-
+
name
: identifier
;
-
+
tableList
: tableName (COMMA_ tableName)*
;
-
+
viewNames
: viewName (COMMA_ viewName)*
;
-
+
columnNames
: columnName (COMMA_ columnName)*
;
-
+
groupName
: identifier
;
-
+
routineName
: identifier
;
-
+
shardLibraryName
: stringLiterals
;
-
+
componentName
: string_
;
-
+
pluginName
: textOrIdentifier
;
-
+
hostname
: string_
;
-
+
port
: NUMBER_
;
-
+
cloneInstance
: username AT_ hostname COLON_ port
;
-
+
cloneDir
: string_
;
-
+
channelName
: identifier (DOT_ identifier)?
;
-
+
logName
: stringLiterals
;
-
+
roleName
: roleIdentifierOrText (AT_ textOrIdentifier)?
;
-
+
roleIdentifierOrText
: identifier | string_
;
-
+
engineRef
: textOrIdentifier
;
-
+
triggerName
: identifier (DOT_ identifier)?
;
-
+
triggerTime
: BEFORE | AFTER
;
-
+
tableOrTables
: TABLE | TABLES
;
-
+
userOrRole
: username | roleName
;
-
+
partitionName
: identifier
;
-
+
identifierList
: identifier (COMMA_ identifier)*
;
-
+
allOrPartitionNameList
: ALL | identifierList
;
-
+
triggerEvent
: INSERT | UPDATE | DELETE
;
-
+
triggerOrder
: (FOLLOWS | PRECEDES) triggerName
;
-
+
expr
: booleanPrimary
| expr andOperator expr
@@ -819,19 +819,19 @@ expr
| expr XOR expr
| notOperator expr
;
-
+
andOperator
: AND | AND_
;
-
+
orOperator
: OR | OR_
;
-
+
notOperator
: NOT | NOT_
;
-
+
booleanPrimary
: booleanPrimary IS NOT? (TRUE | FALSE | UNKNOWN | NULL)
| booleanPrimary SAFE_EQ_ predicate
@@ -841,15 +841,15 @@ booleanPrimary
| booleanPrimary assignmentOperator predicate
| predicate
;
-
+
assignmentOperator
: EQ_ | ASSIGNMENT_
;
-
+
comparisonOperator
: EQ_ | GTE_ | GT_ | LTE_ | LT_ | NEQ_
;
-
+
predicate
: bitExpr NOT? IN subquery
| bitExpr NOT? IN LP_ expr (COMMA_ expr)* RP_
@@ -859,7 +859,7 @@ predicate
| bitExpr NOT? (REGEXP | RLIKE) bitExpr
| bitExpr
;
-
+
bitExpr
: bitExpr VERTICAL_BAR_ bitExpr
| bitExpr AMPERSAND_ bitExpr
@@ -877,7 +877,7 @@ bitExpr
| bitExpr MINUS_ intervalExpression
| simpleExpr
;
-
+
simpleExpr
: functionCall
| parameterMarker
@@ -896,7 +896,7 @@ simpleExpr
| caseExpression
| intervalExpression
;
-
+
path
: string_
;
@@ -904,15 +904,15 @@ path
onEmptyError
: (NULL | ERROR | DEFAULT literals) ON (EMPTY | ERROR)
;
-
+
columnRef
: identifier (DOT_ identifier)? (DOT_ identifier)?
;
-
+
columnRefList
: columnRef (COMMA_ columnRef)*
;
-
+
functionCall
: aggregationFunction | specialFunction | regularFunction | jsonFunction | udfFunction
;
@@ -941,48 +941,48 @@ jsonFunctionName
aggregationFunctionName
: MAX | MIN | SUM | COUNT | AVG | BIT_XOR
;
-
+
distinct
: DISTINCT
;
-
+
overClause
: OVER (windowSpecification | identifier)
;
-
+
windowSpecification
: LP_ identifier? (PARTITION BY expr (COMMA_ expr)*)? orderByClause? frameClause? RP_
;
-
+
frameClause
: (ROWS | RANGE) (frameStart | frameBetween)
;
-
+
frameStart
: CURRENT ROW | UNBOUNDED PRECEDING | UNBOUNDED FOLLOWING | expr PRECEDING | expr FOLLOWING
;
-
+
frameEnd
: frameStart
;
-
+
frameBetween
: BETWEEN frameStart AND frameEnd
;
-
+
specialFunction
: groupConcatFunction | windowFunction | castFunction | convertFunction | positionFunction | substringFunction | extractFunction
| charFunction | trimFunction | weightStringFunction | valuesFunction | currentUserFunction
;
-
+
currentUserFunction
: CURRENT_USER (LP_ RP_)?
;
-
+
groupConcatFunction
: GROUP_CONCAT LP_ distinct? (expr (COMMA_ expr)* | ASTERISK_)? (orderByClause)? (SEPARATOR expr)? RP_
;
-
+
windowFunction
: funcName = (ROW_NUMBER | RANK | DENSE_RANK | CUME_DIST | PERCENT_RANK) LP_ RP_ windowingClause
| funcName = NTILE (simpleExpr) windowingClause
@@ -990,27 +990,27 @@ windowFunction
| funcName = (FIRST_VALUE | LAST_VALUE) LP_ expr RP_ nullTreatment? windowingClause
| funcName = NTH_VALUE LP_ expr COMMA_ simpleExpr RP_ (FROM (FIRST | LAST))? nullTreatment? windowingClause
;
-
+
windowingClause
: OVER (windowName=identifier | windowSpecification)
;
-
+
leadLagInfo
: COMMA_ (NUMBER_ | QUESTION_) (COMMA_ expr)?
;
-
+
nullTreatment
: (RESPECT | IGNORE) NULLS
;
-
+
checkType
: FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED
;
-
+
repairType
: QUICK | EXTENDED | USE_FRM
;
-
+
castFunction
: CAST LP_ expr AS castType ARRAY? RP_
| CAST LP_ expr AT TIME ZONE expr AS DATETIME typeDatetimePrecision? RP_
@@ -1020,7 +1020,7 @@ convertFunction
: CONVERT LP_ expr COMMA_ castType RP_
| CONVERT LP_ expr USING charsetName RP_
;
-
+
castType
: castTypeName = BINARY fieldLength?
| castTypeName = CHAR fieldLength? charsetWithOptBinary?
@@ -1036,58 +1036,58 @@ castType
| castTypeName = DOUBLE PRECISION
| castTypeName = FLOAT precision?
;
-
+
positionFunction
: POSITION LP_ expr IN expr RP_
;
-
+
substringFunction
: (SUBSTRING | SUBSTR) LP_ expr FROM NUMBER_ (FOR NUMBER_)? RP_
| (SUBSTRING | SUBSTR) LP_ expr COMMA_ NUMBER_ (COMMA_ NUMBER_)? RP_
;
-
+
extractFunction
: EXTRACT LP_ identifier FROM expr RP_
;
-
+
charFunction
: CHAR LP_ expr (COMMA_ expr)* (USING charsetName)? RP_
;
-
+
trimFunction
: TRIM LP_ ((LEADING | BOTH | TRAILING) expr? FROM)? expr RP_
| TRIM LP_ (expr FROM)? expr RP_
;
-
+
valuesFunction
: VALUES LP_ columnRefList RP_
;
-
+
weightStringFunction
: WEIGHT_STRING LP_ expr (AS dataType)? levelClause? RP_
;
-
+
levelClause
: LEVEL (levelInWeightListElement (COMMA_ levelInWeightListElement)* | NUMBER_ MINUS_ NUMBER_)
;
-
+
levelInWeightListElement
: NUMBER_ direction? REVERSE?
;
-
+
regularFunction
: completeRegularFunction
| shorthandRegularFunction
;
-
+
shorthandRegularFunction
: CURRENT_DATE | CURRENT_TIME (LP_ NUMBER_? RP_)? | CURRENT_TIMESTAMP | LAST_DAY | LOCALTIME | LOCALTIMESTAMP
;
-
+
completeRegularFunction
: regularFunctionName (LP_ (expr (COMMA_ expr)* | ASTERISK_)? RP_)
;
-
+
regularFunctionName
: IF | LOCALTIME | LOCALTIMESTAMP | REPLACE | INSERT | INTERVAL | MOD
| DATABASE | SCHEMA | LEFT | RIGHT | DATE | DAY | GEOMETRYCOLLECTION | REPEAT
@@ -1095,61 +1095,61 @@ regularFunctionName
| TIME | TIMESTAMP | TIMESTAMP_ADD | TIMESTAMP_DIFF | DATE | CURRENT_TIMESTAMP
| CURRENT_DATE | CURRENT_TIME | UTC_TIMESTAMP | identifier
;
-
+
matchExpression
: MATCH (columnRefList | LP_ columnRefList RP_ ) AGAINST LP_ expr matchSearchModifier? RP_
;
-
+
matchSearchModifier
: IN NATURAL LANGUAGE MODE | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION | IN BOOLEAN MODE | WITH QUERY EXPANSION
;
-
+
caseExpression
: CASE simpleExpr? caseWhen+ caseElse? END
;
-
+
datetimeExpr
: expr
;
-
+
binaryLogFileIndexNumber
: NUMBER_
;
-
+
caseWhen
: WHEN expr THEN expr
;
-
+
caseElse
: ELSE expr
;
-
+
intervalExpression
: INTERVAL intervalValue
;
-
+
intervalValue
: expr intervalUnit
;
-
+
intervalUnit
: MICROSECOND | SECOND | MINUTE | HOUR | DAY | WEEK | MONTH
| QUARTER | YEAR | SECOND_MICROSECOND | MINUTE_MICROSECOND | MINUTE_SECOND | HOUR_MICROSECOND | HOUR_SECOND
| HOUR_MINUTE | DAY_MICROSECOND | DAY_SECOND | DAY_MINUTE | DAY_HOUR | YEAR_MONTH
;
-
+
subquery
: 'refer subquery in DMStement.g4'
;
-
+
orderByClause
: ORDER BY orderByItem (COMMA_ orderByItem)*
;
-
+
orderByItem
: (numberLiterals | expr) direction?
;
-
+
dataType
: dataTypeName = (INTEGER | INT | TINYINT | SMALLINT | MIDDLEINT | MEDIUMINT | BIGINT) fieldLength? fieldOptions?
| (dataTypeName = REAL | dataTypeName = DOUBLE PRECISION?) precision? fieldOptions?
@@ -1182,33 +1182,33 @@ dataType
| dataTypeName = SET stringList charsetWithOptBinary?
| dataTypeName = (SERIAL | JSON | GEOMETRY | GEOMCOLLECTION | GEOMETRYCOLLECTION | POINT | MULTIPOINT | LINESTRING | MULTILINESTRING | POLYGON | MULTIPOLYGON)
;
-
+
stringList
: LP_ textString (COMMA_ textString)* RP_
;
-
+
textString
: string_
| HEX_DIGIT_
| BIT_NUM_
;
-
+
textStringHash
: string_ | HEX_DIGIT_
;
-
+
fieldOptions
: (UNSIGNED | SIGNED | ZEROFILL)+
;
-
+
precision
: LP_ NUMBER_ COMMA_ NUMBER_ RP_
;
-
+
typeDatetimePrecision
: LP_ NUMBER_ RP_
;
-
+
charsetWithOptBinary
: ascii
| unicode
@@ -1216,107 +1216,107 @@ charsetWithOptBinary
| charset charsetName BINARY?
| BINARY (charset charsetName)?
;
-
+
ascii
: ASCII BINARY?
| BINARY ASCII
;
-
+
unicode
: UNICODE BINARY?
| BINARY UNICODE
;
-
+
charset
: (CHAR | CHARACTER) SET
| CHARSET
;
-
+
defaultCollation
: DEFAULT? COLLATE EQ_? collationName
;
-
+
defaultEncryption
: DEFAULT? ENCRYPTION EQ_? string_
;
-
+
defaultCharset
: DEFAULT? charset EQ_? charsetName
;
-
+
now
: (CURRENT_TIMESTAMP | LOCALTIME | LOCALTIMESTAMP) (LP_ NUMBER_? RP_)?
;
-
+
columnFormat
: FIXED
| DYNAMIC
| DEFAULT
;
-
+
storageMedia
: DISK
| MEMORY
| DEFAULT
;
-
+
direction
: ASC | DESC
;
-
+
keyOrIndex
: KEY | INDEX
;
-
+
fieldLength
: LP_ length=NUMBER_ RP_
;
-
+
characterSet
: charset charsetName
;
-
+
collateClause
: COLLATE (collationName | parameterMarker)
;
-
+
fieldOrVarSpec
: LP_ (identifier (COMMA_ identifier)*)? RP_
;
-
+
ifNotExists
: IF NOT EXISTS
;
-
+
ifExists
: IF EXISTS
;
-
+
connectionId
: NUMBER_
;
-
+
labelName
: identifier
;
-
+
cursorName
: identifier
;
-
+
conditionName
: identifier
;
-
+
combineOption
: ALL | DISTINCT
;
-
+
noWriteToBinLog
: LOCAL
| NO_WRITE_TO_BINLOG
;
-
+
channelOption
: FOR CHANNEL string_
;
diff --git a/parser/sql/dialect/hive/src/main/antlr4/imports/hive/DMLStatement.g4 b/parser/sql/dialect/hive/src/main/antlr4/imports/hive/DMLStatement.g4
index 8af67a1dbed..73d90c9bd12 100644
--- a/parser/sql/dialect/hive/src/main/antlr4/imports/hive/DMLStatement.g4
+++ b/parser/sql/dialect/hive/src/main/antlr4/imports/hive/DMLStatement.g4
@@ -264,7 +264,7 @@ limitClause
limitRowCount
: numberLiterals | parameterMarker
;
-
+
limitOffset
: numberLiterals | parameterMarker
;
diff --git a/parser/sql/dialect/hive/src/main/antlr4/imports/hive/Keyword.g4 b/parser/sql/dialect/hive/src/main/antlr4/imports/hive/Keyword.g4
index c9f5c6d91c3..e3bf78ffd1e 100644
--- a/parser/sql/dialect/hive/src/main/antlr4/imports/hive/Keyword.g4
+++ b/parser/sql/dialect/hive/src/main/antlr4/imports/hive/Keyword.g4
@@ -114,7 +114,7 @@ INNODB
REDO_LOG
: 'REDO_LOG'
;
-
+
DELIMITER
: D E L I M I T E R
;
diff --git a/parser/sql/dialect/mysql/src/main/antlr4/imports/mysql/BaseRule.g4 b/parser/sql/dialect/mysql/src/main/antlr4/imports/mysql/BaseRule.g4
index faad6fba9b4..f0aee586d69 100644
--- a/parser/sql/dialect/mysql/src/main/antlr4/imports/mysql/BaseRule.g4
+++ b/parser/sql/dialect/mysql/src/main/antlr4/imports/mysql/BaseRule.g4
@@ -22,7 +22,7 @@ import Comments, Symbol, Keyword, MySQLKeyword, Literals;
parameterMarker
: QUESTION_
;
-
+
customKeyword
: MAX
| MIN
@@ -68,7 +68,7 @@ customKeyword
| UTC_TIMESTAMP
| UTC_TIMESTAMP
;
-
+
literals
: stringLiterals
| numberLiterals
@@ -78,43 +78,43 @@ literals
| booleanLiterals
| nullValueLiterals
;
-
+
string_
: DOUBLE_QUOTED_TEXT | SINGLE_QUOTED_TEXT
;
-
+
stringLiterals
: (UNDERSCORE_CHARSET | UL_BINARY )? string_ | NCHAR_TEXT
;
-
+
numberLiterals
: (PLUS_ | MINUS_)? NUMBER_
;
-
+
temporalLiterals
: (DATE | TIME | TIMESTAMP) textString
;
-
+
hexadecimalLiterals
: UNDERSCORE_CHARSET? UL_BINARY? HEX_DIGIT_ collateClause?
;
-
+
bitValueLiterals
: UNDERSCORE_CHARSET? BIT_NUM_ collateClause?
;
-
+
booleanLiterals
: TRUE | FALSE
;
-
+
nullValueLiterals
: NULL
;
-
+
collationName
: textOrIdentifier | BINARY
;
-
+
identifier
: IDENTIFIER_
| identifierKeywordsUnambiguous
@@ -526,13 +526,13 @@ identifierKeywordsUnambiguous
| CONDITION
| DESCRIBE
;
-
+
identifierKeywordsAmbiguous1RolesAndLabels
: EXECUTE
| RESTART
| SHUTDOWN
;
-
+
identifierKeywordsAmbiguous2Labels
: ASCII
| BEGIN
@@ -570,7 +570,7 @@ identifierKeywordsAmbiguous2Labels
| UNINSTALL
| XA
;
-
+
identifierKeywordsAmbiguous3Roles
: EVENT
| FILE
@@ -582,7 +582,7 @@ identifierKeywordsAmbiguous3Roles
| RESOURCE
| SUPER
;
-
+
identifierKeywordsAmbiguous4SystemVariables
: GLOBAL
| LOCAL
@@ -602,84 +602,84 @@ ipAddress
variable
: userVariable | systemVariable
;
-
+
userVariable
: AT_ textOrIdentifier
| textOrIdentifier
;
-
+
systemVariable
: AT_ AT_ (systemVariableScope=(GLOBAL | SESSION | LOCAL) DOT_)? rvalueSystemVariable
;
-
+
rvalueSystemVariable
: textOrIdentifier
| textOrIdentifier DOT_ identifier
;
-
+
setSystemVariable
: AT_ AT_ (optionType DOT_)? internalVariableName
;
-
+
optionType
: GLOBAL | PERSIST | PERSIST_ONLY | SESSION | LOCAL
;
-
+
internalVariableName
: identifier
| DEFAULT DOT_ identifier
| identifier DOT_ identifier
;
-
+
setExprOrDefault
: expr | DEFAULT | ALL | ON | BINARY | ROW | SYSTEM
;
-
+
transactionCharacteristics
: transactionAccessMode (COMMA_ isolationLevel)?
| isolationLevel (COMMA_ transactionAccessMode)?
;
-
+
isolationLevel
: ISOLATION LEVEL isolationTypes
;
-
+
isolationTypes
: REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED | SERIALIZABLE
;
-
+
transactionAccessMode
: READ (WRITE | ONLY)
;
-
+
databaseName
: identifier
;
-
+
databaseNames
: databaseName (COMMA_ databaseName)*
;
-
+
charsetName
: textOrIdentifier | BINARY | DEFAULT
;
-
+
databasePairs
: databasePair (COMMA_ databasePair)*
;
-
+
databasePair
: LP_ databaseName COMMA_ databaseName RP_
;
-
+
tableName
: (owner DOT_)? name
;
-
+
columnName
: identifier
;
-
+
indexName
: identifier
;
@@ -703,23 +703,23 @@ delimiterName
userIdentifierOrText
: textOrIdentifier (AT_ textOrIdentifier)?
;
-
+
username
: userIdentifierOrText | CURRENT_USER (LP_ RP_)?
;
-
+
eventName
: (owner DOT_)? identifier
;
-
+
serverName
: textOrIdentifier
;
-
+
wrapperName
: textOrIdentifier
;
-
+
functionName
: (owner DOT_)? identifier
;
@@ -731,123 +731,123 @@ procedureName
viewName
: (owner DOT_)? identifier
;
-
+
owner
: identifier
;
-
+
alias
: textOrIdentifier
;
-
+
name
: identifier
;
-
+
tableList
: tableName (COMMA_ tableName)*
;
-
+
viewNames
: viewName (COMMA_ viewName)*
;
-
+
columnNames
: columnName (COMMA_ columnName)*
;
-
+
groupName
: identifier
;
-
+
routineName
: identifier
;
-
+
shardLibraryName
: stringLiterals
;
-
+
componentName
: string_
;
-
+
pluginName
: textOrIdentifier
;
-
+
hostname
: string_
;
-
+
port
: NUMBER_
;
-
+
cloneInstance
: username AT_ hostname COLON_ port
;
-
+
cloneDir
: string_
;
-
+
channelName
: identifier (DOT_ identifier)?
;
-
+
logName
: stringLiterals
;
-
+
roleName
: roleIdentifierOrText (AT_ textOrIdentifier)?
;
-
+
roleIdentifierOrText
: identifier | string_
;
-
+
engineRef
: textOrIdentifier
;
-
+
triggerName
: identifier (DOT_ identifier)?
;
-
+
triggerTime
: BEFORE | AFTER
;
-
+
tableOrTables
: TABLE | TABLES
;
-
+
userOrRole
: username | roleName
;
-
+
partitionName
: identifier
;
-
+
identifierList
: identifier (COMMA_ identifier)*
;
-
+
allOrPartitionNameList
: ALL | identifierList
;
-
+
triggerEvent
: INSERT | UPDATE | DELETE
;
-
+
triggerOrder
: (FOLLOWS | PRECEDES) triggerName
;
-
+
expr
: booleanPrimary
| expr andOperator expr
@@ -855,19 +855,19 @@ expr
| expr XOR expr
| notOperator expr
;
-
+
andOperator
: AND | AND_
;
-
+
orOperator
: OR | OR_
;
-
+
notOperator
: NOT | NOT_
;
-
+
booleanPrimary
: booleanPrimary IS NOT? (TRUE | FALSE | UNKNOWN | NULL)
| booleanPrimary SAFE_EQ_ predicate
@@ -877,15 +877,15 @@ booleanPrimary
| booleanPrimary assignmentOperator predicate
| predicate
;
-
+
assignmentOperator
: EQ_ | ASSIGNMENT_
;
-
+
comparisonOperator
: EQ_ | GTE_ | GT_ | LTE_ | LT_ | NEQ_
;
-
+
predicate
: bitExpr NOT? IN subquery
| bitExpr NOT? IN LP_ expr (COMMA_ expr)* RP_
@@ -895,7 +895,7 @@ predicate
| bitExpr NOT? (REGEXP | RLIKE) bitExpr
| bitExpr
;
-
+
bitExpr
: bitExpr VERTICAL_BAR_ bitExpr
| bitExpr AMPERSAND_ bitExpr
@@ -913,7 +913,7 @@ bitExpr
| bitExpr MINUS_ intervalExpression
| simpleExpr
;
-
+
simpleExpr
: functionCall
| parameterMarker
@@ -932,7 +932,7 @@ simpleExpr
| caseExpression
| intervalExpression
;
-
+
path
: string_
;
@@ -944,15 +944,15 @@ onEmpty
onError
: (NULL | ERROR | DEFAULT literals) ON ERROR
;
-
+
columnRef
: identifier (DOT_ identifier)? (DOT_ identifier)?
;
-
+
columnRefList
: columnRef (COMMA_ columnRef)*
;
-
+
functionCall
: aggregationFunction | specialFunction | jsonFunction | regularFunction | udfFunction
;
@@ -1005,7 +1005,7 @@ jsonFunctionName
aggregationFunctionName
: MAX | MIN | SUM | COUNT | AVG | BIT_XOR | GROUP_CONCAT
;
-
+
distinct
: DISTINCT
;
@@ -1013,27 +1013,27 @@ distinct
overClause
: OVER (windowSpecification | identifier)
;
-
+
windowSpecification
: LP_ identifier? (PARTITION BY expr (COMMA_ expr)*)? orderByClause? frameClause? RP_
;
-
+
frameClause
: (ROWS | RANGE) (frameStart | frameBetween)
;
-
+
frameStart
: CURRENT ROW | UNBOUNDED PRECEDING | UNBOUNDED FOLLOWING | expr PRECEDING | expr FOLLOWING
;
-
+
frameEnd
: frameStart
;
-
+
frameBetween
: BETWEEN frameStart AND frameEnd
;
-
+
specialFunction
: castFunction
| convertFunction
@@ -1050,11 +1050,11 @@ specialFunction
| groupingFunction
| timeStampDiffFunction
;
-
+
currentUserFunction
: CURRENT_USER (LP_ RP_)?
;
-
+
groupingFunction
: GROUPING LP_ expr (COMMA_ expr)* RP_
;
@@ -1066,7 +1066,7 @@ timeStampDiffFunction
groupConcatFunction
: GROUP_CONCAT LP_ distinct? (expr (COMMA_ expr)* | ASTERISK_)? (orderByClause)? (SEPARATOR expr)? RP_
;
-
+
windowFunction
: funcName = (ROW_NUMBER | RANK | DENSE_RANK | CUME_DIST | PERCENT_RANK) LP_ RP_ windowingClause
| funcName = NTILE (simpleExpr) windowingClause
@@ -1078,23 +1078,23 @@ windowFunction
windowingClause
: OVER (windowName=identifier | windowSpecification)
;
-
+
leadLagInfo
: COMMA_ (NUMBER_ | QUESTION_) (COMMA_ expr)?
;
-
+
nullTreatment
: (RESPECT | IGNORE) NULLS
;
-
+
checkType
: FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED
;
-
+
repairType
: QUICK | EXTENDED | USE_FRM
;
-
+
castFunction
: CAST LP_ expr AS castType ARRAY? RP_
| CAST LP_ expr AT TIME ZONE expr AS DATETIME typeDatetimePrecision? RP_
@@ -1104,7 +1104,7 @@ convertFunction
: CONVERT LP_ expr COMMA_ castType RP_
| CONVERT LP_ expr USING charsetName RP_
;
-
+
castType
: castTypeName = BINARY fieldLength?
| castTypeName = CHAR fieldLength? charsetWithOptBinary?
@@ -1120,58 +1120,58 @@ castType
| castTypeName = DOUBLE PRECISION
| castTypeName = FLOAT precision?
;
-
+
positionFunction
: POSITION LP_ expr IN expr RP_
;
-
+
substringFunction
: (SUBSTRING | SUBSTR | MID) LP_ expr FROM NUMBER_ (FOR NUMBER_)? RP_
| (SUBSTRING | SUBSTR | MID) LP_ expr COMMA_ NUMBER_ (COMMA_ NUMBER_)? RP_
;
-
+
extractFunction
: EXTRACT LP_ intervalUnit FROM expr RP_
;
-
+
charFunction
: CHAR LP_ expr (COMMA_ expr)* (USING charsetName)? RP_
;
-
+
trimFunction
: TRIM LP_ ((LEADING | BOTH | TRAILING) expr? FROM)? expr RP_
| TRIM LP_ (expr FROM)? expr RP_
;
-
+
valuesFunction
: VALUES LP_ columnRefList RP_
;
-
+
weightStringFunction
: WEIGHT_STRING LP_ expr (AS dataType)? levelClause? RP_
;
-
+
levelClause
: LEVEL (levelInWeightListElement (COMMA_ levelInWeightListElement)* | NUMBER_ MINUS_ NUMBER_)
;
-
+
levelInWeightListElement
: NUMBER_ direction? REVERSE?
;
-
+
regularFunction
: completeRegularFunction
| shorthandRegularFunction
;
-
+
shorthandRegularFunction
: CURRENT_DATE | CURRENT_TIME (LP_ NUMBER_? RP_)? | CURRENT_TIMESTAMP | LAST_DAY | LOCALTIME | LOCALTIMESTAMP
;
-
+
completeRegularFunction
: regularFunctionName (LP_ (expr (COMMA_ expr)* | ASTERISK_)? RP_)
;
-
+
regularFunctionName
: IF | LOCALTIME | LOCALTIMESTAMP | REPLACE | INSERT | INTERVAL | MOD
| DATABASE | SCHEMA | LEFT | RIGHT | DATE | DAY | GEOMETRYCOLLECTION | REPEAT
@@ -1179,61 +1179,61 @@ regularFunctionName
| TIME | TIMESTAMP | TIMESTAMP_ADD | TIMESTAMP_DIFF | DATE | CURRENT_TIMESTAMP
| CURRENT_DATE | CURRENT_TIME | UTC_TIMESTAMP | identifier
;
-
+
matchExpression
: MATCH (columnRefList | LP_ columnRefList RP_ ) AGAINST LP_ expr matchSearchModifier? RP_
;
-
+
matchSearchModifier
: IN NATURAL LANGUAGE MODE | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION | IN BOOLEAN MODE | WITH QUERY EXPANSION
;
-
+
caseExpression
: CASE expr? caseWhen+ caseElse? END
;
-
+
datetimeExpr
: expr
;
-
+
binaryLogFileIndexNumber
: NUMBER_
;
-
+
caseWhen
: WHEN expr THEN expr
;
-
+
caseElse
: ELSE expr
;
-
+
intervalExpression
: INTERVAL intervalValue
;
-
+
intervalValue
: expr intervalUnit
;
-
+
intervalUnit
: MICROSECOND | SECOND | MINUTE | HOUR | DAY | WEEK | MONTH
| QUARTER | YEAR | SECOND_MICROSECOND | MINUTE_MICROSECOND | MINUTE_SECOND | HOUR_MICROSECOND | HOUR_SECOND
| HOUR_MINUTE | DAY_MICROSECOND | DAY_SECOND | DAY_MINUTE | DAY_HOUR | YEAR_MONTH
;
-
+
subquery
: 'refer subquery in DMStement.g4'
;
-
+
orderByClause
: ORDER BY orderByItem (COMMA_ orderByItem)*
;
-
+
orderByItem
: (numberLiterals | expr) direction?
;
-
+
dataType
: dataTypeName = (INTEGER | INT | TINYINT | SMALLINT | MIDDLEINT | MEDIUMINT | BIGINT) fieldLength? fieldOptions?
| (dataTypeName = REAL | dataTypeName = DOUBLE PRECISION?) precision? fieldOptions?
@@ -1266,33 +1266,33 @@ dataType
| dataTypeName = SET stringList charsetWithOptBinary?
| dataTypeName = (SERIAL | JSON | GEOMETRY | GEOMCOLLECTION | GEOMETRYCOLLECTION | POINT | MULTIPOINT | LINESTRING | MULTILINESTRING | POLYGON | MULTIPOLYGON)
;
-
+
stringList
: LP_ textString (COMMA_ textString)* RP_
;
-
+
textString
: string_
| HEX_DIGIT_
| BIT_NUM_
;
-
+
textStringHash
: string_ | HEX_DIGIT_
;
-
+
fieldOptions
: (UNSIGNED | SIGNED | ZEROFILL)+
;
-
+
precision
: LP_ NUMBER_ COMMA_ NUMBER_ RP_
;
-
+
typeDatetimePrecision
: LP_ NUMBER_ RP_
;
-
+
charsetWithOptBinary
: ascii
| unicode
@@ -1300,107 +1300,107 @@ charsetWithOptBinary
| charset charsetName BINARY?
| BINARY (charset charsetName)?
;
-
+
ascii
: ASCII BINARY?
| BINARY ASCII
;
-
+
unicode
: UNICODE BINARY?
| BINARY UNICODE
;
-
+
charset
: (CHAR | CHARACTER) SET
| CHARSET
;
-
+
defaultCollation
: DEFAULT? COLLATE EQ_? collationName
;
-
+
defaultEncryption
: DEFAULT? ENCRYPTION EQ_? string_
;
-
+
defaultCharset
: DEFAULT? charset EQ_? charsetName
;
-
+
now
: (CURRENT_TIMESTAMP | LOCALTIME | LOCALTIMESTAMP) (LP_ NUMBER_? RP_)?
;
-
+
columnFormat
: FIXED
| DYNAMIC
| DEFAULT
;
-
+
storageMedia
: DISK
| MEMORY
| DEFAULT
;
-
+
direction
: ASC | DESC
;
-
+
keyOrIndex
: KEY | INDEX
;
-
+
fieldLength
: LP_ length=NUMBER_ RP_
;
-
+
characterSet
: charset charsetName
;
-
+
collateClause
: COLLATE (collationName | parameterMarker)
;
-
+
fieldOrVarSpec
: LP_ (userVariable (COMMA_ userVariable)*)? RP_
;
-
+
ifNotExists
: IF NOT EXISTS
;
-
+
ifExists
: IF EXISTS
;
-
+
connectionId
: NUMBER_
;
-
+
labelName
: identifier
;
-
+
cursorName
: identifier
;
-
+
conditionName
: identifier
;
-
+
combineOption
: ALL | DISTINCT
;
-
+
noWriteToBinLog
: LOCAL
| NO_WRITE_TO_BINLOG
;
-
+
channelOption
: FOR CHANNEL string_
;
diff --git a/parser/sql/dialect/mysql/src/main/antlr4/imports/mysql/DALStatement.g4 b/parser/sql/dialect/mysql/src/main/antlr4/imports/mysql/DALStatement.g4
index a4dba5e2080..aab259b1aed 100644
--- a/parser/sql/dialect/mysql/src/main/antlr4/imports/mysql/DALStatement.g4
+++ b/parser/sql/dialect/mysql/src/main/antlr4/imports/mysql/DALStatement.g4
@@ -33,7 +33,7 @@ explain
| explainType? (explainableStatement | FOR CONNECTION connectionId)
| ANALYZE (FORMAT EQ_ TREE)? (select | delete | update | insert))
;
-
+
fromDatabase
: (FROM | IN) databaseName
;
@@ -77,7 +77,7 @@ optionValueNoOptionType
equal
: EQ_ | ASSIGNMENT_
;
-
+
optionValue
: optionType internalVariableName EQ_ setExprOrDefault | optionValueNoOptionType
;
@@ -418,7 +418,7 @@ shutdown
explainType
: (FORMAT EQ_ formatName | EXTENDED | PARTITIONS)
;
-
+
explainableStatement
: select | delete | insert | replace | update
;
@@ -430,7 +430,7 @@ formatName
delimiter
: DELIMITER delimiterName
;
-
+
show
: showDatabases
| showTables
diff --git a/parser/sql/dialect/mysql/src/main/antlr4/imports/mysql/DDLStatement.g4 b/parser/sql/dialect/mysql/src/main/antlr4/imports/mysql/DDLStatement.g4
index e8bca66b1df..7d2fee0ce9b 100644
--- a/parser/sql/dialect/mysql/src/main/antlr4/imports/mysql/DDLStatement.g4
+++ b/parser/sql/dialect/mysql/src/main/antlr4/imports/mysql/DDLStatement.g4
@@ -228,7 +228,7 @@ createDatabaseSpecification_
| defaultCollation
| defaultEncryption
;
-
+
alterDatabaseSpecification_
: createDatabaseSpecification_
| READ ONLY EQ_? (DEFAULT | NUMBER_)
@@ -668,11 +668,11 @@ procedureParameter
fileSizeLiteral
: FILESIZE_LITERAL | numberLiterals
;
-
+
simpleStatement
: validStatement
;
-
+
compoundStatement
: beginStatement
;
@@ -695,21 +695,21 @@ declareStatement
flowControlStatement
: caseStatement | ifStatement | iterateStatement | leaveStatement | loopStatement | repeatStatement | returnStatement | whileStatement
;
-
+
caseStatement
: CASE expr?
(WHEN expr THEN validStatement+)+
(ELSE validStatement+)?
END CASE
;
-
+
ifStatement
: IF expr THEN validStatement+
(ELSEIF expr THEN validStatement+)*
(ELSE validStatement+)?
END IF
;
-
+
iterateStatement
: ITERATE labelName
;
@@ -717,58 +717,58 @@ iterateStatement
leaveStatement
: LEAVE labelName
;
-
+
loopStatement
: (labelName COLON_)? LOOP
validStatement+
END LOOP labelName?
;
-
+
repeatStatement
: (labelName COLON_)? REPEAT
validStatement+
UNTIL expr
END REPEAT labelName?
;
-
+
returnStatement
: RETURN expr
;
-
+
whileStatement
: (labelName COLON_)? WHILE expr DO
validStatement+
END WHILE labelName?
;
-
+
cursorStatement
: cursorCloseStatement | cursorDeclareStatement | cursorFetchStatement | cursorOpenStatement
;
-
+
cursorCloseStatement
: CLOSE cursorName
;
-
+
cursorDeclareStatement
: DECLARE cursorName CURSOR FOR select
;
-
+
cursorFetchStatement
: FETCH ((NEXT)? FROM)? cursorName INTO variable (COMMA_ variable)*
;
-
+
cursorOpenStatement
: OPEN cursorName
;
-
+
conditionHandlingStatement
: declareConditionStatement | declareHandlerStatement | getDiagnosticsStatement | resignalStatement | signalStatement
;
-
+
declareConditionStatement
: DECLARE conditionName CONDITION FOR conditionValue
;
-
+
declareHandlerStatement
: DECLARE handlerAction HANDLER FOR conditionValue (COMMA_ conditionValue)* validStatement
;
@@ -783,11 +783,11 @@ getDiagnosticsStatement
statementInformationItem
: variable EQ_ statementInformationItemName
;
-
+
conditionInformationItem
: variable EQ_ conditionInformationItemName
;
-
+
conditionNumber
: variable | numberLiterals
;
@@ -796,7 +796,7 @@ statementInformationItemName
: NUMBER
| ROW_COUNT
;
-
+
conditionInformationItemName
: CLASS_ORIGIN
| SUBCLASS_ORIGIN
@@ -812,41 +812,41 @@ conditionInformationItemName
| COLUMN_NAME
| CURSOR_NAME
;
-
+
handlerAction
: CONTINUE | EXIT | UNDO
;
-
+
conditionValue
: numberLiterals | SQLSTATE (VALUE)? stringLiterals | conditionName | SQLWARNING | NOT FOUND | SQLEXCEPTION
;
-
+
resignalStatement
: RESIGNAL conditionValue?
(SET signalInformationItem (COMMA_ signalInformationItem)*)?
;
-
+
signalStatement
: SIGNAL conditionValue
(SET signalInformationItem (COMMA_ signalInformationItem)*)?
;
-
+
signalInformationItem
: conditionInformationItemName EQ_ expr
;
-
+
prepare
: PREPARE identifier FROM (stringLiterals | userVariable)
;
-
+
executeStmt
: EXECUTE identifier (USING executeVarList)?
;
-
+
executeVarList
: userVariable (COMMA_ userVariable)*
;
-
+
deallocate
: (DEALLOCATE | DROP) PREPARE identifier
;
diff --git a/parser/sql/dialect/mysql/src/main/antlr4/imports/mysql/DMLStatement.g4 b/parser/sql/dialect/mysql/src/main/antlr4/imports/mysql/DMLStatement.g4
index fae20c6ebe0..e3ffd2c716a 100644
--- a/parser/sql/dialect/mysql/src/main/antlr4/imports/mysql/DMLStatement.g4
+++ b/parser/sql/dialect/mysql/src/main/antlr4/imports/mysql/DMLStatement.g4
@@ -359,7 +359,7 @@ limitClause
limitRowCount
: numberLiterals | parameterMarker
;
-
+
limitOffset
: numberLiterals | parameterMarker
;
diff --git a/parser/sql/dialect/mysql/src/main/antlr4/imports/mysql/Keyword.g4 b/parser/sql/dialect/mysql/src/main/antlr4/imports/mysql/Keyword.g4
index 081f2c5e573..68cdec8445f 100644
--- a/parser/sql/dialect/mysql/src/main/antlr4/imports/mysql/Keyword.g4
+++ b/parser/sql/dialect/mysql/src/main/antlr4/imports/mysql/Keyword.g4
@@ -115,7 +115,7 @@ AUTOCOMMIT
REDO_LOG
: 'REDO_LOG'
;
-
+
DELIMITER
: D E L I M I T E R
;
diff --git a/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/BaseRule.g4 b/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/BaseRule.g4
index e852aa49f8f..abf4c2e63d3 100644
--- a/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/BaseRule.g4
+++ b/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/BaseRule.g4
@@ -121,7 +121,7 @@ identifier
uescape
: UESCAPE STRING_
;
-
+
unreservedWord
: ABORT
| ABSOLUTE
@@ -490,7 +490,7 @@ synonymName
objectName
: (owner DOT_)? identifier
;
-
+
tableName
: (owner DOT_)? name
;
@@ -846,7 +846,7 @@ jsonOperator
| JSONB_PATH_CONTAIN_ANY_VALUE_ # jsonbPathContainAnyValue
| JSONB_PATH_PREDICATE_CHECK_ # jsonbPathPredicateCheck
;
-
+
geometricOperator
: GEOMETRIC_LENGTH_
| GEOMETRIC_DISTANCE_
@@ -1972,11 +1972,11 @@ event
typeNameList
: typeName (COMMA_ typeName)*
;
-
+
ifNotExists
: IF NOT EXISTS
;
-
+
ifExists
: IF EXISTS
;
diff --git a/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/DALStatement.g4 b/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/DALStatement.g4
index 6344fecc527..17ddd22334e 100644
--- a/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/DALStatement.g4
+++ b/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/DALStatement.g4
@@ -127,7 +127,7 @@ valuesClause
vacuum
: VACUUM ((FULL? FREEZE? VERBOSE? ANALYZE?) | (LP_ vacAnalyzeOptionList RP_)) vacuumRelationList?
;
-
+
emptyStatement
:
;
diff --git a/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/DDLStatement.g4 b/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/DDLStatement.g4
index 448463f3a5a..f506aa2fdf7 100644
--- a/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/DDLStatement.g4
+++ b/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/DDLStatement.g4
@@ -852,7 +852,7 @@ alterExtension
createSynonym
: CREATE (OR REPLACE)? SYNONYM synonymName FOR objectName
;
-
+
alterExtensionClauses
: UPDATE alterExtensionOptList
| (ADD | DROP) ACCESS METHOD name
@@ -980,7 +980,7 @@ declare
cursor
: CURSOR cursorName cursorOptions (WITH HOLD | WITHOUT HOLD)? FOR select
;
-
+
cursorOptions
: cursorOption*
;
@@ -1700,7 +1700,7 @@ dropOperatorClass
dropOperatorFamily
: DROP OPERATOR FAMILY ifExists? anyName USING name dropBehavior?
;
-
+
dropOwned
: DROP OWNED BY roleList dropBehavior?
;
@@ -1796,7 +1796,7 @@ move
prepare
: PREPARE name prepTypeClause? AS preparableStmt
;
-
+
deallocate
: DEALLOCATE PREPARE? (name | ALL)
;
@@ -1900,11 +1900,11 @@ schemaStmt
grant
: GRANT (privilegeClause | roleClause)
;
-
+
privilegeClause
: privilegeTypes ON onObjectClause (FROM | TO) granteeList (WITH GRANT OPTION)?
;
-
+
roleClause
: privilegeList (FROM | TO) roleList (WITH ADMIN OPTION)? (GRANTED BY roleSpec)?
;
@@ -1912,7 +1912,7 @@ roleClause
privilegeTypes
: privilegeType columnNames? (COMMA_ privilegeType columnNames?)*
;
-
+
onObjectClause
: DATABASE nameList
| SCHEMA nameList
@@ -1936,11 +1936,11 @@ onObjectClause
| CLIENT_MASTER_KEY nameList
| COLUMN_ENCRYPTION_KEY nameList
;
-
+
numericOnlyList
: numericOnly (COMMA_ numericOnly)*
;
-
+
privilegeLevel
: ASTERISK_ | ASTERISK_ DOT_ASTERISK_ | identifier DOT_ASTERISK_ | tableNames | schemaName DOT_ routineName
;
diff --git a/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/DMLStatement.g4 b/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/DMLStatement.g4
index a25a0658b4a..e97b5950e16 100644
--- a/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/DMLStatement.g4
+++ b/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/DMLStatement.g4
@@ -391,7 +391,7 @@ innerJoinType
outerJoinType
: (FULL | LEFT | RIGHT) OUTER? JOIN
;
-
+
naturalJoinType
: NATURAL INNER? JOIN
| NATURAL (FULL | LEFT | RIGHT) OUTER? JOIN
diff --git a/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/Keyword.g4 b/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/Keyword.g4
index 74997d56eb2..2a69c54c9e5 100644
--- a/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/Keyword.g4
+++ b/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/Keyword.g4
@@ -599,7 +599,7 @@ EXCEPT
PACKAGE
: P A C K A G E
;
-
+
MINUS
: M I N U S
;
diff --git a/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/Literals.g4 b/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/Literals.g4
index 0362d7db881..96243b34aa7 100644
--- a/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/Literals.g4
+++ b/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/Literals.g4
@@ -63,7 +63,7 @@ fragment IdentifierChar
: StrictIdentifierChar
| DOLLAR_
;
-
+
fragment StrictIdentifierChar
: IdentifierStartChar
| [0-9]
diff --git a/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/OpenGaussKeyword.g4 b/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/OpenGaussKeyword.g4
index bd9e06022eb..78f80d3f6b6 100644
--- a/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/OpenGaussKeyword.g4
+++ b/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/OpenGaussKeyword.g4
@@ -1376,7 +1376,7 @@ AUTHORIZATION
VERBOSE
: V E R B O S E
;
-
+
PERFORMANCE
: P E R F O R M A N C E
;
diff --git a/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/BaseRule.g4 b/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/BaseRule.g4
index 6f623a3cd7c..2bde63a09ee 100644
--- a/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/BaseRule.g4
+++ b/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/BaseRule.g4
@@ -73,7 +73,7 @@ hexadecimalLiterals
bitValueLiterals
: BIT_NUM_
;
-
+
booleanLiterals
: TRUE | FALSE
;
@@ -884,7 +884,7 @@ charSet
: NCHAR_CS
| ignoredIdentifier
;
-
+
extractFunction
: EXTRACT LP_ (YEAR | MONTH | DAY | HOUR | MINUTE | SECOND | TIMEZONE_HOUR | TIMEZONE_MINUTE | TIMEZONE_REGION | TIMEZONE_ABBR) FROM expr RP_
;
@@ -972,7 +972,7 @@ dataTypeName
datetimeTypeSuffix
: (WITH LOCAL? TIME ZONE)? | TO MONTH | TO SECOND (LP_ NUMBER_ RP_)?
;
-
+
typeAttribute
: (variableName | objectName) MOD_ TYPE
;
@@ -1804,7 +1804,7 @@ attributeDimensionName
sequenceName
: identifier
;
-
+
spfileName
: STRING_
;
diff --git a/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/DCLStatement.g4 b/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/DCLStatement.g4
index c29c87793e6..cca5ff81677 100644
--- a/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/DCLStatement.g4
+++ b/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/DCLStatement.g4
@@ -58,7 +58,7 @@ systemPrivilegeClause
grantSystemTo
: TO (revokeeGranteeClause | granteeIdentifiedBy) (WITH (ADMIN | DELEGATE) OPTION)?
;
-
+
roleClause
: ignoredIdentifiers
;
diff --git a/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/DDLStatement.g4 b/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/DDLStatement.g4
index 52b570d5968..b956d704c5c 100644
--- a/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/DDLStatement.g4
+++ b/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/DDLStatement.g4
@@ -184,7 +184,7 @@ dropPackage
dropTrigger
: DROP TRIGGER triggerName
;
-
+
dropIndex
: DROP INDEX indexName ONLINE? FORCE? invalidationSpecification? (ON tableName)?
;
@@ -595,7 +595,7 @@ bitmapJoinIndexClause
columnSortsClause_
: LP_? columnSortClause_ (COMMA_ columnSortClause_)* RP_?
;
-
+
columnSortClause_
: (tableName | alias)? columnName (ASC | DESC)?
;
@@ -1817,7 +1817,7 @@ alterDatabaseDictionary
| DELETE CREDENTIALS KEY
)
;
-
+
alterDatabase
: ALTER databaseClauses
( startupClauses
@@ -2636,7 +2636,7 @@ createDatabaseLink
: CREATE SHARED? PUBLIC? DATABASE LINK dbLink
(connectToClause | dbLinkAuthentication)* (USING connectString)?
;
-
+
alterDatabaseLink
: ALTER SHARED? PUBLIC? DATABASE LINK dbLink (
| CONNECT TO username IDENTIFIED BY password dbLinkAuthentication?
@@ -2996,7 +2996,7 @@ createRestorePoint
dropRestorePoint
: DROP RESTORE POINT restorePointName (FOR PLUGGABLE DATABASE pdbName)?
;
-
+
dropOperator
: DROP OPERATOR (schemaName DOT_)? operatorName FORCE?
;
diff --git a/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/Keyword.g4 b/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/Keyword.g4
index 138eb1bb72f..fa46ae24e9a 100644
--- a/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/Keyword.g4
+++ b/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/Keyword.g4
@@ -370,7 +370,7 @@ BOOLEAN
BODY
: B O D Y
;
-
+
DOUBLE
: D O U B L E
;
@@ -463,19 +463,19 @@ SECOND
MICROSECOND
: M I C R O S E C O N D
;
-
+
TIMEZONE_HOUR
: T I M E Z O N E UL_ H O U R
;
-
+
TIMEZONE_MINUTE
: T I M E Z O N E UL_ M I N U T E
;
-
+
TIMEZONE_REGION
: T I M E Z O N E UL_ R E G I O N
;
-
+
TIMEZONE_ABBR
: T I M E Z O N E UL_ A B B R
;
@@ -487,7 +487,7 @@ MAX
MIN
: M I N
;
-
+
SUM
: S U M
;
@@ -503,7 +503,7 @@ AVG
DEFAULT
: D E F A U L T
;
-
+
DEFAULTS
: D E F A U L T S
;
@@ -799,7 +799,7 @@ SHOW
XMLTABLE
: X M L T A B L E
;
-
+
ISSCHEMAVALID
: I S S C H E M A V A L I D
;
@@ -819,15 +819,15 @@ PATH
EXTRACT
: E X T R A C T
;
-
+
ANYDATA
: A N Y D A T A
;
-
+
ANYTYPE
: A N Y T Y P E
;
-
+
ANYDATASET
: A N Y D A T A S E T
;
@@ -843,7 +843,7 @@ WM_CONCAT
DECLARE
: D E C L A R E
;
-
+
BULK
: B U L K
;
@@ -855,55 +855,55 @@ COLLECT
INSERTING
: I N S E R T I N G
;
-
+
UPDATING
: U P D A T I N G
;
-
+
DELETING
: D E L E T I N G
;
-
+
ROWCOUNT
: R O W C O U N T
;
-
+
BULK_ROWCOUNT
: B U L K UL_ R O W C O U N T
;
-
+
RAISE
: R A I S E
;
-
+
WHILE
: W H I L E
;
-
+
GOTO
: G O T O
;
-
+
MUTABLE
: M U T A B L E
;
-
+
IMMUTABLE
: I M M U T A B L E
;
-
+
INDICES
: I N D I C E S
;
-
+
PAIRS
: P A I R S
;
-
+
PIPE
: P I P E
;
-
+
FORALL
: F O R A L L
;
diff --git a/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/OracleKeyword.g4 b/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/OracleKeyword.g4
index 05cf60f028c..d5c1128b5ae 100644
--- a/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/OracleKeyword.g4
+++ b/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/OracleKeyword.g4
@@ -746,7 +746,7 @@ NVARCHAR2
LONG
: L O N G
;
-
+
BLOB
: B L O B
;
diff --git a/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/PLSQL.g4 b/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/PLSQL.g4
index a04651cc7a1..77dc4bb3871 100644
--- a/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/PLSQL.g4
+++ b/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/PLSQL.g4
@@ -422,7 +422,7 @@ exceptionHandler
declareSection
: declareItem+
;
-
+
declareItem
: typeDefinition
| cursorDeclaration
diff --git a/parser/sql/dialect/postgresql/src/main/antlr4/imports/postgresql/BaseRule.g4 b/parser/sql/dialect/postgresql/src/main/antlr4/imports/postgresql/BaseRule.g4
index 3f0834c736b..751ca07f4e0 100644
--- a/parser/sql/dialect/postgresql/src/main/antlr4/imports/postgresql/BaseRule.g4
+++ b/parser/sql/dialect/postgresql/src/main/antlr4/imports/postgresql/BaseRule.g4
@@ -122,7 +122,7 @@ identifier
uescape
: UESCAPE STRING_
;
-
+
unreservedWord
: ABORT
| ABSOLUTE
@@ -816,7 +816,7 @@ jsonOperator
| JSONB_PATH_CONTAIN_ANY_VALUE_ # jsonbPathContainAnyValue
| JSONB_PATH_PREDICATE_CHECK_ # jsonbPathPredicateCheck
;
-
+
geometricOperator
: GEOMETRIC_LENGTH_
| GEOMETRIC_DISTANCE_
diff --git a/parser/sql/dialect/postgresql/src/main/antlr4/imports/postgresql/DALStatement.g4 b/parser/sql/dialect/postgresql/src/main/antlr4/imports/postgresql/DALStatement.g4
index 6951d049729..3ad3e9b6fe0 100644
--- a/parser/sql/dialect/postgresql/src/main/antlr4/imports/postgresql/DALStatement.g4
+++ b/parser/sql/dialect/postgresql/src/main/antlr4/imports/postgresql/DALStatement.g4
@@ -128,7 +128,7 @@ valuesClause
vacuum
: VACUUM ((FULL? FREEZE? VERBOSE? ANALYZE?) | (LP_ vacAnalyzeOptionList RP_)) vacuumRelationList?
;
-
+
emptyStatement
:
;
diff --git a/parser/sql/dialect/postgresql/src/main/antlr4/imports/postgresql/DDLStatement.g4 b/parser/sql/dialect/postgresql/src/main/antlr4/imports/postgresql/DDLStatement.g4
index d8e60f672a8..927d90250e9 100644
--- a/parser/sql/dialect/postgresql/src/main/antlr4/imports/postgresql/DDLStatement.g4
+++ b/parser/sql/dialect/postgresql/src/main/antlr4/imports/postgresql/DDLStatement.g4
@@ -1709,7 +1709,7 @@ dropOperatorClass
dropOperatorFamily
: DROP OPERATOR FAMILY ifExists? anyName USING name dropBehavior?
;
-
+
dropOwned
: DROP OWNED BY roleList dropBehavior?
;
@@ -1958,11 +1958,11 @@ securityLabelClausces
grant
: GRANT (privilegeClause | roleClause)
;
-
+
privilegeClause
: privilegeTypes ON onObjectClause (FROM | TO) granteeList (WITH GRANT OPTION)?
;
-
+
roleClause
: privilegeList (FROM | TO) roleList (WITH ADMIN OPTION)? (GRANTED BY roleSpec)?
;
@@ -1970,7 +1970,7 @@ roleClause
privilegeTypes
: privilegeType columnNames? (COMMA_ privilegeType columnNames?)*
;
-
+
onObjectClause
: DATABASE nameList
| SCHEMA nameList
@@ -1992,11 +1992,11 @@ onObjectClause
| ALL PROCEDURES IN SCHEMA nameList
| ALL ROUTINES IN SCHEMA nameList
;
-
+
numericOnlyList
: numericOnly (COMMA_ numericOnly)*
;
-
+
privilegeLevel
: ASTERISK_ | ASTERISK_ DOT_ASTERISK_ | identifier DOT_ASTERISK_ | tableNames | schemaName DOT_ routineName
;
diff --git a/parser/sql/dialect/postgresql/src/main/antlr4/imports/postgresql/DMLStatement.g4 b/parser/sql/dialect/postgresql/src/main/antlr4/imports/postgresql/DMLStatement.g4
index 1a10b345948..60570045b65 100644
--- a/parser/sql/dialect/postgresql/src/main/antlr4/imports/postgresql/DMLStatement.g4
+++ b/parser/sql/dialect/postgresql/src/main/antlr4/imports/postgresql/DMLStatement.g4
@@ -399,7 +399,7 @@ innerJoinType
outerJoinType
: (FULL | LEFT | RIGHT) OUTER? JOIN
;
-
+
naturalJoinType
: NATURAL INNER? JOIN
| NATURAL (FULL | LEFT | RIGHT) OUTER? JOIN
diff --git a/parser/sql/dialect/postgresql/src/main/antlr4/imports/postgresql/Literals.g4 b/parser/sql/dialect/postgresql/src/main/antlr4/imports/postgresql/Literals.g4
index 171981b64a6..f66af87cce3 100644
--- a/parser/sql/dialect/postgresql/src/main/antlr4/imports/postgresql/Literals.g4
+++ b/parser/sql/dialect/postgresql/src/main/antlr4/imports/postgresql/Literals.g4
@@ -47,7 +47,7 @@ fragment INT_
fragment HEX_
: [0-9a-fA-F]
;
-
+
fragment IDENTIFIER_START_CHAR
: [a-zA-Z_]
| [\u00AA\u00B5\u00BA\u00C0-\u00D6\u00D8-\u00F6\u00F8-\u00FF]
@@ -59,12 +59,12 @@ fragment IDENTIFIER_CHAR
: STRICT_IDENTIFIER_CHAR
| DOLLAR_
;
-
+
fragment STRICT_IDENTIFIER_CHAR
: IDENTIFIER_START_CHAR
| [0-9]
;
-
+
DEFAULT_DOES_NOT_MATCH_ANYTHING
: 'Default does not match anything'
;
diff --git a/parser/sql/dialect/postgresql/src/main/antlr4/imports/postgresql/ModeLexer.g4 b/parser/sql/dialect/postgresql/src/main/antlr4/imports/postgresql/ModeLexer.g4
index 773526b38d2..5bc78e1fb90 100644
--- a/parser/sql/dialect/postgresql/src/main/antlr4/imports/postgresql/ModeLexer.g4
+++ b/parser/sql/dialect/postgresql/src/main/antlr4/imports/postgresql/ModeLexer.g4
@@ -23,11 +23,11 @@ BEGIN_DOLLAR_STRING_CONSTANT
: '$' TAG? '$'
{pushTag();} -> pushMode (DOLLAR_QUOTED_STRING_MODE)
;
-
+
fragment TAG
: IDENTIFIER_START_CHAR STRICT_IDENTIFIER_CHAR*
;
-
+
mode DOLLAR_QUOTED_STRING_MODE;
DOLLAR_TEXT
: ~ '$'+
diff --git a/parser/sql/dialect/postgresql/src/main/antlr4/imports/postgresql/PostgreSQLKeyword.g4 b/parser/sql/dialect/postgresql/src/main/antlr4/imports/postgresql/PostgreSQLKeyword.g4
index 1177b2f5b45..2150b4ed1c7 100644
--- a/parser/sql/dialect/postgresql/src/main/antlr4/imports/postgresql/PostgreSQLKeyword.g4
+++ b/parser/sql/dialect/postgresql/src/main/antlr4/imports/postgresql/PostgreSQLKeyword.g4
@@ -142,7 +142,7 @@ COLLATE
COMMENTS
: C O M M E N T S
;
-
+
COMPRESSION
: C O M P R E S S I O N
;
@@ -154,7 +154,7 @@ CONCURRENTLY
FINALIZE
: F I N A L I Z E
;
-
+
CONNECT
: C O N N E C T
;
diff --git a/parser/sql/dialect/presto/src/main/antlr4/imports/presto/BaseRule.g4 b/parser/sql/dialect/presto/src/main/antlr4/imports/presto/BaseRule.g4
index e472b6b53aa..e9097a67281 100644
--- a/parser/sql/dialect/presto/src/main/antlr4/imports/presto/BaseRule.g4
+++ b/parser/sql/dialect/presto/src/main/antlr4/imports/presto/BaseRule.g4
@@ -22,7 +22,7 @@ import Symbol, Keyword, PrestoKeyword, Literals;
parameterMarker
: QUESTION_
;
-
+
customKeyword
: MAX
| MIN
@@ -56,7 +56,7 @@ customKeyword
| UTC_TIMESTAMP
| UTC_TIMESTAMP
;
-
+
literals
: stringLiterals
| numberLiterals
@@ -66,43 +66,43 @@ literals
| booleanLiterals
| nullValueLiterals
;
-
+
string_
: DOUBLE_QUOTED_TEXT | SINGLE_QUOTED_TEXT
;
-
+
stringLiterals
: (UNDERSCORE_CHARSET | UL_BINARY )? string_ | NCHAR_TEXT
;
-
+
numberLiterals
: (PLUS_ | MINUS_)? NUMBER_
;
-
+
temporalLiterals
: (DATE | TIME | TIMESTAMP) SINGLE_QUOTED_TEXT
;
-
+
hexadecimalLiterals
: UNDERSCORE_CHARSET? HEX_DIGIT_ collateClause?
;
-
+
bitValueLiterals
: UNDERSCORE_CHARSET? BIT_NUM_ collateClause?
;
-
+
booleanLiterals
: TRUE | FALSE
;
-
+
nullValueLiterals
: NULL
;
-
+
collationName
: textOrIdentifier | BINARY
;
-
+
identifier
: IDENTIFIER_
| identifierKeywordsUnambiguous
@@ -115,7 +115,7 @@ identifier
| UNDERSCORE_CHARSET
| BQUOTA_STRING
;
-
+
identifierKeywordsUnambiguous
: ACTION
| ACCOUNT
@@ -510,13 +510,13 @@ identifierKeywordsUnambiguous
| YEAR
| YEAR_MONTH
;
-
+
identifierKeywordsAmbiguous1RolesAndLabels
: EXECUTE
| RESTART
| SHUTDOWN
;
-
+
identifierKeywordsAmbiguous2Labels
: ASCII
| BEGIN
@@ -554,7 +554,7 @@ identifierKeywordsAmbiguous2Labels
| UNINSTALL
| XA
;
-
+
identifierKeywordsAmbiguous3Roles
: EVENT
| FILE
@@ -566,7 +566,7 @@ identifierKeywordsAmbiguous3Roles
| RESOURCE
| SUPER
;
-
+
identifierKeywordsAmbiguous4SystemVariables
: GLOBAL
| LOCAL
@@ -586,76 +586,76 @@ ipAddress
variable
: userVariable | systemVariable
;
-
+
userVariable
: AT_ textOrIdentifier
| textOrIdentifier
;
-
+
systemVariable
: AT_ AT_ (systemVariableScope=(GLOBAL | SESSION | LOCAL) DOT_)? rvalueSystemVariable
;
-
+
rvalueSystemVariable
: textOrIdentifier
| textOrIdentifier DOT_ identifier
;
-
+
setSystemVariable
: AT_ AT_ (optionType DOT_)? internalVariableName
;
-
+
optionType
: GLOBAL | PERSIST | PERSIST_ONLY | SESSION | LOCAL
;
-
+
internalVariableName
: identifier
| DEFAULT DOT_ identifier
| identifier DOT_ identifier
;
-
+
setExprOrDefault
: expr | DEFAULT | ALL | ON | BINARY | ROW | SYSTEM
;
-
+
transactionCharacteristics
: transactionAccessMode (COMMA_ isolationLevel)?
| isolationLevel (COMMA_ transactionAccessMode)?
;
-
+
isolationLevel
: ISOLATION LEVEL isolationTypes
;
-
+
isolationTypes
: REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED | SERIALIZABLE
;
-
+
transactionAccessMode
: READ (WRITE | ONLY)
;
-
+
schemaName
: identifier
;
-
+
schemaNames
: schemaName (COMMA_ schemaName)*
;
-
+
charsetName
: textOrIdentifier | BINARY | DEFAULT
;
-
+
schemaPairs
: schemaPair (COMMA_ schemaPair)*
;
-
+
schemaPair
: LP_ schemaName COMMA_ schemaName RP_
;
-
+
tableName
: ((databaseName DOT_)? owner DOT_)? name
;
@@ -663,11 +663,11 @@ tableName
databaseName
: identifier
;
-
+
columnName
: identifier
;
-
+
indexName
: identifier
;
@@ -691,23 +691,23 @@ delimiterName
userIdentifierOrText
: textOrIdentifier (AT_ textOrIdentifier)?
;
-
+
username
: userIdentifierOrText | CURRENT_USER (LP_ RP_)?
;
-
+
eventName
: (owner DOT_)? identifier
;
-
+
serverName
: textOrIdentifier
;
-
+
wrapperName
: textOrIdentifier
;
-
+
functionName
: (owner DOT_)? identifier
;
@@ -719,123 +719,123 @@ procedureName
viewName
: (owner DOT_)? identifier
;
-
+
owner
: identifier
;
-
+
alias
: textOrIdentifier
;
-
+
name
: identifier
;
-
+
tableList
: tableName (COMMA_ tableName)*
;
-
+
viewNames
: viewName (COMMA_ viewName)*
;
-
+
columnNames
: columnName (COMMA_ columnName)*
;
-
+
groupName
: identifier
;
-
+
routineName
: identifier
;
-
+
shardLibraryName
: stringLiterals
;
-
+
componentName
: string_
;
-
+
pluginName
: textOrIdentifier
;
-
+
hostname
: string_
;
-
+
port
: NUMBER_
;
-
+
cloneInstance
: username AT_ hostname COLON_ port
;
-
+
cloneDir
: string_
;
-
+
channelName
: identifier (DOT_ identifier)?
;
-
+
logName
: stringLiterals
;
-
+
roleName
: roleIdentifierOrText (AT_ textOrIdentifier)?
;
-
+
roleIdentifierOrText
: identifier | string_
;
-
+
engineRef
: textOrIdentifier
;
-
+
triggerName
: identifier (DOT_ identifier)?
;
-
+
triggerTime
: BEFORE | AFTER
;
-
+
tableOrTables
: TABLE | TABLES
;
-
+
userOrRole
: username | roleName
;
-
+
partitionName
: identifier
;
-
+
identifierList
: identifier (COMMA_ identifier)*
;
-
+
allOrPartitionNameList
: ALL | identifierList
;
-
+
triggerEvent
: INSERT | UPDATE | DELETE
;
-
+
triggerOrder
: (FOLLOWS | PRECEDES) triggerName
;
-
+
expr
: booleanPrimary
| expr andOperator expr
@@ -844,19 +844,19 @@ expr
| notOperator expr
| LP_ expr RP_
;
-
+
andOperator
: AND | AND_
;
-
+
orOperator
: OR | OR_
;
-
+
notOperator
: NOT | NOT_
;
-
+
booleanPrimary
: booleanPrimary IS NOT? (TRUE | FALSE | UNKNOWN | NULL)
| booleanPrimary SAFE_EQ_ predicate
@@ -866,15 +866,15 @@ booleanPrimary
| booleanPrimary assignmentOperator predicate
| predicate
;
-
+
assignmentOperator
: EQ_ | ASSIGNMENT_
;
-
+
comparisonOperator
: EQ_ | GTE_ | GT_ | LTE_ | LT_ | NEQ_
;
-
+
predicate
: bitExpr NOT? IN subquery
| bitExpr NOT? IN LP_ expr (COMMA_ expr)* RP_
@@ -884,7 +884,7 @@ predicate
| bitExpr NOT? (REGEXP | RLIKE) bitExpr
| bitExpr
;
-
+
bitExpr
: bitExpr VERTICAL_BAR_ bitExpr
| bitExpr AMPERSAND_ bitExpr
@@ -903,7 +903,7 @@ bitExpr
| LP_ bitExpr RP_
| simpleExpr
;
-
+
simpleExpr
: functionCall
| parameterMarker
@@ -921,7 +921,7 @@ simpleExpr
| caseExpression
| intervalExpression
;
-
+
path
: string_
;
@@ -929,15 +929,15 @@ path
onEmptyError
: (NULL | ERROR | DEFAULT literals) ON (EMPTY | ERROR)
;
-
+
columnRef
: identifier (DOT_ identifier)? (DOT_ identifier)?
;
-
+
columnRefList
: columnRef (COMMA_ columnRef)*
;
-
+
functionCall
: aggregationFunction | specialFunction | regularFunction | jsonFunction | udfFunction
;
@@ -966,35 +966,35 @@ jsonFunctionName
aggregationFunctionName
: MAX | MIN | SUM | COUNT | AVG | BIT_XOR
;
-
+
distinct
: DISTINCT
;
-
+
overClause
: OVER (windowSpecification | identifier)
;
-
+
windowSpecification
: LP_ identifier? (PARTITION BY expr (COMMA_ expr)*)? orderByClause? frameClause? RP_
;
-
+
frameClause
: (ROWS | RANGE) (frameStart | frameBetween)
;
-
+
frameStart
: CURRENT ROW | UNBOUNDED PRECEDING | UNBOUNDED FOLLOWING | expr PRECEDING | expr FOLLOWING
;
-
+
frameEnd
: frameStart
;
-
+
frameBetween
: BETWEEN frameStart AND frameEnd
;
-
+
specialFunction
: groupConcatFunction | windowFunction | castFunction | convertFunction | positionFunction | substringFunction | extractFunction
| charFunction | trimFunction | weightStringFunction | valuesFunction | currentUserFunction | indexFunction | timezoneFunction
@@ -1013,7 +1013,7 @@ mapFunction
arrayFunction
: ARRAY LBT_ expr (COMMA_ expr)* RBT_
;
-
+
timezoneFunction
: TIMEZONE_HOUR LP_ TIMESTAMP string_ AT TIME ZONE string_ RP_
| TIMEZONE_MINUTE LP_ TIMESTAMP string_ AT TIME ZONE string_ RP_
@@ -1026,11 +1026,11 @@ indexFunction
currentUserFunction
: CURRENT_USER (LP_ RP_)?
;
-
+
groupConcatFunction
: GROUP_CONCAT LP_ distinct? (expr (COMMA_ expr)* | ASTERISK_)? (orderByClause)? (SEPARATOR expr)? RP_
;
-
+
windowFunction
: funcName = (ROW_NUMBER | RANK | DENSE_RANK | CUME_DIST | PERCENT_RANK) LP_ RP_ windowingClause
| funcName = NTILE LP_ NUMBER_ RP_ windowingClause
@@ -1038,27 +1038,27 @@ windowFunction
| funcName = (FIRST_VALUE | LAST_VALUE) LP_ expr RP_ nullTreatment? windowingClause
| funcName = NTH_VALUE LP_ expr COMMA_ simpleExpr RP_ (FROM (FIRST | LAST))? nullTreatment? windowingClause
;
-
+
windowingClause
: OVER (windowName=identifier | windowSpecification)
;
-
+
leadLagInfo
: COMMA_ (NUMBER_ | QUESTION_) (COMMA_ expr)?
;
-
+
nullTreatment
: (RESPECT | IGNORE) NULLS
;
-
+
checkType
: FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED
;
-
+
repairType
: QUICK | EXTENDED | USE_FRM
;
-
+
castFunction
: (CAST | TRY_CAST) LP_ expr AS castType ARRAY? RP_
| (CAST | TRY_CAST) LP_ expr AS expr ARRAY? RP_
@@ -1069,7 +1069,7 @@ convertFunction
: CONVERT LP_ expr COMMA_ castType RP_
| CONVERT LP_ expr USING charsetName RP_
;
-
+
castType
: castTypeName = BINARY fieldLength?
| castTypeName = CHAR fieldLength? charsetWithOptBinary?
@@ -1091,58 +1091,58 @@ castType
| castTypeName = BIGINT
| castTypeName = INTEGER
;
-
+
positionFunction
: POSITION LP_ expr IN expr RP_
;
-
+
substringFunction
: (SUBSTRING | SUBSTR) LP_ expr FROM NUMBER_ (FOR NUMBER_)? RP_
| (SUBSTRING | SUBSTR) LP_ expr COMMA_ NUMBER_ (COMMA_ NUMBER_)? RP_
;
-
+
extractFunction
: EXTRACT LP_ identifier FROM expr RP_
;
-
+
charFunction
: CHAR LP_ expr (COMMA_ expr)* (USING charsetName)? RP_
;
-
+
trimFunction
: TRIM LP_ ((LEADING | BOTH | TRAILING) expr? FROM)? expr RP_
| TRIM LP_ (expr FROM)? expr RP_
;
-
+
valuesFunction
: VALUES LP_ columnRefList RP_
;
-
+
weightStringFunction
: WEIGHT_STRING LP_ expr (AS dataType)? levelClause? RP_
;
-
+
levelClause
: LEVEL (levelInWeightListElement (COMMA_ levelInWeightListElement)* | NUMBER_ MINUS_ NUMBER_)
;
-
+
levelInWeightListElement
: NUMBER_ direction? REVERSE?
;
-
+
regularFunction
: completeRegularFunction
| shorthandRegularFunction
;
-
+
shorthandRegularFunction
: CURRENT_DATE | CURRENT_TIME (LP_ NUMBER_? RP_)? | CURRENT_TIMESTAMP | LAST_DAY | LOCALTIME | LOCALTIMESTAMP
;
-
+
completeRegularFunction
: regularFunctionName (LP_ distinct? (expr (COMMA_ expr)* | ASTERISK_)? RP_)
;
-
+
regularFunctionName
: IF | LOCALTIME | LOCALTIMESTAMP | REPLACE | INSERT | INTERVAL | MOD
| DATABASE | SCHEMA | LEFT | RIGHT | DATE | DAY | GEOMETRYCOLLECTION | REPEAT
@@ -1150,57 +1150,57 @@ regularFunctionName
| TIME | TIMESTAMP | TIMESTAMP_ADD | TIMESTAMP_DIFF | DATE | CURRENT_TIMESTAMP
| CURRENT_DATE | CURRENT_TIME | UTC_TIMESTAMP | identifier
;
-
+
matchExpression
: MATCH (columnRefList | LP_ columnRefList RP_ ) AGAINST LP_ expr matchSearchModifier? RP_
;
-
+
matchSearchModifier
: IN NATURAL LANGUAGE MODE | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION | IN BOOLEAN MODE | WITH QUERY EXPANSION
;
-
+
caseExpression
: CASE simpleExpr? caseWhen+ caseElse? END
;
-
+
datetimeExpr
: expr
;
-
+
binaryLogFileIndexNumber
: NUMBER_
;
-
+
caseWhen
: WHEN expr THEN expr
;
-
+
caseElse
: ELSE expr
;
-
+
intervalExpression
: INTERVAL intervalValue
;
-
+
intervalValue
: expr intervalUnit
;
-
+
intervalUnit
: MICROSECOND | SECOND | MINUTE | HOUR | DAY | WEEK | MONTH
| QUARTER | YEAR | SECOND_MICROSECOND | MINUTE_MICROSECOND | MINUTE_SECOND | HOUR_MICROSECOND | HOUR_SECOND
| HOUR_MINUTE | DAY_MICROSECOND | DAY_SECOND | DAY_MINUTE | DAY_HOUR | YEAR_MONTH
;
-
+
subquery
: 'refer subquery in DMStement.g4'
;
-
+
orderByClause
: ORDER BY orderByItem (COMMA_ orderByItem)*
;
-
+
orderByItem
: (numberLiterals | expr) direction?
;
@@ -1246,33 +1246,33 @@ dataType
| dataTypeName = ROW LP_ columnDefinition (COMMA_ columnDefinition)* RP_
| dataTypeName = (SERIAL | JSON | GEOMETRY | GEOMCOLLECTION | GEOMETRYCOLLECTION | POINT | MULTIPOINT | LINESTRING | MULTILINESTRING | POLYGON | MULTIPOLYGON)
;
-
+
stringList
: LP_ textString (COMMA_ textString)* RP_
;
-
+
textString
: string_
| HEX_DIGIT_
| BIT_NUM_
;
-
+
textStringHash
: string_ | HEX_DIGIT_
;
-
+
fieldOptions
: (UNSIGNED | SIGNED | ZEROFILL)+
;
-
+
precision
: LP_ NUMBER_ COMMA_ NUMBER_ RP_
;
-
+
typeDatetimePrecision
: LP_ NUMBER_ RP_
;
-
+
charsetWithOptBinary
: ascii
| unicode
@@ -1280,107 +1280,107 @@ charsetWithOptBinary
| charset charsetName BINARY?
| BINARY (charset charsetName)?
;
-
+
ascii
: ASCII BINARY?
| BINARY ASCII
;
-
+
unicode
: UNICODE BINARY?
| BINARY UNICODE
;
-
+
charset
: (CHAR | CHARACTER) SET
| CHARSET
;
-
+
defaultCollation
: DEFAULT? COLLATE EQ_? collationName
;
-
+
defaultEncryption
: DEFAULT? ENCRYPTION EQ_? string_
;
-
+
defaultCharset
: DEFAULT? charset EQ_? charsetName
;
-
+
now
: (CURRENT_TIMESTAMP | LOCALTIME | LOCALTIMESTAMP) (LP_ NUMBER_? RP_)?
;
-
+
columnFormat
: FIXED
| DYNAMIC
| DEFAULT
;
-
+
storageMedia
: DISK
| MEMORY
| DEFAULT
;
-
+
direction
: ASC | DESC
;
-
+
keyOrIndex
: KEY | INDEX
;
-
+
fieldLength
: LP_ length=NUMBER_ RP_
;
-
+
characterSet
: charset charsetName
;
-
+
collateClause
: COLLATE (collationName | parameterMarker)
;
-
+
fieldOrVarSpec
: LP_ (identifier (COMMA_ identifier)*)? RP_
;
-
+
ifNotExists
: IF NOT EXISTS
;
-
+
ifExists
: IF EXISTS
;
-
+
connectionId
: NUMBER_
;
-
+
labelName
: identifier
;
-
+
cursorName
: identifier
;
-
+
conditionName
: identifier
;
-
+
combineOption
: ALL | DISTINCT
;
-
+
noWriteToBinLog
: LOCAL
| NO_WRITE_TO_BINLOG
;
-
+
channelOption
: FOR CHANNEL string_
;
diff --git a/parser/sql/dialect/presto/src/main/antlr4/imports/presto/DALStatement.g4 b/parser/sql/dialect/presto/src/main/antlr4/imports/presto/DALStatement.g4
index 1a8c369ef54..f1575fcf9b9 100644
--- a/parser/sql/dialect/presto/src/main/antlr4/imports/presto/DALStatement.g4
+++ b/parser/sql/dialect/presto/src/main/antlr4/imports/presto/DALStatement.g4
@@ -23,7 +23,7 @@ explain
: DESCRIBE tableName
| ANALYZE tableName
;
-
+
fromSchema
: (FROM | IN) (owner DOT_)? schemaName
;
diff --git a/parser/sql/dialect/presto/src/main/antlr4/imports/presto/DMLStatement.g4 b/parser/sql/dialect/presto/src/main/antlr4/imports/presto/DMLStatement.g4
index dd2e016a38c..b02cd0835e5 100644
--- a/parser/sql/dialect/presto/src/main/antlr4/imports/presto/DMLStatement.g4
+++ b/parser/sql/dialect/presto/src/main/antlr4/imports/presto/DMLStatement.g4
@@ -279,7 +279,7 @@ limitClause
limitRowCount
: numberLiterals | parameterMarker
;
-
+
limitOffset
: numberLiterals | parameterMarker
;
diff --git a/parser/sql/dialect/presto/src/main/antlr4/imports/presto/Keyword.g4 b/parser/sql/dialect/presto/src/main/antlr4/imports/presto/Keyword.g4
index ca4d4e120f4..c8d3cdef4ee 100644
--- a/parser/sql/dialect/presto/src/main/antlr4/imports/presto/Keyword.g4
+++ b/parser/sql/dialect/presto/src/main/antlr4/imports/presto/Keyword.g4
@@ -122,7 +122,7 @@ INNODB
REDO_LOG
: 'REDO_LOG'
;
-
+
DELIMITER
: D E L I M I T E R
;
diff --git a/parser/sql/dialect/sql92/src/main/antlr4/imports/sql92/BaseRule.g4 b/parser/sql/dialect/sql92/src/main/antlr4/imports/sql92/BaseRule.g4
index f511b157eea..6d3d1da193a 100644
--- a/parser/sql/dialect/sql92/src/main/antlr4/imports/sql92/BaseRule.g4
+++ b/parser/sql/dialect/sql92/src/main/antlr4/imports/sql92/BaseRule.g4
@@ -53,7 +53,7 @@ hexadecimalLiterals
bitValueLiterals
: characterSetName? BIT_NUM_ collateClause?
;
-
+
booleanLiterals
: TRUE | FALSE
;
@@ -140,7 +140,7 @@ expr
andOperator
: AND | AND_
;
-
+
orOperator
: OR
;
diff --git a/parser/sql/dialect/sql92/src/main/antlr4/imports/sql92/DMLStatement.g4 b/parser/sql/dialect/sql92/src/main/antlr4/imports/sql92/DMLStatement.g4
index 97707d9110a..e837c4e5fdd 100644
--- a/parser/sql/dialect/sql92/src/main/antlr4/imports/sql92/DMLStatement.g4
+++ b/parser/sql/dialect/sql92/src/main/antlr4/imports/sql92/DMLStatement.g4
@@ -153,7 +153,7 @@ limitClause
limitRowCount
: numberLiterals | parameterMarker
;
-
+
limitOffset
: numberLiterals | parameterMarker
;
diff --git a/parser/sql/dialect/sql92/src/main/antlr4/imports/sql92/Keyword.g4 b/parser/sql/dialect/sql92/src/main/antlr4/imports/sql92/Keyword.g4
index 9cd7b9035cf..68694fc391e 100644
--- a/parser/sql/dialect/sql92/src/main/antlr4/imports/sql92/Keyword.g4
+++ b/parser/sql/dialect/sql92/src/main/antlr4/imports/sql92/Keyword.g4
@@ -430,7 +430,7 @@ MAX
MIN
: M I N
;
-
+
SUM
: S U M
;