Skip to content

GaussDB SQL Parser Support in GSP

Explore the GaussDB SQL Parser product page

This page documents the SQL syntax support for GaussDB (openGauss) in the General SQL Parser.

Syntax Coverage Corpus

GSP tests GaussDB syntax against 27 documented constructs grouped into 18 categories, each cross-referenced to the documentation that defines it (27 distinct source pages).

Parse coverage

Measured against GSP Java 4.2.9 on 2026-09-09 (UTC) (artifact sha256 3bb68197fad6). Each construct below carries the complete set of examples from the GaussDB documentation; a construct counts as fully covered only when every one of its examples parses. Percentages are pass rates over this documented-example corpus — not a percentage of the entire SQL dialect.

Constructs fully parsed Individual statements parsed
All constructs 26 of 27 (96%) 59 of 60 (98%)
SELECT (queries) 2 of 2 (100%) 2 of 2 (100%)
DML (INSERT / UPDATE / DELETE / MERGE) 4 of 4 (100%) 9 of 9 (100%)
Stored procedures 2 of 2 (100%) 3 of 3 (100%)

Statements are split using the parser's own statement splitter, so multi-statement examples and procedure bodies are counted correctly. The SELECT, DML and stored-procedure rows classify each statement by its parsed statement type: a construct is counted in a row when its examples contain at least one statement of that class, and is fully parsed when all of them parse. Stored procedures covers CREATE PROCEDURE / FUNCTION / PACKAGE / TRIGGER definitions and anonymous blocks.

Machine-readable: dialect data (JSON) · all-dialect matrix · coverage matrix overview

All 27 constructs

Construct Category Parses Specified in
ALTER TABLE ALTER all 4 third-party reference
CALL CALL all 2 third-party reference
COMMENT COMMENT all 2 third-party reference
CREATE FUNCTION CREATE all 2 third-party reference
CREATE INDEX CREATE all 4 third-party reference
CREATE PROCEDURE CREATE all 2 third-party reference
CREATE ROLE CREATE all 2 third-party reference
CREATE SCHEMA CREATE all 2 third-party reference
CREATE SEQUENCE CREATE all 1 third-party reference
CREATE TABLE CREATE all 1 third-party reference
CREATE TYPE CREATE all 2 third-party reference
CREATE USER CREATE all 2 third-party reference
CREATE VIEW CREATE all 2 third-party reference
DELETE DELETE all 3 third-party reference
DROP TABLE DROP all 2 third-party reference
GRANT GRANT all 4 third-party reference
INSERT INSERT all 3 third-party reference
MERGE INTO MERGE all 1 third-party reference
Anonymous Block PLSQL all 1 third-party reference
PREPARE and EXECUTE PREPARE all 3 third-party reference
REVOKE REVOKE all 2 third-party reference
SELECT SELECT all 1 third-party reference
Transaction Control TRANSACTION all 6 third-party reference
TRUNCATE TRUNCATE all 2 third-party reference
UPDATE UPDATE all 2 third-party reference
UPSERT UPSERT 0 of 1 third-party reference
WITH RECURSIVE WITH all 1 third-party reference

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