- About MogDB
- Quick Start
- Characteristic Description
- Overview
- High Performance
- CBO Optimizer
- LLVM
- Vectorized Engine
- Hybrid Row-Column Store
- Adaptive Compression
- Adaptive Two-phase Hash Aggregation
- SQL Bypass
- Kunpeng NUMA Architecture Optimization
- High Concurrency of Thread Pools
- SMP for Parallel Execution
- Xlog no Lock Flush
- Parallel Page-based Redo For Ustore
- Row-Store Execution to Vectorized Execution
- Astore Row Level Compression
- BTree Index Compression
- Tracing SQL Function
- Parallel Index Scan
- Parallel Query Optimization
- Enhancement of Tracing Backend Key Thread
- Ordering Operator Optimization
- OCK-accelerated Data Transmission
- OCK SCRLock Accelerate Distributed Lock
- Enhancement of WAL Redo Performance
- High Availability (HA)
- Primary/Standby
- Logical Replication
- Logical Backup
- Physical Backup
- Automatic Job Retry upon Failure
- Ultimate RTO
- High Availability Based on the Paxos Protocol
- Cascaded Standby Server
- Delayed Replay
- Adding or Deleting a Standby Server
- Delaying Entering the Maximum Availability Mode
- Parallel Logical Decoding
- DCF
- CM(Cluster Manager)
- Global SysCache
- Using a Standby Node to Build a Standby Node
- Two City and Three Center DR
- CM Cluster Management Component Supporting Two Node Deployment
- Query of the Original DDL Statement for a View
- Maintainability
- Compatibility
- Add %rowtype Attribute To The View
- Aggregate Functions Distinct Performance Optimization
- Aggregate Functions Support Keep Clause
- Aggregate Functions Support Scenario Extensions
- Compatible With MySQL Alias Support For Single Quotes
- current_date/current_time Keywords As Field Name
- Custom Type Array
- For Update Support Outer Join
- MogDB Supports Insert All
- Oracle DBLink Syntax Compatibility
- Remove Type Conversion Hint When Creating PACKAGE/FUNCTION/PROCEDURE
- Support Bypass Method When Merge Into Hit Index
- Support For Adding Nocopy Attributes To Procedure And Function Parameters
- Support For Passing The Count Attribute Of An Array As A Parameter Of The Array Extend
- Support Q Quote Escape Character
- Support Subtracting Two Date Types To Return Numeric Type
- Support table()
- Support To Keep The Same Name After The End With Oracle
- Support Where Current Of
- Support For Constants In Package As Default Values
- Support PLPGSQL subtype
- Support Synonym Calls Without Parentheses For Function Without Parameters
- Support For dbms_utility.format_error_backtrace
- Database Security
- Access Control Model
- Separation of Control and Access Permissions
- Database Encryption Authentication
- Data Encryption and Storage
- Database Audit
- Network Communication Security
- Resource Label
- Unified Audit
- Dynamic Data Anonymization
- Row-Level Access Control
- Password Strength Verification
- Equality Query in a Fully-encrypted Database
- Ledger Database Mechanism
- Transparent Data Encryption
- Enterprise-Level Features
- Support for Functions and Stored Procedures
- SQL Hints
- Full-Text Indexing
- Copy Interface for Error Tolerance
- Partitioning
- Support for Advanced Analysis Functions
- Materialized View
- HyperLogLog
- Creating an Index Online
- Autonomous Transaction
- Global Temporary Table
- Pseudocolumn ROWNUM
- Stored Procedure Debugging
- JDBC Client Load Balancing and Read/Write Isolation
- In-place Update Storage Engine
- Publication-Subscription
- Foreign Key Lock Enhancement
- Data Compression in OLTP Scenarios
- Transaction Async Submit
- Index Creation Parallel Control
- Dynamic Partition Pruning
- COPY Import Optimization
- SQL Running Status Observation
- BRIN Index
- BLOOM Index
- Event Trigger
- Application Development Interfaces
- AI Capabilities
- Middleware
- Workload Management
- Installation Guide
- Upgrade Guide
- Administrator Guide
- Localization
- Routine Maintenance
- Starting and Stopping MogDB
- Using the gsql Client for Connection
- Routine Maintenance
- Checking OS Parameters
- Checking MogDB Health Status
- Checking Database Performance
- Checking and Deleting Logs
- Checking Time Consistency
- Checking The Number of Application Connections
- Routinely Maintaining Tables
- Routinely Recreating an Index
- Exporting and Viewing the WDR
- Data Security Maintenance Suggestions
- Slow SQL Diagnosis
- Log Reference
- Primary and Standby Management
- Column-store Tables Management
- Backup and Restoration
- Database Deployment Solutions
- Importing and Exporting Data
- High Available Guide
- AI Features Guide
- AI4DB: Autonomous Database O&M
- DBMind Mode
- Components that Support DBMind
- AI Sub-functions of the DBMind
- ABO Optimizer
- DB4AI: Database-driven AI
- AI4DB: Autonomous Database O&M
- Security Guide
- Developer Guide
- Application Development Guide
- Development Specifications
- Development Based on JDBC
- JDBC Package, Driver Class, and Environment Class
- Development Process
- Loading the Driver
- Connecting to a Database
- Connecting to the Database (Using SSL)
- Connecting to the Database (Using UDS)
- Running SQL Statements
- Processing Data in a Result Set
- Closing a Connection
- Managing Logs
- Example: Common Operations
- Example: Retrying SQL Queries for Applications
- Example: Importing and Exporting Data Through Local Files
- Example 2: Migrating Data from a MY Database to MogDB
- Example: Logic Replication Code
- Example: Parameters for Connecting to the Database in Different Scenarios
- Example: JDBC Primary/Standby Cluster Load Balancing
- JDBC API Reference
- java.sql.Connection
- java.sql.CallableStatement
- java.sql.DatabaseMetaData
- java.sql.Driver
- java.sql.PreparedStatement
- java.sql.ResultSet
- java.sql.ResultSetMetaData
- java.sql.Statement
- javax.sql.ConnectionPoolDataSource
- javax.sql.DataSource
- javax.sql.PooledConnection
- javax.naming.Context
- javax.naming.spi.InitialContextFactory
- CopyManager
- JDBC-based Common Parameter Reference
- JDBC Release Notes
- Development Based on ODBC
- Development Based on libpq
- Psycopg2-Based Development
- Commissioning
- Stored Procedure
- User Defined Functions
- PL/pgSQL-SQL Procedural Language
- Scheduled Jobs
- Autonomous Transaction
- Logical Replication
- Extension
- MySQL Compatibility Description
- Dolphin Extension
- Dolphin Overview
- Dolphin Installation
- Dolphin Restrictions
- Dolphin Syntax
- SQL Reference
- Keywords
- Data Types
- Functions and Operators
- Assignment Operators
- Character Processing Functions and Operators
- Arithmetic Functions and Operators
- Dolphin Lock
- Date and Time Processing Functions and Operators
- Advisory Lock Functions
- Network Address Functions and Operators
- Conditional Expression Functions
- Aggregate Functions
- System Information Functions
- Logical Operators
- Bit String Functions and Operators
- JSON-JSONB Functions and Operators
- Type Conversion Functions
- Compatible Operators and Operations
- Comment Operators
- Expressions
- DDL Syntax
- DML Syntax
- DCL Syntax
- SQL Syntax
- ALTER DATABASE
- ALTER FUNCTION
- ALTER PROCEDURE
- ALTER SERVER
- ALTER TABLE
- ALTER TABLE PARTITION
- ALTER TABLESPACE
- ALTER VIEW
- ANALYZE | ANALYSE
- AST
- CHECKSUM TABLE
- CREATE DATABASE
- CREATE FUNCTION
- CREATE INDEX
- CREATE PROCEDURE
- CREATE SERVER
- CREATE TABLE
- CREATE TABLE AS
- CREATE TABLE PARTITION
- CREATE TABLESPACE
- CREATE TRIGGER
- CREATE VIEW
- DESCRIBE TABLE
- DO
- DROP DATABASE
- DROP INDEX
- DROP TABLESPACE
- EXECUTE
- EXPLAIN
- FLUSH BINARY LOGS
- GRANT
- GRANT/REVOKE PROXY
- INSERT
- KILL
- LOAD DATA
- OPTIMIZE TABLE
- PREPARE
- RENAME TABLE
- RENAME USER
- REVOKE
- SELECT
- SELECT HINT
- SET CHARSET
- SET PASSWORD
- SHOW CHARACTER SET
- SHOW COLLATION
- SHOW COLUMNS
- SHOW CREATE DATABASE
- SHOW CREATE FUNCTION
- SHOW CREATE PROCEDURE
- SHOW CREATE TABLE
- SHOW CREATE TRIGGER
- SHOW CREATE VIEW
- SHOW DATABASES
- SHOW FUNCTION STATUS
- SHOW GRANTS
- SHOW INDEX
- SHOW MASTER STATUS
- SHOW PLUGINS
- SHOW PRIVILEGES
- SHOW PROCEDURE STATUS
- SHOW PROCESSLIST
- SHOW SLAVE HOSTS
- SHOW STATUS
- SHOW TABLES
- SHOW TABLE STATUS
- SHOW TRIGGERS
- SHOW VARIABLES
- SHOW WARNINGS/ERRORS
- UPDATE
- USE db_name
- System Views
- GUC Parameters
- Resetting Parameters
- Stored Procedures
- Identifiers
- SQL Reference
- MySQL Syntax Compatibility Assessment Tool
- Dolphin Extension
- Materialized View
- Partition Management
- Application Development Guide
- Performance Tuning Guide
- Reference Guide
- System Catalogs and System Views
- Overview
- Querying a System Catalog
- System Catalogs
- GS_ASP
- GS_AUDITING_POLICY
- GS_AUDITING_POLICY_ACCESS
- GS_AUDITING_POLICY_FILTERS
- GS_AUDITING_POLICY_PRIVILEGES
- GS_CLIENT_GLOBAL_KEYS
- GS_CLIENT_GLOBAL_KEYS_ARGS
- GS_COLUMN_KEYS
- GS_COLUMN_KEYS_ARGS
- GS_DB_PRIVILEGE
- GS_ENCRYPTED_COLUMNS
- GS_ENCRYPTED_PROC
- GS_GLOBAL_CHAIN
- GS_GLOBAL_CONFIG
- GS_MASKING_POLICY
- GS_MASKING_POLICY_ACTIONS
- GS_MASKING_POLICY_FILTERS
- GS_MATVIEW
- GS_MATVIEW_DEPENDENCY
- GS_MODEL_WAREHOUSE
- GS_OPT_MODEL
- GS_PACKAGE
- GS_POLICY_LABEL
- GS_RECYCLEBIN
- GS_TXN_SNAPSHOT
- GS_UID
- GS_WLM_EC_OPERATOR_INFO
- GS_WLM_INSTANCE_HISTORY
- GS_WLM_OPERATOR_INFO
- GS_WLM_PLAN_ENCODING_TABLE
- GS_WLM_PLAN_OPERATOR_INFO
- GS_WLM_SESSION_QUERY_INFO_ALL
- GS_WLM_USER_RESOURCE_HISTORY
- PG_AGGREGATE
- PG_AM
- PG_AMOP
- PG_AMPROC
- PG_APP_WORKLOADGROUP_MAPPING
- PG_ATTRDEF
- PG_ATTRIBUTE
- PG_AUTH_HISTORY
- PG_AUTH_MEMBERS
- PG_AUTHID
- PG_CAST
- PG_CLASS
- PG_COLLATION
- PG_CONSTRAINT
- PG_CONVERSION
- PG_DATABASE
- PG_DB_ROLE_SETTING
- PG_DEFAULT_ACL
- PG_DEPEND
- PG_DESCRIPTION
- PG_DIRECTORY
- PG_ENUM
- PG_EVENT_TRIGGER
- PG_EXTENSION
- PG_EXTENSION_DATA_SOURCE
- PG_FOREIGN_DATA_WRAPPER
- PG_FOREIGN_SERVER
- PG_FOREIGN_TABLE
- PG_HASHBUCKET
- PG_INDEX
- PG_INHERITS
- PG_JOB
- PG_JOB_PROC
- PG_LANGUAGE
- PG_LARGEOBJECT
- PG_LARGEOBJECT_METADATA
- PG_NAMESPACE
- PG_OBJECT
- PG_OPCLASS
- PG_OPERATOR
- PG_OPFAMILY
- PG_PARTITION
- PG_PLTEMPLATE
- PG_PROC
- PG_PUBLICATION
- PG_PUBLICATION_REL
- PG_RANGE
- PG_REPLICATION_ORIGIN
- PG_RESOURCE_POOL
- PG_REWRITE
- PG_RLSPOLICY
- PG_SECLABEL
- PG_SET
- PG_SHDEPEND
- PG_SHDESCRIPTION
- PG_SHSECLABEL
- PG_STATISTIC
- PG_STATISTIC_EXT
- PG_SUBSCRIPTION
- PG_SUBSCRIPTION_REL
- PG_SYNONYM
- PG_TABLESPACE
- PG_TRIGGER
- PG_TS_CONFIG
- PG_TS_CONFIG_MAP
- PG_TS_DICT
- PG_TS_PARSER
- PG_TS_TEMPLATE
- PG_TYPE
- PG_USER_MAPPING
- PG_USER_STATUS
- PG_WORKLOAD_GROUP
- PGXC_CLASS
- PGXC_GROUP
- PGXC_NODE
- PGXC_SLICE
- PLAN_TABLE_DATA
- STATEMENT_HISTORY
- System Views
- GET_GLOBAL_PREPARED_XACTS(Discarded)
- GS_ASYNC_SUBMIT_SESSIONS_STATUS
- GS_AUDITING
- GS_AUDITING_ACCESS
- GS_AUDITING_PRIVILEGE
- GS_CLUSTER_RESOURCE_INFO
- GS_COMPRESSION
- GS_DB_PRIVILEGES
- GS_FILE_STAT
- GS_GSC_MEMORY_DETAIL
- GS_INSTANCE_TIME
- GS_LABELS
- GS_LSC_MEMORY_DETAIL
- GS_MASKING
- GS_MATVIEWS
- GS_OS_RUN_INFO
- GS_REDO_STAT
- GS_SESSION_CPU_STATISTICS
- GS_SESSION_MEMORY
- GS_SESSION_MEMORY_CONTEXT
- GS_SESSION_MEMORY_DETAIL
- GS_SESSION_MEMORY_STATISTICS
- GS_SESSION_STAT
- GS_SESSION_TIME
- GS_SQL_COUNT
- GS_STAT_SESSION_CU
- GS_THREAD_MEMORY_CONTEXT
- GS_TOTAL_MEMORY_DETAIL
- GS_WLM_CGROUP_INFO
- GS_WLM_EC_OPERATOR_STATISTICS
- GS_WLM_OPERATOR_HISTORY
- GS_WLM_OPERATOR_STATISTICS
- GS_WLM_PLAN_OPERATOR_HISTORY
- GS_WLM_REBUILD_USER_RESOURCE_POOL
- GS_WLM_RESOURCE_POOL
- GS_WLM_SESSION_HISTORY
- GS_WLM_SESSION_INFO
- GS_WLM_SESSION_INFO_ALL
- GS_WLM_SESSION_STATISTICS
- GS_WLM_USER_INFO
- MPP_TABLES
- PG_AVAILABLE_EXTENSION_VERSIONS
- PG_AVAILABLE_EXTENSIONS
- PG_COMM_DELAY
- PG_COMM_RECV_STREAM
- PG_COMM_SEND_STREAM
- PG_COMM_STATUS
- PG_CONTROL_GROUP_CONFIG
- PG_CURSORS
- PG_EXT_STATS
- PG_GET_INVALID_BACKENDS
- PG_GET_SENDERS_CATCHUP_TIME
- PG_GROUP
- PG_GTT_ATTACHED_PIDS
- PG_GTT_RELSTATS
- PG_GTT_STATS
- PG_INDEXES
- PG_LOCKS
- PG_NODE_ENV
- PG_OS_THREADS
- PG_PREPARED_STATEMENTS
- PG_PREPARED_XACTS
- PG_PUBLICATION_TABLES
- PG_REPLICATION_ORIGIN_STATUS
- PG_REPLICATION_SLOTS
- PG_RLSPOLICIES
- PG_ROLES
- PG_RULES
- PG_RUNNING_XACTS
- PG_SECLABELS
- PG_SESSION_IOSTAT
- PG_SESSION_WLMSTAT
- PG_SETTINGS
- PG_SHADOW
- PG_STAT_ACTIVITY
- PG_STAT_ACTIVITY_NG
- PG_STAT_ALL_INDEXES
- PG_STAT_ALL_TABLES
- PG_STAT_BAD_BLOCK
- PG_STAT_BGWRITER
- PG_STAT_DATABASE
- PG_STAT_DATABASE_CONFLICTS
- PG_STAT_REPLICATION
- PG_STAT_SUBSCRIPTION
- PG_STAT_SYS_INDEXES
- PG_STAT_SYS_TABLES
- PG_STAT_USER_FUNCTIONS
- PG_STAT_USER_INDEXES
- PG_STAT_USER_TABLES
- PG_STAT_XACT_ALL_TABLES
- PG_STAT_XACT_SYS_TABLES
- PG_STAT_XACT_USER_FUNCTIONS
- PG_STAT_XACT_USER_TABLES
- PG_STATIO_ALL_INDEXES
- PG_STATIO_ALL_SEQUENCES
- PG_STATIO_ALL_TABLES
- PG_STATIO_SYS_INDEXES
- PG_STATIO_SYS_SEQUENCES
- PG_STATIO_SYS_TABLES
- PG_STATIO_USER_INDEXES
- PG_STATIO_USER_SEQUENCES
- PG_STATIO_USER_TABLES
- PG_STATS
- PG_TABLES
- PG_TDE_INFO
- PG_THREAD_WAIT_STATUS
- PG_TIMEZONE_ABBREVS
- PG_TIMEZONE_NAMES
- PG_TOTAL_MEMORY_DETAIL
- PG_TOTAL_USER_RESOURCE_INFO
- PG_TOTAL_USER_RESOURCE_INFO_OID
- PG_USER
- PG_USER_MAPPINGS
- PG_VARIABLE_INFO
- PG_VIEWS
- PG_WLM_STATISTICS
- PGXC_PREPARED_XACTS
- PLAN_TABLE
- Functions and Operators
- Logical Operators
- Comparison Operators
- Character Processing Functions and Operators
- Binary String Functions and Operators
- Bit String Functions and Operators
- Mode Matching Operators
- Mathematical Functions and Operators
- Date and Time Processing Functions and Operators
- Type Conversion Functions
- Geometric Functions and Operators
- Network Address Functions and Operators
- Text Search Functions and Operators
- JSON/JSONB Functions and Operators
- HLL Functions and Operators
- SEQUENCE Functions
- Array Functions and Operators
- Range Functions and Operators
- Aggregate Functions
- Window Functions(Analysis Functions)
- Security Functions
- Ledger Database Functions
- Encrypted Equality Functions
- Set Returning Functions
- Conditional Expression Functions
- System Information Functions
- System Administration Functions
- Configuration Settings Functions
- Universal File Access Functions
- Server Signal Functions
- Backup and Restoration Control Functions
- Snapshot Synchronization Functions
- Database Object Functions
- Advisory Lock Functions
- Logical Replication Functions
- Segment-Page Storage Functions
- Other Functions
- Undo System Functions
- Row-store Compression System Functions
- Statistics Information Functions
- Trigger Functions
- Event Trigger Functions
- Hash Function
- Prompt Message Function
- Global Temporary Table Functions
- Fault Injection System Function
- AI Feature Functions
- Dynamic Data Masking Functions
- Other System Functions
- Internal Functions
- Global SysCache Feature Functions
- Data Damage Detection and Repair Functions
- XML Functions
- Obsolete Functions
- Supported Data Types
- SQL Syntax
- ABORT
- ALTER AGGREGATE
- ALTER AUDIT POLICY
- ALTER DATABASE
- ALTER DATA SOURCE
- ALTER DEFAULT PRIVILEGES
- ALTER DIRECTORY
- ALTER EVENT
- ALTER EVENT TRIGGER
- ALTER EXTENSION
- ALTER FOREIGN DATA WRAPPER
- ALTER FOREIGN TABLE
- ALTER FUNCTION
- ALTER GLOBAL CONFIGURATION
- ALTER GROUP
- ALTER INDEX
- ALTER LANGUAGE
- ALTER LARGE OBJECT
- ALTER MASKING POLICY
- ALTER MATERIALIZED VIEW
- ALTER OPERATOR
- ALTER PACKAGE
- ALTER PROCEDURE
- ALTER PUBLICATION
- ALTER RESOURCE LABEL
- ALTER RESOURCE POOL
- ALTER ROLE
- ALTER ROW LEVEL SECURITY POLICY
- ALTER RULE
- ALTER SCHEMA
- ALTER SEQUENCE
- ALTER SERVER
- ALTER SESSION
- ALTER SUBSCRIPTION
- ALTER SYNONYM
- ALTER SYSTEM KILL SESSION
- ALTER SYSTEM SET
- ALTER TABLE
- ALTER TABLE PARTITION
- ALTER TABLE SUBPARTITION
- ALTER TABLESPACE
- ALTER TEXT SEARCH CONFIGURATION
- ALTER TEXT SEARCH DICTIONARY
- ALTER TRIGGER
- ALTER TYPE
- ALTER USER
- ALTER USER MAPPING
- ALTER VIEW
- ANALYZE | ANALYSE
- BEGIN
- CALL
- CHECKPOINT
- CLEAN CONNECTION
- CLOSE
- CLUSTER
- COMMENT
- COMMIT | END
- COMMIT PREPARED
- CONNECT BY
- COPY
- CREATE AGGREGATE
- CREATE AUDIT POLICY
- CREATE CAST
- CREATE CLIENT MASTER KEY
- CREATE COLUMN ENCRYPTION KEY
- CREATE DATABASE
- CREATE DATA SOURCE
- CREATE DIRECTORY
- CREATE EVENT
- CREATE EVENT TRIGGER
- CREATE EXTENSION
- CREATE FOREIGN DATA WRAPPER
- CREATE FOREIGN TABLE
- CREATE FUNCTION
- CREATE GROUP
- CREATE INCREMENTAL MATERIALIZED VIEW
- CREATE INDEX
- CREATE LANGUAGE
- CREATE MASKING POLICY
- CREATE MATERIALIZED VIEW
- CREATE MODEL
- CREATE OPERATOR
- CREATE PACKAGE
- CREATE PROCEDURE
- CREATE PUBLICATION
- CREATE RESOURCE LABEL
- CREATE RESOURCE POOL
- CREATE ROLE
- CREATE ROW LEVEL SECURITY POLICY
- CREATE RULE
- CREATE SCHEMA
- CREATE SEQUENCE
- CREATE SERVER
- CREATE SUBSCRIPTION
- CREATE SYNONYM
- CREATE TABLE
- CREATE TABLE AS
- CREATE TABLE PARTITION
- CREATE TABLESPACE
- CREATE TABLE SUBPARTITION
- CREATE TEXT SEARCH CONFIGURATION
- CREATE TEXT SEARCH DICTIONARY
- CREATE TRIGGER
- CREATE TYPE
- CREATE USER
- CREATE USER MAPPING
- CREATE VIEW
- CREATE WEAK PASSWORD DICTIONARY
- CURSOR
- DEALLOCATE
- DECLARE
- DELETE
- DELIMITER
- DO
- DROP AGGREGATE
- DROP AUDIT POLICY
- DROP CAST
- DROP CLIENT MASTER KEY
- DROP COLUMN ENCRYPTION KEY
- DROP DATABASE
- DROP DATA SOURCE
- DROP DIRECTORY
- DROP EVENT
- DROP EVENT TRIGGER
- DROP EXTENSION
- DROP FOREIGN DATA WRAPPER
- DROP FOREIGN TABLE
- DROP FUNCTION
- DROP GLOBAL CONFIGURATION
- DROP GROUP
- DROP INDEX
- DROP LANGUAGE
- DROP MASKING POLICY
- DROP MATERIALIZED VIEW
- DROP MODEL
- DROP OPERATOR
- DROP OWNED
- DROP PACKAGE
- DROP PROCEDURE
- DROP PUBLICATION
- DROP RESOURCE LABEL
- DROP RESOURCE POOL
- DROP ROLE
- DROP ROW LEVEL SECURITY POLICY
- DROP RULE
- DROP SCHEMA
- DROP SEQUENCE
- DROP SERVER
- DROP SUBSCRIPTION
- DROP SYNONYM
- DROP TABLE
- DROP TABLESPACE
- DROP TEXT SEARCH CONFIGURATION
- DROP TEXT SEARCH DICTIONARY
- DROP TRIGGER
- DROP TYPE
- DROP USER
- DROP USER MAPPING
- DROP VIEW
- DROP WEAK PASSWORD DICTIONARY
- EXECUTE
- EXECUTE DIRECT
- EXPLAIN
- EXPLAIN PLAN
- FETCH
- GRANT
- INSERT
- LOCK
- MERGE INTO
- MOVE
- PREDICT BY
- PREPARE
- PREPARE TRANSACTION
- PURGE
- REASSIGN OWNED
- REFRESH INCREMENTAL MATERIALIZED VIEW
- REFRESH MATERIALIZED VIEW
- REINDEX
- RELEASE SAVEPOINT
- RESET
- REVOKE
- ROLLBACK
- ROLLBACK PREPARED
- ROLLBACK TO SAVEPOINT
- SAVEPOINT
- SELECT
- SELECT INTO
- SET
- SET CONSTRAINTS
- SET ROLE
- SET SESSION AUTHORIZATION
- SET TRANSACTION
- SHOW
- SHOW EVENTS
- SHRINK
- SHUTDOWN
- SNAPSHOT
- START TRANSACTION
- TIMECAPSULE TABLE
- TRUNCATE
- UPDATE
- VACUUM
- VALUES
- SQL Reference
- MogDB SQL
- Keywords
- Constant and Macro
- Expressions
- Type Conversion
- Full Text Search
- System Operation
- Controlling Transactions
- DDL Syntax Overview
- DML Syntax Overview
- DCL Syntax Overview
- Subquery
- LLVM
- Alias
- Lock
- Transaction
- Ordinary Table
- Partitioned Table
- Index
- Constraints
- Cursors
- Anonymous Block
- Trigger
- INSERT_RIGHT_REF_DEFAULT_VALUE
- Appendix
- GUC Parameters
- GUC Parameter Usage
- GUC Parameter List
- File Location
- Connection and Authentication
- Resource Consumption
- Write Ahead Log
- HA Replication
- Query Planning
- Error Reporting and Logging
- Alarm Detection
- Statistics During the Database Running
- Load Management
- Automatic Vacuuming
- Default Settings of Client Connection
- Lock Management
- Version and Platform Compatibility
- Faut Tolerance
- Connection Pool Parameters
- MogDB Transaction
- Replication Parameters of Two Database Instances
- Developer Options
- Auditing
- CM Parameters
- Backend Compression
- Upgrade Parameters
- Miscellaneous Parameters
- Wait Events
- Query
- System Performance Snapshot
- Security Configuration
- Global Temporary Table
- HyperLogLog
- Scheduled Task
- Thread Pool
- User-defined Functions
- Backup and Restoration
- DCF Parameters Settings
- Flashback
- Rollback Parameters
- Reserved Parameters
- AI Features
- Global SysCache Parameters
- Parameters Related to Efficient Data Compression Algorithms
- Writer Statement Parameters Supported by Standby Servers
- Appendix
- Schema
- Information Schema
- DBE_PERF
- OS
- Instance
- Memory
- File
- Object
- STAT_USER_TABLES
- SUMMARY_STAT_USER_TABLES
- GLOBAL_STAT_USER_TABLES
- STAT_USER_INDEXES
- SUMMARY_STAT_USER_INDEXES
- GLOBAL_STAT_USER_INDEXES
- STAT_SYS_TABLES
- SUMMARY_STAT_SYS_TABLES
- GLOBAL_STAT_SYS_TABLES
- STAT_SYS_INDEXES
- SUMMARY_STAT_SYS_INDEXES
- GLOBAL_STAT_SYS_INDEXES
- STAT_ALL_TABLES
- SUMMARY_STAT_ALL_TABLES
- GLOBAL_STAT_ALL_TABLES
- STAT_ALL_INDEXES
- SUMMARY_STAT_ALL_INDEXES
- GLOBAL_STAT_ALL_INDEXES
- STAT_DATABASE
- SUMMARY_STAT_DATABASE
- GLOBAL_STAT_DATABASE
- STAT_DATABASE_CONFLICTS
- SUMMARY_STAT_DATABASE_CONFLICTS
- GLOBAL_STAT_DATABASE_CONFLICTS
- STAT_XACT_ALL_TABLES
- SUMMARY_STAT_XACT_ALL_TABLES
- GLOBAL_STAT_XACT_ALL_TABLES
- STAT_XACT_SYS_TABLES
- SUMMARY_STAT_XACT_SYS_TABLES
- GLOBAL_STAT_XACT_SYS_TABLES
- STAT_XACT_USER_TABLES
- SUMMARY_STAT_XACT_USER_TABLES
- GLOBAL_STAT_XACT_USER_TABLES
- STAT_XACT_USER_FUNCTIONS
- SUMMARY_STAT_XACT_USER_FUNCTIONS
- GLOBAL_STAT_XACT_USER_FUNCTIONS
- STAT_BAD_BLOCK
- SUMMARY_STAT_BAD_BLOCK
- GLOBAL_STAT_BAD_BLOCK
- STAT_USER_FUNCTIONS
- SUMMARY_STAT_USER_FUNCTIONS
- GLOBAL_STAT_USER_FUNCTIONS
- Workload
- Session/Thread
- SESSION_STAT
- GLOBAL_SESSION_STAT
- SESSION_TIME
- GLOBAL_SESSION_TIME
- SESSION_MEMORY
- GLOBAL_SESSION_MEMORY
- SESSION_MEMORY_DETAIL
- GLOBAL_SESSION_MEMORY_DETAIL
- SESSION_STAT_ACTIVITY
- GLOBAL_SESSION_STAT_ACTIVITY
- THREAD_WAIT_STATUS
- GLOBAL_THREAD_WAIT_STATUS
- LOCAL_THREADPOOL_STATUS
- GLOBAL_THREADPOOL_STATUS
- SESSION_CPU_RUNTIME
- SESSION_MEMORY_RUNTIME
- STATEMENT_IOSTAT_COMPLEX_RUNTIME
- LOCAL_ACTIVE_SESSION
- Transaction
- Query
- STATEMENT
- SUMMARY_STATEMENT
- STATEMENT_COUNT
- GLOBAL_STATEMENT_COUNT
- SUMMARY_STATEMENT_COUNT
- GLOBAL_STATEMENT_COMPLEX_HISTORY
- GLOBAL_STATEMENT_COMPLEX_HISTORY_TABLE
- GLOBAL_STATEMENT_COMPLEX_RUNTIME
- STATEMENT_RESPONSETIME_PERCENTILE
- STATEMENT_COMPLEX_RUNTIME
- STATEMENT_COMPLEX_HISTORY_TABLE
- STATEMENT_COMPLEX_HISTORY
- STATEMENT_WLMSTAT_COMPLEX_RUNTIME
- STATEMENT_HISTORY
- Cache/IO
- STATIO_USER_TABLES
- SUMMARY_STATIO_USER_TABLES
- GLOBAL_STATIO_USER_TABLES
- STATIO_USER_INDEXES
- SUMMARY_STATIO_USER_INDEXES
- GLOBAL_STATIO_USER_INDEXES
- STATIO_USER_SEQUENCES
- SUMMARY_STATIO_USER_SEQUENCES
- GLOBAL_STATIO_USER_SEQUENCES
- STATIO_SYS_TABLES
- SUMMARY_STATIO_SYS_TABLES
- GLOBAL_STATIO_SYS_TABLES
- STATIO_SYS_INDEXES
- SUMMARY_STATIO_SYS_INDEXES
- GLOBAL_STATIO_SYS_INDEXES
- STATIO_SYS_SEQUENCES
- SUMMARY_STATIO_SYS_SEQUENCES
- GLOBAL_STATIO_SYS_SEQUENCES
- STATIO_ALL_TABLES
- SUMMARY_STATIO_ALL_TABLES
- GLOBAL_STATIO_ALL_TABLES
- STATIO_ALL_INDEXES
- SUMMARY_STATIO_ALL_INDEXES
- GLOBAL_STATIO_ALL_INDEXES
- STATIO_ALL_SEQUENCES
- SUMMARY_STATIO_ALL_SEQUENCES
- GLOBAL_STATIO_ALL_SEQUENCES
- GLOBAL_STAT_DB_CU
- GLOBAL_STAT_SESSION_CU
- Utility
- REPLICATION_STAT
- GLOBAL_REPLICATION_STAT
- REPLICATION_SLOTS
- GLOBAL_REPLICATION_SLOTS
- BGWRITER_STAT
- GLOBAL_BGWRITER_STAT
- GLOBAL_CKPT_STATUS
- GLOBAL_DOUBLE_WRITE_STATUS
- GLOBAL_PAGEWRITER_STATUS
- GLOBAL_RECORD_RESET_TIME
- GLOBAL_REDO_STATUS
- GLOBAL_RECOVERY_STATUS
- CLASS_VITAL_INFO
- USER_LOGIN
- SUMMARY_USER_LOGIN
- GLOBAL_GET_BGWRITER_STATUS
- GLOBAL_SINGLE_FLUSH_DW_STATUS
- GLOBAL_CANDIDATE_STATUS
- Lock
- Wait Events
- Configuration
- Operator
- Workload Manager
- Global Plancache
- RTO
- DBE_PLDEBUGGER Schema
- DBE_PLDEBUGGER.turn_on
- DBE_PLDEBUGGER.turn_off
- DBE_PLDEBUGGER.local_debug_server_info
- DBE_PLDEBUGGER.attach
- DBE_PLDEBUGGER.info_locals
- DBE_PLDEBUGGER.next
- DBE_PLDEBUGGER.continue
- DBE_PLDEBUGGER.abort
- DBE_PLDEBUGGER.print_var
- DBE_PLDEBUGGER.info_code
- DBE_PLDEBUGGER.step
- DBE_PLDEBUGGER.add_breakpoint
- DBE_PLDEBUGGER.delete_breakpoint
- DBE_PLDEBUGGER.info_breakpoints
- DBE_PLDEBUGGER.backtrace
- DBE_PLDEBUGGER.disable_breakpoint
- DBE_PLDEBUGGER.enable_breakpoint
- DBE_PLDEBUGGER.finish
- DBE_PLDEBUGGER.set_var
- DB4AI Schema
- DBE_PLDEVELOPER
- DBE_SQL_UTIL Schema
- Tool Reference
- Tool Overview
- Client Tool
- Server Tools
- Tools Used in the Internal System
- dsscmd
- dssserver
- mogdb
- gs_backup
- gs_basebackup
- gs_ctl
- gs_initdb
- gs_install
- gs_postuninstall
- gs_preinstall
- gs_sshexkey
- gs_tar
- gs_uninstall
- gs_upgradectl
- gs_expansion
- gs_dropnode
- gs_probackup
- gstrace
- kdb5_util
- kadmin.local
- kinit
- klist
- krb5kdc
- kdestroy
- pg_config
- pg_controldata
- pg_recvlogical
- pg_resetxlog
- pg_archivecleanup
- pssh
- pscp
- transfer.py
- FAQ
- Functions of MogDB Executable Scripts
- System Catalogs and Views Supported by gs_collector
- Error Code Reference
- Description of SQL Error Codes
- Third-Party Library Error Codes
- GAUSS-00001 - GAUSS-00100
- GAUSS-00101 - GAUSS-00200
- GAUSS 00201 - GAUSS 00300
- GAUSS 00301 - GAUSS 00400
- GAUSS 00401 - GAUSS 00500
- GAUSS 00501 - GAUSS 00600
- GAUSS 00601 - GAUSS 00700
- GAUSS 00701 - GAUSS 00800
- GAUSS 00801 - GAUSS 00900
- GAUSS 00901 - GAUSS 01000
- GAUSS 01001 - GAUSS 01100
- GAUSS 01101 - GAUSS 01200
- GAUSS 01201 - GAUSS 01300
- GAUSS 01301 - GAUSS 01400
- GAUSS 01401 - GAUSS 01500
- GAUSS 01501 - GAUSS 01600
- GAUSS 01601 - GAUSS 01700
- GAUSS 01701 - GAUSS 01800
- GAUSS 01801 - GAUSS 01900
- GAUSS 01901 - GAUSS 02000
- GAUSS 02001 - GAUSS 02100
- GAUSS 02101 - GAUSS 02200
- GAUSS 02201 - GAUSS 02300
- GAUSS 02301 - GAUSS 02400
- GAUSS 02401 - GAUSS 02500
- GAUSS 02501 - GAUSS 02600
- GAUSS 02601 - GAUSS 02700
- GAUSS 02701 - GAUSS 02800
- GAUSS 02801 - GAUSS 02900
- GAUSS 02901 - GAUSS 03000
- GAUSS 03001 - GAUSS 03100
- GAUSS 03101 - GAUSS 03200
- GAUSS 03201 - GAUSS 03300
- GAUSS 03301 - GAUSS 03400
- GAUSS 03401 - GAUSS 03500
- GAUSS 03501 - GAUSS 03600
- GAUSS 03601 - GAUSS 03700
- GAUSS 03701 - GAUSS 03800
- GAUSS 03801 - GAUSS 03900
- GAUSS 03901 - GAUSS 04000
- GAUSS 04001 - GAUSS 04100
- GAUSS 04101 - GAUSS 04200
- GAUSS 04201 - GAUSS 04300
- GAUSS 04301 - GAUSS 04400
- GAUSS 04401 - GAUSS 04500
- GAUSS 04501 - GAUSS 04600
- GAUSS 04601 - GAUSS 04700
- GAUSS 04701 - GAUSS 04800
- GAUSS 04801 - GAUSS 04900
- GAUSS 04901 - GAUSS 05000
- GAUSS 05001 - GAUSS 05100
- GAUSS 05101 - GAUSS 05200
- GAUSS 05201 - GAUSS 05300
- GAUSS 05301 - GAUSS 05400
- GAUSS 05401 - GAUSS 05500
- GAUSS 05501 - GAUSS 05600
- GAUSS 05601 - GAUSS 05700
- GAUSS 05701 - GAUSS 05800
- GAUSS 05801 - GAUSS 05900
- GAUSS 05901 - GAUSS 06000
- GAUSS 06001 - GAUSS 06100
- GAUSS 06101 - GAUSS 06200
- GAUSS 06201 - GAUSS 06300
- GAUSS 06301 - GAUSS 06400
- GAUSS 06401 - GAUSS 06500
- GAUSS 06501 - GAUSS 06600
- GAUSS 06601 - GAUSS 06700
- GAUSS 06701 - GAUSS 06800
- GAUSS 06801 - GAUSS 06900
- GAUSS 06901 - GAUSS 07000
- GAUSS 07001 - GAUSS 07100
- GAUSS 07101 - GAUSS 07200
- GAUSS 07201 - GAUSS 07300
- GAUSS 07301 - GAUSS 07400
- GAUSS 07401 - GAUSS 07500
- GAUSS 50000 - GAUSS 50999
- GAUSS 51000 - GAUSS 51999
- GAUSS 52000 - GAUSS 52999
- GAUSS 53000 - GAUSS 53699
- Error Log Reference
- System Catalogs and System Views
- Common Faults and Identification
- Common Fault Locating Methods
- Common Fault Locating Cases
- Core Fault Locating
- Permission/Session/Data Type Fault Location
- Service/High Availability/Concurrency Fault Location
- Standby Node in the Need Repair (WAL) State
- Service Startup Failure
- Primary Node Is Hung in Demoting During a Switchover
- "too many clients already" Is Reported or Threads Failed To Be Created in High Concurrency Scenarios
- Performance Deterioration Caused by Dirty Page Flushing Efficiency During TPCC High Concurrentcy Long Term Stable Running
- A Query Error Is Reported Due to Predicate Pushdown
- Table/Partition Table Fault Location
- File System/Disk/Memory Fault Location
- After You Run the du Command to Query Data File Size In the XFS File System, the Query Result Is Greater than the Actual File Size
- File Is Damaged in the XFS File System
- Insufficient Memory
- "Error:No space left on device" Is Displayed
- When the TPC-C is running and a disk to be injected is full, the TPC-C stops responding
- Disk Space Usage Reaches the Threshold and the Database Becomes Read-only
- Shared Memory Leakage
- SQL Fault Location
- Index Fault Location
- CM Two-Node Fault Location
- Source Code Parsing
- FAQs
- Glossary
- Communication Matrix
- Mogeaver
GAUSS-00001 - GAUSS-00100
GAUSS-00001 - GAUSS-00010
GAUSS-00001: "operator does not exist: %s"
SQLSTATE: 42883
Description: The specified operator does not exist.
Solution: Ensure that the error code contains the data type corresponding to the operator so that you can check whether the operator exists in the system catalog.
GAUSS-00002: "could not identify an ordering operator for type %s"
SQLSTATE: 42883
Description: When you perform a sort or group operation, data is sorted. If the greater than (gt) or less than (lt) operator corresponding to the data type does not exist, this error is reported.
Solution: The error code contains a data type. Query the operator corresponding to the data type from the pg_operator system catalog before using the operator and ensure that the operator exists.
GAUSS-00003: "could not identify an equality operator for type %s"
SQLSTATE: 42883
Description: When you perform a group or unique operation, if the equal to (et) operation is involved, but the operator corresponding to the involved data type does not exist, this error is reported.
Solution: The error code contains a data type. Query the operator corresponding to the data type from the pg_operator system catalog before using the operator and ensure that the operator exists.
GAUSS-00004: "operator requires run-time type coercion: %s"
SQLSTATE: 42883
Description:order by using is used to specify an operator. During code execution, a parse function checks whether the provided data type and operator match. If they do not match, this error is reported.
Solution: Ensure that the specified operator and data type match.
GAUSS-00005: "operator is not unique: %s"
SQLSTATE: 42725
Description: No identified operators are provided for certain data types. Data types need to be converted to match proper operators. When multiple data types are converted, this error is reported.
Solution: Convert a data type that has no corresponding operator to use a specific operator.
GAUSS-00006: "operator is only a shell: %s"
SQLSTATE: 42883
Description: Undefined function.
Solution: Modify the input statement.
GAUSS-00007: "op ANY/ALL (array) requires array on right side"
SQLSTATE: 42809
Description: For the ANY/ALL (array) operator, the right parameter is not of the array type.
Solution: For the ANY/ALL (array) operator, use the right parameter of the array type.
GAUSS-00008: "op ANY/ALL (array) requires operator to yield Boolean"
SQLSTATE: 42809
Description: The value returned for the ANY/ALL (array) operator is not of the Boolean type.
Solution: Ensure that the value returned for the ANY/ALL (array) operator is of the Boolean type.
GAUSS-00009: "op ANY/ALL (array) requires operator not to return a set"
SQLSTATE: 42809
Description: The value returned for the ANY/ALL (array) operator is of the set type, which is not supported.
Solution: Ensure that the value returned for the ANY/ALL (array) operator is of a type excluding the set type.
GAUSS-00010: "could not find array type for data type %s"
SQLSTATE: 42704
Description: The array type corresponding to a data type cannot be found.
Solution: When using the array type corresponding to a data type, ensure that any corresponding or compatible array type exists in the pg_type system catalog.
GAUSS-00011 - GAUSS-00020
GAUSS-00011: "hash table corrupted"
SQLSTATE: LL002
Description: The hash table is damaged.
Solution:Contact technical support.
GAUSS-00012: "target lists can have at most %d entries"
SQLSTATE: 54000
Description: The number of attributes in the target list exceeds 1664.
Solution: Reduce the number of attributes in the target list.
GAUSS-00013: "cache lookup failed for type %u"
SQLSTATE: 22P06
Description: The operator is invalid.
Solution: Ensure that the operator in the SQL statement is valid.
GAUSS-00014: "cannot subscript type %s because it is not an array"
SQLSTATE: 42804
Description: A subscript operation is performed on a non-array type.
Solution: Do not perform a subscript operation on a non-array type.
GAUSS-00015: "array subscript must have type integer"
SQLSTATE: 42804
Description: The array subscript is incorrect.
Solution: Ensure that the array subscript is an integer.
GAUSS-00016: "array assignment requires type %s but expression is of type %s"
SQLSTATE: 42804
Description: When you set variables of an array type, variables cannot be converted.
Solution: Reassign values to variables. Provide a conversion function so that variables of an array type can be converted. Obtain related information from the pg_cast system catalog.
GAUSS-00017: "unrecognized node type: %d"
SQLSTATE: XX004
Description:Internal system error.
Solution:Contact technical support.
GAUSS-00018: "failed to find conversion function from %s to %s"
SQLSTATE: XX000
Description:Internal system error.
Solution:Contact technical support.
GAUSS-00020: "cache lookup failed for function %u"
SQLSTATE: 22P06
Description: The function with the corresponding ID is not found in the system catalog.
Solution: Ensure that no concurrent sessions perform a drop, cancel, or replace operation on the function.
GAUSS-00021 - GAUSS-00030
GAUSS-00021: "unsupported pathtype %d in build_coercion_expression"
SQLSTATE: XX000
Description:Internal system error.
Solution:Contact technical support.
GAUSS-00022: "cannot cast type %s to %s"
SQLSTATE: 42846
Description: Two types cannot be converted to each other.
Solution: Provide a type conversion function. Obtain related information from the pg_cast system catalog.
GAUSS-00024: "argument of %s must not return a set"
SQLSTATE: 42804
Description: A set cannot be returned.
Solution: Ensure that the expression can return a set.
GAUSS-00025: "argument of %s must be type %s, not type %s"
SQLSTATE: 42804
Description: The source and target types are different and cannot be converted.
Solution: Ensure that the source and target types are compatible and can be convertible.
GAUSS-00026: "%s types %s and %s cannot be matched"
SQLSTATE: 42804
Description: The two types do not belong to the same category.
Solution: Check the typcategory column in the pg_type system catalog for the category of each type.
GAUSS-00027: "%s could not convert type %s to %s"
SQLSTATE: 42846
Description: The source and target types are different and cannot be converted.
Solution: Ensure that the source and target types are compatible and can be convertible.
GAUSS-00028: "arguments declared 'anyelement' are not all alike"
SQLSTATE: 42804
Description: A function uses pseudo-type parameters, but the types of elements in an array are different from the defined ones.
Solution: Ensure that the types of elements in an array are same as the defined ones.
GAUSS-00029: "arguments declared 'anyarray' are not all alike"
SQLSTATE: 42804
Description: A function uses pseudo-type parameters, but the types of elements in an array are different from the defined ones.
Solution: Ensure that the types of elements in an array are same as the defined ones.
GAUSS-00030: "arguments declared 'anyrange' are not all alike"
SQLSTATE: 42804
Description: A function uses pseudo-type parameters, but the types of elements in an array are different from the defined ones.
Solution: Ensure that the types of elements in an array are same as the defined ones.
GAUSS-00031 - GAUSS-00040
GAUSS-00031: "argument declared 'anyarray' is not an array but type %s"
SQLSTATE: 42804
Description: The type of the declared parameter is inconsistent with that of the input parameter.
Solution: Use an input parameter of the same type as the declared parameter.
GAUSS-00032: "argument declared 'anyarray' is not consistent with argument declared 'anyelement'"
SQLSTATE: 42804
Description: The array type defined does not match the types of elements in an ANY array.
Solution: Ensure that the array type defined in the query statement and the types of elements in an ANY array are correct.
GAUSS-00033: "argument declared 'anyrange' is not a range but type %s"
SQLSTATE: 42804
Description: The range type defined does not match the types of elements in an ANY range.
Solution: Ensure that the range type defined in the query statement and the types of elements in an ANY range are correct.
GAUSS-00034: "argument declared 'anyrange' is not consistent with argument declared 'anyelement'"
SQLSTATE: 42804
Description: The parameter type is different from the declared parameter type.
Solution: Use a parameter of the declared type.
GAUSS-00035: "could not determine polymorphic type because input has type 'unknown'"
SQLSTATE: 42804
Description: Array element types cannot be identified.
Solution: Ensure that the array element types in the ANY predicate are correct.
GAUSS-00036: "type matched to anynonarray is an array type: %s"
SQLSTATE: 42804
Description: The required type is not array.
Solution: Internal system error. Contact technical support.
GAUSS-00037: "type matched to anyenum is not an enum type: %s"
SQLSTATE: 42804
Description: The required type is ENUM.
Solution: Ensure that an ENUM-type value is used for the parameter of the ANYENUM type.
GAUSS-00038: "could not find range type for data type %s"
SQLSTATE: 42704
Description: The declared array type is range, but the input value is not of the range type.
Solution: Assign a value of the defined type to the array.
GAUSS-00039: "could not determine polymorphic type because context isn't polymorphic"
SQLSTATE: XX000
Description:Internal system error.
Solution:Contact technical support.
GAUSS-00040: "unrecognized castcontext: %d"
SQLSTATE: XX000
Description:Internal system error.
Solution:Contact technical support.
GAUSS-00041 - GAUSS-00050
GAUSS-00041: "unrecognized castmethod: %d"
SQLSTATE: XX000
Description:Internal system error.
Solution:Contact technical support.
GAUSS-00042: "cache lookup failed for relation %u"
SQLSTATE: XX000
Description: When ALTER TABLE SET TABLESPACE is run, the relational table does not exist.
Solution: Modify this operation.
GAUSS-00043: "unsafe use of string constant with Unicode escapes"
SQLSTATE: 0A000
Description: When standard_conforming_strings is set to off, the string constant is defined as an escape character of unified codes.
Solution: 1. Check whether the escape string in the input statement is correct. 2. Set standard_conforming_strings to on using gsql.
GAUSS-00044: "invalid Unicode escape"
SQLSTATE: 22025
Description: The input statement contains an invalid escape character sequence.
Solution: Check whether a character sequence similar to \uXXXX or \UXXXXXXXXX exists. X indicates a digit (0-9), uppercase letter (A-F), or lowercase letter (a-f).
GAUSS-00045: "unsafe use of \' in a string literal"
SQLSTATE: 22P06
Description: A string uses an invalid escape character ().
Solution: Correct the invalid escape character () used in the SQL syntax.
GAUSS-00046: "%s at end of input"
SQLSTATE: 42601
Description: The syntax of the terminator in the specified statement is incorrect.
Solution: Ensure that the syntax of the input statement is correct.
GAUSS-00047: "%s at or near '%s'"
SQLSTATE: 42601
Description: Syntax error.
Solution: Correct the syntax of the SQL statement to be executed.
GAUSS-00048: "core_yylex_init() failed: %m"
SQLSTATE: XX000
Description:Internal system error.
Solution:Contact technical support.
GAUSS-00049: "invalid hexadecimal digit"
SQLSTATE: XX000
Description: Invalid format.
Solution: Modify the input SQL statement.
GAUSS-00051 - GAUSS-00060
GAUSS-00052: "column '%s' of relation '%s' does not exist"
SQLSTATE: 42703
Description: The column name is empty, incorrectly spelled, or not a column name defined in a relational table.
Solution: Run \d tblname to check whether the specified column name is the one specified in the table. If it is not, change it to a valid column name.
GAUSS-00053: "type '%s' does not exist"
SQLSTATE: 42704
Description: A specified type is not found in the pg_type system catalog.
Solution: Correct the type used in the statement. (See types defined in the pg_type system catalog.)
GAUSS-00054: "type '%s' is only a shell"
SQLSTATE: 42704
Description: No corresponding operation functions are defined in the pg_type system catalog for a specified type.
Solution: Check whether the type used in the statement is correct. If it is, use the CREATE TYPE statement to define the operation function corresponding to the specified type.
GAUSS-00055: "type modifier cannot be specified for shell type '%s'"
SQLSTATE: 42601
Description: The user-defined type contains typmod.
Solution: Correct the user-defined type, typmod.
GAUSS-00056: "type modifier is not allowed for type '%s'"
SQLSTATE: 42601
Description: The user-defined type contains typmod.
Solution: Correct the user-defined type, typmod.
GAUSS-00057: "type modifiers must be simple constants or identifiers"
SQLSTATE: 42601
Description: The provided type modifier is incorrect.
Solution: A type modifier must be defined as a constant or identifier. Check whether the syntax of the specified type modifier is correct. If it is incorrect, define a valid type modifier.
GAUSS-00058: "collations are not supported by type %s"
SQLSTATE: 42804
Description: The collation does not match the type, and the input is incorrect.
Solution: Modify the input SQL statement.
GAUSS-00059: "typeTypeId() called with NULL type struct"
SQLSTATE: XX000
Description:Internal system error.
Solution:Contact technical support.
GAUSS-00060: "invalid type name '%s'"
SQLSTATE: 42601
Description: The specified type is invalid.
Solution: Correct the type used in the statement. (See types defined in the pg_type system catalog.)
GAUSS-00061 - GAUSS-00070
GAUSS-00061: "unrecognized A_Expr kind: %d"
SQLSTATE: XX000
Description:Internal system error.
Solution:Contact technical support.
GAUSS-00062: "column %s.%s does not exist"
SQLSTATE: 42703
Description: The column name is empty, incorrectly spelled, or not a column name defined in a relational table.
Solution: Run \d tblname to check whether the specified column name is the one specified in the table. If it is not, change it to a valid column name.
GAUSS-00063: "column '%s' not found in data type %s"
SQLSTATE: 42703
Description: The type of the specified column is incorrectly defined.
Solution: Run \d tblname to check whether the type of the column in the table is correct.
GAUSS-00064: "could not identify column '%s' in record data type"
SQLSTATE: 42703
Description: The column does not exist because it cannot be identified using the record data type.
Solution: Ensure that the column exists.
GAUSS-00065: "column notation .%s applied to type %s, which is not a composite type"
SQLSTATE: 42809
Description: A non-composite type member is accessed using a dot (.).
Solution: Do not use a dot (.) to access a non-composite type member.
GAUSS-00066: "row expansion via '*' is not supported here"
SQLSTATE: 0A000
Description: The current context does not support unfolding columns using an asterisk (*).
Solution: Do not use an asterisk (*) to unfold columns in the current context.
GAUSS-00067: "column reference '%s' is ambiguous"
SQLSTATE: 42702
Description: A column is referenced multiple times.
Solution: Do not reference a column multiple times.
GAUSS-00068: "column '%s' does not exist"
SQLSTATE: 42703
Description: The column does not exist.
Solution: Ensure that the column to be used exists in the table definition.
GAUSS-00069: "cross-database references are not implemented: %s"
SQLSTATE: 0A000
Description: An object cannot be referenced from a database to another.
Solution: Do not reference an object from a database to another. For example, do not access an object in Database1 from Database2 using Database1.schema.object. The object can be a table, index, or view.
GAUSS-00070: "improper qualified name (too many dotted names): %s"
SQLSTATE: 42601
Description: Excessive dot separators are used. As a result, the name cannot be correctly resolved.
Solution: Reduce the number of dot separators and try again.
GAUSS-00071 - GAUSS-00080
GAUSS-00071: "there is no parameter $%d"
SQLSTATE: 42P02
Description: The parameter sequence number is invalid.
Solution: Ensure that the parameter sequence number is within the range.
GAUSS-00072: "NULLIF requires = operator to yield Boolean"
SQLSTATE: 42804
Description: When comparing parameters in the NULLIF expression, the return value of the function used is not of the Boolean type.
Solution: Ensure that the return value of the function is a Boolean type.
GAUSS-00073: "arguments of row IN must all be row expressions"
SQLSTATE: 42601
Description: The parameter in the IN expression is neither of the array type nor a row expression.
Solution: Ensure that the parameter is an array type or a row expression.
GAUSS-00074: "unexpected non-SELECT command in SubLink"
SQLSTATE: XX000
Description:Internal system error.
Solution:Contact technical support.
GAUSS-00075: "subquery must return a column"
SQLSTATE: 42601
Description: No columns are returned for a subquery.
Solution: Ensure that at least one column is returned for a subquery.
GAUSS-00076: "subquery must return only one column"
SQLSTATE: 42601
Description: When a subquery is used as a sub-expression, more than one column is returned.
Solution: Ensure that only one column is returned.
GAUSS-00077: "subquery has too many columns"
SQLSTATE: 42601
Description: In a row expression, the number of columns returned for a subquery is more than the number of required columns.
Solution: Ensure that the number of columns returned is the same as the number of required columns.
GAUSS-00078: "subquery has too few columns"
SQLSTATE: 42601
Description: In a row expression, the number of columns returned for a subquery is less than the number of required columns.
Solution: Ensure that the number of columns returned is the same as the number of required columns.
GAUSS-00079: "cannot determine type of empty array"
SQLSTATE: 42P18
Description: The type of an empty array cannot be determined.
Solution: Forcibly convert the data type.
GAUSS-00080: "could not find element type for data type %s"
SQLSTATE: 42704
Description: The type of an element in the array is invalid.
Solution: Ensure that the type of an element stored in the array is the same as the specified one.
GAUSS-00081 - GAUSS-00090
GAUSS-00081: "unnamed XML attribute value must be a column reference"
SQLSTATE: 42601
Description: The unnamed XML attribute values must be referenced by a column.
Solution: Modify the input SQL statement.
GAUSS-00082: "XML attribute name '%s' appears more than once"
SQLSTATE: 42601
Description: A duplicate column exists in XMLELEMENT.
Solution: Modify the input SQL statement.
GAUSS-00083: "cannot cast XMLSERIALIZE result to %s"
SQLSTATE: 42846
Description: The XMLSERIALIZE type is converted to another type.
Solution: Ensure that types can be converted.
GAUSS-00084: "unrecognized booltesttype: %d"
SQLSTATE: XX004
Description:Internal system error.
Solution:Contact technical support.
GAUSS-00085: "WHERE CURRENT OF clause not yet supported"
SQLSTATE: 54001
Description: The WHERE CURRENT OF syntax is used, which is not supported.
Solution: Do not use the WHERE CURRENT OF syntax.
GAUSS-00086: "unequal number of entries in row expressions"
SQLSTATE: 42601
Description: In a row expression, the number of parameters on the right and that on the left of the equal to (et) operator are different.
Solution: Ensure that the numbers are the same.
GAUSS-00087: "cannot compare rows of zero length"
SQLSTATE: 0A000
Description: The lengths of rows to be compared are zero.
Solution: Ensure that the lengths are not zero.
GAUSS-00088: "row comparison operator must yield type Boolean, not type %s"
SQLSTATE: 42804
Description: The value returned after row expression comparison is not a Boolean type.
Solution: Ensure that the value returned is a Boolean type.
GAUSS-00089: "row comparison operator must not return a set"
SQLSTATE: 42804
Description: The value returned after row expression comparison is a set.
Solution: Ensure that the value returned is not a set.
GAUSS-00090: "could not determine interpretation of row comparison operator %s"
SQLSTATE: 0A000
Description: The row comparison operator cannot be found.
Solution: Ensure that the row comparison operator to be used exists.
GAUSS-00091 - GAUSS-00100
GAUSS-00091: "IS DISTINCT FROM requires = operator to yield Boolean"
SQLSTATE: 42804
Description: In the IS DISTINCT FROM statement, the value returned for the operator used for deduplication is not of the Boolean type.
Solution: Ensure that the value returned is a Boolean type.
GAUSS-00092: "collation mismatch between implicit collations '%s' and '%s'"
SQLSTATE: 42P21
Description: Two character sets cannot be converted in implicit mode.
Solution: Ensure that two character sets to be converted are compatible.
GAUSS-00093: "collation mismatch between explicit collations '%s' and '%s'"
SQLSTATE: 42P21
Description: Two character sets cannot be converted in explicit mode.
Solution: Ensure that two character sets to be converted are compatible.
GAUSS-00094: "table reference '%s' is ambiguous"
SQLSTATE: 42P09
Description: Table reference is ambiguous because duplicate table names exist.
Solution: Provide a specific table name when referencing a table.
GAUSS-00095: "table reference %u is ambiguous"
SQLSTATE: 42P09
Description: Table reference is ambiguous because duplicate table names exist.
Solution: Provide a specific table name when referencing a table.
GAUSS-00096: "table name '%s' specified more than once"
SQLSTATE: 42712
Description: In the FROM clause, the same table is used multiple times without an alias.
Solution: Specify an alias for the table so that it can be used multiple times.
GAUSS-00097: "RTE not found (internal error)"
SQLSTATE: XX000
Description:Internal system error.
Solution:Contact technical support.
GAUSS-00098: "bad levelsup for CTE '%s'"
SQLSTATE: XX000
Description:Internal system error.
Solution:Contact technical support.
GAUSS-00099: "could not find CTE '%s'"
SQLSTATE: XX000
Description:Internal system error.
Solution:Contact technical support.