You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by pa...@apache.org on 2020/06/20 08:03:01 UTC

[shardingsphere] branch master updated: format pg g4 file (#6139)

This is an automated email from the ASF dual-hosted git repository.

panjuan 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 9fa2801  format pg g4 file (#6139)
9fa2801 is described below

commit 9fa280199d8aef3a31bc3c583b2b46e9a69f06cd
Author: JingShang Lu <ji...@gmail.com>
AuthorDate: Sat Jun 20 16:02:46 2020 +0800

    format pg g4 file (#6139)
---
 .../src/main/antlr4/imports/postgresql/BaseRule.g4 | 1420 ++++++++++----------
 .../main/antlr4/imports/postgresql/DMLStatement.g4 |   10 +-
 2 files changed, 715 insertions(+), 715 deletions(-)

diff --git a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/antlr4/imports/postgresql/BaseRule.g4 b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/antlr4/imports/postgresql/BaseRule.g4
index 1284173..23e960f 100644
--- a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/antlr4/imports/postgresql/BaseRule.g4
+++ b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/antlr4/imports/postgresql/BaseRule.g4
@@ -23,85 +23,85 @@ parameterMarker
     : QUESTION_ literalsType_?
     ;
 
-reserved_keyword
+reservedKeyword
     : ALL
-	| ANALYSE
-	| ANALYZE
-	| AND
-	| ANY
-	| ARRAY
-	| AS
-	| ASC
-	| ASYMMETRIC
-	| BOTH
-	| CASE
-	| CAST
-	| CHECK
-	| COLLATE
-	| COLUMN
-	| CONSTRAINT
-	| CREATE
-	| CURRENT_CATALOG
-	| CURRENT_DATE
-	| CURRENT_ROLE
-	| CURRENT_TIME
-	| CURRENT_TIMESTAMP
-	| CURRENT_USER
-	| DEFAULT
-	| DEFERRABLE
-	| DESC
-	| DISTINCT
-	| DO
-	| ELSE
-	| END
-	| EXCEPT
-	| FALSE
-	| FETCH
-	| FOR
-	| FOREIGN
-	| FROM
-	| GRANT
-	| GROUP
-	| HAVING
-	| IN
-	| INITIALLY
-	| INTERSECT
-	| INTO
-	| LATERAL
-	| LEADING
-	| LIMIT
-	| LOCALTIME
-	| LOCALTIMESTAMP
-	| NOT
-	| NULL
-	| OFFSET
-	| ON
-	| ONLY
-	| OR
-	| ORDER
-	| PLACING
-	| PRIMARY
-	| REFERENCES
-	| RETURNING
-	| SELECT
-	| SESSION_USER
-	| SOME
-	| SYMMETRIC
-	| TABLE
-	| THEN
-	| TO
-	| TRAILING
-	| TRUE
-	| UNION
-	| UNIQUE
-	| USER
-	| USING
-	| VARIADIC
-	| WHEN
-	| WHERE
-	| WINDOW
-	| WITH
-	;
+    | ANALYSE
+    | ANALYZE
+    | AND
+    | ANY
+    | ARRAY
+    | AS
+    | ASC
+    | ASYMMETRIC
+    | BOTH
+    | CASE
+    | CAST
+    | CHECK
+    | COLLATE
+    | COLUMN
+    | CONSTRAINT
+    | CREATE
+    | CURRENT_CATALOG
+    | CURRENT_DATE
+    | CURRENT_ROLE
+    | CURRENT_TIME
+    | CURRENT_TIMESTAMP
+    | CURRENT_USER
+    | DEFAULT
+    | DEFERRABLE
+    | DESC
+    | DISTINCT
+    | DO
+    | ELSE
+    | END
+    | EXCEPT
+    | FALSE
+    | FETCH
+    | FOR
+    | FOREIGN
+    | FROM
+    | GRANT
+    | GROUP
+    | HAVING
+    | IN
+    | INITIALLY
+    | INTERSECT
+    | INTO
+    | LATERAL
+    | LEADING
+    | LIMIT
+    | LOCALTIME
+    | LOCALTIMESTAMP
+    | NOT
+    | NULL
+    | OFFSET
+    | ON
+    | ONLY
+    | OR
+    | ORDER
+    | PLACING
+    | PRIMARY
+    | REFERENCES
+    | RETURNING
+    | SELECT
+    | SESSION_USER
+    | SOME
+    | SYMMETRIC
+    | TABLE
+    | THEN
+    | TO
+    | TRAILING
+    | TRUE
+    | UNION
+    | UNIQUE
+    | USER
+    | USING
+    | VARIADIC
+    | WHEN
+    | WHERE
+    | WINDOW
+    | WITH
+    ;
 
 numberLiterals
    : MINUS_? NUMBER_ literalsType_?
@@ -125,331 +125,331 @@ uescape_
     
 unreservedWord
     : ABORT
-	| ABSOLUTE
-	| ACCESS
-	| ACTION
-	| ADD
-	| ADMIN
-	| AFTER
-	| AGGREGATE
-	| ALSO
-	| ALTER
-	| ALWAYS
-	| ASSERTION
-	| ASSIGNMENT
-	| AT
-	| ATTACH
-	| ATTRIBUTE
-	| BACKWARD
-	| BEFORE
-	| BEGIN
-	| BY
-	| CACHE
-	| CALL
-	| CALLED
-	| CASCADE
-	| CASCADED
-	| CATALOG
-	| CHAIN
-	| CHARACTERISTICS
-	| CHECKPOINT
-	| CLASS
-	| CLOSE
-	| CLUSTER
-	| COLUMNS
-	| COMMENT
-	| COMMENTS
-	| COMMIT
-	| COMMITTED
-	| CONFIGURATION
-	| CONFLICT
-	| CONNECTION
-	| CONSTRAINTS
-	| CONTENT
-	| CONTINUE
-	| CONVERSION
-	| COPY
-	| COST
-	| CSV
-	| CUBE
-	| CURRENT
-	| CURSOR
-	| CYCLE
-	| DATA
-	| DATABASE
-	| DAY
-	| DEALLOCATE
-	| DECLARE
-	| DEFAULTS
-	| DEFERRED
-	| DEFINER
-	| DELETE
-	| DELIMITER
-	| DELIMITERS
-	| DEPENDS
-	| DETACH
-	| DICTIONARY
-	| DISABLE
-	| DISCARD
-	| DOCUMENT
-	| DOMAIN
-	| DOUBLE
-	| DROP
-	| EACH
-	| ENABLE
-	| ENCODING
-	| ENCRYPTED
-	| ENUM
-	| ESCAPE
-	| EVENT
-	| EXCLUDE
-	| EXCLUDING
-	| EXCLUSIVE
-	| EXECUTE
-	| EXPLAIN
-	| EXPRESSION
-	| EXTENSION
-	| EXTERNAL
-	| FAMILY
-	| FILTER
-	| FIRST
-	| FOLLOWING
-	| FORCE
-	| FORWARD
-	| FUNCTION
-	| FUNCTIONS
-	| GENERATED
-	| GLOBAL
-	| GRANTED
-	| GROUPS
-	| HANDLER
-	| HEADER
-	| HOLD
-	| HOUR
-	| IDENTITY
-	| IF
-	| IMMEDIATE
-	| IMMUTABLE
-	| IMPLICIT
-	| IMPORT
-	| INCLUDE
-	| INCLUDING
-	| INCREMENT
-	| INDEX
-	| INDEXES
-	| INHERIT
-	| INHERITS
-	| INLINE
-	| INPUT
-	| INSENSITIVE
-	| INSERT
-	| INSTEAD
-	| INVOKER
-	| ISOLATION
-	| KEY
-	| LABEL
-	| LANGUAGE
-	| LARGE
-	| LAST
-	| LEAKPROOF
-	| LEVEL
-	| LISTEN
-	| LOAD
-	| LOCAL
-	| LOCATION
-	| LOCK
-	| LOCKED
-	| LOGGED
-	| MAPPING
-	| MATCH
-	| MATERIALIZED
-	| MAXVALUE
-	| METHOD
-	| MINUTE
-	| MINVALUE
-	| MODE
-	| MONTH
-	| MOVE
-	| NAME
-	| NAMES
-	| NEW
-	| NEXT
-	| NFC
-	| NFD
-	| NFKC
-	| NFKD
-	| NO
-	| NORMALIZED
-	| NOTHING
-	| NOTIFY
-	| NOWAIT
-	| NULLS
-	| OBJECT
-	| OF
-	| OFF
-	| OIDS
-	| OLD
-	| OPERATOR
-	| OPTION
-	| OPTIONS
-	| ORDINALITY
-	| OTHERS
-	| OVER
-	| OVERRIDING
-	| OWNED
-	| OWNER
-	| PARALLEL
-	| PARSER
-	| PARTIAL
-	| PARTITION
-	| PASSING
-	| PASSWORD
-	| PLANS
-	| POLICY
-	| PRECEDING
-	| PREPARE
-	| PREPARED
-	| PRESERVE
-	| PRIOR
-	| PRIVILEGES
-	| PROCEDURAL
-	| PROCEDURE
-	| PROCEDURES
-	| PROGRAM
-	| PUBLICATION
-	| QUOTE
-	| RANGE
-	| READ
-	| REASSIGN
-	| RECHECK
-	| RECURSIVE
-	| REF
-	| REFERENCING
-	| REFRESH
-	| REINDEX
-	| RELATIVE
-	| RELEASE
-	| RENAME
-	| REPEATABLE
-	| REPLACE
-	| REPLICA
-	| RESET
-	| RESTART
-	| RESTRICT
-	| RETURNS
-	| REVOKE
-	| ROLE
-	| ROLLBACK
-	| ROLLUP
-	| ROUTINE
-	| ROUTINES
-	| ROWS
-	| RULE
-	| SAVEPOINT
-	| SCHEMA
-	| SCHEMAS
-	| SCROLL
-	| SEARCH
-	| SECOND
-	| SECURITY
-	| SEQUENCE
-	| SEQUENCES
-	| SERIALIZABLE
-	| SERVER
-	| SESSION
-	| SET
-	| SETS
-	| SHARE
-	| SHOW
-	| SIMPLE
-//	| SKIP
-	| SNAPSHOT
-	| SQL
-	| STABLE
-	| STANDALONE
-	| START
-	| STATEMENT
-	| STATISTICS
-	| STDIN
-	| STDOUT
-	| STORAGE
-	| STORED
-	| STRICT
-	| STRIP
-	| SUBSCRIPTION
-	| SUPPORT
-	| SYSID
-	| SYSTEM
-	| TABLES
-	| TABLESPACE
-	| TEMP
-	| TEMPLATE
-	| TEMPORARY
-	| TEXT
-	| TIES
-	| TRANSACTION
-	| TRANSFORM
-	| TRIGGER
-	| TRUNCATE
-	| TRUSTED
-	| TYPE
-	| TYPES
-	| UESCAPE
-	| UNBOUNDED
-	| UNCOMMITTED
-	| UNENCRYPTED
-	| UNKNOWN
-	| UNLISTEN
-	| UNLOGGED
-	| UNTIL
-	| UPDATE
-	| VACUUM
-	| VALID
-	| VALIDATE
-	| VALIDATOR
-	| VALUE
-	| VARYING
-	| VERSION
-	| VIEW
-	| VIEWS
-	| VOLATILE
-	| WHITESPACE
-	| WITHIN
-	| WITHOUT
-	| WORK
-	| WRAPPER
-	| WRITE
-	| XML
-	| YEAR
-	| YES
-	| ZONE
-	;
+    | ABSOLUTE
+    | ACCESS
+    | ACTION
+    | ADD
+    | ADMIN
+    | AFTER
+    | AGGREGATE
+    | ALSO
+    | ALTER
+    | ALWAYS
+    | ASSERTION
+    | ASSIGNMENT
+    | AT
+    | ATTACH
+    | ATTRIBUTE
+    | BACKWARD
+    | BEFORE
+    | BEGIN
+    | BY
+    | CACHE
+    | CALL
+    | CALLED
+    | CASCADE
+    | CASCADED
+    | CATALOG
+    | CHAIN
+    | CHARACTERISTICS
+    | CHECKPOINT
+    | CLASS
+    | CLOSE
+    | CLUSTER
+    | COLUMNS
+    | COMMENT
+    | COMMENTS
+    | COMMIT
+    | COMMITTED
+    | CONFIGURATION
+    | CONFLICT
+    | CONNECTION
+    | CONSTRAINTS
+    | CONTENT
+    | CONTINUE
+    | CONVERSION
+    | COPY
+    | COST
+    | CSV
+    | CUBE
+    | CURRENT
+    | CURSOR
+    | CYCLE
+    | DATA
+    | DATABASE
+    | DAY
+    | DEALLOCATE
+    | DECLARE
+    | DEFAULTS
+    | DEFERRED
+    | DEFINER
+    | DELETE
+    | DELIMITER
+    | DELIMITERS
+    | DEPENDS
+    | DETACH
+    | DICTIONARY
+    | DISABLE
+    | DISCARD
+    | DOCUMENT
+    | DOMAIN
+    | DOUBLE
+    | DROP
+    | EACH
+    | ENABLE
+    | ENCODING
+    | ENCRYPTED
+    | ENUM
+    | ESCAPE
+    | EVENT
+    | EXCLUDE
+    | EXCLUDING
+    | EXCLUSIVE
+    | EXECUTE
+    | EXPLAIN
+    | EXPRESSION
+    | EXTENSION
+    | EXTERNAL
+    | FAMILY
+    | FILTER
+    | FIRST
+    | FOLLOWING
+    | FORCE
+    | FORWARD
+    | FUNCTION
+    | FUNCTIONS
+    | GENERATED
+    | GLOBAL
+    | GRANTED
+    | GROUPS
+    | HANDLER
+    | HEADER
+    | HOLD
+    | HOUR
+    | IDENTITY
+    | IF
+    | IMMEDIATE
+    | IMMUTABLE
+    | IMPLICIT
+    | IMPORT
+    | INCLUDE
+    | INCLUDING
+    | INCREMENT
+    | INDEX
+    | INDEXES
+    | INHERIT
+    | INHERITS
+    | INLINE
+    | INPUT
+    | INSENSITIVE
+    | INSERT
+    | INSTEAD
+    | INVOKER
+    | ISOLATION
+    | KEY
+    | LABEL
+    | LANGUAGE
+    | LARGE
+    | LAST
+    | LEAKPROOF
+    | LEVEL
+    | LISTEN
+    | LOAD
+    | LOCAL
+    | LOCATION
+    | LOCK
+    | LOCKED
+    | LOGGED
+    | MAPPING
+    | MATCH
+    | MATERIALIZED
+    | MAXVALUE
+    | METHOD
+    | MINUTE
+    | MINVALUE
+    | MODE
+    | MONTH
+    | MOVE
+    | NAME
+    | NAMES
+    | NEW
+    | NEXT
+    | NFC
+    | NFD
+    | NFKC
+    | NFKD
+    | NO
+    | NORMALIZED
+    | NOTHING
+    | NOTIFY
+    | NOWAIT
+    | NULLS
+    | OBJECT
+    | OF
+    | OFF
+    | OIDS
+    | OLD
+    | OPERATOR
+    | OPTION
+    | OPTIONS
+    | ORDINALITY
+    | OTHERS
+    | OVER
+    | OVERRIDING
+    | OWNED
+    | OWNER
+    | PARALLEL
+    | PARSER
+    | PARTIAL
+    | PARTITION
+    | PASSING
+    | PASSWORD
+    | PLANS
+    | POLICY
+    | PRECEDING
+    | PREPARE
+    | PREPARED
+    | PRESERVE
+    | PRIOR
+    | PRIVILEGES
+    | PROCEDURAL
+    | PROCEDURE
+    | PROCEDURES
+    | PROGRAM
+    | PUBLICATION
+    | QUOTE
+    | RANGE
+    | READ
+    | REASSIGN
+    | RECHECK
+    | RECURSIVE
+    | REF
+    | REFERENCING
+    | REFRESH
+    | REINDEX
+    | RELATIVE
+    | RELEASE
+    | RENAME
+    | REPEATABLE
+    | REPLACE
+    | REPLICA
+    | RESET
+    | RESTART
+    | RESTRICT
+    | RETURNS
+    | REVOKE
+    | ROLE
+    | ROLLBACK
+    | ROLLUP
+    | ROUTINE
+    | ROUTINES
+    | ROWS
+    | RULE
+    | SAVEPOINT
+    | SCHEMA
+    | SCHEMAS
+    | SCROLL
+    | SEARCH
+    | SECOND
+    | SECURITY
+    | SEQUENCE
+    | SEQUENCES
+    | SERIALIZABLE
+    | SERVER
+    | SESSION
+    | SET
+    | SETS
+    | SHARE
+    | SHOW
+    | SIMPLE
+//    | SKIP
+    | SNAPSHOT
+    | SQL
+    | STABLE
+    | STANDALONE
+    | START
+    | STATEMENT
+    | STATISTICS
+    | STDIN
+    | STDOUT
+    | STORAGE
+    | STORED
+    | STRICT
+    | STRIP
+    | SUBSCRIPTION
+    | SUPPORT
+    | SYSID
+    | SYSTEM
+    | TABLES
+    | TABLESPACE
+    | TEMP
+    | TEMPLATE
+    | TEMPORARY
+    | TEXT
+    | TIES
+    | TRANSACTION
+    | TRANSFORM
+    | TRIGGER
+    | TRUNCATE
+    | TRUSTED
+    | TYPE
+    | TYPES
+    | UESCAPE
+    | UNBOUNDED
+    | UNCOMMITTED
+    | UNENCRYPTED
+    | UNKNOWN
+    | UNLISTEN
+    | UNLOGGED
+    | UNTIL
+    | UPDATE
+    | VACUUM
+    | VALID
+    | VALIDATE
+    | VALIDATOR
+    | VALUE
+    | VARYING
+    | VERSION
+    | VIEW
+    | VIEWS
+    | VOLATILE
+    | WHITESPACE
+    | WITHIN
+    | WITHOUT
+    | WORK
+    | WRAPPER
+    | WRITE
+    | XML
+    | YEAR
+    | YES
+    | ZONE
+    ;
 
 typeFuncNameKeyword
     : AUTHORIZATION
-	| BINARY
-	| COLLATION
-	| CONCURRENTLY
-	| CROSS
-	| CURRENT_SCHEMA
-	| FREEZE
-	| FULL
-	| ILIKE
-	| INNER
-	| IS
-	| ISNULL
-	| JOIN
-	| LEFT
-	| LIKE
-	| NATURAL
-	| NOTNULL
-	| OUTER
-	| OVERLAPS
-	| RIGHT
-	| SIMILAR
-	| TABLESAMPLE
-	| VERBOSE
-	;
+    | BINARY
+    | COLLATION
+    | CONCURRENTLY
+    | CROSS
+    | CURRENT_SCHEMA
+    | FREEZE
+    | FULL
+    | ILIKE
+    | INNER
+    | IS
+    | ISNULL
+    | JOIN
+    | LEFT
+    | LIKE
+    | NATURAL
+    | NOTNULL
+    | OUTER
+    | OVERLAPS
+    | RIGHT
+    | SIMILAR
+    | TABLESAMPLE
+    | VERBOSE
+    ;
 
 schemaName
     : identifier
@@ -506,240 +506,240 @@ comparisonOperator
 
 cursorName
     : name
-	;
+    ;
 
 aExpr
     : cExpr
-	| aExpr TYPE_CAST_ typeName
-	| aExpr COLLATE anyName
-	| aExpr AT TIME ZONE aExpr
-	| PLUS_ aExpr
-	| MINUS_ aExpr
-	| aExpr PLUS_ aExpr
-	| aExpr MINUS_ aExpr
-	| aExpr ASTERISK_ aExpr
-	| aExpr SLASH_ aExpr
-	| aExpr MOD_ aExpr
-	| aExpr CARET_ aExpr
-	| aExpr comparisonOperator aExpr
+    | aExpr TYPE_CAST_ typeName
+    | aExpr COLLATE anyName
+    | aExpr AT TIME ZONE aExpr
+    | PLUS_ aExpr
+    | MINUS_ aExpr
+    | aExpr PLUS_ aExpr
+    | aExpr MINUS_ aExpr
+    | aExpr ASTERISK_ aExpr
+    | aExpr SLASH_ aExpr
+    | aExpr MOD_ aExpr
+    | aExpr CARET_ aExpr
+    | aExpr comparisonOperator aExpr
     | LP_ aExpr RP_ optIndirection
-	| aExpr qualOp aExpr
-	| qualOp aExpr
-	| aExpr qualOp
-	| NOT aExpr
-	| aExpr LIKE aExpr
-	| aExpr LIKE aExpr ESCAPE aExpr
-	| aExpr NOT LIKE aExpr
-	| aExpr NOT LIKE aExpr ESCAPE aExpr
-	| aExpr ILIKE aExpr
-	| aExpr ILIKE aExpr ESCAPE aExpr
-	| aExpr NOT ILIKE aExpr
-	| aExpr NOT ILIKE aExpr ESCAPE aExpr
-	| aExpr SIMILAR TO aExpr
-	| aExpr SIMILAR TO aExpr ESCAPE aExpr
-	| aExpr NOT SIMILAR TO aExpr
-	| aExpr NOT SIMILAR TO aExpr ESCAPE aExpr
-	| aExpr IS NULL
-	| aExpr ISNULL
-	| aExpr IS NOT NULL
-	| aExpr NOTNULL
-	| row OVERLAPS row
-	| aExpr IS TRUE
-	| aExpr IS NOT TRUE
-	| aExpr IS FALSE
-	| aExpr IS NOT FALSE
-	| aExpr IS UNKNOWN
-	| aExpr IS NOT UNKNOWN
-	| aExpr IS DISTINCT FROM aExpr
-	| aExpr IS NOT DISTINCT FROM aExpr
-	| aExpr IS OF LP_ typeList RP_
-	| aExpr IS NOT OF LP_ typeList RP_
-	| aExpr BETWEEN ASYMMETRIC? bExpr AND aExpr
-	| aExpr NOT BETWEEN ASYMMETRIC? bExpr AND aExpr
-	| aExpr BETWEEN SYMMETRIC bExpr AND aExpr
-	| aExpr NOT BETWEEN SYMMETRIC bExpr AND aExpr
-	| aExpr IN inExpr
-	| aExpr NOT IN inExpr
-	| aExpr subqueryOp subType selectWithParens
-	| aExpr subqueryOp subType LP_ aExpr RP_
-	| UNIQUE selectWithParens
-	| aExpr IS DOCUMENT
-	| aExpr IS NOT DOCUMENT
-	| aExpr IS NORMALIZED
-	| aExpr IS unicodeNormalForm NORMALIZED
-	| aExpr IS NOT NORMALIZED
-	| aExpr IS NOT unicodeNormalForm NORMALIZED
-	| aExpr logicalOperator aExpr
-	| DEFAULT
-	;
+    | aExpr qualOp aExpr
+    | qualOp aExpr
+    | aExpr qualOp
+    | NOT aExpr
+    | aExpr LIKE aExpr
+    | aExpr LIKE aExpr ESCAPE aExpr
+    | aExpr NOT LIKE aExpr
+    | aExpr NOT LIKE aExpr ESCAPE aExpr
+    | aExpr ILIKE aExpr
+    | aExpr ILIKE aExpr ESCAPE aExpr
+    | aExpr NOT ILIKE aExpr
+    | aExpr NOT ILIKE aExpr ESCAPE aExpr
+    | aExpr SIMILAR TO aExpr
+    | aExpr SIMILAR TO aExpr ESCAPE aExpr
+    | aExpr NOT SIMILAR TO aExpr
+    | aExpr NOT SIMILAR TO aExpr ESCAPE aExpr
+    | aExpr IS NULL
+    | aExpr ISNULL
+    | aExpr IS NOT NULL
+    | aExpr NOTNULL
+    | row OVERLAPS row
+    | aExpr IS TRUE
+    | aExpr IS NOT TRUE
+    | aExpr IS FALSE
+    | aExpr IS NOT FALSE
+    | aExpr IS UNKNOWN
+    | aExpr IS NOT UNKNOWN
+    | aExpr IS DISTINCT FROM aExpr
+    | aExpr IS NOT DISTINCT FROM aExpr
+    | aExpr IS OF LP_ typeList RP_
+    | aExpr IS NOT OF LP_ typeList RP_
+    | aExpr BETWEEN ASYMMETRIC? bExpr AND aExpr
+    | aExpr NOT BETWEEN ASYMMETRIC? bExpr AND aExpr
+    | aExpr BETWEEN SYMMETRIC bExpr AND aExpr
+    | aExpr NOT BETWEEN SYMMETRIC bExpr AND aExpr
+    | aExpr IN inExpr
+    | aExpr NOT IN inExpr
+    | aExpr subqueryOp subType selectWithParens
+    | aExpr subqueryOp subType LP_ aExpr RP_
+    | UNIQUE selectWithParens
+    | aExpr IS DOCUMENT
+    | aExpr IS NOT DOCUMENT
+    | aExpr IS NORMALIZED
+    | aExpr IS unicodeNormalForm NORMALIZED
+    | aExpr IS NOT NORMALIZED
+    | aExpr IS NOT unicodeNormalForm NORMALIZED
+    | aExpr logicalOperator aExpr
+    | DEFAULT
+    ;
 
 bExpr
     : cExpr
-	| bExpr TYPE_CAST_ typeName
-	| PLUS_ bExpr
-	| MINUS_ bExpr
-	| bExpr qualOp bExpr
-	| qualOp bExpr
-	| bExpr qualOp
-	| bExpr IS DISTINCT FROM bExpr
-	| bExpr IS NOT DISTINCT FROM bExpr
-	| bExpr IS OF LP_ typeList RP_
-	| bExpr IS NOT OF LP_ typeList RP_
-	| bExpr IS DOCUMENT
-	| bExpr IS NOT DOCUMENT
-	;
+    | bExpr TYPE_CAST_ typeName
+    | PLUS_ bExpr
+    | MINUS_ bExpr
+    | bExpr qualOp bExpr
+    | qualOp bExpr
+    | bExpr qualOp
+    | bExpr IS DISTINCT FROM bExpr
+    | bExpr IS NOT DISTINCT FROM bExpr
+    | bExpr IS OF LP_ typeList RP_
+    | bExpr IS NOT OF LP_ typeList RP_
+    | bExpr IS DOCUMENT
+    | bExpr IS NOT DOCUMENT
+    ;
 
 cExpr
     : parameterMarker
     | columnref
-	| aexprConst
-	| PARAM indirectionEl?
-	| caseExpr
-	| funcExpr
-	| selectWithParens
-	| selectWithParens indirection
-	| EXISTS selectWithParens
-	| ARRAY selectWithParens
-	| ARRAY arrayExpr
-	| explicitRow
-	| implicitRow
-	| GROUPING LP_ exprList RP_
-	;
+    | aexprConst
+    | PARAM indirectionEl?
+    | caseExpr
+    | funcExpr
+    | selectWithParens
+    | selectWithParens indirection
+    | EXISTS selectWithParens
+    | ARRAY selectWithParens
+    | ARRAY arrayExpr
+    | explicitRow
+    | implicitRow
+    | GROUPING LP_ exprList RP_
+    ;
 
 indirection
     : indirectionEl
-	| indirection indirectionEl
-	;
+    | indirection indirectionEl
+    ;
 
 optIndirection
     : optIndirection indirectionEl |
-	;
+    ;
 
 indirectionEl
     : DOT_ attrName
-	| DOT_ ASTERISK_
-	| LBT_ aExpr RBT_
-	| LBT_ sliceBound? COLON_ sliceBound? RBT_
-	;
+    | DOT_ ASTERISK_
+    | LBT_ aExpr RBT_
+    | LBT_ sliceBound? COLON_ sliceBound? RBT_
+    ;
 
 sliceBound
     : aExpr
-	;
+    ;
 
 inExpr
     : selectWithParens | LP_ exprList RP_
-	;
+    ;
 
 caseExpr
     : CASE caseArg? whenClauseList caseDefault? END
-	;
+    ;
 
 whenClauseList
     : whenClause
-	| whenClauseList whenClause
-	;
+    | whenClauseList whenClause
+    ;
 
 whenClause
     : WHEN aExpr THEN aExpr
-	;
+    ;
 
 caseDefault
     : ELSE aExpr
-	;
+    ;
 
 caseArg
     : aExpr
-	;
+    ;
 
 columnref
     : colId
-	| colId indirection
-	;
+    | colId indirection
+    ;
 
 qualOp
     : mathOperator
     | TILDE_TILDE_
     | NOT_TILDE_TILDE_
     | OPERATOR LP_ anyOperator RP_
-	;
+    ;
 
 subqueryOp
     : allOp
-	| OPERATOR LP_ anyOperator RP_
-	| LIKE
-	| NOT LIKE
-	| ILIKE
-	| NOT ILIKE
-	;
+    | OPERATOR LP_ anyOperator RP_
+    | LIKE
+    | NOT LIKE
+    | ILIKE
+    | NOT ILIKE
+    ;
 
 allOp
     : mathOperator
-	;
+    ;
 
 mathOperator
     : PLUS_
-	| MINUS_
-	| ASTERISK_
-	| SLASH_
-	| MOD_
-	| CARET_
-	| LT_
-	| GT_
-	| EQ_
-	| LTE_
-	| GTE_
-	| NEQ_
-	;
+    | MINUS_
+    | ASTERISK_
+    | SLASH_
+    | MOD_
+    | CARET_
+    | LT_
+    | GT_
+    | EQ_
+    | LTE_
+    | GTE_
+    | NEQ_
+    ;
 
 qualAllOp
     : allOp
-	| OPERATOR LP_ anyOperator RP_
-	;
+    | OPERATOR LP_ anyOperator RP_
+    ;
 
 ascDesc
     : ASC | DESC
-	;
+    ;
 
 anyOperator
     : allOp | colId DOT_ anyOperator
-	;
+    ;
 
 frameClause
     : RANGE frameExtent windowExclusionClause?
-	| ROWS frameExtent windowExclusionClause?
-	| GROUPS frameExtent windowExclusionClause?
-	;
+    | ROWS frameExtent windowExclusionClause?
+    | GROUPS frameExtent windowExclusionClause?
+    ;
 
 frameExtent
     : frameBound
-	| BETWEEN frameBound AND frameBound
-	;
+    | BETWEEN frameBound AND frameBound
+    ;
 
 frameBound
     : UNBOUNDED PRECEDING
-	| UNBOUNDED FOLLOWING
-	| CURRENT ROW
-	| aExpr PRECEDING
-	| aExpr FOLLOWING
-	;
+    | UNBOUNDED FOLLOWING
+    | CURRENT ROW
+    | aExpr PRECEDING
+    | aExpr FOLLOWING
+    ;
 
 windowExclusionClause
     : EXCLUDE CURRENT ROW
-	| EXCLUDE GROUP
-	| EXCLUDE TIES
-	| EXCLUDE NO OTHERS
-	;
+    | EXCLUDE GROUP
+    | EXCLUDE TIES
+    | EXCLUDE NO OTHERS
+    ;
 
 row
     : ROW LP_ exprList RP_
-	| ROW LP_ RP_
-	| LP_ exprList COMMA_ aExpr RP_
-	;
+    | ROW LP_ RP_
+    | LP_ exprList COMMA_ aExpr RP_
+    ;
 
 explicitRow
     : ROW LP_ exprList RP_
-	| ROW LP_ RP_
-	;
+    | ROW LP_ RP_
+    ;
 
 implicitRow
     : LP_ exprList COMMA_ aExpr RP_
@@ -747,37 +747,37 @@ implicitRow
 
 subType
     : ANY | SOME | ALL
-	;
+    ;
 
 arrayExpr
     : LBT_ exprList RBT_
-	| LBT_ arrayExprList RBT_
-	| LBT_ RBT_
-	;
+    | LBT_ arrayExprList RBT_
+    | LBT_ RBT_
+    ;
 
 arrayExprList
     : arrayExpr | arrayExprList COMMA_ arrayExpr
-	;
+    ;
 
 funcArgList
     : funcArgExpr
-	| funcArgList COMMA_ funcArgExpr
-	;
+    | funcArgList COMMA_ funcArgExpr
+    ;
 
 paramName
     : typeFunctionName
-	;
+;
 
 funcArgExpr
     : aExpr
-	| paramName CQ_ aExpr
-	| paramName GTE_ aExpr
-	;
+    | paramName CQ_ aExpr
+    | paramName GTE_ aExpr
+    ;
 
 typeList
     : typeName
-	| typeList COMMA_ typeName
-	;
+    | typeList COMMA_ typeName
+    ;
 
 funcApplication
     : funcName LP_ RP_
@@ -795,13 +795,13 @@ funcName
 
 aexprConst
     : NUMBER_
-	| STRING_
-	| funcName STRING_
-	| funcName LP_ funcArgList sortClause? RP_ STRING_
-	| TRUE
-	| FALSE
-	| NULL
-	;
+    | STRING_
+    | funcName STRING_
+    | funcName LP_ funcArgList sortClause? RP_ STRING_
+    | TRUE
+    | FALSE
+    | NULL
+    ;
 
 qualifiedName
     : colId | colId indirection
@@ -822,54 +822,54 @@ functionTable
 
 xmlTable
     : XMLTABLE LP_ cExpr xmlExistsArgument COLUMNS xmlTableColumnList RP_
-	| XMLTABLE LP_ XMLNAMESPACES LP_ xmlNamespaceList RP_ COMMA_ cExpr xmlExistsArgument COLUMNS xmlTableColumnList RP_
-	;
+    | XMLTABLE LP_ XMLNAMESPACES LP_ xmlNamespaceList RP_ COMMA_ cExpr xmlExistsArgument COLUMNS xmlTableColumnList RP_
+    ;
 
 xmlTableColumnList
     : xmlTableColumnEl
-	| xmlTableColumnList COMMA_ xmlTableColumnEl
-	;
+    | xmlTableColumnList COMMA_ xmlTableColumnEl
+    ;
 
 xmlTableColumnEl
     : colId typeName
-	| colId typeName xmlTableColumnOptionList
-	| colId FOR ORDINALITY
-	;
+    | colId typeName xmlTableColumnOptionList
+    | colId FOR ORDINALITY
+    ;
 
 xmlTableColumnOptionList
     : xmlTableColumnOptionEl
-	| xmlTableColumnOptionList xmlTableColumnOptionEl
-	;
+    | xmlTableColumnOptionList xmlTableColumnOptionEl
+    ;
 
 xmlTableColumnOptionEl
     : identifier bExpr
-	| DEFAULT bExpr
-	| NOT NULL
-	| NULL
-	;
+    | DEFAULT bExpr
+    | NOT NULL
+    | NULL
+    ;
 
 xmlNamespaceList
     : xmlNamespaceEl
-	| xmlNamespaceList COMMA_ xmlNamespaceEl
-	;
+    | xmlNamespaceList COMMA_ xmlNamespaceEl
+    ;
 
 xmlNamespaceEl
     : bExpr AS identifier
-	| DEFAULT bExpr
-	;
+    | DEFAULT bExpr
+    ;
 
 funcExpr
     : funcApplication withinGroupClause? filterClause? overClause?
-	| functionExprCommonSubexpr
-	;
+    | functionExprCommonSubexpr
+    ;
 
 withinGroupClause
     : WITHIN GROUP LP_ sortClause RP_
-	;
+    ;
 
 filterClause
     : FILTER LP_ WHERE aExpr RP_
-	;
+    ;
 
 functionExprWindowless
     : funcApplication | functionExprCommonSubexpr
@@ -928,12 +928,12 @@ functionExprCommonSubexpr
 
 typeName
     : simpleTypeName optArrayBounds
-	| SETOF simpleTypeName optArrayBounds
-	| simpleTypeName ARRAY LBT_ NUMBER_ RBT_
-	| SETOF simpleTypeName ARRAY LBT_ NUMBER_ RBT_
-	| simpleTypeName ARRAY
-	| SETOF simpleTypeName ARRAY
-	;
+    | SETOF simpleTypeName optArrayBounds
+    | simpleTypeName ARRAY LBT_ NUMBER_ RBT_
+    | SETOF simpleTypeName ARRAY LBT_ NUMBER_ RBT_
+    | simpleTypeName ARRAY
+    | SETOF simpleTypeName ARRAY
+    ;
 
 simpleTypeName
 	: genericType
@@ -952,7 +952,7 @@ exprList
 
 extractList
     : extractArg FROM aExpr
-	;
+    ;
 
 extractArg
     : YEAR
@@ -962,7 +962,7 @@ extractArg
     | MINUTE
     | SECOND
     | identifier
-	;
+    ;
 
 genericType
     :    typeFunctionName typeModifiers? | typeFunctionName attrs typeModifiers?
@@ -978,36 +978,36 @@ numeric
 
 constDatetime
     : TIMESTAMP LP_ NUMBER_ RP_ optTimezone
-	| TIMESTAMP optTimezone
-	| TIME LP_ NUMBER_ RP_ optTimezone
-	| TIME optTimezone
+    | TIMESTAMP optTimezone
+    | TIME LP_ NUMBER_ RP_ optTimezone
+    | TIME optTimezone
     ;
 
 optTimezone
     : WITH TIME ZONE
-	| WITHOUT TIME ZONE
-	|
-	;
+    | WITHOUT TIME ZONE
+    |
+    ;
 
 character
     : characterWithLength | characterWithoutLength
-	;
+    ;
 
 characterWithLength
     : characterClause LP_ NUMBER_ RP_
-	;
+    ;
 
 characterWithoutLength
     : characterClause
-	;
+    ;
 
 characterClause
     : CHARACTER VARYING?
-	| CHAR VARYING?
-	| VARCHAR
+    | CHAR VARYING?
+    | VARCHAR
     | NATIONAL CHARACTER VARYING?
-	| NATIONAL CHAR VARYING?
-	| NCHAR VARYING?
+    | NATIONAL CHAR VARYING?
+    | NCHAR VARYING?
 	;
 
 optFloat
@@ -1032,11 +1032,11 @@ bit
 
 bitWithLength
     : BIT VARYING? LP_ exprList RP_
-	;
+    ;
 
 bitWithoutLength
     : BIT VARYING?
-	;
+    ;
 
 constInterval
     : INTERVAL
@@ -1044,20 +1044,20 @@ constInterval
 
 optInterval
     : YEAR
-	| MONTH
-	| DAY
-	| HOUR
-	| MINUTE
-	| intervalSecond
-	| YEAR TO MONTH
-	| DAY TO HOUR
-	| DAY TO MINUTE
-	| DAY TO intervalSecond
-	| HOUR TO MINUTE
-	| HOUR TO intervalSecond
-	| MINUTE TO intervalSecond
-	|
-	;
+    | MONTH
+    | DAY
+    | HOUR
+    | MINUTE
+    | intervalSecond
+    | YEAR TO MONTH
+    | DAY TO HOUR
+    | DAY TO MINUTE
+    | DAY TO intervalSecond
+    | HOUR TO MINUTE
+    | HOUR TO intervalSecond
+    | MINUTE TO intervalSecond
+    |
+    ;
 
 optArrayBounds
     : optArrayBounds LBT_ RBT_
@@ -1067,18 +1067,18 @@ optArrayBounds
 
 intervalSecond
     : SECOND
-	| SECOND LP_ NUMBER_ RP_
-	;
+    | SECOND LP_ NUMBER_ RP_
+    ;
 
 unicodeNormalForm
     : NFC | NFD | NFKC | NFKD
-	;
+    ;
 
 trimList
     : aExpr FROM exprList
-	| FROM exprList
-	| exprList
-	;
+    | FROM exprList
+    | exprList
+    ;
 
 overlayList
     : aExpr overlayPlacing substrFrom substrFor
@@ -1099,78 +1099,78 @@ substrFor
 
 positionList
     : bExpr IN bExpr |
-	;
+    ;
 
 substrList
     : aExpr substrFrom substrFor
-	| aExpr substrFor substrFrom
-	| aExpr substrFrom
-	| aExpr substrFor
-	| exprList
-	|
-	;
+    | aExpr substrFor substrFrom
+    | aExpr substrFrom
+    | aExpr substrFor
+    | exprList
+    |
+    ;
 
 xmlAttributes
     : XMLATTRIBUTES LP_ xmlAttributeList RP_
-	;
+    ;
 
 xmlAttributeList
     : xmlAttributeEl
-	| xmlAttributeList COMMA_ xmlAttributeEl
-	;
+    | xmlAttributeList COMMA_ xmlAttributeEl
+    ;
 
 xmlAttributeEl
     : aExpr AS identifier | aExpr
-	;
+    ;
 
 xmlExistsArgument
     : PASSING cExpr
-	| PASSING cExpr xmlPassingMech
-	| PASSING xmlPassingMech cExpr
-	| PASSING xmlPassingMech cExpr xmlPassingMech
-	;
+    | PASSING cExpr xmlPassingMech
+    | PASSING xmlPassingMech cExpr
+    | PASSING xmlPassingMech cExpr xmlPassingMech
+    ;
 
 xmlPassingMech
     : BY REF | BY VALUE
-	;
+    ;
 
 documentOrContent
     : DOCUMENT | CONTENT
-	;
+    ;
 
 xmlWhitespaceOption
     : PRESERVE WHITESPACE | STRIP WHITESPACE |
-	;
+    ;
 
 xmlRootVersion
     : VERSION aExpr
-	| VERSION NO VALUE
-	;
+    | VERSION NO VALUE
+    ;
 
 optXmlRootStandalone
     : COMMA_ STANDALONE YES
-	| COMMA_ STANDALONE NO
-	| COMMA_ STANDALONE NO VALUE
-	|
-	;
+    | COMMA_ STANDALONE NO
+    | COMMA_ STANDALONE NO VALUE
+    |
+    ;
 
 rowsFromItem
     : functionExprWindowless optColumnDefList
-	;
+    ;
 
 rowsFromList
     : rowsFromItem
 	| rowsFromList COMMA_ rowsFromItem
-	;
+    ;
 
 optColumnDefList
     : AS LP_ tableFuncElementList RP_
-	;
+    ;
 
 tableFuncElementList
     : tableFuncElement
     | tableFuncElementList COMMA_ tableFuncElement
-	;
+    ;
 
 tableFuncElement
     :  typeName optCollateClause
@@ -1182,60 +1182,60 @@ optCollateClause
 
 anyName
     : colId | colId attrs
-	;
+    ;
 
 aliasClause
     : AS colId LP_ nameList RP_
-	| AS colId
-	| colId LP_ nameList RP_
-	| colId
-	;
+    | AS colId
+    | colId LP_ nameList RP_
+    | colId
+    ;
 
 nameList
     : name | nameList COMMA_ name
-	;
+    ;
 
 funcAliasClause
     : aliasClause
-	| AS LP_ tableFuncElementList RP_
-	| AS colId LP_ tableFuncElementList RP_
-	| colId LP_ tableFuncElementList RP_
-	;
+    | AS LP_ tableFuncElementList RP_
+    | AS colId LP_ tableFuncElementList RP_
+    | colId LP_ tableFuncElementList RP_
+    ;
 
 tablesampleClause
     : TABLESAMPLE funcName LP_ exprList RP_ repeatableClause?
-	;
+    ;
 
 repeatableClause
     : REPEATABLE LP_ aExpr RP_
-	;
+    ;
 
 allOrDistinct
     : ALL | DISTINCT
-	;
+    ;
 
 sortClause
     : ORDER BY sortbyList
-	;
+    ;
 
 sortbyList
     : sortby (COMMA_ sortby)*
-	;
+    ;
 
 sortby
     : aExpr USING qualAllOp nullsOrder?
-	| aExpr ascDesc? nullsOrder?
-	;
+    | aExpr ascDesc? nullsOrder?
+    ;
 
 nullsOrder
     : NULLS FIRST
-	| NULLS LAST
-	;
+    | NULLS LAST
+    ;
 
 distinctClause
     : DISTINCT
-	| DISTINCT ON LP_ exprList RP_
-	;
+    | DISTINCT ON LP_ exprList RP_
+    ;
 
 distinct
     : DISTINCT
@@ -1243,79 +1243,79 @@ distinct
 
 overClause
     : OVER windowSpecification
-	| OVER colId
-	;
+    | OVER colId
+    ;
 
 windowSpecification
     : LP_ windowName? partitionClause? sortClause? frameClause? RP_
-	;
+    ;
 
 windowName
     : colId
-	;
+    ;
 
 partitionClause
     : PARTITION BY exprList
-	;
+    ;
 
 indexParams
     : indexElem
-	| indexParams COMMA_ indexElem
-	;
+    | indexParams COMMA_ indexElem
+    ;
 
 indexElemOptions
     : collate? optClass ascDesc? nullsOrder?
-	| collate? anyName reloptions ascDesc? nullsOrder?
-	;
+    | collate? anyName reloptions ascDesc? nullsOrder?
+    ;
 
 indexElem
     : colId indexElemOptions
-	| functionExprWindowless indexElemOptions
-	| LP_ aExpr RP_ indexElemOptions
-	;
+    | functionExprWindowless indexElemOptions
+    | LP_ aExpr RP_ indexElemOptions
+    ;
 
 collate
     : COLLATE anyName
-	;
+    ;
 
 optClass
     : anyName |
-	;
+    ;
 
 reloptions
     : LP_ reloptionList RP_
-	;
+    ;
 
 optReloptions
     : WITH reloptions |
-	;
+    ;
 
 reloptionList
     : reloptionElem
-	| reloptionList COMMA_ reloptionElem
+    | reloptionList COMMA_ reloptionElem
 	;
 
 reloptionElem
     : alias EQ_ defArg
-	| alias
-	| alias DOT_ alias EQ_ defArg
-	| alias DOT_ alias
+    | alias
+    | alias DOT_ alias EQ_ defArg
+    | alias DOT_ alias
 	;
 
 defArg
     : funcType
-	| reserved_keyword
-	| qualAllOp
-	| NUMBER_
-	| STRING_
-	| NONE
-	;
+    | reservedKeyword
+    | qualAllOp
+    | NUMBER_
+    | STRING_
+    | NONE
+    ;
 
 funcType
     : typeName
-	| typeFunctionName attrs MOD_ TYPE
-	| SETOF typeFunctionName attrs MOD_ TYPE
-	;
+    | typeFunctionName attrs MOD_ TYPE
+    | SETOF typeFunctionName attrs MOD_ TYPE
+    ;
 
 selectWithParens
     : 'Default does not match anything'
diff --git a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/antlr4/imports/postgresql/DMLStatement.g4 b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/antlr4/imports/postgresql/DMLStatement.g4
index 64e3710..aca36f4 100644
--- a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/antlr4/imports/postgresql/DMLStatement.g4
+++ b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/antlr4/imports/postgresql/DMLStatement.g4
@@ -29,11 +29,11 @@ insertTarget
 
 insertRest
     : select
-	| OVERRIDING overrideKind VALUE select
-	| LP_ insertColumnList RP_ select
-	| LP_ insertColumnList RP_ OVERRIDING overrideKind VALUE select
-	| DEFAULT VALUES
-	;
+    | OVERRIDING overrideKind VALUE select
+    | LP_ insertColumnList RP_ select
+    | LP_ insertColumnList RP_ OVERRIDING overrideKind VALUE select
+    | DEFAULT VALUES
+    ;
 
 overrideKind
     : USER | SYSTEM