gudusoft.gsqlparser.sqlcmds

Class TSqlCmdsOceanbase

Object

gudusoft.gsqlparser.sqlcmds.AbstractSqlCmds

gudusoft.gsqlparser.sqlcmds.TSqlCmdsMysql

gudusoft.gsqlparser.sqlcmds.TSqlCmdsOceanbase

All Implemented Interfaces:

ISqlCmds

public class TSqlCmdsOceanbase
extends TSqlCmdsMysql

OceanBase SQL command resolver — Phase 1 skeleton.

OceanBase user tenants in MySQL mode and the sys system tenant share the MySQL command surface, so this resolver inherits all MySQL command patterns from TSqlCmdsMysql via subclassing. The vendor field is then re-tagged to EDbVendor.dbvoceanbase so any statement constructed via the inherited resolver carries OceanBase vendor identity.

For Phase 1 we additionally register a small set of unmistakable OceanBase administrative DDL prefixes (CREATE TENANT, ALTER TENANT, DROP TENANT, ALTER SYSTEM, CREATE/ALTER RESOURCE POOL, CREATE/ALTER RESOURCE UNIT) so the splitter recognizes them as statement boundaries in multi-statement admin scripts. These statements are tagged ESqlStatementType.sstunknown because Phase 1 has no AST nodes for them yet — Phase 4 will add proper AST classes and replace sstunknown with vendor-specific types such as sstoceanbase_create_tenant.

Mode awareness

This class is constructed once per TGSqlParser instance via SqlCmdsFactory, before the user has had a chance to call setOBTenantMode. So a single TSqlCmdsOceanbase cannot select between MySQL-family and Oracle-family command sets at construction time. Phase 1 deliberately accepts a MySQL-family command surface here because:

• The Oracle delegate (OracleSqlParser) used by OceanBaseSqlParser for ORACLE mode has its own internal TSqlCmdsOracle that handles PL/SQL boundary detection independently of this class.
• The TGSqlParser-level sqlcmds field is consulted primarily for validation and post-processing of MySQL-family statements; ORACLE-mode dbvoceanbase scripts that exercise this class are a Phase 4 concern.

Phase 4 will revisit whether TSqlCmdsOceanbase should grow mode-awareness via a separate factory dispatch path or whether it should be split into TSqlCmdsOceanbaseMysql / TSqlCmdsOceanbaseOracle with the active instance selected from EOBTenantMode.

Since:

4.0.1.4

See Also:

TSqlCmdsMysql, SqlCmdsFactory, EOBTenantMode

Field Summary

Fields inherited from class gudusoft.gsqlparser.sqlcmds.AbstractSqlCmds

gnewsqlstatementtype, initialized, initLock, sqlCmdList, vendor

Constructor Summary

Constructors

Constructor and Description
TSqlCmdsOceanbase()

Method Summary

Modifier and Type	Method and Description
static String	detectSystemPrefixConflict(String sqltext) Scan sqltext for an unmistakable OceanBase system-tenant DDL prefix at a statement boundary.
protected String	getToken1Str(int token1) Get the string representation for vendor-specific token codes.
protected void	initializeCommands() Initialize vendor-specific commands.
TCustomSqlStatement	issql(TSourceToken pcst, EFindSqlStateType pstate, TCustomSqlStatement psqlstatement) Identifies the SQL statement type from a token stream.

Methods inherited from class gudusoft.gsqlparser.sqlcmds.AbstractSqlCmds

addCmd, addCmd, addCmd, addCmd, addCmd, addCmd, addCmd, addCmd, ensureInitialized, findcte, finddbcmd, getSqlCmdList, getStatementTypeForToken, getVendor

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

TSqlCmdsOceanbase

public TSqlCmdsOceanbase()

Method Detail

initializeCommands

protected void initializeCommands()

Description copied from class: AbstractSqlCmds

Initialize vendor-specific commands. Subclasses must implement this to populate sqlCmdList.

Overrides:

initializeCommands in class TSqlCmdsMysql

getToken1Str

protected String getToken1Str(int token1)

Description copied from class: AbstractSqlCmds

Get the string representation for vendor-specific token codes. Subclasses should override this method to provide mappings for vendor-specific reserved words (tokens > TBaseType.rrw_abort).

Overrides:

getToken1Str in class TSqlCmdsMysql

Parameters:

token1 - Token code

Returns:

String representation of the token, or null if not applicable

issql

public TCustomSqlStatement issql(TSourceToken pcst,
                                 EFindSqlStateType pstate,
                                 TCustomSqlStatement psqlstatement)

Identifies the SQL statement type from a token stream. This method is called repeatedly during parsing to identify statement boundaries and types in complex SQL scripts.

The inherited TSqlCmdsMysql.issql(gudusoft.gsqlparser.TSourceToken, gudusoft.gsqlparser.EFindSqlStateType, gudusoft.gsqlparser.TCustomSqlStatement) switch statement does not know about sstoceanbase_* enum values and routes them to its default branch, which produces a TUnknownSqlStatement. This override intercepts the result and swaps in the proper OceanBase statement class when a tenant-family type is detected, preserving the splitter's tag on the returned instance.

Specified by:

issql in interface ISqlCmds

Overrides:

issql in class TSqlCmdsMysql

Parameters:

pcst - Current token being analyzed

pstate - Current parsing state (start, in body, or in exception)

psqlstatement - Current statement being built (may be modified)

Returns:

The identified or modified SQL statement

detectSystemPrefixConflict

public static String detectSystemPrefixConflict(String sqltext)

Scan sqltext for an unmistakable OceanBase system-tenant DDL prefix at a statement boundary. Comments and string literals are masked before the scan so text inside them cannot trigger a false positive.

This helper exists so OceanBaseSqlParser can emit a targeted error when a user submits system-tenant DDL while the parser is in EOBTenantMode.ORACLE, matching the real OceanBase server's "wrong tenant" rejection with a clearer message than a raw Oracle yacc syntax error at the TENANT token.

Per ADR-7 the check is narrow by design and the caller still owns mode selection — this helper reports; it never promotes.

Parameters:

sqltext - the raw SQL script to scan; may be null

Returns:

a canonical uppercase prefix name (for example "CREATE TENANT") when a system-only prefix is found, or null when the script contains no such prefix (or the input is null / empty)

Since:

4.0.1.4