This is an automated email from the ASF dual-hosted git repository.
zhaojinchao 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 7d71db78d09 Update create database option name for opengauss sql
parser (#37350)
7d71db78d09 is described below
commit 7d71db78d090f261b44a16a16bf30ac575b0799d
Author: Raigor <[email protected]>
AuthorDate: Thu Dec 11 22:43:13 2025 +0800
Update create database option name for opengauss sql parser (#37350)
---
.../opengauss/src/main/antlr4/imports/opengauss/BaseRule.g4 | 2 +-
.../opengauss/src/main/antlr4/imports/opengauss/DDLStatement.g4 | 7 ++++---
.../src/main/antlr4/imports/opengauss/OpenGaussKeyword.g4 | 8 ++++++++
3 files changed, 13 insertions(+), 4 deletions(-)
diff --git
a/parser/sql/engine/dialect/opengauss/src/main/antlr4/imports/opengauss/BaseRule.g4
b/parser/sql/engine/dialect/opengauss/src/main/antlr4/imports/opengauss/BaseRule.g4
index 15bc7937053..ba89d9f1bf7 100644
---
a/parser/sql/engine/dialect/opengauss/src/main/antlr4/imports/opengauss/BaseRule.g4
+++
b/parser/sql/engine/dialect/opengauss/src/main/antlr4/imports/opengauss/BaseRule.g4
@@ -126,7 +126,7 @@ uescape
unreservedWord
: SELECT | INSERT | UPDATE | DELETE | CREATE | ALTER | DROP | TRUNCATE |
SCHEMA | GRANT | REVOKE | ADD | SET | TABLE | COLUMN | INDEX | CONSTRAINT |
PRIMARY | UNIQUE | FOREIGN | KEY | POSITION | PRECISION | FUNCTION | TRIGGER |
PROCEDURE | VIEW | INTO | VALUES | WITH | UNION | DISTINCT | MAXSIZE | CASE |
WHEN | CAST | TRIM | SUBSTRING | FROM | NATURAL | JOIN | FULL | INNER | OUTER |
LEFT | RIGHT | CROSS | USING | WHERE | AS | ON | IF | ELSE | THEN | FOR | TO |
AND | OR | IS | NOT | N [...]
- | ADMIN | BINARY | ESCAPE | EXISTS | EXCLUDE | MOD | PARTITION | ROW |
UNKNOWN | ALWAYS | CASCADE | CHECK | GENERATED | ISOLATION | LEVEL | NO |
OPTION | PRIVILEGES | READ | REFERENCES | ROLE | ROWS | START | TRANSACTION |
USER | ACTION | CACHE | CHARACTERISTICS | CLUSTER | COLLATE | COMMENTS |
CONCURRENTLY | CONNECT | CONSTRAINTS | CURRENT_TIMESTAMP | CYCLE | DATA |
DATABASE | DEFAULTS | DEFERRABLE | DEFERRED | DEPENDS | DOMAIN | EXCLUDING |
EXECUTE | EXTENDED | EXTENSION | EXTERNAL [...]
+ | ADMIN | BINARY | ESCAPE | EXISTS | EXCLUDE | MOD | PARTITION | ROW |
UNKNOWN | ALWAYS | CASCADE | CHECK | GENERATED | ISOLATION | LEVEL | NO |
OPTION | PRIVILEGES | READ | REFERENCES | ROLE | ROWS | START | TRANSACTION |
USER | ACTION | CACHE | CHARACTERISTICS | CLUSTER | COLLATE | COMMENTS |
CONCURRENTLY | CONNECT | CONSTRAINTS | CURRENT_TIMESTAMP | CYCLE | DATA |
DATABASE | DEFAULTS | DEFERRABLE | DEFERRED | DEPENDS | DOMAIN | EXCLUDING |
EXECUTE | EXTENDED | EXTENSION | EXTERNAL [...]
;
typeFuncNameKeyword
diff --git
a/parser/sql/engine/dialect/opengauss/src/main/antlr4/imports/opengauss/DDLStatement.g4
b/parser/sql/engine/dialect/opengauss/src/main/antlr4/imports/opengauss/DDLStatement.g4
index 1c53e433327..90f55ab918e 100644
---
a/parser/sql/engine/dialect/opengauss/src/main/antlr4/imports/opengauss/DDLStatement.g4
+++
b/parser/sql/engine/dialect/opengauss/src/main/antlr4/imports/opengauss/DDLStatement.g4
@@ -139,10 +139,11 @@ createDatabaseSpecification
;
createdbOptName
- : identifier
- | CONNECTION LIMIT
+ : CONNECTION LIMIT
| ENCODING
- | LOCATION
+ | LC_COLLATE
+ | LC_CTYPE
+ | DBCOMPATIBILITY
| OWNER
| TABLESPACE
| TEMPLATE
diff --git
a/parser/sql/engine/dialect/opengauss/src/main/antlr4/imports/opengauss/OpenGaussKeyword.g4
b/parser/sql/engine/dialect/opengauss/src/main/antlr4/imports/opengauss/OpenGaussKeyword.g4
index 78f80d3f6b6..b11ad08f487 100644
---
a/parser/sql/engine/dialect/opengauss/src/main/antlr4/imports/opengauss/OpenGaussKeyword.g4
+++
b/parser/sql/engine/dialect/opengauss/src/main/antlr4/imports/opengauss/OpenGaussKeyword.g4
@@ -1061,6 +1061,14 @@ LOCATION
: L O C A T I O N
;
+LC_COLLATE
+ : L C UL_ C O L L A T E
+ ;
+
+LC_CTYPE
+ : L C UL_ C T Y P E
+ ;
+
LABEL
: L A B E L
;
