GaussDB SQL Syntax Support¶
This page documents the SQL syntax support for GaussDB (openGauss) in the General SQL Parser.
Syntax Coverage Corpus¶
GSP tests GaussDB syntax against 5 documented constructs grouped into 4 categories, each cross-referenced to the specific page in GaussDB's own documentation that defines it (5 distinct source pages).
Parse coverage¶
Measured on 2026-07-25 against GSP Java 4.1.5.15, the current release. Each construct carries the complete set of examples from GaussDB's documentation; a construct counts as fully covered only when every one of its examples parses.
| Constructs | Individual statements | |
|---|---|---|
| Fully parsed | 4 of 5 (80%) | 4 of 5 (80%) |
Statements are split using the parser's own statement splitter, so multi-statement examples and procedure bodies are counted correctly.
Categories covered¶
| Category | Constructs |
|---|---|
| CREATE | 2 |
| SELECT | 1 |
| UPSERT | 1 |
| WITH | 1 |
Full construct lists are being published progressively; see Sybase, PostgreSQL or MySQL.
Key Features Supported¶
- Standard SQL operations (SELECT, INSERT, UPDATE, DELETE)
- GaussDB-specific functions and data types
- UPSERT operations and conflict resolution
- Advanced window functions and CTEs
- Stored procedures and user-defined functions
- Partitioning and distributed query features