OceanBase
English日本語简体中文
Docs Home
Products
Integrations
Release Notes

Databases

OceanBase DatabaseOceanBase AI DatabaseOceanBase Cloud OceanBase Best Practices

Tools

OceanBase Cloud PlatformOceanBase Migration ServiceOceanBase Developer CenterOceanBase Migration AssessmentOceanBase Admin ToolOceanBase Loader and DumperOceanBase DeployerKubernetes operator for OceanBaseOceanBase Diagnostic Tool OceanBase Binlog ServiceOceanBase DataPilotOceanBase OAgent

Connectors and Middleware

OceanBase Database Proxy OceanBase Connector/C OceanBase Connector/J OceanBase Connector/ODBC OceanBase Connector/NETOceanBase Command-Line Client

Databases

OceanBase DatabaseOceanBase AI DatabaseOceanBase Cloud OceanBase Best Practices

Connectors and Middleware

OceanBase Database Proxy OceanBase Connector/C OceanBase Connector/J OceanBase Connector/ODBC OceanBase Connector/NETOceanBase Command-Line Client

Tools

OceanBase Cloud PlatformOceanBase Migration ServiceOceanBase Developer CenterOceanBase Migration AssessmentOceanBase Admin ToolOceanBase Loader and DumperOceanBase DeployerKubernetes operator for OceanBaseOceanBase Diagnostic Tool OceanBase Binlog ServiceOceanBase DataPilotOceanBase OAgent
OceanBase DatabaseOceanBase Cloud ToolsConnectors and MiddlewareLifecycle Support Policy

OceanBase AI Database

V4.6.3
  • Introduction
    • Overview
    • Core features
    • System architecture
  • Get Started
    • Get started with OceanBase AI Database
  • Deploy
    • Choose an appropriate deployment plan
    • Deployment process
    • Before deployment
      • Prepare servers
      • Configure Servers
      • Prepare object storage
      • Prepare installation packages
      • Deploy OAT
    • Add a server
    • Deploy OCP
      • OCP deployment overview
      • Upload installation packages
      • Create MetaDB
      • Deploy OCP
    • Deploy OceanBase AI Database
      • Create an object storage configuration
      • Deploy a LogService cluster by using OCP
      • Deploy an OceanBase AI Database cluster using OCP
    • (Optional) Deploy OBProxy
    • Deploy Java SDK
    • Recommended configurations
  • Connect
    • Overview of connection methods
    • Clients
      • MySQL client
      • OBClient
      • ODC
    • GUI tools
      • DBeaver
      • Navicat
    • Drivers and ORMs
      • Connect via driver or ORM framework
      • Examples
        • C#
          • MySQL Connector/C
        • Go
          • Go-SQL-Driver/MySQL
          • GORM
        • Java
          • Connector/J
          • Spring JDBC
          • SpringBoot
          • SpringBatch
          • SpringDataJPA
          • Hibernate
          • MyBatis
          • TestContainers
        • PHP
          • EXT
          • MySQLi
          • PDO
        • Python
          • PyMySQL
          • mysqlclient
          • MySQL-connector-python
          • SQLAlchemy
          • Django
          • peewee
    • Connection pool
      • Database connection pool configuration
      • Tomcat
      • C3P0
      • Proxool
      • HikariCP
      • DBCP
      • Commons Pool
      • Druid
      • JDBC
    • Connect to OceanBase AI Database by using SDK
  • Design Database Schema
    • Overview of database schema design
    • Table design
    • Data distribution
    • Indexes
    • Data types
    • Logical table
      • Logical table overview
      • Agent hybrid search scenario
        • Overview
        • Quick start
        • Collection and namespace management
        • Write data
        • Search data
        • Indexes and embedding functions
        • Monitoring and maintenance
        • API reference
      • Flash application scenario
        • Overview
        • Limitations and constraints
        • Connect
        • Quick start
        • Collection and app management
        • Data operations
  • Data Pipeline
    • Data ingestion
      • Data migration
        • Data migration overview
        • Use mydumper and myloader to migrate data from a MySQL database
        • Use DBCAT to migrate table structures from a MySQL database
        • Use DataX to migrate table data from a MySQL database
        • Use DBCAT to migrate table structures from an Oracle database
        • Use DataX to migrate table data from an Oracle database
        • Use DBCAT to migrate table structures from a DB2 LUW database
        • Migrate from CSV files
          • Use DataX
          • Use LOAD DATA
        • Migrate by using SQL statements
          • Migrate data between tables
          • Migrate resource units
          • Export data using the OUTFILE statement
      • Data import
        • Data import overview
        • Import data by using the LOAD DATA statement
        • INSERT INTO SELECT
          • Use the INSERT INTO SELECT FROM FILES statement for direct load
          • Import data from external tables using INSERT INTO SELECT
        • Import data via direct load using the CREATE TABLE AS SELECT statement
        • Import data by using obloader
    • Data delivery
      • Export data
      • Data lake
        • Data lake overview
        • Data lake integration
          • Access Hive tables through HMS Catalog
          • Load an Iceberg table through Catalog
          • Read Paimon tables by using plugins
          • ODPS Catalog and external tables
          • Catalogs and external tables
          • File external tables
        • External tables via URL
    • Data sharing
      • Automatic catalog data synchronization
      • Manual catalog data synchronization
  • Data Processing
    • Structured data processing
      • In-database processing
      • Materialized views
      • Data processing tools
    • Unstructured data processing
      • Vector embedding
        • Overview of Vector Embedding Technology
        • Use the AI_EMBED function
        • Use external embedding models
  • Data Branching
    • Overview of Fork
    • Fork Table
    • Fork Database
  • AI Search
    • Vector search
      • Vector search overview
      • Perform vector search using SQL
      • Vector data types overview
      • Store vector data
      • Vector index
        • Overview of vector indexes
        • Vector index memory management
        • Dense index
          • Overview of dense indexes
          • Index type selection
          • HNSW series indexes
          • IVF series indexes
        • Sparse index
          • In-memory sparse vector index
        • Monitor and maintain indexes
        • Index performance optimization
      • Search index
      • Use SQL functions
      • Vector nearest neighbor search
      • FAQ on AI scenarios
    • Semantic search
    • Full-text search
    • Hybrid search
    • Rerank search
  • Query Acceleration
    • Statistics
    • Choose the query parallelism
    • Accelerate queries with materialized views
  • Manage
    • Log in to an user tenant
    • Manage clusters
      • Cluster overview
      • Compute service management
        • Cluster parameters
        • Common cluster operations
          • View a zone
          • View a node
          • Restart a node
          • Add a node
          • Delete a node
          • Isolate a node
          • Replace a node
          • Start a zone
          • Add a zone
          • Delete a zone
          • Modify a zone
          • Isolate a zone
          • View cluster parameters
          • Modify cluster parameters
          • Reset cluster parameters
          • Update object storage access credentials
        • Data load balancing
          • Data load balancing overview
          • Transfer a partition
          • Cancel a partition transfer task
          • Cancel a balance job
          • Stop and resume a balance job
          • Table group weight management
            • Aggregation of user tables under a database
            • Set table group weights
            • Clear a table group's weight
            • Application scenarios of table group weight balancing
          • Partition weight management
            • Set partition weights
            • Clear partition weights
          • Partition balance management
            • Configure a scheduled partition balancing task
            • Manually trigger partition balancing
            • View the configurations of a scheduled partition balancing task
            • View the trigger history of scheduled partition balancing tasks
            • View background partition balancing tasks
            • View the history of background partition balancing tasks
          • GTS exclusive application case
      • Object storage management
        • Object storage overview
        • Update object storage information
        • Object storage-related views and parameters
        • FAQ on object storage
      • LogService management
        • LogService parameters
        • LogService operations
          • View a LogService node
          • Add a LogService node
          • Delete a LogService node
          • Replace a LogService node
          • Rotate LogService access credentials
          • View LogService parameters
          • Modify LogService parameters
        • LogService load balancing
          • LogService load balancing overview
          • View the load balancing status
          • Configure the load balancing strategy
    • Manage tenants
      • Tenant introduction
      • Tenant capacity
      • Tenant types
      • User tenant introduction
      • Tenant system variables
      • Common tenant operations
        • Create a tenant
        • Resource isolation
          • Resource isolation overview
          • Configure cgroup
          • Configure global CPU resource isolation for foreground and background tasks
          • Calibrate disk performance
          • Configure resource isolation within a tenant
          • Update a plan directive
          • Delete a plan directive
          • Delete a resource management plan
          • Delete a resource group
          • Clear cgroup configurations
          • Resource isolation configuration examples for background tasks
        • View tenant and resource information
        • View and set the tenant allowlist
        • View tenant system variables
        • Modify tenant system variables
        • Scale in/out
          • Introduction to tenant scaling
          • Resource planning for tenant scaling
          • Tenant pre-scaling
          • Scale tenants by adjusting resource specifications
          • Scale tenants by adjusting the unit number
          • Scale tenants by adjusting the primary zone
          • Smooth scaling application scenarios
        • Modify attributes of a resource pool
        • Modify tenant attributes
        • Lock and unlock a tenant
        • Drop a tenant
        • Restore a tenant
        • Rename a tenant
        • Manage resource pools
          • View resource pools
          • Allocate a resource pool to a tenant
          • Remove resource pools from a tenant
          • Merge and split a resource pool
          • Drop a resource pool
        • Manage resource specifications
          • View resource specifications
          • Modify a unit config
          • Drop a unit config
    • Manage log streams
      • Create a log stream
      • Modify a log stream
    • Manage replicas
      • Replicas
      • Replica distribution
        • Locality
        • Common locality operations
          • View locality
          • Modify locality
          • Add a replica
          • Reduce replicas
          • Adjust the distribution of replicas
          • View the locality change history
          • Replica migration
          • Modify the quorum size of a log stream
          • Cancel a replica task
      • Traffic distribution
      • Data distribution
    • High availability
      • High availability overview
      • Multi-replica disaster recovery
        • Data link introduction
        • High availability at the proxy layer
        • High availability at the database layer
        • Disaster recovery deployment solutions
      • Manage recycle bin
        • Overview of the recycle bin
        • Enable or disable the recycle bin
        • View recycle bin objects
        • Restore objects from the recycle bin
        • Clean up the recycle bin
      • Flashback query
    • Security and permissions
      • Overview of security permissions
      • Identification and authentication
        • Identity authentication
          • Identity authentication
          • Password complexity
          • Handle login failures
      • Access control
        • Overview of access control
        • Users and permissions
          • User and permission overview
          • Permissions
            • Permission classification
            • Create a user
            • Grant privileges directly
            • Privilege delegation
            • Role management
              • Role management overview
              • Create a role
              • Add privileges to a role
              • Grant roles to users or other roles
              • Activate a role
              • View roles
              • Revoke privileges from a role
              • Revoke roles from a user or role
              • Drop a role
            • Indirect authorization
            • View user privileges
            • Revoke privileges
            • Lock or unlock a user
            • Drop a user
        • Row-level security
          • Row-level security
        • Network security access control
        • RPC connection authentication
      • Data encryption
        • Data encryption overview
        • Data transmission encryption
          • Overview of data transmission encryption
          • Transport encryption for OBServer
          • ODP transmission encryption
        • Tenant master key management
          • Overview of tenant master keys
          • Generate tenant master key
        • Data storage encryption
          • Overview of database transparent encryption
          • Set up transparent data encryption for a newly created table
          • Enable transparent data encryption for an existing table
          • Decrypt a table
        • Column encryption
          • Column encryption overview
          • Create a column encryption rule
          • Column encryption privilege management
          • FAQ on column encryption
      • Security audit
        • Security audit overview
        • Security audit
          • Enable security auditing
          • Set an auditing rule
          • View auditing records
          • Disable security auditing
    • Backup and restore
      • Overview of physical backup and restore
      • Physical backup and restore with a minimal experience
      • Log archive
        • Overview of log archiving
        • Prepare for log archiving
        • Enable archiving mode
        • Suspend archiving
        • Disable archiving mode
        • View piece information
        • View archiving progress
        • View the archiving history
        • View archive parameters
        • Change the archive destination
        • Clear the archive path configuration
        • Introduction to log archiving views
      • Data backup
        • Data backup overview
        • Prepare for backup
        • Initiate a full data backup
        • Back up parameters
        • Stop a backup
        • View the data backup progress
        • View data backup results
        • View data backup parameters
        • Change the backup destination
        • Introduction to data backup-related views
      • Update object storage key information
      • Clear backup data
        • Automatic backup cleanup
          • Automatically clean up expired backups
          • Delete a cleanup policy
        • Manual backup cleanup
          • Manually trigger expired backup cleanup
          • Manually clean up specified backup or archive data
          • Manually clear a backup or archive path
        • Cancel a cleanup task
        • View backup cleanup progress
        • View backup cleanup results
        • Introduction to backup cleanup parameters
        • Introduction to cleanup-related views
      • Restore data
        • Preparations before restore
        • Perform physical restore
        • Restore from a specified path
        • Cancel physical restore
        • View the physical restore progress
        • View the result of physical restore
        • Segment-based log replay for a standby tenant
        • Convert a standby tenant into a primary tenant
        • Upgrade a tenant after restore is complete
        • Introduction to physical restore parameters
        • Introduction to views related to physical restore
      • Backup and restore performance tuning
      • Appendix: S3 path format
    • Monitor
      • Monitoring overview
      • Metrics
        • System monitoring
          • Overview of system monitoring metrics
          • SYSSTAT metrics
          • Wait events
          • Lock events
        • SQL monitoring
          • Overview of SQL monitoring
          • SQL audit
          • Execution plans
      • Root service events
      • Cases
    • Logs
      • Log overview
      • Log levels
      • Log interpretation
      • Log stability
      • Log control methods
      • Log compression and decompression
      • Log monitoring metrics
      • Alert logs
      • View logs
        • Search for the logs of a specific SQL request
        • Query the log of a previous SQL request by using the SQL Trace feature
  • Performance Test
    • TPC-DS
      • OceanBase AI Database TPC-DS test
      • OceanBase AI Database TPC-DS test report
    • TPC-H
      • OceanBase AI Database TPC-H test
      • OceanBase AI Database TPC-H test report
  • Reference
    • System management
      • Configuration management
        • Introduction to Configuration Management
        • Set parameters
        • Set variables
      • Storage management
        • Minor compaction management
          • Overview of minor compaction
          • Automatic minor compaction
          • Manually trigger a minor compaction
          • View minor compaction information
          • Modify minor compaction settings
        • Major compaction management
          • Overview of major compaction management
          • Automatically trigger a major compaction
          • Schedule daily tenant major compactions
          • Window compaction
          • Adaptive compaction
          • Manually trigger a major compaction
          • View major compaction information
          • Manually control a major compaction
          • Modify major compaction configuration
        • Data compression
          • Data compression overview
          • Use data encoding and compression
        • Use the TTL feature
        • Custom hot and cold data storage policies
          • Overview of custom hot/cold storage policies
          • Create a table-level hot/cold storage policy
          • Create a partition-level hot/cold storage policy
          • Modify a table-level hot/cold storage policy
          • Modify a partition-level hot/cold storage policy
          • O&M guide for custom hot/cold storage policies
      • Memory management
        • Memory management overview
        • Memory structure
        • Set the maximum memory for a database
        • Internal system memory management
        • Memory management within a tenant
        • Plan cache memory management
        • Memleak-based regular memory leak diagnostics mechanism
        • View memory usage information
        • Common memory issues
      • Process management
        • Overview of OceanBase AI Database threads
        • Multi-tenant threads
        • View thread status
        • Background threads of OceanBase AI Database
        • FAQ about multi-tenant threads
      • Disk management
        • Configure dynamic expansion of disk data files
        • View disk space usage of a tenant or table
    • Database object management
      • Overview of database object management
      • Create and manage databases
        • Create a database
        • View databases
        • Modify a database
        • Drop a database
      • Create and manage tables
        • About tables
        • Create a table
        • Column Skip Index attribute
        • Define an auto-increment column
        • Define column constraints
        • View tables
        • Modify a table
        • Change the attribute of a replicated table
        • Truncate a table
        • Drop a table
        • Lock a table
        • Create and manage external tables
          • External tables and external files
          • Create and query external tables
          • Create a partitioned external table
          • Manage external files
          • Data type mappings
      • Create and manage partitions
        • Partitioning overview
        • Create a partitioned table
        • Partition splitting
          • Overview of partition splitting
          • Manually split a partition
          • Automatic partition splitting
          • Recommended configurations for automatic partitioning
        • Dynamic partitioning
          • Overview of dynamic partitioning
          • Create a dynamic partitioned table
          • View a dynamic partitioned table
          • Modify a dynamic partitioned table
          • Dynamic partition management tasks
        • Modify partitioning rules
        • Add a partition
        • Drop a partition
        • Truncate partitions
        • Partition pruning
        • Query data from a specified partition
        • Create indexes on partitioned tables
          • Index overview
          • Local index
          • Global index
        • Partition exchange
      • Create and manage table groups
        • About table groups
        • Create a table group
        • View table group information
        • Add tables to a table group
        • Modify the SHARDING attribute of a table group
        • Manage tables within a table group
        • Delete a table group
      • Create and manage indexes
        • About indexes
        • Create an index
        • View indexes
        • Monitor indexes
        • Drop an index
        • List of system functions supported for function-based indexes
        • List of system functions not supported for function-based indexes
      • Manage views
        • Manage regular views
        • Manage materialized views
          • Overview of materialized views
          • Materialized view logs
          • Create a materialized view
          • Refresh a materialized view
          • Query rewrite using materialized views
          • Query materialized views
          • Modify materialized view attributes
          • Drop a materialized view
          • Materialized view resource isolation
      • Create and manage sequences
        • Create a sequence
        • View sequences
        • Reference a sequence
        • Modify a sequence
        • Drop a sequence
      • Create and manage triggers
        • Overview
        • Create a DML trigger
        • View trigger information
        • Drop a trigger
      • Create and manage DBLinks
        • Create a DBLink
        • View created DBLinks
        • Manage DBLinks
        • Access data in a remote database through DBLink
        • Drop a DBLink
      • Create and manage catalogs
        • Overview of Catalog
        • Create a catalog
        • View catalogs
        • Drop a catalog
    • Write and read data
      • Write data
        • Insert data
        • Update data
        • Delete data
        • Replace data
        • Generate test data in batches
      • Read data
        • Single-table query
        • Join tables
          • INNER JOIN
          • FULL JOIN
          • LEFT JOIN
          • RIGHT JOIN
          • Subqueries
          • Lateral derived table
        • Use operators and functions in queries
          • Use arithmetic operators in queries
          • Use numeric functions in queries
          • Use string concatenation operators in queries
          • Use string functions in queries
          • Use time functions in queries
          • Use type conversion functions in queries
          • Use aggregate functions in queries
          • Use NULL-related functions in queries
          • Use the CASE conditional operator in queries
          • Lock query results with SELECT FOR UPDATE
          • Lock in share mode
          • Use regular expressions in queries
        • Query using DBLink
        • Set operations
    • Transaction management
      • Transaction management overview
      • Start a transaction
      • Savepoints
        • Mark a savepoint
        • Roll back a transaction to a savepoint
        • Release a savepoint
      • Commit a transaction
      • Roll back a transaction
    • AI Function service
      • Overview of AI Function Service
      • Get started with AI Function Service
      • AI Function Service Permissions
      • Register an AI model
      • Interaction with AI models (Batch File)
      • Syntax and examples of AI functions
      • View AI model information
    • SQL reference
      • SQL syntax
        • System tenants
          • Overview of management commands
          • ALTER SYSTEM
            • ACTIVATE STANDBY
            • ADD REPLICA
            • ADD RESTORE SOURCE
            • ARCHIVELOG
            • BOOTSTRAP
            • BACKUP KEY
            • BACKUP
            • BACKUP CLUSTER PARAMETERS
            • BALANCE TASK
            • BALANCE JOB
            • CANCEL BACKUP
            • CANCEL DELETE BACKUP
            • CANCEL MIGRATE UNIT
            • CANCEL REPLICA TASK
            • CANCEL RESTORE
            • CANCEL RECOVER TABLE
            • CANCEL TRANSFER PARTITION
            • CREATE LS
            • CLEAR RESTORE SOURCE
            • DELETE BACKUP POLICY
            • DELETE BACKUP ALL
            • DELETE BACKUPSET/ARCHIVELOG_PIECE
            • DELETE OBSOLETE BACKUP
            • LOAD MODULE DATA
            • MAJOR AND MINOR
            • MIGRATE REPLICA
            • MIGRATE UNIT
            • MODIFY LS
            • MODIFY PAXOS_REPLICA_NUM
            • MODIFY REPLICA
            • NOARCHIVELOG
            • FLUSH PLAN CACHE
            • FLUSH SEQUENCE CACHE
            • FLUSH LOCAL_CACHE
            • FLASHBACK STANDBY LOG
            • JOB
            • SET LOG_RESTORE_SOURCE
            • PARAMETER
            • RECOVER STANDBY
            • RECOVER STANDBY CANCEL
            • REMOVE REPLICA
            • REFRESH
            • RESTORE
            • RESTORE PREVIEW
            • SET DATA_BACKUP_DEST
            • SERVER
            • SERVICE_NAME
            • SWITCHOVER
            • SET LOG_ARCHIVE_DEST
            • SET LOG_ARCHIVE_DEST_STATE
            • THROTTLE
            • TRANSFER PARTITION
            • TTL
            • WASH MEMORY FRAGMENTATION
            • ZONE
          • ALTER RESOURCE POOL
          • ALTER RESOURCE TENANT
          • ALTER RESOURCE UNIT
          • ALTER TENANT
          • CREATE RESOURCE POOL
          • CREATE RESOURCE UNIT
          • CREATE TENANT
          • DROP RESOURCE POOL
          • DROP RESOURCE UNIT
          • DROP TENANT
          • SET DECRYPTION
          • SET ENCRYPTION
          • SHOW RESTORE PREVIEW
        • User tenants
          • Basic elements
            • ROWID Pseudo-Column
            • Data types
              • Overview of data types
              • Numeric types
                • Overview of numeric types
                • Integer types
                • Fixed-point types
                • Floating-point types
                • BIT-Value type
              • Datetime types
                • Overview of date and time types
                • DATE, DATETIME and TIMESTAMP types
                • TIME type
                • YEAR type
              • String types
                • Character type overview
                • CHAR and VARCHAR
                • BINARY and VARBINARY
              • Large objects and text types
                • Overview of LOB and text types
                • BLOB type
                • TEXT type
                • STRING type
                • LOB types
                • LOB_WRITEAPPEND
              • Enumeration types
              • Collection types
              • JSON data types
                • Overview of the JSON data type
                • Create a JSON value
                • Query and modify JSON values
                • JSON data type conversion
                • Update partial data in a JSON document
                • Semi-structured encoding
              • Spatial data types
                • Overview of spatial data types
                • Spatial Reference System (SRS)
                • Create a spatial column
                • Create a spatial index
                • Spatial data formats
              • Roaring bitmap types
                • Overview of Efficient Compression for Bitmap Data Types
                • Create an efficient compressed bitmap column
              • Array data types
                • Overview of Array Element Types
                • Create an array column
              • Map data types
                • Overview of mapped data types
                • Create a mapped column
            • Expressions
              • Overview of Expressions
              • Syntax of Expressions
              • Simple Expressions
              • Compound Expressions
              • Conditional Expressions
              • Column Expressions
              • Date and time expressions
              • Function Expressions
              • Interval Expressions
              • Scalar subquery expressions
              • List of Expressions
              • Data type conversion rules
            • Character set and collation
              • Overview
              • Character sets
              • Collation
              • Database-level character set and collation
              • Table-level character set and collation
              • Column-level character set and collation
              • Character expression character sets and collations
              • Character set and collation of client connections
            • Literals
              • Overview of Literals
              • String text
              • Numbers
              • Date and time values
              • Bit value
              • Boolean values
              • NULL values
            • Schema object name
            • User-defined variables
            • Annotations
              • Hints
                • Overview of hints
                • Control query optimization using the Query Block Name and QB_NAME hint
                • Hint list
                  • Global hints
                    • Optimizer Stats Hint under Global Hint Types
                    • Transform hint under global hints
                    • Other hints under global hints
                  • Optimizer hints
                    • Access path hints under the Optimized hint type
                    • Join Order Hint under Optimized Hint Type
                    • Join Operation Hint under Optimized Hint Type
                    • Subquery hint under Optimized hint type
                    • Group by hint under optimized hint type
                    • DISTINCT hint under Optimized hint type
                    • Set hint under Optimized hint type
                    • Distributed DML Hints under Optimized Hint Type
                    • Vector Index Hint under Optimized Hint Type
                  • Transform hints
                    • Stmt Transform Hint under the Transform Hint Type
                    • Cost Based Transform Hint under the Transform Hint Type
                    • Transform Hints of the Heuristics Type
                    • Other hints under the Transform hint type
                  • Outline-related hint
            • Comments
          • Operators
            • Operator overview
            • Operator precedence
            • Arithmetic operators
            • Bitwise operators
            • Comparison operators
            • Logical operators
            • Assignment operators
            • Date and time operators
            • Character concatenation operators
            • BINARY conversion operator
            • CASE Conditional Operator
          • Functions
            • Function overview
            • Single-row functions
              • Datetime functions
                • ADDDATE
                • CONVERT_TZ
                • CURDATE
                • CURRENT_DATE
                • CURRENT_TIME
                • CURRENT_TIMESTAMP
                • CURTIME
                • DATE
                • DATE_ADD
                • DATE_FORMAT
                • DATE_SUB
                • DATEDIFF
                • DAYOFMONTH
                • DAYOFWEEK
                • DAYOFYEAR
                • EXTRACT
                • FROM_DAYS
                • FROM_UNIXTIME
                • GET_FORMAT
                • HOUR
                • LAST_DAY
                • LOCALTIME
                • LOCALTIMESTAMP
                • MAKEDATE
                • MAKETIME
                • MICROSECOND
                • MINUTE
                • MONTH
                • MONTHNAME
                • NOW
                • PERIOD_ADD
                • PERIOD_DIFF
                • QUARTER
                • SEC_TO_TIME
                • SECOND
                • STR_TO_DATE
                • SUBDATE
                • SUBTIME
                • SYSDATE
                • TIME
                • TIME_FORMAT
                • TIME_TO_SEC
                • TIME_TO_USEC
                • TIMEDIFF
                • TIMESTAMP
                • TIMESTAMPADD
                • TIMESTAMPDIFF
                • TO_DAYS
                • TO_SECONDS
                • UNIX_TIMESTAMP
                • USEC_TO_TIME
                • UTC_DATE
                • UTC_TIME
                • UTC_TIMESTAMP
                • WEEK
                • WEEKDAY
                • WEEKOFYEAR
                • YEARWEEK
                • YEAR
                • ADDTIME
                • DAYNAME
                • DAY
                • DATE_TRUNC
                • MONTHS_ADD
                • FORMATDATETIME
                • TOUNIXTIMESTAMP
                • parseDateTime
              • String functions
                • ASCII
                • BIN
                • BIT_LENGTH
                • CHAR
                • CHAR_LENGTH
                • CHARACTER_LENGTH
                • CONCAT
                • CONCAT_WS
                • ELT
                • EXPORT_SET
                • FIELD
                • FIND_IN_SET
                • FORMAT
                • HEX
                • INSERT
                • INSTR
                • INT2IP
                • IP2INT
                • KEYVALUE
                • LCASE
                • LEFT
                • LENGTH
                • LOCATE
                • LOWER
                • LPAD
                • LTRIM
                • MAKE_SET
                • MAX_PT
                • MD5_CONCAT_WS
                • MID
                • OCT
                • OCTET_LENGTH
                • ORD
                • POSITION
                • QUOTE
                • REGEXP
                • REGEXP_INSTR
                • REGEXP_LIKE
                • REGEXP_REPLACE
                • REGEXP_SUBSTR
                • REPEAT
                • REPLACE
                • REVERSE
                • RIGHT
                • RLIKE
                • RPAD
                • RTRIM
                • SPACE
                • SPLIT_PART
                • STRCMP
                • SUBSTR
                • SUBSTRING
                • SUBSTRING_INDEX
                • TRIM
                • UCASE
                • UNHEX
                • UPPER
                • URL_DECODE
                • URL_ENCODE
                • WEIGHT_STRING
                • TO_BASE64
                • FROM_BASE64
                • SOUNDEX
                • EDITDISTANCE
              • Conversion functions
                • CAST
                • CONVERT
                • DECODE_TRACE_ID
                • SCN_TO_TIMESTAMP
                • TIMESTAMP_TO_SCN
                • TO_CHAR(character)
                • TO_CHAR(number)
                • TO_CHAR(datetime)
                • TO_DATE
              • Mathematical functions
                • ABS
                • ACOS
                • ASIN
                • ATAN
                • ATAN2
                • BIT_COUNT
                • CEIL
                • CEILING
                • CONV
                • COS
                • COT
                • CRC32
                • DEGREES
                • EXP
                • FLOOR
                • GENERATOR
                • LN
                • LOG
                • LOG10
                • LOG2
                • MOD
                • NEG
                • PI
                • NORMAL
                • POW
                • POWER
                • RADIANS
                • RAND
                • RANDOM
                • RANDSTR
                • ROUND
                • SIGN
                • SIN
                • SQRT
                • TAN
                • TRUNCATE
                • UNIFORM
                • ZIPF
              • Comparison functions
                • GREATEST
                • INTERVAL
                • ISNULL
                • LEAST
              • Process control functions
                • CASE
                • IF
                • IFNULL
                • NULLIF
                • ORA_DECODE
            • Aggregate functions
              • APPROX_COUNT_DISTINCT
              • AVG
              • ARG_MAX
              • ARG_MIN
              • BIT_AND
              • BIT_OR
              • BIT_XOR
              • COUNT
              • GROUP_CONCAT
              • GROUPING
              • MAX
              • MIN
              • STD
              • STDDEV
              • STDDEV_POP
              • STDDEV_SAMP
              • SUM
              • VAR_POP
              • VAR_SAMP
              • VARIANCE
              • STRING_AGG
              • AVG_WEIGHTED
              • ARBITRARY
              • ANY
              • GROUPCONCAT
              • STDDEVSAMP
              • UNIQ
              • VARSAMP
            • Analysis functions
              • APPROX_COUNT_DISTINCT
              • AVG
              • BIT_AND
              • BIT_OR
              • BIT_XOR
              • COUNT
              • CUME_DIST
              • DENSE_RANK
              • FIRST_VALUE
              • LAG
              • LAST_VALUE
              • LEAD
              • MAX
              • MIN
              • NTH_VALUE
              • NTILE
              • PERCENT_RANK
              • PERCENTILE_CONT
              • RANK
              • ROW_NUMBER
              • STD
              • STDDEV
              • STDDEV_POP
              • STDDEV_SAMP
              • SUM
              • VAR_POP
              • VAR_SAMP
              • VARIANCE
              • LAGINFRAME
              • LEADINFRAME
            • Encryption functions
              • AES_DECRYPT
              • AES_ENCRYPT
              • COMPRESS
              • DECODE
              • DES_DECRYPT
              • DES_ENCRYPT
              • ENCODE
              • ENCRYPT
              • ENHANCED_AES_ENCRYPT
              • ENHANCED_AES_DECRYPT
              • MD5
              • PASSWORD
              • UNCOMPRESS
              • UNCOMPRESSED_LENGTH
              • RANDOM_BYTES
              • SHA
              • SHA1
              • SHA2
              • VALIDATE_PASSWORD_STRENGTH
              • SM3
              • SM4_ENCRYPT
              • SM4_DECRYPT
            • Information functions
              • BENCHMARK
              • CATALOG
              • CHARSET
              • COERCIBILITY
              • COLLATION
              • CONNECTION_ID
              • CURRENT_ROLE
              • CURRENT_USER
              • DATABASE
              • FOUND_ROWS
              • LAST_INSERT_ID
              • LAST_INSERT_ID Behavior Description
              • ICU_VERSION
              • OB_TRANSACTION_ID
              • ROW_COUNT
              • SCHEMA
              • SESSION_USER
              • SYSTEM_USER
              • USER
              • VERSION
              • OB_VERSION
            • JSON functions
              • Overview of JSON functions
              • Functions for creating JSON text
                • JSON_ARRAY
                • JSON_OBJECT
                • JSON_QUOTE
              • Functions for searching JSON text
                • JSON_CONTAINS
                • JSON_CONTAINS_PATH
                • JSON_EXTRACT
                • JSON_KEYS
                • JSON_OVERLAPS
                • JSON_SEARCH
                • JSON_VALUE
                • MEMBER OF
              • Functions for modifying JSON text
                • JSON_ARRAY_APPEND
                • JSON_APPEND
                • JSON_ARRAY_INSERT
                • JSON_INSERT
                • JSON_MERGE
                • JSON_MERGE_PATCH
                • JSON_MERGE_PRESERVE
                • JSON_REMOVE
                • JSON_REPLACE
                • JSON_SET
                • JSON_UNQUOTE
              • Functions for returning JSON text properties
                • JSON_DEPTH
                • JSON_LENGTH
                • JSON_TYPE
                • JSON_VALID
              • JSON_TABLE function
              • JSON utility functions
                • JSON_PRETTY
                • JSON_STORAGE_SIZE
              • JSON aggregate functions
                • JSON_ARRAYAGG
                • JSON_OBJECTAGG
              • JSON schema validation functions
                • JSON_SCHEMA_VALID
                • JSON_SCHEMA_VALIDATION_REPORT
            • XML functions
              • Overview of XML functions
              • Functions for querying XML data
                • EXTRACTVALUE
              • Functions for modifying XML data
                • UPDATEXML
            • Table functions
              • Overview of TABLE FUNCTIONS
              • FILES table function
            • Spatial functions
              • Overview of Spatial Functions
              • Create a geometric value function
              • Spatial operators
              • Spatial relationship functions
              • Geometric property functions
              • Geometric format conversion functions
              • Spatial analysis functions
              • Spatial Constructors
              • Spatial accessor functions
              • Spatial format conversion functions
              • Geometric Processing Functions
              • _ST_GeoHash
            • Performance schema functions
              • FORMAT_BYTES
              • FORMAT_PICO_TIME
            • Lock functions
              • Overview of Lock Functions
              • GET_LOCK
              • IS_FREE_LOCK
              • IS_USED_LOCK
              • RELEASE_ALL_LOCKS()
              • RELEASE_LOCK
            • Bitmap functions
              • Overview of bitmap functions
              • Bitmap Constructor
              • Bitmap cardinality functions
              • Bitmap arithmetic functions
              • Bitmap predicate functions
              • Bitmap output functions
              • Bitmap aggregate functions
            • Array functions
              • Overview of array functions
              • Array constructor
              • Array comparison functions
              • Array output functions
              • Array functions
            • Text processing functions
              • TOKENIZE
            • Audit functions
              • Overview of audit functions
              • AUDIT_LOG_FILTER_REMOVE_FILTER
              • AUDIT_LOG_FILTER_REMOVE_USER
              • AUDIT_LOG_FILTER_SET_FILTER
              • AUDIT_LOG_FILTER_SET_USER
            • Map functions
              • Overview of mapping functions
              • Constructor of Map
              • Mapping judgment function
              • Mapping functions
            • Other functions
              • ANY_VALUE
              • BIN_TO_UUID
              • COALESCE
              • DEFAULT
              • NAME_CONST
              • INET_ATON
              • INET_NTOA
              • INET6_ATON
              • INET6_NTOA
              • IS_IPV4
              • IS_IPV4_COMPAT
              • IS_IPV6
              • IS_UUID
              • MATCH AGAINST
              • NVL
              • UUID_TO_BIN
              • SLEEP
              • UUID
              • UUID_SHORT
              • VALUES
              • ISNAN
          • Queries and subqueries
            • Overview
            • Subquery
            • Connections
            • Full-text query
          • SQL statements
            • General syntax
            • Generalized Table Expressions
            • ALTER COMPILE
            • ALTER DATABASE
            • ALTER LOCATION
            • ALTER MATERIALIZED VIEW
            • ALTER MATERIALIZED VIEW LOG
            • ALTER OUTLINE
            • ALTER EXTERNAL TABLE
            • ALTER SENSITIVE RULE
            • ALTER POLICY
            • ALTER SEQUENCE
            • ALTER/CHANGE/MODIFY EXTERNAL_STORAGE_DEST
            • ALTER SYSTEM FLUSH SEQUENCE CACHE
            • MAJOR AND MINOR
            • STORAGE_CACHE_POLICY_EXECUTOR
            • ALTER TABLE
            • ALTER TABLEGROUP
            • ALTER TABLESPACE
            • ALTER USER
            • ALTER VIEW
            • ALTER INSTANCE ROTATE INNODB MASTER KEY
            • ALTER EVENT
            • ANALYZE
            • CACHE INDEX
            • CREATE CONCURRENT_LIMITING_RULE
            • CREATE DATABASE
            • CREATE DATABASE LINK
            • CREATE EXTERNAL CATALOG
            • CREATE EXTERNAL TABLE
            • CREATE INDEX
            • CREATE LOCATION
            • CREATE MATERIALIZED VIEW
            • CREATE MATERIALIZED VIEW LOG
            • CREATE OUTLINE
            • CREATE POLICY
            • CREATE FORMAT OUTLINE
            • CREATE ROLE
            • CREATE SENSITIVE RULE
            • CREATE SEQUENCE
            • CREATE TABLE
            • CREATE TABLEGROUP
            • CREATE TABLESPACE
            • CREATE USER
            • CREATE VIEW
            • CHECKSUM TABLE
            • CREATE EVENT
            • DEALLOCATE PREPARE
            • DROP DATABASE LINK
            • DELETE
            • DESCRIBE
            • DROP CATALOG
            • DROP CONCURRENT_LIMITING_RULE
            • DROP DATABASE
            • DROP EVENT
            • DROP INDEX
            • DROP LOCATION
            • DROP MATERIALIZED VIEW
            • DROP MATERIALIZED VIEW LOG
            • DROP OUTLINE
            • DROP ROLE
            • DROP SENSITIVE RULE
            • DROP POLICY
            • DROP TABLE
            • DROP TABLEGROUP
            • DROP TABLESPACE
            • DROP SEQUENCE
            • DROP USER
            • DROP VIEW
            • EXECUTE
            • EXPLAIN
            • FLASHBACK
            • FLUSH TABLE
            • GRANT
            • HELP
            • INSERT
            • KILL
            • LOAD DATA
            • LOAD_FILE
            • LOAD INDEX INTO CACHE
            • LOCK TABLES
            • OPTIMIZE
            • PREPARE
            • PURGE
            • PURGE RECYCLEBIN
            • RENAME USER
            • RENAME TABLE
            • REPLACE
            • REPAIR TABLE
            • REMOVE
            • REVOKE
            • SAVEPOINT
            • SCHEMA
            • SELECT INTO
            • SET DEFAULT ROLE
            • SELECT
              • SELECT
              • JOIN clause
              • WINDOW clause
              • UNION clause
              • HYBRID_SEARCH
              • PARTITION TIER
            • SET
            • SET CATALOG
            • SET CHARSET
            • SET NAMES
            • SET PASSWORD
            • SET ROLE
            • SET TRANSACTION
            • SHOW
            • SUBMIT JOB
            • SHOW JOB STATUS
            • CANCEL JOB
            • TRANSACTION
            • TRUNCATE TABLE
            • UNLOCK TABLES
            • UPDATE
            • USE
            • VALUES
            • XA TRANSACTION
          • DDL feature
            • Overview of DDL features
            • Online DDL and Offline DDL Operations
            • Index operations
            • Primary key operations
            • Column operations
            • Generate columns
            • Foreign key operations
            • Table operations
            • Partition operations
            • Column type change rules
            • Number type conversion rules
          • Pseudo columns
            • Overview of PseudoColumns
            • PARTITIONID Pseudo Column
            • Sequence Pseudocolumns
          • Conditions
            • Overview of SQL Conditions
            • Condition priorities
            • Comparison conditions
            • Logical conditions
            • Pattern matching conditions
            • Null value conditions
            • BETWEEN condition
            • EXISTS condition
            • IN Condition
            • JSON Member Conditions
            • Boolean test conditions
      • SQL specifications and practices
        • SQL Writing Restrictions
        • SQL writing specifications
          • SELECT statement writing specifications
          • DML statement writing guidelines
          • DDL statement writing guidelines
          • Multi-table association guidelines
          • Table scan method specifications
          • Transaction specifications
          • Usage guidelines for cache
          • Guidelines for Using HINTS
          • Other related specifications
        • SQL statement examples
          • Implicit type conversion related
          • Suggestions on using JOIN tables
          • Weak-consistency read
          • Paginated query
      • Reserved keywords
      • Data type conversion behavior in strict mode
    • PL reference
      • What is PL
        • PL Overview
        • Key features of PL
        • Architecture of PL
      • PL syntax structure
      • PL stored procedures
        • Overview of stored programs
        • Variables of stored programs
        • Stored procedure
        • Stored Procedures and Privilege Management
        • Stored functions
        • External storage functions
        • Trigger
        • EVENT
        • Limitations on stored programs
        • SQL Transpiler
        • PL asynchronous commit optimization
      • PL cursors
        • Cursor overview
        • Cursor execution process
        • Limitations on server-side cursors
      • PL conditional control statements
        • CASE
        • IF
        • ITERATE
        • LEAVE
        • LOOP
        • REPEAT
        • RETURN
        • WHILE
      • PL data manipulation statements
        • CALL
        • DO
      • PL data definition statements
        • ALTER FUNCTION
        • ALTER PROCEDURE
        • CREATE FUNCTION
        • CREATE PROCEDURE
        • CREATE TRIGGER
        • DROP FUNCTION
        • DROP PROCEDURE
        • DROP TRIGGER
      • PL database management statements
        • SHOW CREATE FUNCTION
        • SHOW CREATE PROCEDURE
        • SHOW CREATE TRIGGER
        • SHOW FUNCTION STATUS
        • SHOW PROCEDURE STATUS
        • SHOW TRIGGERS
      • PL related dictionary views
        • INFORMATION_SCHEMA PARAMETERS
        • INFORMATION_SCHEMA ROUTINES
        • INFORMATION_SCHEMA TRIGGERS
      • PL exception handling
        • Overview of exception handling
        • DECLARE ... CONDITION
        • DECLARE ... HANDLER
        • GET DIAGNOSTICS
        • RESIGNAL
        • SIGNAL
        • Scope of handlers
        • Diagnostic section
        • Exception Handling and OUT/INOUT Parameters
        • Limitations on exception handling
      • PL system packages
        • Overview of system packages
        • DBMS_AI_SERVICE
          • Overview of DBMS_AI_SERVICE
          • CREATE_AI_MODEL
          • DROP_AI_MODEL
          • CREATE_AI_MODEL_ENDPOINT
          • ALTER_AI_MODEL_ENDPOINT
          • DROP_AI_MODEL_ENDPOINT
          • REGISTER_PROVIDER
          • ALTER_PROVIDER
          • UNREGISTER_PROVIDER
          • ALTER_MODEL_PROFILE
          • DROP_MODEL_PROFILE
          • CREATE_AI_GATEWAY
          • ALTER_AI_GATEWAY
          • DROP_AI_GATEWAY
        • DBMS_ASYNC_INDEX
          • Overview of DBMS_ASYNC_INDEX
          • FORCEMERGE
        • DBMS_DAILY_MAINTENANCE
          • Overview of DBMS_DAILY_MAINTENANCE
          • TRIGGER_WINDOW_COMPACTION_PROC
          • SET_THREAD_COUNT
        • DBMS_HYBRID_SEARCH
          • Overview of DBMS_HYBRID_SEARCH
          • SEARCH
          • GET_SQL
        • DBMS_MVIEW
          • Overview of DBMS_MVIEW
          • PURGE_LOG
          • REFRESH
          • KILL_REFRESH
          • REFRESH_REPORT
        • DBMS_MVIEW_STATS
          • Overview of DBMS_MVIEW_STATS
          • PURGE_REFRESH_STATS
          • SET_MVREF_STATS_PARAMS
          • SET_SYSTEM_DEFAULT
        • DBMS_PARTITION
          • Overview of DBMS_PARTITION
          • MANAGE_DYNAMIC_PARTITION
        • DBMS_RESOURCE_MANAGER
          • Overview of DBMS_RESOURCE_MANAGER
          • CREATE_CONSUMER_GROUP
          • CREATE_PLAN
          • CREATE_PLAN_DIRECTIVE
          • COPY_PLAN
          • DELETE_CONSUMER_GROUP
          • DELETE_PLAN
          • DELETE_PLAN_DIRECTIVE
          • System Packages
          • UPDATE_PLAN_DIRECTIVE
        • DBMS_STATS
          • Overview of DBMS_STATS
          • ALTER_STATS_HISTORY_RETENTION
          • CREATE_STAT_TABLE
          • DELETE_CATALOG_GLOBAL_PREFS
          • DELETE_CATALOG_TABLE_PREFS
          • DELETE_COLUMN_STATS
          • DELETE_INDEX_STATS
          • DELETE_TABLE_STATS
          • DELETE_SCHEMA_STATS
          • DELETE_SCHEMA_PREFS
          • DELETE_SYSTEM_STATS
          • DELETE_TABLE_PREFS
          • DROP_STAT_TABLE
          • EXPORT_COLUMN_STATS
          • EXPORT_INDEX_STATS
          • EXPORT_TABLE_STATS
          • EXPORT_SCHEMA_STATS
          • FLUSH_DATABASE_MONITORING_INFO
          • GATHER_CATALOG_TABLE_STATS
          • GATHER_INDEX_STATS
          • GATHER_TABLE_STATS
          • GATHER_SCHEMA_STATS
          • GATHER_SYSTEM_STATS
          • GET_CATALOG_GLOBAL_PREFS
          • GET_CATALOG_PREFS
          • GET_STATS_HISTORY_AVAILABILITY
          • GET_STATS_HISTORY_RETENTION
          • GET_PARAM
          • GET_PREFS
          • IMPORT_INDEX_STATS
          • IMPORT_COLUMN_STATS
          • IMPORT_TABLE_STATS
          • IMPORT_SCHEMA_STATS
          • LOCK_CATALOG_PARTITION_STAT
          • LOCK_CATALOG_TABLE_STAT
          • LOCK_PARTITION_STATS
          • LOCK_SCHEMA_STATS
          • LOCK_TABLE_STATS
          • RESTORE_TABLE_STATS
          • RESTORE_SCHEMA_STATS
          • RESET_GLOBAL_PREF_DEFAULTS
          • RESET_PARAM_DEFAULTS
          • PURGE_STATS
          • SET_CATALOG_GLOBAL_PREFS
          • SET_CATALOG_TABLE_PREFS
          • SET_COLUMN_STATS
          • SET_INDEX_STATS
          • SET_TABLE_STATS
          • SET_GLOBAL_PREFS
          • SET_PARAM
          • SET_SCHEMA_PREFS
          • SET_SYSTEM_STATS
          • SET_TABLE_PREFS
          • UNLOCK_CATALOG_PARTITION_STAT
          • UNLOCK_CATALOG_TABLE_STAT
          • UNLOCK_PARTITION_STATS
          • UNLOCK_SCHEMA_STATS
          • UNLOCK_TABLE_STATS
          • CANCEL_GATHER_STATS
          • COPY_TABLE_STATS
        • DBMS_TRUSTED_CERTIFICATE_MANAGER
          • Overview of DBMS_TRUSTED_CERTIFICATE_MANAGER
          • ADD_TRUSTED_CERTIFICATE
          • DELETE_TRUSTED_CERTIFICATE
          • UPDATE_TRUSTED_CERTIFICATE
        • DBMS_UDR
          • Overview of DBMS_UDR
          • CREATE_RULE
          • DISABLE_RULE
          • ENABLE_RULE
          • REMOVE_RULE
        • DBMS_VECTOR
          • Overview of DBMS_VECTOR
          • REBUILD_INDEX
          • INDEX_VECTOR_MEMORY_ESTIMATE
          • INDEX_VECTOR_MEMORY_ADVISOR
          • FLUSH_INDEX
          • COMPACT_INDEX
          • TRIGGER_ASYNC_TASK
          • ALTER_INDEX_PARAMS
        • DBMS_WORKLOAD_REPOSITORY
          • Overview of DBMS_WORKLOAD_REPOSITORY
          • ASH_REPORT
          • CREATE_SNAPSHOT
          • DROP_SNAPSHOT_RANGE
          • MODIFY_SNAPSHOT_SETTINGS
        • DBMS_SESSION
          • Overview of DBMS_SESSION
          • SET_IDENTIFIER
          • CLEAR_IDENTIFIER
        • DBMS_APPLICATION_INFO
          • Overview of DBMS_APPLICATION_INFO
          • READ_CLIENT_INFO
          • READ_MODULE
          • SET_ACTION
          • SET_CLIENT_INFO
          • SET_MODULE
        • DBMS_XPLAN
          • Overview of DBMS_XPLAN
          • DISPLAY_ACTIVE_SESSION_PLAN
          • DISPLAY_CURSOR
          • DISPLAY
          • DISABLE_OPT_TRACE
          • DISPLAY_SQL_PLAN_BASELINE
          • ENABLE_OPT_TRACE
          • SET_OPT_TRACE_PARAMETER
        • DBMS_XPROFILE
          • Overview of DBMS_XPROFILE
          • DISPLAY_PROFILE
        • DBMS_BALANCE
          • Overview of DBMS_BALANCE
          • SET_BALANCE_WEIGHT
          • CLEAR_BALANCE_WEIGHT
          • TRIGGER_PARTITION_BALANCE
          • SET_TABLEGROUP_BALANCE_WEIGHT
          • CLEAR_TABLEGROUP_BALANCE_WEIGHT
        • DBMS_OB_LIMIT_CALCULATOR
          • Overview of DBMS_OB_LIMIT_CALCULATOR
          • CALCULATE_MIN_PHY_RES_NEEDED_BY_UNIT
          • CALCULATE_MIN_PHY_RES_NEEDED_BY_LOGIC_RES
          • CALCULATE_MIN_PHY_RES_NEEDED_BY_STANDBY_TENANT
        • DBMS_EXTERNAL_TABLE
          • Overview of DBMS_EXTERNAL_TABLE
          • AUTO_REFRESH_EXTERNAL_TABLE
        • DBMS_JAVA
          • Overview of DBMS_JAVA
          • LOADJAVA
          • DROPJAVA
          • GRANT_PERMISSION
          • RESTRICT_PERMISSION
          • REVOKE_PERMISSION
          • DISABLE_PERMISSION
          • ENABLE_PERMISSION
          • DELETE_PERMISSION
        • DBMS_PYTHON
          • Overview of DBMS_PYTHON
          • DROPPYTHON
          • LOADPYTHON
        • DBMS_DATA_DICT
          • DBMS_DATA_DICT
      • Reserved and Non-Reserved PL Keywords
    • System views
      • Overview of system views
      • Overview of system views
      • SYS tenant views
        • Dictionary views
          • information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS
          • information_schema.CHARACTER_SETS
          • information_schema.CHECK_CONSTRAINTS
          • information_schema.COLLATION_CHARACTER_SET_APPLICABILITY
          • information_schema.COLLATIONS
          • information_schema.COLUMN_PRIVILEGES
          • information_schema.COLUMNS
          • information_schema.ENGINES
          • information_schema.events
          • information_schema.GLOBAL_STATUS
          • information_schema.GLOBAL_VARIABLES
          • information_schema.KEY_COLUMN_USAGE
          • information_schema.PARAMETERS
          • information_schema.PARTITIONS
          • information_schema.PROCESSLIST
          • information_schema.QUERY_RESPONSE_TIME
          • information_schema.REFERENTIAL_CONSTRAINTS
          • information_schema.role_table_grants
          • information_schema.role_column_grants
          • information_schema.role_routine_grants
          • information_schema.ROUTINES
          • information_schema.SCHEMA_PRIVILEGES
          • information_schema.SCHEMATA
          • information_schema.SESSION_STATUS
          • information_schema.SESSION_VARIABLES
          • information_schema.STATISTICS
          • information_schema.TABLE_CONSTRAINTS
          • information_schema.TABLE_PRIVILEGES
          • information_schema.TABLES
          • information_schema.TRIGGERS
          • information_schema.USER_PRIVILEGES
          • information_schema.VIEW_TABLE_USAGE
          • information_schema.VIEWS
          • mysql.columns_priv
          • mysql.db
          • mysql.default_roles
          • mysql.help_category
          • mysql.help_keyword
          • mysql.help_relation
          • mysql.help_topic
          • mysql.proc
          • mysql.procs_priv
          • mysql.role_edges
          • mysql.time_zone
          • mysql.time_zone_name
          • mysql.time_zone_transition
          • mysql.time_zone_transition_type
          • mysql.user
          • oceanbase.ALL_OB_EXTERNAL_TABLE_FILES
          • oceanbase.CDB_OB_DATABASE_PRIVILEGE
          • oceanbase.CDB_OB_SHARED_MACRO_BLOCK_GC_STAT
          • oceanbase.CDB_IND_COLUMNS
          • oceanbase.CDB_IND_PARTITIONS
          • oceanbase.CDB_IND_SUBPARTITIONS
          • CDB_INDEX_USAGE
          • oceanbase.CDB_INDEXES
          • CDB_MVIEW_LOGS
          • oceanbase.CDB_MVIEW_RUNNING_JOBS
          • CDB_MVIEWS
          • CDB_MVREF_CHANGE_STATS
          • CDB_MVREF_RUN_STATS
          • CDB_MVREF_STATS
          • CDB_MVREF_STATS_PARAMS
          • CDB_MVREF_STATS_SYS_DEFAULTS
          • CDB_MVREF_STMT_STATS
          • oceanbase.CDB_OB_ACCESS_POINT
          • oceanbase.CDB_OB_AI_BATCH_TASK_HISTORY
          • oceanbase.CDB_OB_AI_BATCH_TASKS
          • oceanbase.CDB_OB_AI_GATEWAY_ENDPOINTS
          • oceanbase.CDB_OB_AI_GATEWAYS
          • oceanbase.CDB_OB_AI_MODEL_ENDPOINTS
          • oceanbase.CDB_OB_AI_MODEL_PROFILES
          • oceanbase.CDB_OB_AI_MODEL_PROVIDERS
          • oceanbase.CDB_OB_AI_MODELS
          • oceanbase.CDB_OB_AGENT_DB_BACKGROUND_TASKS
          • oceanbase.CDB_OB_AGENT_DB_BACKGROUND_TASK_HISTORY
          • oceanbase.CDB_OB_ARCHIVE_DEST
          • oceanbase.CDB_OB_ARCHIVELOG
          • oceanbase.CDB_OB_ARCHIVELOG_PIECE_FILES
          • oceanbase.CDB_OB_ARCHIVELOG_SUMMARY
          • oceanbase.CDB_OB_AUTO_INCREMENT
          • CDB_OB_AUX_STATISTICS
          • oceanbase.CDB_OB_BACKUP_DELETE_JOB_HISTORY
          • oceanbase.CDB_OB_BACKUP_DELETE_JOBS
          • oceanbase.CDB_OB_BACKUP_DELETE_POLICY
          • oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY
          • oceanbase.CDB_OB_BACKUP_DELETE_TASKS
          • oceanbase.CDB_OB_BACKUP_JOB_HISTORY
          • oceanbase.CDB_OB_BACKUP_JOBS
          • oceanbase.CDB_OB_BACKUP_PARAMETER
          • oceanbase.CDB_OB_BACKUP_SET_FILES
          • oceanbase.CDB_OB_BACKUP_STORAGE_INFO
          • oceanbase.CDB_OB_BACKUP_STORAGE_INFO_HISTORY
          • oceanbase.CDB_OB_BACKUP_TASK_HISTORY
          • oceanbase.CDB_OB_BACKUP_TASKS
          • oceanbase.CDB_OB_BALANCE_JOB_HISTORY
          • oceanbase.CDB_OB_BALANCE_JOBS
          • oceanbase.CDB_OB_BALANCE_TASK_HISTORY
          • oceanbase.CDB_OB_BALANCE_TASKS
          • oceanbase.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO
          • oceanbase.CDB_OB_CCL_RULES
          • oceanbase.CDB_OB_CS_REPLICA_STATS
          • oceanbase.CDB_OB_DATA_DICTIONARY_IN_LOG
          • oceanbase.CDB_OB_DATABASES
          • oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY
          • oceanbase.CDB_OB_DYNAMIC_PARTITION_TABLES
          • oceanbase.CDB_OB_EXTERNAL_TABLE_FILES
          • oceanbase.CDB_OB_FREEZE_INFO
          • oceanbase.CDB_OB_IMPORT_TABLE_JOB_HISTORY
          • oceanbase.CDB_OB_IMPORT_TABLE_JOBS
          • oceanbase.CDB_OB_IMPORT_TABLE_TASK_HISTORY
          • oceanbase.CDB_OB_IMPORT_TABLE_TASKS
          • oceanbase.CDB_OB_KV_TTL_TASK_HISTORY
          • oceanbase.CDB_OB_KV_TTL_TASKS
          • oceanbase.CDB_OB_LOG_RESTORE_SOURCE
          • oceanbase.CDB_OB_LOB_CHECK_EXCEPTION_RESULT
          • oceanbase.CDB_OB_LOB_CHECK_TASKS
          • oceanbase.CDB_OB_LS
          • oceanbase.CDB_OB_LS_HISTORY
          • oceanbase.CDB_OB_LS_LOCATIONS
          • oceanbase.CDB_OB_LS_LOG_ARCHIVE_PROGRESS
          • oceanbase.CDB_OB_LS_REPLICA_TASKS
          • oceanbase.CDB_OB_LS_REPLICA_TASK_HISTORY
          • oceanbase.CDB_OB_MAJOR_COMPACTION
          • oceanbase.CDB_OB_OBJECT_BALANCE_WEIGHT
          • oceanbase.CDB_OB_RECOVER_TABLE_JOB_HISTORY
          • oceanbase.CDB_OB_RECOVER_TABLE_JOBS
          • oceanbase.CDB_OB_SERVICES
          • oceanbase.CDB_OB_RESTORE_HISTORY
          • oceanbase.CDB_OB_RESTORE_PROGRESS
          • oceanbase.CDB_OB_RSRC_DIRECTIVES
          • oceanbase.CDB_OB_SENSITIVE_COLUMNS
          • oceanbase.CDB_OB_SENSITIVE_RULE_PLAINACCESS_USERS
          • oceanbase.CDB_OB_SENSITIVE_RULES
          • oceanbase.CDB_OB_SERVER_SPACE_USAGE
          • oceanbase.CDB_OB_SPACE_USAGE
          • oceanbase.CDB_OB_STORAGE_SPACE_USAGE
          • oceanbase.CDB_OB_SYS_VARIABLES
          • oceanbase.CDB_OB_STORAGE_IO_USAGE
          • oceanbase.CDB_OB_SPM_EVO_RESULT
          • oceanbase.CDB_OB_TABLE_LOCATIONS
          • oceanbase.CDB_OB_TABLEGROUP_PARTITIONS
          • oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS
          • oceanbase.CDB_OB_TABLEGROUP_TABLES
          • oceanbase.CDB_OB_TABLEGROUPS
          • oceanbase.CDB_OB_TABLET_CHECKSUM_ERROR_INFO
          • oceanbase.CDB_OB_TABLET_REPLICAS
          • oceanbase.CDB_OB_TABLET_TO_LS
          • oceanbase.CDB_OB_TABLE_SPACE_USAGE
          • oceanbase.CDB_OB_TEMP_FILES
          • oceanbase.CDB_OB_TENANT_EVENT_HISTORY
          • oceanbase.CDB_OB_TENANT_FLASHBACK_LOG_SCN
          • oceanbase.CDB_OB_TRANSFER_PARTITION_TASKS
          • oceanbase.CDB_OB_TRANSFER_PARTITION_TASK_HISTORY
          • oceanbase.CDB_OB_TRANSFER_TASK_HISTORY
          • oceanbase.CDB_OB_TRANSFER_TASKS
          • oceanbase.CDB_OB_TTL_TASKS
          • oceanbase.CDB_OB_TTL_TASK_HISTORY
          • oceanbase.CDB_OB_USERS
          • oceanbase.CDB_OB_VECTOR_INDEX_TASKS
          • oceanbase.CDB_OB_VECTOR_INDEX_TASK_HISTORY
          • oceanbase.CDB_OB_ZONE_MAJOR_COMPACTION
          • oceanbase.CDB_OBJECTS
          • oceanbase.CDB_PART_INDEXES
          • oceanbase.CDB_PART_KEY_COLUMNS
          • oceanbase.CDB_PART_TABLES
          • oceanbase.CDB_SCHEDULER_JOB_RUN_DETAILS
          • oceanbase.CDB_SUBPART_KEY_COLUMNS
          • oceanbase.CDB_SUBPARTITION_TEMPLATES
          • oceanbase.CDB_TAB_COL_STATISTICS
          • oceanbase.CDB_TAB_COLS
          • oceanbase.CDB_TAB_COLS_V$
          • oceanbase.CDB_TAB_PARTITIONS
          • oceanbase.CDB_TAB_SUBPARTITIONS
          • oceanbase.CDB_TABLES
          • oceanbase.CDB_WR_ACTIVE_SESSION_HISTORY
          • oceanbase.CDB_WR_CONTROL
          • oceanbase.CDB_WR_EVENT_NAME
          • oceanbase.CDB_WR_RES_MGR_SYSSTAT
          • oceanbase.CDB_WR_SNAPSHOT
          • oceanbase.CDB_WR_SQL_PLAN
          • oceanbase.CDB_WR_SQLSTAT
          • oceanbase.CDB_WR_SQLTEXT
          • oceanbase.CDB_WR_STATNAME
          • oceanbase.CDB_WR_SYS_TIME_MODEL
          • oceanbase.CDB_WR_SYSSTAT
          • oceanbase.CDB_WR_SYSTEM_EVENT
          • oceanbase.CDB_OB_EXTERNAL_RESOURCES
          • oceanbase.DBA_DB_LINKS
          • oceanbase.DBA_IND_PARTITIONS
          • oceanbase.DBA_IND_STATISTICS
          • oceanbase.DBA_IND_SUBPARTITIONS
          • oceanbase.DBA_INDEX_USAGE
          • oceanbase.DBA_MVIEW_DEPS
          • oceanbase.DBA_MVIEW_LOGS
          • oceanbase.DBA_MVIEW_RUNNING_JOBS
          • oceanbase.DBA_MVIEWS
          • oceanbase.DBA_MVREF_CHANGE_STATS
          • oceanbase.DBA_MVREF_RUN_STATS
          • oceanbase.DBA_MVREF_STATS
          • oceanbase.DBA_MVREF_STATS_PARAMS
          • oceanbase.DBA_MVREF_STATS_SYS_DEFAULTS
          • oceanbase.DBA_MVREF_STMT_STATS
          • oceanbase.DBA_OB_ACCESS_POINT
          • oceanbase.DBA_OB_AI_BATCH_TASK_HISTORY
          • oceanbase.DBA_OB_AI_BATCH_TASKS
          • oceanbase.DBA_OB_AI_GATEWAY_ENDPOINTS
          • oceanbase.DBA_OB_AI_GATEWAYS
          • oceanbase.DBA_OB_AI_MODEL_ENDPOINTS
          • oceanbase.DBA_OB_AI_MODEL_PROFILES
          • oceanbase.DBA_OB_AI_MODEL_PROVIDERS
          • oceanbase.DBA_OB_AI_MODELS
          • oceanbase.DBA_OB_AGENT_DB_BACKGROUND_TASKS
          • oceanbase.DBA_OB_AGENT_DB_BACKGROUND_TASK_HISTORY
          • oceanbase.DBA_OB_ARCHIVE_DEST
          • oceanbase.DBA_OB_ARCHIVELOG
          • oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES
          • oceanbase.DBA_OB_ARCHIVELOG_SUMMARY
          • oceanbase.DBA_OB_AUTO_INCREMENT
          • DBA_OB_AUX_STATISTICS
          • oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY
          • oceanbase.DBA_OB_BACKUP_DELETE_JOBS
          • oceanbase.DBA_OB_BACKUP_DELETE_POLICY
          • oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY
          • oceanbase.DBA_OB_BACKUP_DELETE_TASKS
          • oceanbase.DBA_OB_BACKUP_JOB_HISTORY
          • oceanbase.DBA_OB_BACKUP_JOBS
          • oceanbase.DBA_OB_BACKUP_PARAMETER
          • oceanbase.DBA_OB_BACKUP_SET_FILES
          • oceanbase.DBA_OB_BACKUP_STORAGE_INFO
          • oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY
          • oceanbase.DBA_OB_BACKUP_TASK_HISTORY
          • oceanbase.DBA_OB_BACKUP_TASKS
          • oceanbase.DBA_OB_BALANCE_JOB_HISTORY
          • oceanbase.DBA_OB_BALANCE_JOBS
          • oceanbase.DBA_OB_BALANCE_TASK_HISTORY
          • oceanbase.DBA_OB_BALANCE_TASKS
          • oceanbase.DBA_OB_CLUSTER_EVENT_HISTORY
          • oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL
          • oceanbase.DBA_OB_CCL_RULES
          • oceanbase.DBA_OB_CS_REPLICA_STATS
          • oceanbase.DBA_OB_DATA_DICTIONARY_IN_LOG
          • oceanbase.DBA_OB_DATABASE_PRIVILEGE
          • oceanbase.DBA_OB_DATABASES
          • oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY
          • oceanbase.DBA_OB_DYNAMIC_PARTITION_TABLES
          • oceanbase.DBA_OB_EXTERNAL_PART_COL_STATISTICS
          • oceanbase.DBA_OB_EXTERNAL_TAB_COL_STATISTICS
          • oceanbase.DBA_OB_EXTERNAL_TAB_STATISTICS
          • oceanbase.DBA_OB_EXTERNAL_TABLE_FILES
          • oceanbase.DBA_OB_EXTERNAL_RESOURCES
          • DBA_OB_FORMAT_OUTLINES
          • oceanbase.DBA_OB_FREEZE_INFO
          • oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY
          • oceanbase.DBA_OB_IMPORT_TABLE_JOBS
          • oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY
          • oceanbase.DBA_OB_IMPORT_TABLE_TASKS
          • oceanbase.DBA_OB_KV_TTL_TASK_HISTORY
          • oceanbase.DBA_OB_KV_TTL_TASKS
          • oceanbase.DBA_OB_LOG_RESTORE_SOURCE
          • oceanbase.DBA_OB_LOB_CHECK_EXCEPTION_RESULT
          • oceanbase.DBA_OB_LOB_CHECK_TASKS
          • oceanbase.DBA_OB_LS
          • oceanbase.DBA_OB_LS_HISTORY
          • oceanbase.DBA_OB_LS_LOCATIONS
          • oceanbase.DBA_OB_LS_LOG_ARCHIVE_PROGRESS
          • oceanbase.DBA_OB_LS_REPLICA_TASKS
          • oceanbase.DBA_OB_LS_REPLICA_TASK_HISTORY
          • oceanbase.DBA_OB_MAJOR_COMPACTION
          • oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY
          • oceanbase.DBA_OB_OUTLINES
          • oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY
          • oceanbase.DBA_OB_SERVICES
          • oceanbase.DBA_OB_RECOVER_TABLE_JOBS
          • oceanbase.DBA_OB_RESOURCE_POOLS
          • oceanbase.DBA_OB_RESTORE_HISTORY
          • oceanbase.DBA_OB_RESTORE_PROGRESS
          • oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY
          • oceanbase.DBA_OB_RSRC_IO_DIRECTIVES
          • oceanbase.DBA_OB_RSRC_DIRECTIVES
          • oceanbase.DBA_OB_SEQUENCE_OBJECTS
          • oceanbase.DBA_OB_SERVER_EVENT_HISTORY
          • oceanbase.DBA_OB_SERVER_JOBS
          • oceanbase.DBA_OB_SERVERS
          • oceanbase.DBA_OB_STORAGE_SPACE_USAGE
          • oceanbase.DBA_OB_STORAGE_IO_USAGE
          • oceanbase.DBA_OB_SHARED_MACRO_BLOCK_GC_STAT
          • oceanbase.DBA_OB_SYS_VARIABLES
          • oceanbase.DBA_OB_SPM_EVO_RESULT
          • oceanbase.DBA_OB_TABLE_LOCATIONS
          • oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY
          • oceanbase.DBA_OB_TABLE_STAT_STALE_INFO
          • oceanbase.DBA_OB_TABLEGROUP_PARTITIONS
          • oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS
          • oceanbase.DBA_OB_TABLEGROUP_TABLES
          • oceanbase.DBA_OB_TABLEGROUPS
          • oceanbase.DBA_OB_TABLET_REPLICAS
          • oceanbase.DBA_OB_TABLET_TO_LS
          • oceanbase.DBA_OB_TASK_OPT_STAT_GATHER_HISTORY
          • oceanbase.DBA_OB_TEMP_FILES
          • oceanbase.DBA_OB_TENANT_EVENT_HISTORY
          • oceanbase.DBA_OB_TENANT_FLASHBACK_LOG_SCN
          • oceanbase.DBA_OB_TENANT_JOBS
          • oceanbase.DBA_OB_TENANTS
          • oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS
          • oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY
          • oceanbase.DBA_OB_TRANSFER_TASK_HISTORY
          • oceanbase.DBA_OB_TRANSFER_TASKS
          • DBA_OB_TRUSTED_ROOT_CERTIFICATE
          • oceanbase.DBA_OB_TTL_TASKS
          • oceanbase.DBA_OB_TTL_TASK_HISTORY
          • oceanbase.DBA_OB_UNIT_CONFIGS
          • oceanbase.DBA_OB_UNIT_JOBS
          • oceanbase.DBA_OB_UNITS
          • oceanbase.DBA_OB_USER_DEFINED_RULES
          • oceanbase.DBA_OB_USERS
          • oceanbase.DBA_OB_VECTOR_INDEX_TASKS
          • oceanbase.DBA_OB_VECTOR_INDEX_TASK_HISTORY
          • oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION
          • oceanbase.DBA_OB_ZONES
          • oceanbase.DBA_OB_ZONE_STORAGE
          • oceanbase.DBA_OBJECTS
          • oceanbase.DBA_PART_COL_STATISTICS
          • oceanbase.DBA_PART_HISTOGRAMS
          • oceanbase.DBA_PART_INDEXES
          • oceanbase.DBA_PART_KEY_COLUMNS
          • oceanbase.DBA_PART_TABLES
          • oceanbase.DBA_RECYCLEBIN
          • oceanbase.DBA_RSRC_CONSUMER_GROUPS
          • oceanbase.DBA_RSRC_GROUP_MAPPINGS
          • oceanbase.DBA_RSRC_PLAN_DIRECTIVES
          • oceanbase.DBA_RSRC_PLANS
          • oceanbase.DBA_SCHEDULER_JOBS
          • oceanbase.DBA_SCHEDULER_JOB_RUN_DETAILS
          • oceanbase.DBA_SCHEDULER_WINDOWS
          • oceanbase.DBA_SEQUENCES
          • oceanbase.DBA_SQL_MANAGEMENT_CONFIG
          • oceanbase.DBA_SQL_PLAN_BASELINES
          • oceanbase.DBA_SUBPART_COL_STATISTICS
          • oceanbase.DBA_SUBPART_HISTOGRAMS
          • oceanbase.DBA_SUBPART_KEY_COLUMNS
          • oceanbase.DBA_SUBPARTITION_TEMPLATES
          • oceanbase.DBA_TAB_COL_STATISTICS
          • oceanbase.DBA_TAB_HISTOGRAMS
          • oceanbase.DBA_TAB_MODIFICATIONS
          • oceanbase.DBA_TAB_PARTITIONS
          • oceanbase.DBA_TAB_STATISTICS
          • oceanbase.DBA_TAB_STATS_HISTORY
          • oceanbase.DBA_TAB_SUBPARTITIONS
          • oceanbase.DBA_TABLES
          • oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY
          • oceanbase.DBA_WR_CONTROL
          • oceanbase.DBA_WR_EVENT_NAME
          • oceanbase.DBA_WR_RES_MGR_SYSSTAT
          • oceanbase.DBA_WR_SNAPSHOT
          • oceanbase.DBA_WR_SQL_PLAN
          • oceanbase.DBA_WR_SQLSTAT
          • oceanbase.DBA_WR_SQLTEXT
          • oceanbase.DBA_WR_STATNAME
          • oceanbase.DBA_WR_SYS_TIME_MODEL
          • oceanbase.DBA_WR_SYSSTAT
          • oceanbase.DBA_WR_SYSTEM_EVENT
        • Performance views
          • GV$ACTIVE_SESSION_HISTORY
          • GV$DML_STATS
          • GV$LATCH
          • GV$OB_ACTIVE_SESSION_HISTORY
          • GV$OB_COMPACTION_DIAGNOSE_INFO
          • GV$OB_COMPACTION_PROGRESS
          • GV$OB_COMPACTION_SUGGESTIONS
          • GV$OB_CGROUP_CONFIG
          • GV$OB_DTL_INTERM_RESULT_MONITOR
          • GV$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT
          • GV$OB_FLT_TRACE_CONFIG
          • GV$OB_FUNCTION_IO_STAT
          • GV$OB_GROUP_IO_STAT
          • GV$OB_HMS_CLIENT_POOL_STAT
          • GV$OB_HNSW_INDEX_INFO
          • GV$OB_HNSW_INDEX_SEGMENT_INFO
          • GV$OB_IO_BENCHMARK
          • GV$OB_IO_CALIBRATION_STATUS
          • GV$OB_IVF_INDEX_INFO
          • GV$OB_KVCACHE
          • GV$OB_KV_GROUP_COMMIT_STATUS
          • GV$OB_KV_CONNECTIONS
          • GV$OB_LOG_STAT
          • GV$OB_LOG_TRANSPORT_DEST_STAT
          • GV$OB_LS_SNAPSHOTS
          • GV$OB_MEMORY
          • GV$OB_MEMSTORE
          • GV$OB_MEMSTORE_INFO
          • GV$OB_MERGE_INFO
          • GV$OB_NIC_INFO
          • GV$OB_RPC_INCOMING
          • GV$OB_RPC_OUTGOING
          • GV$OB_PARAMETERS
          • GV$OB_PLAN_CACHE_PLAN_EXPLAIN
          • GV$OB_PLAN_CACHE_PLAN_STAT
          • GV$OB_PLAN_CACHE_STAT
          • GV$OB_PLUGINS
          • GV$OB_PROCESSLIST
          • GV$OB_PS_ITEM_INFO
          • GV$OB_PS_STAT
          • GV$OB_PX_P2P_DATAHUB
          • GV$OB_PX_TARGET_MONITOR
          • GV$OB_PX_WORKER_STAT
          • GV$OB_RES_MGR_SYSSTAT
          • GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM
          • GV$OB_SERVER_SCHEMA_INFO
          • GV$OB_SERVERS
          • GV$OB_SERVER_STORAGE
          • GV$OB_SESS_TIME_MODEL
          • GV$OB_SESSION
          • GV$OB_SESSION_PS_INFO
          • GV$OB_SHARED_STORAGE_QUOTA
          • GV$OB_SINDI_INDEX_INFO
          • GV$OB_SQL_AUDIT
          • GV$OB_SQL_CCL_STATUS
          • GV$SQL_JOIN_FILTER
          • GV$OB_SQL_PLAN
          • GV$SQL_PLAN_MONITOR
          • GV$OB_SQL_WORKAREA_MEMORY_INFO
          • GV$OB_SQLSTAT
          • GV$OB_SSTABLES
          • GV$OB_LOCAL_CACHE
          • GV$OB_LOCAL_CACHE_DIAGNOSE
          • GV$OB_OBJECT_TYPE_IO_STAT
          • GV$OB_STORAGE_CACHE_TASKS
          • GV$OB_SYS_TIME_MODEL
          • GV$OB_TABLET_COMPACTION_HISTORY
          • GV$OB_TABLET_COMPACTION_PROGRESS
          • GV$OB_TABLET_LOCAL_CACHE
          • GV$OB_TABLET_REPLICA_INFO
          • GV$OB_TENANT_MEMORY
          • GV$OB_TENANT_RESOURCE_LIMIT
          • GV$OB_TENANT_RESOURCE_LIMIT_DETAIL
          • GV$OB_TENANT_RUNTIME_INFO
          • GV$OB_TRANSACTION_PARTICIPANTS
          • GV$OB_TRANSACTION_SCHEDULERS
          • GV$OB_UNITS
          • GV$OB_VECTOR_MEMORY
          • GV$SESSION_EVENT
          • GV$SESSION_LONGOPS
          • GV$SESSION_WAIT
          • GV$SESSION_WAIT_HISTORY
          • GV$SESSTAT
          • GV$SQL_WORKAREA
          • GV$SQL_WORKAREA_ACTIVE
          • GV$SQL_WORKAREA_HISTOGRAM
          • GV$SYSSTAT
          • GV$SYSTEM_EVENT
          • GV$OB_KV_CLIENT_INFO
          • GV$OB_LOCKS
          • GV$OB_OPT_STAT_GATHER_MONITOR
          • GV$OB_THREAD
          • GV$OB_PL_CACHE_OBJECT
          • V$OB_PL_CACHE_OBJECT
          • V$ACTIVE_SESSION_HISTORY
          • V$DML_STATS
          • V$ENCRYPTED_TABLESPACES
          • V$EVENT_NAME
          • V$LATCH
          • V$OB_ACTIVE_SESSION_HISTORY
          • V$OB_ARCHIVE_DEST_STATUS
          • V$OB_COMPACTION_DIAGNOSE_INFO
          • V$OB_COMPACTION_PROGRESS
          • V$OB_COMPACTION_SUGGESTIONS
          • V$OB_COMPATIBILITY_CONTROL
          • V$OB_CGROUP_CONFIG
          • V$OB_DTL_INTERM_RESULT_MONITOR
          • V$OB_DYNAMIC_PARTITION_TABLES
          • V$OB_ENCRYPTED_TABLES
          • V$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT
          • V$OB_FUNCTION_IO_STAT
          • V$OB_GROUP_IO_STAT
          • V$OB_HMS_CLIENT_POOL_STAT
          • V$OB_IO_BENCHMARK
          • V$OB_HNSW_INDEX_SEGMENT_INFO
          • V$OB_HNSW_INDEX_INFO
          • V$OB_IO_CALIBRATION_STATUS
          • V$OB_IVF_INDEX_INFO
          • V$OB_KVCACHE
          • V$OB_KV_CLIENT_INFO
          • V$OB_KV_GROUP_COMMIT_STATUS
          • V$OB_KV_CONNECTIONS
          • V$OB_LOG_STAT
          • V$OB_LOG_TRANSPORT_DEST_STAT
          • V$OB_LS_LOG_RESTORE_STATUS
          • V$OB_LS_REPLICA_TASK_PLAN
          • V$OB_LS_SNAPSHOTS
          • V$OB_MEMORY
          • V$OB_MEMSTORE
          • V$OB_MEMSTORE_INFO
          • V$OB_MERGE_INFO
          • V$OB_NIC_INFO
          • V$OB_RPC_INCOMING
          • V$OB_RPC_OUTGOING
          • V$OB_PARAMETERS
          • V$OB_PLAN_CACHE_PLAN_EXPLAIN
          • V$OB_PLAN_CACHE_PLAN_STAT
          • V$OB_PLAN_CACHE_STAT
          • V$OB_PLUGINS
          • V$OB_PROCESSLIST
          • V$OB_PS_ITEM_INFO
          • V$OB_PS_STAT
          • V$OB_PX_P2P_DATAHUB
          • V$OB_PX_TARGET_MONITOR
          • V$OB_PX_WORKER_STAT
          • V$OB_RES_MGR_SYSSTAT
          • V$OB_QUERY_RESPONSE_TIME_HISTOGRAM
          • V$OB_SERVER_SCHEMA_INFO
          • V$OB_SERVERS
          • V$OB_SERVER_STORAGE
          • V$OB_SESS_TIME_MODEL
          • V$OB_SESSION
          • V$SESSION_EVENT
          • V$OB_SESSION_PS_INFO
          • V$OB_SHARED_STORAGE_QUOTA
          • V$OB_SINDI_INDEX_INFO
          • V$OB_SQL_AUDIT
          • V$OB_SQL_CCL_STATUS
          • V$SQL_JOIN_FILTER
          • V$OB_SQL_PLAN
          • V$OB_SQL_WORKAREA_MEMORY_INFO
          • V$OB_SQLSTAT
          • V$OB_SHARED_SSTABLES
          • V$OB_SSTABLES
          • V$OB_LOCAL_CACHE
          • V$OB_LOCAL_CACHE_DIAGNOSE
          • V$OB_OBJECT_TYPE_IO_STAT
          • V$OB_STORAGE_CACHE_TASKS
          • V$OB_SYS_TIME_MODEL
          • V$OB_TABLET_COMPACTION_HISTORY
          • V$OB_TABLET_COMPACTION_PROGRESS
          • V$OB_TABLET_LOCAL_CACHE
          • V$OB_TABLET_REPLICA_INFO
          • V$OB_TENANT_MEMORY
          • V$OB_TENANT_RESOURCE_LIMIT
          • V$OB_TENANT_RESOURCE_LIMIT_DETAIL
          • V$OB_TENANT_RUNTIME_INFO
          • V$OB_TIMESTAMP_SERVICE
          • V$OB_TRANSACTION_PARTICIPANTS
          • V$OB_TRANSACTION_SCHEDULERS
          • V$OB_UNITS
          • V$RSRC_PLAN
          • V$SESSION_LONGOPS
          • V$SESSION_WAIT
          • V$SESSION_WAIT_HISTORY
          • V$SESSTAT
          • V$SQL_MONITOR_STATNAME
          • V$SQL_PLAN_MONITOR
          • V$SQL_WORKAREA
          • V$SQL_WORKAREA_ACTIVE
          • V$SQL_WORKAREA_HISTOGRAM
          • V$STATNAME
          • V$SYSSTAT
          • V$SYSTEM_EVENT
          • V$OB_LOCKS
          • V$OB_OPT_STAT_GATHER_MONITOR
          • V$OB_THREAD
          • V$OB_VECTOR_MEMORY
      • User tenant views
        • Dictionary views
          • information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS
          • information_schema.CHARACTER_SETS
          • information_schema.CHECK_CONSTRAINTS
          • information_schema.COLLATION_CHARACTER_SET_APPLICABILITY
          • information_schema.COLLATIONS
          • information_schema.COLUMN_PRIVILEGES
          • information_schema.COLUMNS
          • information_schema.ENGINES
          • information_schema.events
          • information_schema.GLOBAL_STATUS
          • information_schema.GLOBAL_VARIABLES
          • information_schema.KEY_COLUMN_USAGE
          • information_schema.PARAMETERS
          • information_schema.PARTITIONS
          • information_schema.PROCESSLIST
          • information_schema.QUERY_RESPONSE_TIME
          • information_schema.REFERENTIAL_CONSTRAINTS
          • information_schema.role_table_grants
          • information_schema.role_column_grants
          • information_schema.role_routine_grants
          • information_schema.ROUTINES
          • information_schema.SCHEMA_PRIVILEGES
          • information_schema.SCHEMATA
          • information_schema.SESSION_STATUS
          • information_schema.SESSION_VARIABLES
          • information_schema.ST_GEOMETRY_COLUMNS
          • information_schema.ST_SPATIAL_REFERENCE_SYSTEMS
          • information_schema.STATISTICS
          • information_schema.TABLE_CONSTRAINTS
          • information_schema.TABLE_PRIVILEGES
          • information_schema.TABLES
          • information_schema.TRIGGERS
          • information_schema.USER_PRIVILEGES
          • information_schema.VIEW_TABLE_USAGE
          • information_schema.VIEWS
          • mysql.audit_log_filter
          • mysql.audit_log_user
          • mysql.columns_priv
          • mysql.db
          • mysql.default_roles
          • mysql.help_category
          • mysql.help_keyword
          • mysql.help_relation
          • mysql.help_topic
          • mysql.proc
          • mysql.procs_priv
          • mysql.role_edges
          • mysql.time_zone
          • mysql.time_zone_name
          • mysql.time_zone_transition
          • mysql.time_zone_transition_type
          • mysql.user
          • oceanbase.ALL_OB_EXTERNAL_TABLE_FILES
          • oceanbase.DBA_DB_LINKS
          • oceanbase.DBA_IND_PARTITIONS
          • oceanbase.DBA_IND_STATISTICS
          • oceanbase.DBA_IND_SUBPARTITIONS
          • oceanbase.DBA_INDEX_USAGE
          • oceanbase.DBA_JAVA_POLICY
          • oceanbase.DBA_MVIEW_DEPS
          • oceanbase.DBA_MVIEW_LOGS
          • oceanbase.DBA_MVIEW_RUNNING_JOBS
          • oceanbase.DBA_MVIEWS
          • oceanbase.DBA_MVREF_CHANGE_STATS
          • oceanbase.DBA_MVREF_RUN_STATS
          • oceanbase.DBA_MVREF_STATS
          • oceanbase.DBA_MVREF_STATS_PARAMS
          • oceanbase.DBA_MVREF_STATS_SYS_DEFAULTS
          • oceanbase.DBA_MVREF_STMT_STATS
          • oceanbase.DBA_OB_ACCESS_POINT
          • oceanbase.DBA_OB_AI_BATCH_TASK_HISTORY
          • oceanbase.DBA_OB_AI_BATCH_TASKS
          • oceanbase.DBA_OB_AI_GATEWAY_ENDPOINTS
          • oceanbase.DBA_OB_AI_GATEWAYS
          • oceanbase.DBA_OB_AI_MODEL_ENDPOINTS
          • oceanbase.DBA_OB_AI_MODEL_PROFILES
          • oceanbase.DBA_OB_AI_MODEL_PROVIDERS
          • oceanbase.DBA_OB_AI_MODELS
          • oceanbase.DBA_OB_AGENT_DB_BACKGROUND_TASKS
          • oceanbase.DBA_OB_AGENT_DB_BACKGROUND_TASK_HISTORY
          • oceanbase.DBA_OB_ARCHIVE_DEST
          • oceanbase.DBA_OB_ARCHIVELOG
          • oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES
          • oceanbase.DBA_OB_ARCHIVELOG_SUMMARY
          • oceanbase.DBA_OB_AUTO_INCREMENT
          • DBA_OB_AUX_STATISTICS
          • oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY
          • oceanbase.DBA_OB_BACKUP_DELETE_JOBS
          • oceanbase.DBA_OB_BACKUP_DELETE_POLICY
          • oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY
          • oceanbase.DBA_OB_BACKUP_DELETE_TASKS
          • oceanbase.DBA_OB_BACKUP_JOB_HISTORY
          • oceanbase.DBA_OB_BACKUP_JOBS
          • oceanbase.DBA_OB_BACKUP_PARAMETER
          • oceanbase.DBA_OB_BACKUP_SET_FILES
          • oceanbase.DBA_OB_BACKUP_STORAGE_INFO
          • oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY
          • oceanbase.DBA_OB_BACKUP_TASK_HISTORY
          • oceanbase.DBA_OB_BACKUP_TASKS
          • oceanbase.DBA_OB_BALANCE_JOB_HISTORY
          • oceanbase.DBA_OB_BALANCE_JOBS
          • oceanbase.DBA_OB_BALANCE_TASK_HISTORY
          • oceanbase.DBA_OB_BALANCE_TASKS
          • oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL
          • oceanbase.DBA_OB_CCL_RULES
          • oceanbase.DBA_OB_CS_REPLICA_STATS
          • oceanbase.DBA_OB_DATA_DICTIONARY_IN_LOG
          • oceanbase.DBA_OB_DATABASE_PRIVILEGE
          • oceanbase.DBA_OB_DATABASES
          • oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY
          • oceanbase.DBA_OB_DYNAMIC_PARTITION_TABLES
          • oceanbase.DBA_OB_EXTERNAL_PART_COL_STATISTICS
          • oceanbase.DBA_OB_EXTERNAL_TAB_COL_STATISTICS
          • oceanbase.DBA_OB_EXTERNAL_TAB_STATISTICS
          • oceanbase.DBA_OB_EXTERNAL_TABLE_FILES
          • oceanbase.DBA_OB_EXTERNAL_RESOURCES
          • DBA_OB_FORMAT_OUTLINES
          • oceanbase.DBA_OB_FREEZE_INFO
          • oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY
          • oceanbase.DBA_OB_IMPORT_TABLE_JOBS
          • oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY
          • oceanbase.DBA_OB_IMPORT_TABLE_TASKS
          • oceanbase.DBA_OB_KV_TTL_TASK_HISTORY
          • oceanbase.DBA_OB_KV_TTL_TASKS
          • oceanbase.DBA_OB_LOG_RESTORE_SOURCE
          • oceanbase.DBA_OB_LOB_CHECK_EXCEPTION_RESULT
          • oceanbase.DBA_OB_LOB_CHECK_TASKS
          • oceanbase.DBA_OB_LS
          • oceanbase.DBA_OB_LS_HISTORY
          • oceanbase.DBA_OB_LS_LOCATIONS
          • oceanbase.DBA_OB_LS_LOG_ARCHIVE_PROGRESS
          • oceanbase.DBA_OB_LS_REPLICA_TASKS
          • oceanbase.DBA_OB_LS_REPLICA_TASK_HISTORY
          • oceanbase.DBA_OB_MAJOR_COMPACTION
          • oceanbase.DBA_OB_OBJECT_BALANCE_WEIGHT
          • oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY
          • oceanbase.DBA_OB_OUTLINES
          • oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY
          • oceanbase.DBA_OB_RECOVER_TABLE_JOBS
          • oceanbase.DBA_OB_SERVICES
          • oceanbase.DBA_OB_RESTORE_HISTORY
          • oceanbase.DBA_OB_RESTORE_PROGRESS
          • oceanbase.DBA_OB_RSRC_IO_DIRECTIVES
          • oceanbase.DBA_OB_RSRC_DIRECTIVES
          • oceanbase.DBA_OB_SENSITIVE_COLUMNS
          • oceanbase.DBA_OB_SENSITIVE_RULE_PLAINACCESS_USERS
          • oceanbase.DBA_OB_SENSITIVE_RULES
          • oceanbase.DBA_OB_SEQUENCE_OBJECTS
          • oceanbase.DBA_OB_SHARED_MACRO_BLOCK_GC_STAT
          • oceanbase.DBA_OB_STORAGE_SPACE_USAGE
          • oceanbase.DBA_OB_STORAGE_IO_USAGE
          • oceanbase.DBA_OB_SYS_VARIABLES
          • oceanbase.DBA_OB_SPM_EVO_RESULT
          • oceanbase.DBA_OB_TABLE_LOCATIONS
          • oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY
          • oceanbase.DBA_OB_TABLE_STAT_STALE_INFO
          • oceanbase.DBA_OB_TABLEGROUP_PARTITIONS
          • oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS
          • oceanbase.DBA_OB_TABLEGROUP_TABLES
          • oceanbase.DBA_OB_TABLEGROUPS
          • oceanbase.DBA_OB_TABLET_REPLICAS
          • oceanbase.DBA_OB_TABLE_SPACE_USAGE
          • oceanbase.DBA_OB_TABLET_TO_LS
          • oceanbase.DBA_OB_TASK_OPT_STAT_GATHER_HISTORY
          • oceanbase.DBA_OB_TENANT_EVENT_HISTORY
          • oceanbase.DBA_OB_TENANTS
          • oceanbase.DBA_OB_TEMP_FILES
          • oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS
          • oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY
          • oceanbase.DBA_OB_TRANSFER_TASK_HISTORY
          • oceanbase.DBA_OB_TRANSFER_TASKS
          • oceanbase.DBA_OB_USER_DEFINED_RULES
          • oceanbase.DBA_OB_USERS
          • oceanbase.DBA_OB_VECTOR_INDEX_TASKS
          • oceanbase.DBA_OB_VECTOR_INDEX_TASK_HISTORY
          • oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION
          • oceanbase.DBA_OBJECTS
          • oceanbase.DBA_PART_COL_STATISTICS
          • oceanbase.DBA_PART_HISTOGRAMS
          • oceanbase.DBA_PART_INDEXES
          • oceanbase.DBA_PART_KEY_COLUMNS
          • oceanbase.DBA_PART_TABLES
          • oceanbase.DBA_RECYCLEBIN
          • oceanbase.DBA_RLS_POLICIES
          • oceanbase.DBA_RSRC_CONSUMER_GROUPS
          • oceanbase.DBA_RSRC_GROUP_MAPPINGS
          • oceanbase.DBA_RSRC_PLAN_DIRECTIVES
          • oceanbase.DBA_RSRC_PLANS
          • oceanbase.DBA_SCHEDULER_JOBS
          • oceanbase.DBA_SCHEDULER_JOB_RUN_DETAILS
          • oceanbase.DBA_SCHEDULER_WINDOWS
          • oceanbase.DBA_SEQUENCES
          • oceanbase.DBA_SQL_MANAGEMENT_CONFIG
          • oceanbase.DBA_SQL_PLAN_BASELINES
          • oceanbase.DBA_SUBPART_COL_STATISTICS
          • oceanbase.DBA_SUBPART_HISTOGRAMS
          • oceanbase.DBA_SUBPART_KEY_COLUMNS
          • oceanbase.DBA_SUBPARTITION_TEMPLATES
          • oceanbase.DBA_TAB_COL_STATISTICS
          • oceanbase.DBA_TAB_HISTOGRAMS
          • oceanbase.DBA_TAB_MODIFICATIONS
          • oceanbase.DBA_TAB_PARTITIONS
          • oceanbase.DBA_TAB_STATISTICS
          • oceanbase.DBA_TAB_STATS_HISTORY
          • oceanbase.DBA_TAB_SUBPARTITIONS
          • oceanbase.DBA_TABLES
          • oceanbase.DBA_OB_TENANT_FLASHBACK_LOG_SCN
          • oceanbase.DBA_OB_TTL_TASKS
          • oceanbase.DBA_OB_TTL_TASK_HISTORY
          • oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY
          • oceanbase.DBA_WR_CONTROL
          • oceanbase.DBA_WR_EVENT_NAME
          • oceanbase.DBA_WR_RES_MGR_SYSSTAT
          • oceanbase.DBA_WR_SNAPSHOT
          • oceanbase.DBA_WR_SQL_PLAN
          • oceanbase.DBA_WR_SQLSTAT
          • oceanbase.DBA_WR_SQLTEXT
          • oceanbase.DBA_WR_STATNAME
          • oceanbase.DBA_WR_SYS_TIME_MODEL
          • oceanbase.DBA_WR_SYSSTAT
          • oceanbase.DBA_WR_SYSTEM_EVENT
          • oceanbase.USER_JAVA_POLICY
        • Performance views
          • GV$ACTIVE_SESSION_HISTORY
          • GV$DML_STATS
          • GV$LATCH
          • GV$OB_ACTIVE_SESSION_HISTORY
          • GV$OB_COMPACTION_DIAGNOSE_INFO
          • GV$OB_COMPACTION_PROGRESS
          • GV$OB_COMPACTION_SUGGESTIONS
          • GV$OB_CGROUP_CONFIG
          • GV$OB_DTL_INTERM_RESULT_MONITOR
          • GV$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT
          • GV$OB_FLT_TRACE_CONFIG
          • GV$OB_FUNCTION_IO_STAT
          • GV$OB_GROUP_IO_STAT
          • GV$OB_HNSW_INDEX_INFO
          • GV$OB_HMS_CLIENT_POOL_STAT
          • GV$OB_IVF_INDEX_INFO
          • GV$OB_HNSW_INDEX_SEGMENT_INFO
          • GV$OB_KVCACHE
          • GV$OB_KV_CLIENT_INFO
          • GV$OB_KV_GROUP_COMMIT_STATUS
          • GV$OB_KV_CONNECTIONS
          • GV$OB_LOG_STAT
          • GV$OB_LOG_TRANSPORT_DEST_STAT
          • GV$OB_LS_SNAPSHOTS
          • GV$OB_MEMORY
          • GV$OB_MEMSTORE
          • GV$OB_MEMSTORE_INFO
          • GV$OB_MERGE_INFO
          • GV$OB_NIC_INFO
          • GV$OB_RPC_INCOMING
          • GV$OB_RPC_OUTGOING
          • GV$OB_PARAMETERS
          • GV$OB_PLAN_CACHE_PLAN_EXPLAIN
          • GV$OB_PLAN_CACHE_PLAN_STAT
          • GV$OB_PLAN_CACHE_STAT
          • GV$OB_PROCESSLIST
          • GV$OB_PS_ITEM_INFO
          • GV$OB_PS_STAT
          • GV$OB_PX_P2P_DATAHUB
          • GV$OB_PX_TARGET_MONITOR
          • GV$OB_PX_WORKER_STAT
          • GV$OB_RES_MGR_SYSSTAT
          • GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM
          • GV$OB_SERVER_SCHEMA_INFO
          • GV$OB_SESS_TIME_MODEL
          • GV$OB_SESSION
          • GV$OB_SESSION_PS_INFO
          • GV$OB_SHARED_STORAGE_QUOTA
          • GV$OB_SINDI_INDEX_INFO
          • GV$OB_SQL_AUDIT
          • GV$OB_SQL_CCL_STATUS
          • GV$SQL_JOIN_FILTER
          • GV$OB_SQL_PLAN
          • GV$OB_SQL_WORKAREA_MEMORY_INFO
          • GV$OB_SQLSTAT
          • GV$OB_SSTABLES
          • GV$OB_LOCAL_CACHE
          • GV$OB_LOCAL_CACHE_DIAGNOSE
          • GV$OB_OBJECT_TYPE_IO_STAT
          • GV$OB_STORAGE_CACHE_TASKS
          • GV$OB_SYS_TIME_MODEL
          • GV$OB_TABLET_COMPACTION_HISTORY
          • GV$OB_TABLET_COMPACTION_PROGRESS
          • GV$OB_TABLET_LOCAL_CACHE
          • GV$OB_TABLET_MACRO_CACHE_STAT
          • GV$OB_TENANT_MEMORY
          • GV$OB_TENANT_RESOURCE_LIMIT
          • GV$OB_TENANT_RESOURCE_LIMIT_DETAIL
          • GV$OB_TRANSACTION_PARTICIPANTS
          • GV$OB_TRANSACTION_SCHEDULERS
          • GV$OB_UNITS
          • GV$OB_VECTOR_MEMORY
          • GV$SESSION_EVENT
          • GV$SESSION_LONGOPS
          • GV$SESSION_WAIT
          • GV$SESSION_WAIT_HISTORY
          • GV$SESSTAT
          • GV$SQL_PLAN_MONITOR
          • GV$SQL_WORKAREA
          • GV$SQL_WORKAREA_ACTIVE
          • GV$SQL_WORKAREA_HISTOGRAM
          • GV$SYSSTAT
          • GV$SYSTEM_EVENT
          • GV$OB_LOCKS
          • GV$OB_OPT_STAT_GATHER_MONITOR
          • GV$OB_THREAD
          • GV$OB_PL_CACHE_OBJECT
          • V$OB_PL_CACHE_OBJECT
          • V$ACTIVE_SESSION_HISTORY
          • V$DML_STATS
          • V$EVENT_NAME
          • V$LATCH
          • V$OB_ACTIVE_SESSION_HISTORY
          • V$OB_ARCHIVE_DEST_STATUS
          • V$OB_COMPACTION_DIAGNOSE_INFO
          • V$OB_COMPACTION_PROGRESS
          • V$OB_COMPACTION_SUGGESTIONS
          • V$OB_COMPATIBILITY_CONTROL
          • V$OB_CGROUP_CONFIG
          • V$OB_DTL_INTERM_RESULT_MONITOR
          • V$OB_DYNAMIC_PARTITION_TABLES
          • V$OB_ENCRYPTED_TABLES
          • V$ENCRYPTED_TABLESPACES
          • V$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT
          • V$OB_FUNCTION_IO_STAT
          • V$OB_GROUP_IO_STAT
          • V$OB_HMS_CLIENT_POOL_STAT
          • V$OB_HNSW_INDEX_INFO
          • V$OB_HNSW_INDEX_SEGMENT_INFO
          • V$OB_IVF_INDEX_INFO
          • V$OB_KVCACHE
          • V$OB_KV_CLIENT_INFO
          • V$OB_KV_GROUP_COMMIT_STATUS
          • V$OB_KV_CONNECTIONS
          • V$OB_LOG_STAT
          • V$OB_LOG_TRANSPORT_DEST_STAT
          • V$OB_LS_LOG_RESTORE_STATUS
          • V$OB_LS_REPLICA_TASK_PLAN
          • V$OB_LS_SNAPSHOTS
          • V$OB_MEMORY
          • V$OB_MEMSTORE
          • V$OB_MEMSTORE_INFO
          • V$OB_MERGE_INFO
          • V$OB_NIC_INFO
          • V$OB_RPC_INCOMING
          • V$OB_RPC_OUTGOING
          • V$OB_PARAMETERS
          • V$OB_PLAN_CACHE_PLAN_EXPLAIN
          • V$OB_PLAN_CACHE_PLAN_STAT
          • V$OB_PLAN_CACHE_STAT
          • V$OB_PROCESSLIST
          • V$OB_PS_ITEM_INFO
          • V$OB_PS_STAT
          • V$OB_PX_P2P_DATAHUB
          • V$OB_PX_TARGET_MONITOR
          • V$OB_PX_WORKER_STAT
          • V$OB_RES_MGR_SYSSTAT
          • V$OB_QUERY_RESPONSE_TIME_HISTOGRAM
          • V$RSRC_PLAN
          • V$OB_SERVER_SCHEMA_INFO
          • V$OB_SESS_TIME_MODEL
          • V$OB_SESSION
          • V$SESSION_EVENT
          • V$OB_SESSION_PS_INFO
          • V$OB_SHARED_STORAGE_QUOTA
          • V$OB_SINDI_INDEX_INFO
          • V$OB_SQL_AUDIT
          • V$OB_SQL_CCL_STATUS
          • V$SQL_JOIN_FILTER
          • V$OB_SQL_PLAN
          • V$OB_SQL_WORKAREA_MEMORY_INFO
          • V$OB_SQLSTAT
          • V$OB_SHARED_SSTABLES
          • V$OB_SSTABLES
          • V$OB_LOCAL_CACHE
          • V$OB_LOCAL_CACHE_DIAGNOSE
          • V$OB_OBJECT_TYPE_IO_STAT
          • V$OB_STORAGE_CACHE_TASKS
          • V$OB_SYS_TIME_MODEL
          • V$OB_TABLET_COMPACTION_HISTORY
          • V$OB_TABLET_COMPACTION_PROGRESS
          • V$OB_TABLET_LOCAL_CACHE
          • V$OB_TABLET_MACRO_CACHE_STAT
          • V$OB_TENANT_MEMORY
          • V$OB_TENANT_RESOURCE_LIMIT
          • V$OB_TENANT_RESOURCE_LIMIT_DETAIL
          • V$OB_TIMESTAMP_SERVICE
          • V$OB_TRANSACTION_PARTICIPANTS
          • V$OB_TRANSACTION_SCHEDULERS
          • V$OB_UNITS
          • V$OB_VECTOR_MEMORY
          • V$RESTORE_POINT
          • V$SESSION_LONGOPS
          • V$SESSION_WAIT
          • V$SESSION_WAIT_HISTORY
          • V$SESSTAT
          • V$SQL_MONITOR_STATNAME
          • V$SQL_PLAN_MONITOR
          • V$SQL_WORKAREA
          • V$SQL_WORKAREA_ACTIVE
          • V$SQL_WORKAREA_HISTOGRAM
          • V$STATNAME
          • V$SYSSTAT
          • V$SYSTEM_EVENT
          • V$OB_LOCKS
          • V$OB_OPT_STAT_GATHER_MONITOR
          • V$OB_THREAD
      • Overview of Metrics
      • Common wait events
    • Parameters and system variables
      • Overview of parameters and system variables
      • Parameters
        • Parameter overview
        • Cluster-level parameters
          • alert_log_level
          • all_cluster_list
          • all_server_list
          • autoinc_cache_refresh_interval
          • async_ps_cursor_max_count
          • balancer_log_interval
          • balancer_task_timeout
          • system_protected_sys_variables
          • system-protected-tenant-parameters
          • balancer_tolerance_percentage
          • bf_cache_miss_count_threshold
          • bf_cache_priority
          • builtin_db_data_verify_cycle
          • cache_wash_threshold
          • clog_io_isolation_mode
          • clog_sync_time_warn_threshold
          • cluster
          • cluster_id
          • config_additional_dir
          • cpu_count
          • data_dir
          • data_disk_usage_limit_percentage
          • data_disk_write_limit_percentage
          • data_storage_error_tolerance_time
          • data_storage_warning_tolerance_time
          • datafile_disk_percentage
          • datafile_maxsize
          • datafile_next
          • datafile_size
          • dead_socket_detection_timeout
          • debug_sync_timeout
          • default_compress_func
          • default_row_format
          • devname
          • diag_syslog_per_error_limit
          • disk_io_thread_count
          • dtl_buffer_size
          • enable_asan_for_memory_context
          • enable_async_syslog
          • enable_cgroup
          • enable_dblink
          • enable_ddl
          • enable_global_background_resource_isolation
          • enable_logservice
          • enable_major_freeze
          • enable_ob_error_msg_style
          • enable_ob_ratelimit
          • enable_perf_event
          • enable_record_trace_id
          • enable_record_trace_log
          • enable_rereplication
          • enable_rich_error_msg
          • enable_rpc_authentication_bypass
          • enable_sql_audit
          • enable_sql_operator_dump
          • enable_sys_table_ddl
          • enable_sys_unit_standalone
          • enable_syslog_recycle
          • enable_syslog_wf
          • enable_tcp_keepalive
          • enable_upgrade_mode
          • ext_plugin_config
          • fuse_row_cache_priority
          • global_background_cpu_quota
          • high_priority_net_thread_count
          • ignore_replay_checksum_error
          • index_block_cache_priority
          • internal_sql_execute_timeout
          • io_scheduler_thread_count
          • large_query_threshold
          • large_query_worker_percentage
          • leak_mod_to_check
          • lease_time
          • local_ip
          • location_cache_cpu_quota
          • location_cache_expire_time
          • location_cache_refresh_min_interval
          • location_cache_refresh_rpc_timeout
          • location_cache_refresh_sql_timeout
          • location_fetch_concurrency
          • location_refresh_thread_count
          • log_disk_percentage
          • log_disk_size
          • logservice_access_point
          • log_storage_warning_trigger_percentage
          • log_storage_warning_tolerance_time
          • ls_meta_table_check_interval
          • max_string_print_length
          • max_syslog_file_count
          • memory_chunk_cache_size
          • memory_limit
          • memory_limit_percentage
          • memory_reserved
          • memstore_limit_percentage
          • micro_block_merge_verify_level
          • migration_disable_time
          • min_observer_version
          • mysql_port
          • net_thread_count
          • ob_event_history_recycle_interval
          • ob_ratelimit_stat_period
          • ob_startup_mode
          • ob_python_home
          • obconfig_url
          • observer_id
          • ob_storage_s3_url_encode_type
          • ob_enable_java_env
          • ob_java_home
          • ob_java_connector_path
          • ob_java_opts
          • ob_enable_java_udf_sandbox
          • ob_enable_utl_http
          • opt_tab_stat_cache_priority
          • plan_cache_evict_interval
          • px_task_size
          • plugins_load
          • recyclebin_object_expire_time
          • resource_hard_limit
          • rest_oauth2_credential_refresh_interval
          • rest_oauth2_credential_evict_time
          • rootservice_async_task_queue_size
          • rootservice_async_task_thread_count
          • rootservice_list
          • rootservice_ready_check_interval
          • row_compaction_update_limit
          • rpc_client_authentication_method
          • rpc_port
          • rpc_server_authentication_method
          • rpc_timeout
          • schema_history_expire_time
          • schema_history_recycle_interval
          • server_balance_cpu_mem_tolerance_percent
          • server_balance_critical_disk_waterlevel
          • server_balance_disk_tolerance_percent
          • server_check_interval
          • server_cpu_quota_max
          • server_cpu_quota_min
          • server_permanent_offline_time
          • sql_login_thread_count
          • sql_net_thread_count
          • sql_protocol_min_tls_version
          • ssl_client_authentication
          • ssl_external_kms_info
          • stack_size
          • standby_fetch_log_bandwidth_limit
          • storage_meta_cache_priority
          • strict_check_os_params
          • sync_io_thread_count
          • sys_bkgd_migration_change_member_list_timeout
          • sys_bkgd_migration_retry_num
          • sys_bkgd_net_percentage
          • sys_ckpt_thread_score
          • syslog_compress_func
          • syslog_disk_size
          • syslog_file_uncompressed_count
          • syslog_io_bandwidth_limit
          • syslog_level
          • system_memory
          • tablet_ls_cache_priority
          • tablet_meta_table_check_interval
          • tablet_meta_table_scan_batch_count
          • tablet_size
          • tcp_keepcnt
          • tcp_keepidle
          • tcp_keepintvl
          • tenant_task_queue_size
          • trace_log_slow_query_watermark
          • trx_2pc_retry_interval
          • unit_gc_wait_time
          • use_large_pages
          • user_block_cache_priority
          • user_row_cache_priority
          • virtual_table_location_cache_expire_time
          • weak_read_version_refresh_interval
          • workers_per_cpu_quota
          • zone
        • Tenant-level parameters
          • agent_db_background_delete_thread_score
          • agent_db_hot_namespace_ttl
          • arbitration_timeout
          • archive_lag_target
          • approx_count_distinct_precision
          • audit_log_buffer_size
          • audit_log_compression
          • attach_shared_sstable_thread_score
          • audit_log_enable
          • audit_log_format
          • audit_log_max_size
          • audit_log_path
          • audit_log_prune_seconds
          • audit_log_query_sql
          • audit_log_rotate_on_size
          • audit_log_strategy
          • audit_sys_operations
          • audit_trail
          • auto_split_tablet_size
          • backup_data_file_size
          • balancer_idle_time
          • catalog_sync_target
          • choose_migration_source_policy
          • compaction_dag_cnt_limit
          • compaction_high_thread_score
          • compaction_low_thread_score
          • compaction_mid_thread_score
          • compaction_schedule_tablet_batch_cnt
          • compatible
          • connection_control_failed_connections_threshold
          • connection_control_max_connection_delay
          • connection_control_min_connection_delay
          • cpu_quota_concurrency
          • ddl_thread_score
          • default_auto_increment_mode
          • default_delta_format
          • default_enable_extended_rowid
          • default_load_mode
          • default_micro_block_format_version
          • default_progressive_merge_num
          • default_skip_index_level
          • default_storage_cache_policy
          • default_table_merge_engine
          • default_table_organization
          • default_table_store_format
          • direct_load_allow_fallback
          • ddl_high_thread_score
          • document_ai_file_max_size
          • dtl_compress_func
          • dump_data_dictionary_to_log_interval
          • enable_agent_db_background_task
          • enable_adaptive_plan_cache
          • enable_auto_split
          • enable_database_sharding_none
          • enable_early_lock_release
          • enable_hbase_rowkey_ttl
          • enable_pl_rich_error_msg
          • enable_gts_standalone
          • enable_kv_group_commit
          • enable_kv_ttl
          • enable_lake_table_parallel_resolving
          • enable_lock_priority
          • enable_manual_storage_cache_policy
          • enable_mlog_auto_maintenance
          • enable_monotonic_weak_read
          • enable_mv_binlog_minimal_mode
          • enable_ls_leader_balance
          • enable_rebalance
          • enable_sql_extension
          • enable_transfer
          • enable_ttl
          • enable_user_defined_rewrite_rules
          • enable_window_compaction
          • enable_ps_parameterize
          • external_kms_info
          • external_table_io_hole_size
          • external_table_io_range_size
          • external_table_csv_max_buffer_size
          • ob_vector_search_strategy
          • freeze_trigger_percentage
          • global_index_auto_split_policy
          • ha_high_thread_score
          • ha_low_thread_score
          • ha_mid_thread_score
          • inc_sstable_upload_thread_score
          • shared_gc_executor_thread_score
          • shared_gc_generator_thread_score
          • json_document_max_depth
          • kv_ttl_duty_duration
          • kv_group_commit_batch_size
          • kv_group_commit_rw_mode
          • kv_hbase_client_scanner_timeout_period
          • kv_ttl_delete_max_ops
          • kv_ttl_history_recycle_interval
          • kv_transport_compress_threshold
          • lake_table_pruning_thread_count
          • load_data_diagnosis_log_compression
          • load_data_diagnosis_log_max_size
          • load_vector_index_on_follower
          • lob_enable_block_cache_threshold
          • log_archive_concurrency
          • log_disk_throttling_maximum_duration
          • log_disk_throttling_percentage
          • log_disk_utilization_limit_threshold
          • log_disk_utilization_threshold
          • log_restore_concurrency
          • log_storage_compress_all
          • log_storage_compress_func
          • log_transport_compress_all
          • log_transport_compress_func
          • ls_gc_delay_time
          • ls_scale_out_factor
          • major_compact_trigger
          • major_freeze_duty_time
          • max_partition_num
          • max_stale_time_for_weak_consistency
          • mds_compaction_high_thread_score
          • mds_compaction_mid_thread_score
          • mds_minor_compact_trigger
          • merger_check_interval
          • minor_compact_trigger
          • mlog_trim_interval
          • model_max_retries
          • model_request_timeout
          • mv_refresh_concurrency
          • ob_compaction_schedule_interval
          • ob_enable_batched_multi_statement
          • ob_encoding_granularity
          • ob_enable_java_udf
          • ob_enable_python_udf
          • ob_proxy_readonly_transaction_routing_policy
          • ob_query_switch_leader_retry_timeout
          • ob_ssl_invited_common_names
          • ob_vector_index_active_segment_max_size
          • ob_vector_index_merge_trigger_percentage
          • ob_vector_memory_limit_percentage
          • open_cursors
          • optimizer_index_cost_adj
          • partition_balance_schedule_interval
          • plsql_code_type
          • plsql_debug
          • px_node_policy
          • package_state_sync_max_size
          • px_target_high_watermark
          • px_target_low_watermark
          • px_target_workers_per_cpu
          • px_workers_per_cpu_quota
          • query_memory_limit_percentage
          • query_response_time_flush
          • query_response_time_range_base
          • query_response_time_stats
          • range_optimizer_max_mem_size
          • recover_table_concurrency
          • recover_table_dop
          • replica_parallel_migration_mode
          • result_cache_max_size
          • result_cache_max_result
          • ob_result_cache_evict_percentage
          • ob_deterministic_udf_cache_max_size
          • rpc_memory_limit_percentage
          • shared_log_retention
          • shared_storage_data_check_thread_score
          • spill_compression_codec
          • sql_func_extension_mode
          • sql_work_area
          • standby_db_fetch_log_rpc_timeout
          • standby_db_preferred_upstream_log_region
          • storage_rowsets_size
          • sts_credential
          • suspend_storage_cache_task
          • kv_transport_compress_func
          • tde_method
          • tenant_sql_login_thread_count
          • tenant_sql_net_thread_count
          • temporary_file_max_disk_size
          • ttl_duty_time
          • ttl_thread_score
          • undo_retention
          • vector_index_memory_saving_mode
          • vector_index_optimization_concurrency
          • vector_index_optimize_duty_time
          • vector_task_thread_limit_percent
          • workarea_size_policy
          • writing_throttling_maximum_duration
          • writing_throttling_trigger_percentage
          • zone_deploy_mode
      • System variables
        • Overview of system variables
        • Global variables
          • ap_query_cost_threshold
          • ap_query_route_policy
          • ap_query_replica_fallback
          • activate_all_roles_on_login
          • auto_increment_cache_size
          • auto_increment_increment
          • auto_increment_offset
          • autocommit
          • automatic_sp_privileges
          • binlog_row_image
          • block_encryption_mode
          • character_set_client
          • character_set_connection
          • cardinality_estimation_model
          • character_set_database
          • character_set_filesystem
          • character_set_results
          • character_set_server
          • character_set_system
          • collation_connection
          • collation_database
          • collation_server
          • connect_timeout
          • cte_max_recursion_depth
          • cursor_sharing
          • datadir
          • default_authentication_plugin
          • default_password_lifetime
          • default_storage_engine
          • div_precision_increment
          • error_on_overlap_time
          • event_scheduler
          • explicit_defaults_for_timestamp
          • enable_optimizer_rowgoal
          • foreign_key_checks
          • group_concat_max_len
          • init_connect
          • innodb_stats_persistent
          • innodb_strict_mode
          • interactive_timeout
          • license
          • lc_time_names
          • log_row_value_options
          • long_query_time
          • lower_case_table_names
          • max_allowed_packet
          • max_connections
          • max_sp_recursion_depth
          • max_user_connections
          • mview_refresh_dop
          • net_buffer_length
          • net_read_timeout
          • net_write_timeout
          • ob_bnl_join_cache_size
          • ob_compatibility_mode
          • ob_compatibility_control
          • ob_compatibility_version
          • ob_default_lob_inrow_threshold
          • ob_early_lock_release
          • ob_enable_ps_parameter_anonymous_block
          • ob_enable_pl_async_commit
          • ob_enable_aggregation_pushdown
          • ob_enable_index_direct_select
          • ob_enable_jit
          • ob_enable_pl_cache
          • ob_enable_plan_cache
          • ob_enable_rich_error_msg
          • ob_enable_sql_audit
          • ob_enable_transformation
          • ob_enable_transmission_checksum
          • ob_enable_truncate_flashback
          • ob_log_level
          • ob_max_read_stale_time
          • ob_pl_block_timeout
          • ob_plan_cache_evict_high_percentage
          • ob_plan_cache_evict_low_percentage
          • ob_plan_cache_percentage
          • ob_query_timeout
          • ob_read_consistency
          • ob_reserved_meta_memory_percentage
          • ob_route_policy
          • ob_sql_audit_percentage
          • ob_sql_work_area_percentage
          • ob_table_access_policy
          • ob_tcp_invited_nodes
          • ob_temp_tablespace_size_percentage
          • ob_trx_idle_timeout
          • ob_trx_lock_timeout
          • ob_trx_timeout
          • optimizer_capture_sql_plan_baselines
          • ob_security_version
          • optimizer_dynamic_sampling
          • optimizer_features_enable
          • optimizer_use_sql_plan_baselines
          • parallel_degree_limit
          • parallel_degree_policy
          • parallel_min_scan_time_threshold
          • parallel_servers_target
          • partition_index_dive_limit
          • performance_schema
          • plugin_dir
          • pid_file
          • query_cache_size
          • plsql_optimize_level
          • plsql_can_transform_sql_to_assign
          • port
          • query_cache_type
          • query_rewrite_enabled
          • query_rewrite_integrity
          • read_only
          • recyclebin
          • regexp_stack_limit
          • regexp_time_limit
          • resource_manager_plan
          • socket
          • range_index_dive_limit
          • runtime_bloom_filter_max_size
          • runtime_filter_max_in_num
          • runtime_filter_type
          • runtime_filter_wait_time_ms
          • secure_file_priv
          • server_uuid
          • sql_auto_is_null
          • sql_mode
          • sql_quote_show_create
          • sql_safe_updates
          • sql_select_limit
          • sql_throttle_current_priority
          • sql_throttle_network
          • sql_throttle_priority
          • sql_throttle_rt
          • sql_transpiler
          • sql_warnings
          • system_time_zone
          • time_zone
          • transaction_isolation
          • transaction_read_only
          • tx_isolation
          • tx_read_only
          • validate_password_check_user_name
          • validate_password_length
          • validate_password_mixed_case_count
          • validate_password_number_count
          • validate_password_policy
          • validate_password_special_char_count
          • version
          • version_comment
          • wait_timeout
        • Session variables
          • enable_sql_plan_monitor
          • is_result_accurate
          • identity
          • last_insert_id
          • ob_capability_flag
          • ob_enable_show_trace
          • ob_global_debug_sync
          • ob_hnsw_ef_search
          • ob_ivf_nprobes
          • ob_last_schema_version
          • ob_org_cluster_id
          • ob_proxy_global_variables_version
          • ob_sparse_drop_ratio_search
          • ob_proxy_partition_hit
          • ob_proxy_set_trx_executed
          • ob_trace_info
          • partition_index_dive_limit
          • range_index_dive_limit
          • timestamp
          • tracefile_identifier
    • Error codes
      • Overview of error messages
      • 0001 ~ 3999
      • 4000 ~ 4499
      • 4500 ~ 4999
      • 5000 ~ 5999
      • 6000 ~ 6999
      • 7000 ~ 7999
      • 8000 ~ 8999
      • 9000 ~ 9499
      • 9500 ~ 9999
      • 10000 ~ 12000
      • 22998, 30926, 38104, 38105
    • LogService reference
      • LogService commands
        • Overview of LS-CTRL
        • LS-CTRL commands
          • bootstrap
          • show az
          • show ln
          • show meta
          • show ap
          • show parameter
          • show v-table
          • add ln
          • delete ln
          • set param
          • check
          • upgrade
          • fetch
          • migrate replica
          • rotate-ak
          • param-version-status
      • LogService parameters
        • Overview of Log Service parameters
        • Cluster parameters
          • min_oblogservice_version
          • node_permanent_offline_time_sec
          • stream_replica_task_history_retention_sec
          • object_store_url
          • log_local_target_retention_sec
          • retained_remote_log_blocks
          • log_local_disk_utilization_threshold
          • max_syslog_file_count
          • enable_rebalance
          • load_balance_policy
          • rebalance_interval_sec
          • metric_sample_save_interval_sec
          • max_utilization_threshold
          • min_utilization_threshold
          • log_disk_throttling_percentage
          • log_disk_throttling_maximum_duration
          • rebuild_log_lag_threshold
        • Server parameters
          • cluster_id
          • region
          • az
          • local_ip
          • rpc_port
          • log_disk_size
          • io_worker_count
          • http_port
          • status_thread_pool_size
          • stack_size
          • net_thread_count
          • enable_heap_profile
          • log_disk_percentage
          • memory_limit
          • log_level
          • max_syslog_file_size
          • disk_max_iops
          • disk_max_bandwidth
          • upload_block_concurrency
          • log_cache_memory_percentage
          • log_cache_evict_scan_budget
          • log_cache_enable_write
          • log_cache_enable_read
          • log_cache_metrics_dump_interval_sec
          • ln_id
          • local_storage_dir
      • LogService views
        • Overview of LogService views
        • List of LogService views
        • Virtual views
          • node_load
          • az_load
          • stream_replica_io
        • Internal tables
          • t_stream_upload_mapping
          • t_resource_event
    • OBKV
      • OBKV overview
      • OBKV architecture
      • OBKV-Table
        • OBKV-Table overview
          • OBKV-Table overview
          • Core features of OBKV-Table
          • OBKV-Table deployment overview
        • Quick start with simple key-value storage (Java)
        • Use the OBKV-Table client
          • Java development guide for OBKV-Table
          • Prepare for development with OBKV-Table
          • Connect to a cluster by using the OBKV-Table Java client
          • OBKV-Table examples
            • Write data to OBKV-Table
            • Query data in OBKV-Table
            • Update data in OBKV-Table
            • Delete data from OBKV-Table
          • Set parameters for the OBKV-Table Java client
        • OBKV-Table management
          • OBKV-Table management overview
          • High availability of OBKV-Table
          • Security permissions of OBKV-Table
          • OBKV-Table monitoring metrics
        • OBKV-Table reference
          • Data model of OBKV-Table
          • OBKV-Table operations
          • Data types supported by OBKV-Table
          • Full-text indexes in OBKV-Table
          • Scope of use and examples of global indexes in OBKV-Table
          • Delete expired data from OBKV-Table
          • Group commit in OBKV-Table
          • Weak-consistency reads and near reads in OBKV-Table
          • OBKV-Table related views
        • OBKV-Table FAQ
      • OBKV-HBase
        • Overview of OBKV-HBase
        • Core features of OBKV-HBase
        • OBKV-HBase deployment
        • OBKV-HBase development
          • Overview of OBKV-HBase application development
          • Connect to a cluster by using the OBKV-HBase Java client
          • Migrate HBase business code to OBKV-HBase
          • Data operation examples
        • OBKV-HBase migration guide
        • OBKV-HBase management
          • Overview of OBKV-HBase management
          • High availability of OBKV-HBase
          • Security and permissions in OBKV-HBase
          • OBKV-HBase monitoring metrics
        • Query optimization in OBKV-HBase
        • Performance testing of OBKV-HBase
        • OBKV-HBase reference
          • OBKV-HBase data model
          • OBKV-HBase data model
          • HBase-compatible interfaces
          • HBase-compatible filters
          • Automatic partition splitting in OBKV-HBase
          • Delete expired data in OBKV-HBase
          • OBKV-HBase weak-consistency reads and near reads
          • OBKV-HBase views
        • OBKV-HBase integrations
          • Flink integration
            • Synchronize data to OBKV-HBase by using the Flink connector
            • Access OBKV-HBase by using native Flink
          • Access OBKV-HBase by using Hive
          • Access OBKV-HBase by using Spark
    • Performance tuning
      • Overview
      • Performance related tools
        • System tools
          • Top general purpose tool
          • CPU tools
          • Memory tools
          • Disk I/O tools
          • Network tools
        • Internal tables
          • GV$SYSSTAT
          • GV$OB_SQL_AUDIT
          • GV$OB_TRANSACTION_PARTICIPANTS
        • Logs
          • slow trans
          • tenant dump info
          • trace log
        • OCP
      • System tuning
        • Operating system parameter tuning
        • Database parameter tuning
          • CPU parameters
          • I/O parameters
          • Memory-related parameters
          • Network transmission parameters
        • ODP parameter tuning
          • CPU-related parameters
          • Network transmission parameters
          • Node routing parameters
      • Performance diagnosis
        • Monitor and diagnose cluster performance
        • Diagnose tenant performance
        • Monitor OBProxy performance
        • Monitor host performance
        • WR management
          • Overview of WR
          • Manage WR
          • Monitor historical session performance
          • Clean up WR data
        • Diagnostic practice: Use TRACE_ID to diagnose materialized view refresh performance issues
        • ASH report
          • Introduction to ASH
          • Generate an ASH report
          • Analyze an ASH report
          • ASH best practices
      • Business model tuning
        • Load balancing
        • SQL diagnostics
        • Distributed transactions
      • SQL tuning
        • SQL request execution process
        • SQL execution plans
          • Introduction to SQL execution plans
          • Execution plan operators
            • TABLE SCAN
            • JOIN
            • GROUP BY
            • WINDOW FUNCTION
            • SUBPLAN FILTER
            • DISTINCT
            • SEQUENCE
            • MATERIAL
            • SORT
            • LIMIT
            • FOR UPDATE
            • SELECT INTO
            • SUBPLAN SCAN
            • UNION
            • INTERSECT
            • EXCEPT/MINUS
            • INSERT
            • DELETE
            • UPDATE
            • EXCHANGE
            • GI
          • Plan cache
          • Fast parameterization
          • Real-time execution plan display
          • SQL optimization practice with EXPLAIN
        • Distributed execution plans
          • Distributed execution and parallel query
          • Distributed plan generation
          • Distributed execution plan scheduling
          • Distributed execution plan management
          • Parallel execution enabling methods and their priority
          • Auto DOP
          • Execution of parallel queries
          • Perform parameter tuning for a parallel query
          • Parallel DML
          • Parallel DDL
        • Parallel execution plans
          • Introduction to parallel execution
          • Classification and optimization of parallel execution
          • Set concurrent execution
            • Concurrency control and queuing
            • Set the degree of parallelism for parallel execution
            • Set parallel execution parameters
          • Diagnose parallel execution issues
          • Tips for parallel execution tuning
          • Quick start of parallel execution
        • SQL tuning
          • Overview of SQL tuning
          • Basic SQL tuning process
          • SQL execution performance monitoring
            • GV$OB_SQL_AUDIT
            • SQL Trace
            • Plan cache views
            • SQL performance analysis example
              • Analyze wait events in queries by using SQL Audit
              • Analyze SQL queries that cause an abrupt RT jitter
              • View and analyze the shape of an execution plan
              • Analyze slow SQL queries
              • Query SQL traffic distribution and QPS
              • Check whether SQL queries are balanced across servers in a cluster
              • Find the TOP N SQL queries
              • Analyze whether an unusually large number of remote execution requests exist in the system or the execution of an SQL statement
              • Find full table scan SQL statements in a tenant
              • Find the TOP N queries with the longest execution time within a certain period
              • Analyze queries related to distributed plans
              • Check whether the RPC execution count of a distributed subplan is balanced across servers in a cluster
          • Optimizer statistics
            • Overview of statistics
            • Statistics collection methods
              • Overview of statistics collection methods
              • Introduction to histograms
              • Collect statistics manually
              • Automatic statistics collection
              • Online statistics collection
              • Dynamic sampling by the optimizer
            • Statistics management
              • Overview of statistics management
              • Delete statistics
              • Set statistics
              • Import and export statistics
              • Lock and unlock statistics
              • Manage statistics history
              • Manage statistics collection strategies (Prefs)
            • Partitioned table statistics collection and update strategy
            • Monitoring and diagnostics for statistics collection
            • Comprehensive example
          • Query rewrite
            • Overview
            • Rule-based query rewriting
            • Cost-based query rewriting
          • Query optimization
            • Access path
              • Overview
              • Rule-based path selection
              • Cost-based path selection
            • Join algorithm
              • Overview
              • Join algorithms
              • Runtime filter
              • Join order
          • Manage execution plans
            • Optimizer hint
            • Plan binding
            • Execution plan management
        • Related terms
        • FAQ on SQL tuning
    • Database proxy
      • Database connection and routing overview
      • OceanBase Database Proxy (ODP)
      • ODP
        • ODP management overview
        • Manage ODP clusters
          • Create an OBProxy cluster
          • Manage parameters of an OBProxy cluster
          • Delete an OBProxy cluster
          • Upgrade all OBProxies in an OBProxy cluster
          • Restart all OBProxies in an OBProxy cluster
          • Manage OceanBase AI Database clusters connected to OBProxy
          • Monitor the performance of an OBProxy cluster
        • Manage ODP
          • Add an OBProxy
          • Start OBProxy
          • Refresh OBProxy configuration
          • Stop OBProxy
          • Restart OBProxy
          • Delete an OBProxy
          • Upgrade OBProxy
        • OBProxy parameters
      • Physical connections
      • Logical connection
        • Query all sessions
        • Query the details of a session
        • Query the statistics of a session
        • Query session variables
        • Terminate a server session
      • Route management
        • Table-based routing of ODP
        • LDC-based routing
        • ODP routing policy
          • Read/write splitting
          • Follower-first read
          • Blocklist mechanism
          • Transaction routing
      • View tenant sessions
      • Terminate a tenant session
      • Set the maximum number of connections for a tenant
    • Drivers
      • OceanBase Call Interface (OBCI)
      • OceanBase Connector/J
      • OceanBase Connector/C
      • OceanBase Connector/ODBC
    • Platforms
      • OceanBase Migration Assessment (OMA)
      • OceanBase Migration Service (OMS)
      • OceanBase Cloud Platform (OCP)
      • OceanBase Developer Center (ODC)
      • OceanBase Admin Toolkit (OAT)
    • Components & tools
      • ob_error
      • Data integration
        • obloader/obdumper
        • OceanBase Binlog Service
        • obcdc
          • Overview of obcdc
          • obcdc parameters
            • Sample configuration file
            • Common obcdc parameters
            • obcdc parameters
          • obcdc development instructions
          • obcdc_tailf
          • Throttling
          • obcdc allowlist and blocklist
          • obcdc supports incremental direct load
          • obcdc supports synchronizing from a standby database
          • Data dictionary support in obcdc
          • FAQ
    • OceanBase AI Database plugins
      • Overview of OceanBase AI Database plugins
      • Tokenizer plugin
      • MySQL external table plugin
  • Release Notes
    • Version number guidelines
    • OceanBase AI Database V4.6.3
    • OceanBase AI Database V4.6.2

Download PDF

Document Feedback
  1. Documentation Center
  2. OceanBase AI Database
  3. V4.6.3

0001 ~ 3999

Last Updated:2026-11-16 14:00:05

ERROR 1007 (HY000) : Can't create database '%s'; database exists
ERROR 1008 (HY000) : Can't drop database '%.*s'; database doesn't exist
ERROR 1017 (HY000) : File not exist
ERROR 1018 (HY000) : Directory not exist
ERROR 1022 (23000) : Can't write; duplicate key in table \'%.*s\'
ERROR 1025 (HY000) : ## ERROR on rename of \'%s.%s\' to \'%s.%s\'
ERROR 1040 (08004) : Too many connections
ERROR 1041 (53000) : Out of resource
ERROR 1044 (42000) : Access denied for user '%.*s'@'%.*s' to database '%.*s'
ERROR 1045 (42000) : Access denied for user '%.*s'@'%.*s' (using password: %s)
ERROR 1046 (3D000) : No database selected
ERROR 1047 (HY001) : Unknown packet
ERROR 1048 (23000) : Column '%.*s' cannot be null
ERROR 1049 (42000) : Unknown database '%.*s'
ERROR 1050 (42S01) : Table '%.*s' already exists
ERROR 1051 (42S02) : Unknown table '%.*s'
ERROR 1052 (23000) : Column '%.*s' in %.*s is ambiguous
ERROR 1054 (42S22) : Unknown column '%.*s' in '%.*s'
ERROR 1055 (42000) : \'%.*s\' is not in GROUP BY
ERROR 1056 (42000) : Can't group on '%.*s'
ERROR 1059 (42000) : Identifier name \'%.*s\' is too long
ERROR 1060 (42S21) : Duplicate column group name '%.*s'
ERROR 1061 (42000) : Duplicate key name \'%.*s\'
ERROR 1062 (23000) : Duplicate entry \'%s\' for key \'%.*s\'
ERROR 1063 (42000) : Incorrect column specifier for column '%.*s'
ERROR 1064 (0B000) : Failed to init SQL parser
ERROR 1064 (42000) : Parse error", "%s near \'%.*s\' at line %d
ERROR 1064 (42000) : Wrong number of partitions defined, mismatch with previous setting
ERROR 1065 (42000) : Query was empty
ERROR 1066 (42000) : Not unique table/alias: \'%.*s\'
ERROR 1067 (42000) : Invalid default value for \'%.*s\'
ERROR 1068 (42000) : Multiple primary key defined
ERROR 1069 (42000) : Too many keys specified; max %ld keys allowed
ERROR 1070 (42000) : Too many key parts specified; max %ld parts allowed
ERROR 1071 (42000) : Specified key was too long; max key length is %ld bytes
ERROR 1072 (42000) : Key column '%.*s' doesn't exist in table
ERROR 1074 (42000) : Column length too big for column '%s' (max = %d)
ERROR 1074 (42000) : Column length too big for column '%.*s' (max = %d); use BLOB or TEXT instead
ERROR 1075 (42000) : Incorrect table definition; there can be only one auto column
ERROR 1078 (01000) : (string):%s: Got signal %d. Aborting
ERROR 1082 (42S12) : Illegal index
ERROR 1082 (42000) : Index unavailable
ERROR 1083 (42000) : Field separator argument is not what is expected; check the manual
ERROR 1083 (HY000) : Non-ASCII separator arguments are not fully supported
ERROR 1083 (HY000) : First character of the FIELDS TERMINATED string is ambiguous; please use non-optional and non-empty FIELDS ENCLOSED BY
ERROR 1086 (58000) : File already exist
ERROR 1089 (HY000) : Incorrect prefix key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique prefix keys
ERROR 1090 (42000) : You can't delete all columns with ALTER TABLE; use DROP TABLE instead
ERROR 1091 (42000) : Can't DROP '%.*s'; check that column/key exists
ERROR 1093 (HY000) : You can\'t specify target table \'%s\' for update in FROM clause
ERROR 1094 (HY000) : Unknown thread id: %lu
ERROR 1095 (HY000) : You are not owner of thread %lu
ERROR 1096 (HY000) : No tables used
ERROR 1097 (HY000) : Too many strings for column %.*s and SET
ERROR 1101 (42000) : BLOB, TEXT, GEOMETRY or JSON column '%.*s' can't have a default value
ERROR 1102 (42000) : Incorrect database name '%.*s'
ERROR 1103 (42000) : Incorrect table name '%.*s'
ERROR 1105 (42000) : invalid xpath expression
ERROR 1105 (42000) : Given XPATH expression not supported
ERROR 1108 (HY000) : Incorrect parameters to procedure '%.*s'
ERROR 1109 (42S02) : Unknown table '%.*s' in %.*s
ERROR 1110 (42000) : Column \'%s\' specified twice
ERROR 1111 (HY000) : Invalid use of group function
ERROR 1113 (42000) : A table must have at least 1 column
ERROR 1115 (42000) : Unknown character set: '%.*s'
ERROR 1117 (42000) : Too many columns
ERROR 1118 (42000) : Row size too large
ERROR 1122 (HY000) : Can not load function %s
ERROR 1123 (HY000) : Can not initialize function '%.*s'
ERROR 1124 (HY000) : No paths allowed for shared library
ERROR 1125 (HY000) : Function %.*s already exists
ERROR 1126 (HY000) : Can not open shared library '%.*s'
ERROR 1127 (HY000) : Can't find symbol %.*s in library
ERROR 1028 (HY000) : Function %.*s is not defined
ERROR 1133 (42000) : Can not find any matching row in the user table'%.*s'
ERROR 1133 (42000) : Incorrect password
ERROR 1136 (21S01) : column count does not match value count at row '%d'
ERROR 1136 (21S01) : Column count doesn\'t match value count at row %ld
ERROR 1138 (22004) : Invalid use of NULL value
ERROR 1139 (42000) : Got error '%s' from regexp
ERROR 1140 (42000) : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
ERROR 1141 (HY000) : There is no such grant defined for user '%.*s' on host '%.*s'
ERROR 1142 (42000) : %.*s command denied to user '%.*s'@'%.*s' for table '%.*s'
ERROR 1144 (42000) : Illegal GRANT/REVOKE command; please consult the manual to see which privileges can be used
ERROR 1146 (42S02) : Table \'%s.%s\' doesn\'t exist
ERROR 1149 (42000) : You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use
ERROR 1153 (08S01) : Got a packet bigger than \'max_allowed_packet\' bytes"
ERROR 1166 (42000) : Incorrect column name '%.*s'
ERROR 1167 (42000) : The used storage engine can't index column '%.*s'
ERROR 1171 (42000) : Insert null into %.*s
ERROR 1171 (42000) : All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
ERROR 1172 (42000) : Result consisted of more than one row
ERROR 1173 (42000) : Primary key columns) not specified in the WHERE clause
ERROR 1175 (HY000) : You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
ERROR 1176 (42000) : Key '%.*s' doesn't exist in table '%.*s'
ERROR 1192 (HY000) : Can't execute the given command because you have active locked tables or an active transaction
ERROR 1193 (HY000) : Unknown system variable '%.*s'
ERROR 1203 (42000) : Too many sessions
ERROR 1205 (HY000) : Lock wait timeout exceeded; try restarting transaction
ERROR 1205 (HY000) : Lock wait timeout exceeded; try restarting transaction
ERROR 1210 (HY000) : Incorrect arguments to %s
ERROR 1210 (HY000) : Miss argument for %s
ERROR 1210 (HY000) : Miss argument for %s
ERROR 1213 (HY000) : Deadlock
ERROR 1215 (HY000) : Cannot add foreign key constraint
ERROR 1221 (HY000) : Incorrect usage of DB GRANT and GLOBAL PRIVILEGES
ERROR 1221 (HY000) : Incorrect usage of UNION and INTO
ERROR 1222 (21000) : The used SELECT statements have a different number of columns
ERROR 1225 (HY000) : Option '%s' used twice in statement
ERROR 1226 (42000) : User '%.*s' has exceeded the '%s' resource (current value: %lu)
ERROR 1227 (42501) : Access denied; you need (at least one of) the %s privilege(s) for this operation
ERROR 1228 (HY000) : Variable \'%.*s\' is a SESSION variable and can't be used with SET GLOBAL
ERROR 1229 (HY000) : Variable \'%.*s\' is a GLOBAL variable and should be set with SET GLOBAL
ERROR 1230 (42000) : Variable '%.*s' doesn't have a default value
ERROR 1231 (42000) : Variable \'%.*s\' can't be set to the value of \'%.*s\'
ERROR 1232 (42000) : Incorrect argument type to variable '%.*s'
ERROR 1234 (42000) : Incorrect usage/placement of '%s'
ERROR 1235 (0A000) : %s not supported
ERROR 1235 (42000) : This version of MySQL doesn't yet support 'non-string DEFAULT value for a column in a JSON_TABLE expression'
ERROR 1235 (42000) : This version doesn't yet support 'references in JSON Schema.
ERROR 1235 (42000) : This version of OceanBase doesn't yet support 'multiple triggers with the same action time and event for one table'
ERROR 1238 (HY000) : Variable '%.*s' is a %.*s variable
ERROR 1239 (42000) : Incorrect foreign key definition: Key reference and table reference don't match
ERROR 1241 (21000) : Operand should contain %ld column(s)
ERROR 1243 (HY007) : statement not prepared, stmt_id=%u
ERROR 1242 (21000) : Subquery returns more than 1 row
ERROR 1243 (HY000) : Unknown prepared statement handle
ERROR 1247 (42S22) : Reference '%.*s' not supported (reference to group function)
ERROR 1250 (42000) : Table \'%.*s\' from one of the SELECTs cannot be used in global ORDER clause
ERROR 1252 (7280) : All parts of a SPATIAL index must be NOT NULL.
ERROR 1253 (42000) : COLLATION '%.*s' is not valid for CHARACTER SET '%.*s'
ERROR 1259 (HY000) : ZLIB: Input data corrupted
ERROR 1260 (42000) : Row %ld was cut by GROUP_CONCAT()
ERROR 1261 (1000) : Row %ld doesn't contain data for all columns
ERROR 1262 (1000) : Row %ld was truncated; it contained more data than there were input columns
ERROR 1264 (22003) : Out of range value for column '%.*s' at row %ld
ERROR 1264 (22003) : value larger than specified precision(%ld,%ld) allowed for this column
ERROR 1264 (22003) : value(%s) larger than specified precision(%ld,%ld) allowed for this column
ERROR 1264 (22003) : Result value was out of range when casting varchar to number
ERROR 1264 (22003) : Out of range value for column '%.*s' at row %ld
ERROR 1265 (01000) : Data truncated for column '%.*s' at row %ld
ERROR 1265 (01000) : Timeout value truncated to 102 years
ERROR 1267 (HY000) : Illegal mix of collations (%s,%s), (%s,%s)
ERROR 1273 (HY000) : Unknown collation: '%.*s'
ERROR 1280 (42000) : Incorrect index name '%.*s'
ERROR 1283 (HY000) : Column '%.*s' cannot be part of FULLTEXT index
ERROR 1283 (42000) : A FTS index may only contain a text type column.
ERROR 1286 (42000) : Unknown storage engine \'%.*s\'
ERROR 1287 (HY000) : %s is deprecated and will be removed in a future release. Please use '%s' instead
ERROR 1288 (HY000) : The target table %.*s of the %.*s is not updatable
ERROR 1290 (HY000) : The MySQL server is running with the --read-only option so it cannot execute this statement
ERROR 1291 (HY000) : Column '%.*s' has duplicated value '%.*s' in %s
ERROR 1292 (22007) : %s=%d must between %d and %d
ERROR 1292 (22007) : Incorrect value
ERROR 1292 (01000) : Truncated incorrect DOUBLE value: '%.*s'
ERROR 1292 (22007) : Incorrect datetime value: '%.*s' for column '%s'
ERROR 1292 (22007) : Truncated incorrect %.*s value: '%.*s'
ERROR 1294 (HY000) : Invalid ON UPDATE clause for \'%s\' column
ERROR 1295 (HY000) : This command is not supported in the prepared statement protocol yet
ERROR 1298 (HY000) : Unknown or incorrect time zone: \'%.*s\'
ERROR 1300 (HY000) : Invalid %.*s character string: \'%.*s\'
ERROR 1301 (HY000) : Result of %s() was larger than max_allowed_packet (%d) truncated
ERROR 1302 (42000) : Conflicting declarations: '%s' and '%s'
ERROR 1303 (2F003) : Cant create a routine from within another routine
ERROR 1304 (42000) : %s %.*s already exists
ERROR 1305 (42000) : %s %.*s does not exist
ERROR 1305 (42000) : %s %.*s.%.*s does not exist
ERROR 1305 (42000) : savepoint does not exist
ERROR 1308 (42000) : no matching label: %.*s
ERROR 1308 (42000) : %s with no matching label: %s
ERROR 1309 (42000) : Redefining label '%.*s'
ERROR 1313 (42000) : RETURN is only allowed in a FUNCTION
ERROR 1314 (HY000) : '%.*s' is not allowed in stored procedure
ERROR 1317 (70100) : Query execution was interrupted
ERROR 1318 (42000) : Incorrect number of arguments for %s %s; expected %u, got %u
ERROR 1319 (42000) : Undefined CONDITION: %.*s
ERROR 1320 (42000) : No Return found in FUNCTION '%.*s'
ERROR 1321 (2F005) : FUNCTION %s ended without RETURN
ERROR 1323 (42000) : Cursor SELECT must not have INTO
ERROR 1324 (42000) : Undefined CURSOR: %.*s
ERROR 1325 (24000) : Cursor is already open
ERROR 1326 (24000) : Cursor is not open
ERROR 1327 (42000) : Undeclared variable: %.*s
ERROR 1327 (42000) : Undeclared type: %.*s
ERROR 1328 (HY000) : Incorrect number of FETCH variables
ERROR 1329 (02000) : No data - zero rows fetched, selected, or processed
ERROR 1330 (42000) : Duplicate parameter: %.*s
ERROR 1330 (42000) : Duplicate type: %.*s
ERROR 1330 (42000) : Duplicate label: %.*s
ERROR 1331 (42000) : Duplicate variable: %.*s
ERROR 1332 (42000) : Duplicate condition: %.*s
ERROR 1333 (42000) : Duplicate cursor: %.*s
ERROR 1336 (0A000) : %s is not allowed in stored function or trigger
ERROR 1337 (42000) : Variable or condition declaration after cursor or handler declaration
ERROR 1338 (42000) : Cursor declaration after handler declaration
ERROR 1339 (20000) : Case not found for CASE statement
ERROR 1347 (HY000) : \'%s.%s\' is not %s
ERROR 1348 (HY000) : Column '%.*s' is not updatable
ERROR 1349 (HY000) : View's SELECT contains a subquery in the FROM clause
ERROR 1350 (HY000) : View's SELECT contains a 'INTO' clause.
ERROR 1353 (HY000) : View's SELECT and view's field list have different column counts
ERROR 1356 (42S22) : View \'%.*s.%.*s\' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
ERROR 1360 (HY000) : Trigger does not exist
ERROR 1362 (HY000) : Updating of %s row is not allowed in %s trigger
ERROR 1363 (HY000) : There is no %s row in on %s trigger
ERROR 1364 (HY000) : Field \'%s\' doesn't have a default value
ERROR 1365 (22012) : Divided by zero
ERROR 1366 (22007) : Incorrect datetime value: '%s' for column '%s'
ERROR 1366 (HY000) : Incorrect integer value for column '%.*s' at row %ld
ERROR 1366 (HY000) : Incorrect string value for column '%.*s' at row %ld
ERROR 1367 (22007) : Illegal %s '%.*s' value found during parsing
ERROR 1368 (HY000) : CHECK OPTION on non-updatable view '%.*s.%.*s'
ERROR 1369 (HY000) : CHECK OPTION failed '%.*s.%.*s'
ERROR 1370 (42000) : %.*s command denied to user '%.*s'@'%.*s' for routine '%.*s'
ERROR 1382 (HY000) : The '%.*s' syntax is reserved for purposes internal to the OceanBase Server
ERROR 1390 (54000) : Prepared statement contains too many placeholders
ERROR 1391 (HY000) : Key part \'%.*s\' length cannot be 0
ERROR 1393 (HY000) : Can not modify more than one base table through a join view '%.*s.%.*s'
ERROR 1395 (HY000) : Can not delete from join view '%.*s.%.*s'
ERROR 1396 (HY000) : Operation %.*s failed for %.*s
ERROR 1397 (XAE04) : Unknown XID
ERROR 1398 (XAE05) : XAER_INVAL: Invalid arguments (or unsupported command)
ERROR 1399 (XAE07) : The command cannot be executed when global transaction is in the %s state
ERROR 1399 (XAE07) : RMFAIL: The command cannot be executed when global transaction is in the %s state
ERROR 1400 (XAE09) : Some work is done outside global transaction
ERROR 1401 (XAE03) : XAER_RMERR: Fatal error occurred in the transaction branch - check your data for consistency
ERROR 1402 (XA100) : XA_RBROLLBACK: Transaction branch was rolled back
ERROR 1406 (22001) : Data too long for column '%.*s' at row %ld
ERROR 1406 (22001) : Data too long for column
ERROR 1407 (42000) : Bad SQLSTATE: \'%.*s\'
ERROR 1410 (42000) : You are not allowed to create a user with GRANT
ERROR 1411 (HY000) : Incorrect %.*s value: '%.*s' for function %.*s
ERROR 1411 (HY000) : Incorrect string value for function %s
ERROR 1413 (42000) : Duplicate handler declared in the same block
ERROR 1414 (42000) : OUT or INOUT argument %d for routine %.*s is not a variable
ERROR 1415 (0A000) : Not allowed to return a result set from a %s
ERROR 1416 (22003) : Cannot get geometry object from data you send to the GEOMETRY field.
ERROR 1422 (HY000) : Explicit or implicit commit is not allowed in stored function or trigger
ERROR 1422 (HY000) : '%.*s' is not allowed in stored function or trigger
ERROR 1424 (HY000) : Recursive stored functions are not allowed
ERROR 1425 (42000) : Too big scale %d specified for column '%s'. Maximum is %ld
ERROR 1426 (42000) : Too big precision %d specified for column '%s'. Maximum is %ld
ERROR 1427 (42000) : For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column '%s')
ERROR 1435 (HY000) : Trigger in wrong schema
ERROR 1439 (42000) : Display width out of range for column '%s' (max = %ld)
ERROR 1439 (42000) : Display width out of range for column '%.*s' (max = %d)
ERROR 1440 (XAE08) : The XID already exists
ERROR 1441 (22008) : Datetime overflow
ERROR 1442 (HY000) : Can't update table \'%s\' in stored function/trigger because it is already used by statement which invoked this stored function/trigger
ERROR 1444 (HY000) : The prepared statement contains a stored routine call that refers to that same statement. It's not allowed to execute a prepared statement in such a recursive manner
ERROR 1445 (HY000) : Not allowed to set autocommit from a stored function or trigger
ERROR 1449 (HY000) : User not exist
ERROR 1451 (23000) : Cannot delete or update a parent row: a foreign key constraint fails
ERROR 1451 (23000) : Cannot delete or update a parent row: a foreign key constraint fails
ERROR 1452 (23000) : Cannot add or update a child row: a foreign key constraint fails
ERROR 1456 (HY000) : Recursive limit %ld (as set by the max_sp_recursion_depth variable) was exceeded for routine
ERROR 1458 (42000) : Incorrect routine name \'%.*s\'
ERROR 1462 (42S02) : \'%.*s'.'%.*s\' contains view recursion
ERROR 1466 (HY000) : Leading spaces are removed from name \'%.*s\'
ERROR 1467 (HY000) : Failed to read auto increment value from storage engine
ERROR 1470 (HY000) : String '%.*s' is too long for user name (should be no longer than 64)
ERROR 1471 (HY000) : The target table %.*s of the INSERT is not insertable-into
ERROR 1474 (HY000) : Name \'%.*s\' has become ''
ERROR 1475 (42000) : Ambiguous column
ERROR 1480 (HY000) : Only RANGE PARTITIONING can use VALUES LESS THAN in partition definition
ERROR 1486 (HY000) : Constant or random or timezone-dependent expressions in sub)partitioning function are not allowed
ERROR 1488 (HY000) : Field in list of fields for partition function not found in table
ERROR 1491 (HY000) : The PARTITION function returns the wrong type
ERROR 1493 (HY000) : VALUES LESS THAN value must be strictly increasing for each partition%.*s
ERROR 1493 (HY000) : VALUES LESS THAN value must be strictly increasing for each partition
ERROR 1495 (HY000) : Multiple definition of same constant in list partitioning
ERROR 1499 (HY000) : Too many partitions (including subpartitions) were defined
ERROR 1500 (HY000) : It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning
ERROR 1503 (HY000) : A %s must include all columns in the table's partitioning function
ERROR 1503 (HY000) : A PRIMARY KEY must include all columns in the table\'s partitioning function
ERROR 1504 (HY000) : Number of partitions = 0 is not an allowed value
ERROR 1505 (HY000) : Partition management on a not partitioned table is not possible
ERROR 1507 (HY000) : error in list of partitions to DROP
ERROR 1508 (HY000) : Cannot remove all partitions, use DROP TABLE instead
ERROR 1512 (HY000) : %s PARTITION can only be used on RANGE/LIST partitions
ERROR 1517 (HY000) : Duplicate partition name \'%.*s\'
ERROR 1517 (HY000) : Duplicate partition name %.*s
ERROR 1517 (HY000) : Duplicate partition name %.*s
ERROR 1517 (HY000) : missing or invalid WAIT interval
ERROR 1520 (HY000) : Reorganize of range partitions cannot change total ranges except for last partition where it can extend the range
ERROR 1524 (HY000) : Plugin '%.*s' is not loaded
ERROR 1525 (HY000) : Incorrect %s value: '%s'
ERROR 1525 (HY000) : XML parsing failed
ERROR 1526 (HY000) : Table has no partition for value
ERROR 1537 (HY000) : Event '%.*s' already exists
ERROR 1539 (HY000) : Unknown '%.*s' event
ERROR 1540 (HY000) : Failed to alter event '%.*s'
ERROR 1541 (HY000) : Failed to drop %.*s
ERROR 1542 (HY000) : INTERVAL is either not positive or too big
ERROR 1543 (HY000) : ENDS is either invalid or before STARTS
ERROR 1544 (HY000) : Event execution time is in the past. Event has been disabled
ERROR 1549 (HY000) : Failed to delete the event from mysql.event
ERROR 1551 (HY000) : Same old and new event name
ERROR 1552 (HY000) : Data for column '%.*s' too long
ERROR 1562 (HY000) : Cannot create temporary table with partitions
ERROR 1563 (HY000) : Partition constant is out of partition function domain
ERROR 1564 (HY000) : This partition function is not allowed
ERROR 1566 (HY000) : Not allowed to use NULL value in VALUES LESS THAN
ERROR 1567 (HY000) : Incorrect partition name '%.*s'
ERROR 1568 (25001) : Transaction characteristics can't be changed while a transaction is in progress
ERROR 1576 (HY000) : Recursion of EVENT DDL statements is forbidden when body is present
ERROR 1582 (42000) : Incorrect parameter count in the call to native function '%.*s'
ERROR 1583 (42000) : Incorrect parameters in the call to native function '%.*s'
ERROR 1588 (HY000) : Event execution time is in the past and ON COMPLETION NOT PRESERVE is set. The event was dropped immediately after creation.
ERROR 1589 (HY000) : Event execution time is in the past. The event was not changed. Specify a time in the future.
ERROR 1613 (XA106) : XA_RBTIMEOUT: Transaction branch was rolled back: took too long
ERROR 1621 (HY000) : variable is read only", "%.*s variable '%.*s' is read-only. Use SET %.*s to assign the value
ERROR 1628 (HY000) : Comment for table is too long (max = %ld)
ERROR 1629 (HY000) : Comment for field is too long (max = %ld)
ERROR 1642 (01000) : Unhandled user-defined warning condition
ERROR 1644 (HY000) : Unhandled user-defined exception condition
ERROR 1645 (0K000) : RESIGNAL when handler not active
ERROR 1646 (HY000) : SIGNAL/RESIGNAL can only use a CONDITION defined with SQLSTATE
ERROR 1652 (HY000) : Duplicate partition field name '%.*s'
ERROR 1653 (HY000) : Inconsistency in usage of column lists for partitioning
ERROR 1654 (HY000) : Partition column values of incorrect type
ERROR 1654 (HY000) : Partition column values of incorrect type
ERROR 1654 (HY000) : Partition column values of incorrect type
ERROR 1655 (HY000) : Too many fields in \'list of partition fields\'
ERROR 1657 (HY000) : Cannot have more than one value for this type of RANGE partitioning
ERROR 1659 (HY000) : Field \'%.*s\' is of a not allowed type for this type of partitioning
ERROR 1688 (HY000) : Comment for index is too long (max = %ld)
ERROR 1690 (22003) : %s value is out of range in '%s'
ERROR 1697 (HY000) : VALUES value for partition \'%.*s\' must have type INT
ERROR 1701 (42000) : Cannot truncate a table referenced in a foreign key constraint %.*s
ERROR 1706 (HY000) : Primary key/index key/partition key update is not allowed since the table is updated both as '%.*s' and '%.*s'
ERROR 1708 (HY000) : The value of \'%s\' should be no less than the value of \'%s\'
ERROR 1731 (HY000) : Non matching attribute '%s' between partition and table
ERROR 1732 (HY000) : Table to exchange with partition is partitioned: '%.*s'
ERROR 1735 (HY000) : Unkown partition '%.*s' in table '%.*s'
ERROR 1736 (HY000) : Tables have different definitions
ERROR 1748 (HY000) : Found a row not matching the given partition set
ERROR 1758 (35000) : Invalid condition number
ERROR 1792 (25006) : Cannot execute statement in a READ ONLY transaction
ERROR 1792 (25006) : Cannot execute statement in a READ ONLY transaction
ERROR 1819 (HY000) : Your password does not satisfy the current policy requirements
ERROR 1820 (HY000) : You must reset your password using ALTER USER statement before executing this statement
ERROR 1827 (42000) : The password hash doesn't have the expected format. Check if the correct password algorithm is being used with the PASSWORD() function
ERROR 1830 (HY000) : Column '%s' cannot be NOT NULL: needed in a foreign key constraint '%s' SET NULL
ERROR 1830 (HY000) : Cannot define foreign key with ON DELETE SET NULL clause on a generated column
ERROR 1831 (HY000) : Duplicate index '%s' defined on the table '%s.%s'
ERROR 1869 (HY000) : Auto-increment value in UPDATE conflicts with internally generated values
ERROR 1882 (HY000) : The initialization vector supplied to aes_encrypt is too short. Must be at least 16 bytes long
ERROR 3004 (0Z002) : GET STACKED DIAGNOSTICS when handler not active
ERROR 3011 (HY000) : Referenced trigger '%s' for the given action time and event type does not exist
ERROR 3020 (2201E) : Invalid argument for logarithm
ERROR 3024 (HY000) : maybe you can adjust the session variable max_execution_time or max_execution_time hint, and try again
ERROR 3028 (HY000) : Expression #%d of ORDER BY contains aggregate function and applies to a UNION
ERROR 3033 (HY000) : Binary geometry function %s given two geometries of different srids: %u and %u, which should have been identical
ERROR 3034 (HY000) : Calling geometry function %s with unsupported types of arguments
ERROR 3035 (HY000) : Unknown GIS error occurred in function %s
ERROR 3036 (HY000) : Unknown exception caught in GIS function %s
ERROR 3037 (22023) : Invalid GIS data provided to function %s
ERROR 3038 (HY000) : The geometry has no data in function %s.
ERROR 3039 (HY000) : Unable to calculate centroid because geometry is empty in function %s.
ERROR 3040 (HY000) : Geometry overlay calculation error: geometry data is invalid in function %s.
ERROR 3041 (HY000) : Geometry turn info calculation error: geometry data is invalid in function %s.
ERROR 3042 (HY000) : Analysis procedures of intersection points interrupted unexpectedly in function %s.
ERROR 3043 (HY000) : Unknown exception thrown in function %s.
ERROR 3044 (HY000) : Memory allocation error: %-.256s in function %s.
ERROR 3045 (HY000) : Domain error", "Domain error: %-.256s in function %s.
ERROR 3046 (HY000) : Length error: %-.256s in function %s.
ERROR 3047 (HY000) : Invalid argument error: %-.256s in function %s.
ERROR 3048 (HY000) : Out of range error: %-.256s in function %s.
ERROR 3049 (HY000) : Overflow error: %-.256s in function %s.
ERROR 3530 (HY000) : role '%.*s' not granted or does not exist
ERROR 3530 (HY000) : %.*s@%.*s is not granted to %.*s@%.*s
ERROR 3050 (HY000) : Range error: %-.256s in function %s.
ERROR 3051 (HY000) : Underflow error: %-.256s in function %s.
ERROR 3052 (HY000) : Logic error: %-.256s in function %s.
ERROR 3053 (HY000) : Runtime error: %-.256s in function %s.
ERROR 3054 (HY000) : Unknown exception: %-.384s in function %s.
ERROR 3055 (HY000) : Geometry byte string must be little endian.
ERROR 3060 (HY000) : Do not support online operation on table with GIS index
ERROR 3061 (42000) : User variable name %.*s is illegal
ERROR 3064 (HY000) : invalid type given for an argument
ERROR 3105 (HY000) : The value specified for generated column '%.*s' in table '%.*s' is not allowed
ERROR 3106 (HY000) : '%s' is not supported for generated columns
ERROR 3108 (HY000) : Column '%.*s' has a generated column dependency
ERROR 3118 (HY000) : User locked
ERROR 3122 (HY000) : Inconsistent intersection points.
ERROR 3134 (HY000) : Parameter %s exceeds the maximum number of points in a geometry (%lu) in function %s.
ERROR 3140 (22032) : Invalid JSON text
ERROR 3141 (22032) : Invalid JSON text in argument
ERROR 3142 (42000) : The JSON binary value contains invalid data
ERROR 3143 (42000) : Invalid JSON path expression
ERROR 3144 (22032) : Cannot create a JSON value from a string
ERROR 3145 (22032) : Invalid JSON character data provided to function
ERROR 3146 (22032) : Invalid data type for JSON data in argument %u to function %s; a JSON string or JSON type is required
ERROR 3147 (22032) : Cannot CAST value to JSON
ERROR 3148 (42000) : A path expression must be encoded in the utf8 character set
ERROR 3149 (42000) : In this situation, path expressions may not contain the * and ** tokens
ERROR 3150 (22032) : The JSON value is too big to be stored in a JSON column
ERROR 3151 (22032) : The JSON object contains a key name that is too long
ERROR 1351 (HY000) : View's SELECT contains a variable or parameter
ERROR 3153 (42000) : The path expression is not allowed in this context
ERROR 3154 (42000) : The oneOrAll argument may take these values: \'one\' or \'all\'
ERROR 3155 (22003) : Out of range JSON value for CAST
ERROR 3156 (22018) : Invalid JSON value for CAST
ERROR 3157 (22032) : The JSON document exceeds the maximum depth
ERROR 3158 (22032) : JSON documents may not contain NULL member names
ERROR 3162 (HY000) : User %.*s does not exist
ERROR 3163 (HY000) : Authorization ID '%.*s'@'%.*s' already exists
ERROR 3165 (42000) : A path expression is not a path to a cell in an array
ERROR 3504 (HY000) : Too many enumeration valuesfor column %.*s
ERROR 3505 (HY000) : Too long enumeration/setvalue for column %.*s
ERROR 3516 (22S01) : %.64s value is a geometry of unexpected type %.64s in %.64s.
ERROR 3516 (22S01) : Unknown WKB type(%d)! Full WKB type number was (%d).
ERROR 3517 (SR002) : Can't parse the spatial reference system definition of SRID %u.
ERROR 3518 (SR003) : The spatial reference system definition for SRID %u does not specify the mandatory %s (EPSG %u) projection parameter.
ERROR 3519 (01000) : There's no spatial reference system with SRID %u.
ERROR 3520 (22S00) : Function %s is only defined for Cartesian spatial reference systems, but one of its arguments is in SRID %u, which is not Cartesian.
ERROR 3521 (SR001) : Function %s is only defined for Cartesian spatial reference systems, but one of its arguments is in SRID %u, which has not been defined.
ERROR 3523 (HY000) : Unknown authorization ID %.*s@%.*s
ERROR 3548 (SR001) : There's no spatial reference system with SRID %u.
ERROR 3548 (SR001) : Spatial reference system is empty
ERROR 3558 (22023) : Invalid option key '%.192s' in function %.192s.
ERROR 3559 (22023) : Invalid value '%.192s' for option '%.192s' in function '%.192s'.
ERROR 3560 (22023) : The string '%.192s' is not a valid key %c value pair in function %.192s.
ERROR 3565 (01000) : There's no spatial reference system with SRID %u. The axis order is unknown.
ERROR 3573 (HY000) : Recursive Common Table Expression should contain a UNION ALL
ERROR 3574 (HY000) : Recursive Common Table Expression should have one or more non-recursive query blocks followed by one or more recursive ones: %s
ERROR 3575 (HY000) : ORDER BY / LIMIT / SELECT DISTINCT / HAVING / WINDOW FUNCTION / GROUP BY in recursive query block of Common Table Expression not supported
ERROR 3576 (HY000) : In recursive query block of Recursive Common Table Expression, the recursive table must neither be in the right argument of a LEFT JOIN, nor be forced to be non-first with join order hints
ERROR 3577 (HY000) : In recursive query block of Recursive Common Table Expression, the recursive table must be referenced only once, and not in any subquery
ERROR 3581 (HY000) : A window which depends on another cannot define partitioning
ERROR 3582 (HY000) : Window '%.*s' has a frame definition, so cannot be referenced by another window
ERROR 3583 (HY000) : Window '%.*s' cannot inherit '%.*s' since both contain an ORDER BY clause
ERROR 3586 (HY000) : Window '%.*s': frame start or end is negative or NULL or of non-integral type
ERROR 3587 (HY000) : Window '%s' with RANGE N PRECEDING/FOLLOWING frame requires exactly one ORDER BY expression of numeric or temporal type
ERROR 3588 (HY000) : Window '%.*s' with RANGE frame has ORDER BY expression of datetime type. Only INTERVAL bound value allowed.
ERROR 3589 (HY000) : Window '%.*s' with RANGE frame has ORDER BY expression of numeric type. INTERVAL bound value not allowed.
ERROR 3590 (HY000) : Window '%.*s' has a non-constant frame bound.
ERROR 3592 (HY000) : Window '%s': ORDER BY or PARTITION BY uses legacy position indication, which is not supported use expression
ERROR 3596 (HY000) : Window '%s': INTERVAL can only be used with RANGE frames
ERROR 3616 (22S02) : Longitude %f is out of range in function %.192s. It must be within (%f, %f].
ERROR 3617 (22S03) : Latitude %f is out of range in function %.192s. It must be within [%f, %f].
ERROR 3618 (22S00) : %.192s(%.80s) has not been implemented for geographic spatial reference systems.
ERROR 3636 (HY000) : Recursive query aborted after %u iterations. Try increasing @@cte_max_recursion_depth to a larger value.
ERROR 3643 (HY000) : The SRID of the geometry does not match the SRID of the column. The SRID of the geometry is %lu, but the SRID of the column is %lu. Consider changing the SRID of the geometry or the SRID property of the column.
ERROR 3644 (HY000) : The SRID specification on the column '%.64s' cannot be changed because there is a spatial index on the column. Please remove the spatial index before altering the SRID specification.
ERROR 3666 (42000) : Can't store an array or an object in the scalar %s column 'jpath'
ERROR 3667 (42000) : Every table function must have an alias
ERROR 3674 (HY000) : The spatial index on column '%.64s' will not be used by the query optimizer since the column does not have an SRID attribute. Consider adding an SRID attribute to the column.
ERROR 3682 (22S00) : Function %.192s is only defined for SRID 0 and SRID 4326.
ERROR 3704 (22S00) : %.192s(%.80s) has not been implemented for Cartesian spatial reference systems.
ERROR 3705 (22S00) : %.192s(%.80s) has not been implemented for projected spatial reference systems.
ERROR 3706 (22023) : Invalid radius provided to function %s: Radius(%lf) must be greater than zero.
ERROR 3708 (SR006) : Missing mandatory attribute %s.
ERROR 3709 (SR006) : Multiple definitions of attribute %s.
ERROR 3710 (SR006) : The spatial reference system name can't be an empty string or start or end with whitespace.
ERROR 3711 (SR006) : The organization name can't be an empty string or start or end with whitespace.
ERROR 3712 (SR004) : There is already a spatial reference system with SRID %u.
ERROR 3713 (01S00) : There is already a spatial reference system with SRID %u.
ERROR 3714 (SR000) : SRID 0 is not modifiable.
ERROR 3715 (01S01) : The SRID range [%u, %u] has been reserved for system use. SRSs in this range may be added, modified or removed without warning during upgrade.
ERROR 3716 (SR005) : Can't modify SRID %u. There is at least one column depending on it.
ERROR 3717 (SR006) : Invalid character in attribute %s.
ERROR 3718 (SR006) : Attribute %s is too long. The maximum length is %u characters.
ERROR 3726 (22S00) : Function %s is only defined for geographic spatial reference systems, but one of its arguments is in SRID %u, which is not geographic.
ERROR 3727 (22023) : Function %s encountered a polygon that was too large. Polygons must cover less than half the planet.
ERROR 3728 (HY000) : Spatial indexes can't be primary or unique indexes.
ERROR 3729 (HY000) : The index type %.20s is not supported for spatial indexes.
ERROR 3729 (HY000) : The index type %s is not supported for spatial indexes.
ERROR 3731 (22S02) : A parameter of function %.192s contains a geometry with longitude %f, which is out of range. It must be within (%f, %f].
ERROR 3732 (22S03) : A parameter of function %.192s contains a geometry with latitude %f, which is out of range. It must be within [%f, %f].
ERROR 3736 (SR002) : The spatial reference system definition for SRID %u specifies invalid geographic axes '%.20s' and '%.20s'. One axis must be NORTH or SOUTH and the other must be EAST or WEST.
ERROR 3737 (SR002) : The length of the semi-major axis must be a positive number.
ERROR 3738 (SR002) : The inverse flattening must be larger than 1.0, or 0.0 if the ellipsoid is a sphere.
ERROR 3739 (SR002) : The angular unit conversion factor must be a positive number.
ERROR 3740 (SR002) : The prime meridian must be within (-180, 180] degrees, specified in the SRS angular unit.
ERROR 3741 (22S00) : Transformation from SRID %u is not supported.
ERROR 3742 (22S00) : Transformation to SRID %u is not supported.
ERROR 3743 (22S00) : Transformation from SRID %u is not supported. The spatial reference system has no TOWGS84 clause.
ERROR 3744 (22S00) : Transformation to SRID %u is not supported. The spatial reference system has no TOWGS84 clause.
ERROR 3753 (42000) : Cannot create a functional index on a function that returns a JSON or GEOMETRY value.
ERROR 3754 (HY000) : Functional index '%.*s' cannot refer to an auto-increment column.
ERROR 3757 (HY000) : Cannot create a functional index on an expression that returns a BLOB or TEXT. Please consider using CAST.
ERROR 3758 (HY000) : Expression of functional index contains a disallowed function.
ERROR 3760 (HY000) : Spatial functional index is not supported.
ERROR 3762 (HY000) : Functional index on a column is not supported. Consider using a regular index instead.
ERROR 3812 (HY000) : An expression of non-boolean type specified to a check constraint \'%.*s\'
ERROR 3813 (HY000) : Column check constraint \'%.*s\' references other column
ERROR 3814 (HY000) : An expression of a check constraint \'%.*s\' contains disallowed function: %.*s
ERROR 3815 (HY000) : An expression of a check constraint \'%.*s\' contains disallowed function
ERROR 3816 (HY000) : An expression of a check constraint \'%.*s\' cannot refer to a user or system variable
ERROR 3818 (HY000) : Check constraint \'%.*s\' cannot refer to an auto-increment column
ERROR 3819 (HY000) : check constraint violated
ERROR 3820 (HY000) : Check constraint \'%.*s\' refers to non-existing column \'%.*s\'
ERROR 3821 (HY000) : Check constraint \'%.*s\' is not found in the table
ERROR 3822 (HY000) : Duplicate check constraint name \'%.*s\'
ERROR 3837 (HY000) : Column '%.*s' has a functional index dependency and cannot be dropped or renamed.
ERROR 3853 (22032) : Invalid JSON type in argument, should be object.
ERROR 3855 (HY000) : Column '%.*s' has a partitioning function dependency and cannot be dropped or renamed.
ERROR 3939 (HY000) : Table has multiple constraints with the name \'%.*s\'. Please use constraint specific \'%.*s\' clause
ERROR 3940 (HY000) : Constraint \'%.*s\' does not exist
ERROR 3941 (HY000) : Altering constraint enforcement is not supported for the constraint \'%.*s\'. Enforcement state alter is not supported for the PRIMARY, UNIQUE and FOREIGN KEY type constraints
ERROR 3942 (HY000) : Each row of a VALUES clause must have at least one column, unless when used as source in an INSERT statement.
ERROR 3943 (HY000) : A VALUES clause cannot use DEFAULT values, unless used as a source in an INSERT statement.
ERROR 3959 (HY000) : Check constraint \'%.*s\' uses column \'%.*s\', hence column cannot be dropped or renamed
ERROR 3966 (22035) : No value was found by '%.192s' on the specified path
ERROR 3967 (22035) : More than one value was found by '%.192s' on the specified path

This error code range indicates compatibility with MySQL error codes.

ERROR 1007 (HY000) : Can't create database '%s'; database exists

  • OceanBase error code: 5158

  • Compatible MySQL error code: 1007

ERROR 1008 (HY000) : Can't drop database '%.*s'; database doesn't exist

  • OceanBase error code: 5166

  • Compatible MySQL error code: 1008

ERROR 1017 (HY000) : File not exist

  • OceanBase error code: 4027

  • Compatible MySQL error code: 1017

ERROR 1018 (HY000) : Directory not exist

  • OceanBase error code: 4066

  • Compatible MySQL error code: 1018

ERROR 1022 (23000) : Can't write; duplicate key in table \'%.*s\'

  • OceanBase error code: 5595

  • Compatible MySQL error code: 1022

ERROR 1025 (HY000) : ## ERROR on rename of \'%s.%s\' to \'%s.%s\'

  • OceanBase error code: 5215

  • Compatible MySQL error code: 1025

ERROR 1040 (08004) : Too many connections

  • OceanBase error code: 5271

  • Compatible MySQL error code: 1040

ERROR 1041 (53000) : Out of resource

  • OceanBase error code: 4153

  • Compatible MySQL error code: 1041

ERROR 1044 (42000) : Access denied for user '%.*s'@'%.*s' to database '%.*s'

  • OceanBase error code: 5170

  • Compatible MySQL error code: 1044

ERROR 1045 (42000) : Access denied for user '%.*s'@'%.*s' (using password: %s)

  • OceanBase error code: 4043

  • Compatible MySQL error code: 1045

ERROR 1046 (3D000) : No database selected

  • OceanBase error code: 5134

  • Compatible MySQL error code: 1046

ERROR 1047 (HY001) : Unknown packet

  • OceanBase error code: 4118

  • Compatible MySQL error code: 1047

ERROR 1048 (23000) : Column '%.*s' cannot be null

  • OceanBase error code: 4235

  • Compatible MySQL error code: 1048

ERROR 1049 (42000) : Unknown database '%.*s'

  • OceanBase error code: 5154

  • Compatible MySQL error code: 1049

ERROR 1050 (42S01) : Table '%.*s' already exists

  • OceanBase error code: 5020

  • Compatible MySQL error code: 1050

ERROR 1051 (42S02) : Unknown table '%.*s'

  • OceanBase error code: 5201

  • Compatible MySQL error code: 1051

ERROR 1052 (23000) : Column '%.*s' in %.*s is ambiguous

  • OceanBase error code: 5207

  • Compatible MySQL error code: 1052

ERROR 1054 (42S22) : Unknown column '%.*s' in '%.*s'

  • OceanBase error code: 5217

  • Compatible MySQL error code: 1054

ERROR 1055 (42000) : \'%.*s\' is not in GROUP BY

  • OceanBase error code: 5218

  • Compatible MySQL error code: 1055

ERROR 1056 (42000) : Can't group on '%.*s'

  • OceanBase error code: 5206

  • Compatible MySQL error code: 1056

ERROR 1059 (42000) : Identifier name \'%.*s\' is too long

  • OceanBase error code: 5179, 9526

  • Compatible MySQL error code: 1059

ERROR 1060 (42S21) : Duplicate column group name '%.*s'

  • OceanBase error code: 5404

  • Compatible MySQL error code: 1060

ERROR 1061 (42000) : Duplicate key name \'%.*s\'

  • OceanBase error code: 5025

  • Compatible MySQL error code: 1061

ERROR 1062 (23000) : Duplicate entry \'%s\' for key \'%.*s\'

  • OceanBase error code: 5024

  • Compatible MySQL error code: 1062

ERROR 1063 (42000) : Incorrect column specifier for column '%.*s'

  • OceanBase error code: 5165

  • Compatible MySQL error code: 1063

ERROR 1064 (0B000) : Failed to init SQL parser

  • OceanBase error code: 5000

  • Compatible MySQL error code: 1064

ERROR 1064 (42000) : Parse error", "%s near \'%.*s\' at line %d

  • OceanBase error code: 5001

  • Compatible MySQL error code: 1064

ERROR 1064 (42000) : Wrong number of partitions defined, mismatch with previous setting

  • OceanBase error code: 5282

  • Compatible MySQL error code: 1064

ERROR 1065 (42000) : Query was empty

  • OceanBase error code: 5253

  • Compatible MySQL error code: 1065

ERROR 1066 (42000) : Not unique table/alias: \'%.*s\'

  • OceanBase error code: 5208

  • Compatible MySQL error code: 1066

ERROR 1067 (42000) : Invalid default value for \'%.*s\'

  • OceanBase error code: 5173

  • Compatible MySQL error code: 1067

ERROR 1068 (42000) : Multiple primary key defined

  • OceanBase error code: 5210

  • Compatible MySQL error code: 1068

ERROR 1069 (42000) : Too many keys specified; max %ld keys allowed

  • OceanBase error code: 5194

  • Compatible MySQL error code: 1069

ERROR 1070 (42000) : Too many key parts specified; max %ld parts allowed

  • OceanBase error code: 5195

  • Compatible MySQL error code: 1070

ERROR 1071 (42000) : Specified key was too long; max key length is %ld bytes

  • OceanBase error code: 5196

  • Compatible MySQL error code: 1071

ERROR 1072 (42000) : Key column '%.*s' doesn't exist in table

  • OceanBase error code: 5211

  • Compatible MySQL error code: 1072

ERROR 1074 (42000) : Column length too big for column '%s' (max = %d)

  • OceanBase error code: 5198

  • Compatible MySQL error code: 1074

ERROR 1074 (42000) : Column length too big for column '%.*s' (max = %d); use BLOB or TEXT instead

  • OceanBase error code: 9577

  • Compatible MySQL error code: 1074

ERROR 1075 (42000) : Incorrect table definition; there can be only one auto column

  • OceanBase error code: 5193

  • Compatible MySQL error code: 1075

ERROR 1078 (01000) : (string):%s: Got signal %d. Aborting

  • OceanBase error code: 4662

  • Compatible MySQL error code: 1078

ERROR 1082 (42S12) : Illegal index

  • OceanBase error code: 5028

  • Compatible MySQL error code: 1082

ERROR 1082 (42000) : Index unavailable

  • OceanBase error code: 5073

  • Compatible MySQL error code: 1082

ERROR 1083 (42000) : Field separator argument is not what is expected; check the manual

  • OceanBase error code: 5295

  • Compatible MySQL error code: 1083

ERROR 1083 (HY000) : Non-ASCII separator arguments are not fully supported

  • OceanBase error code: 5609

  • Compatible MySQL error code: 1083

ERROR 1083 (HY000) : First character of the FIELDS TERMINATED string is ambiguous; please use non-optional and non-empty FIELDS ENCLOSED BY

  • OceanBase error code: 5610

  • Compatible MySQL error code: 1083

ERROR 1086 (58000) : File already exist

  • OceanBase error code: 4117

  • Compatible MySQL error code: 1086

ERROR 1089 (HY000) : Incorrect prefix key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique prefix keys

  • OceanBase error code: 5190

  • Compatible MySQL error code: 1089

ERROR 1090 (42000) : You can't delete all columns with ALTER TABLE; use DROP TABLE instead

  • OceanBase error code: 5187

  • Compatible MySQL error code: 1090

ERROR 1091 (42000) : Can't DROP '%.*s'; check that column/key exists

  • OceanBase error code: 5209

  • Compatible MySQL error code: 1091

ERROR 1093 (HY000) : You can\'t specify target table \'%s\' for update in FROM clause

  • OceanBase error code: 5174

  • Compatible MySQL error code: 1093

ERROR 1094 (HY000) : Unknown thread id: %lu

  • OceanBase error code: 4174

  • Compatible MySQL error code: 1094

ERROR 1095 (HY000) : You are not owner of thread %lu

  • OceanBase error code: 5251

  • Compatible MySQL error code: 1095

ERROR 1096 (HY000) : No tables used

  • OceanBase error code: 5185

  • Compatible MySQL error code: 1096

ERROR 1097 (HY000) : Too many strings for column %.*s and SET

  • OceanBase error code: 5336

  • Compatible MySQL error code: 1097

ERROR 1101 (42000) : BLOB, TEXT, GEOMETRY or JSON column '%.*s' can't have a default value

  • OceanBase error code: 5430

  • Compatible MySQL error code: 1101

ERROR 1102 (42000) : Incorrect database name '%.*s'

  • OceanBase error code: 5162

  • Compatible MySQL error code: 1102

ERROR 1103 (42000) : Incorrect table name '%.*s'

  • OceanBase error code: 5163

  • Compatible MySQL error code: 1103

ERROR 1105 (42000) : invalid xpath expression

  • OceanBase error code: 7404

  • Compatible MySQL error code: 1105

  • Cause: The XPath expression is incorrectly formatted or invalid.

  • Solution: Check the XPath expression and verify that the XML data is correct.

ERROR 1105 (42000) : Given XPATH expression not supported

  • OceanBase error code: 7409

  • Compatible MySQL error code: 1105

  • Cause: The XPath expression is not supported.

  • Solution: Check whether the XPath expression used is correct and whether the database version supports using this XPath expression.

ERROR 1108 (HY000) : Incorrect parameters to procedure '%.*s'

  • OceanBase error code: 5406

  • Compatible MySQL error code: 1108

ERROR 1109 (42S02) : Unknown table '%.*s' in %.*s

  • OceanBase error code: 5200

  • Compatible MySQL error code: 1109

ERROR 1110 (42000) : Column \'%s\' specified twice

  • OceanBase error code: 4228

  • Compatible MySQL error code: 1110

ERROR 1111 (HY000) : Invalid use of group function

  • OceanBase error code: 5176

  • Compatible MySQL error code: 1111

ERROR 1113 (42000) : A table must have at least 1 column

  • OceanBase error code: 5904

  • Compatible MySQL error code: 1113

ERROR 1115 (42000) : Unknown character set: '%.*s'

  • OceanBase error code: 5142

  • Compatible MySQL error code: 1115

ERROR 1117 (42000) : Too many columns

  • OceanBase error code: 5197

  • Compatible MySQL error code: 1117

ERROR 1118 (42000) : Row size too large

  • OceanBase error code: 5199

  • Compatible MySQL error code: 1118

ERROR 1122 (HY000) : Can not load function %s

  • OceanBase error code: 4291

  • Compatible MySQL error code: 1122

ERROR 1123 (HY000) : Can not initialize function '%.*s'

  • OceanBase error code: 4292

  • Compatible MySQL error code: 1123

ERROR 1124 (HY000) : No paths allowed for shared library

  • OceanBase error code: 4293

  • Compatible MySQL error code: 1124

ERROR 1125 (HY000) : Function %.*s already exists

  • OceanBase error code: 4294

  • Compatible MySQL error code: 1125

ERROR 1126 (HY000) : Can not open shared library '%.*s'

  • OceanBase error code: 4295

  • Compatible MySQL error code: 1126

ERROR 1127 (HY000) : Can't find symbol %.*s in library

  • OceanBase error code: 4296

  • Compatible MySQL error code: 1127

ERROR 1028 (HY000) : Function %.*s is not defined

  • OceanBase error code: 9203

  • Compatible MySQL error code: 1128

  • Cause: The corresponding plugin feature is not available. This usually occurs because the plugin is not installed or initialization failed.

  • Solution: Check whether the plugin is correctly installed and initialized.

ERROR 1133 (42000) : Can not find any matching row in the user table'%.*s'

  • OceanBase error code: 4042

  • Compatible MySQL error code: 1133

ERROR 1133 (42000) : Incorrect password

  • OceanBase error code: 5038

  • Compatible MySQL error code: 1133

ERROR 1136 (21S01) : column count does not match value count at row '%d'

  • OceanBase error code: 5168

  • Compatible MySQL error code: 1136

ERROR 1136 (21S01) : Column count doesn\'t match value count at row %ld

  • OceanBase error code: 5175

  • Compatible MySQL error code: 1136

ERROR 1138 (22004) : Invalid use of NULL value

  • OceanBase error code: 5596

  • Compatible MySQL error code: 1138

ERROR 1139 (42000) : Got error '%s' from regexp

  • OceanBase error code: 5115

  • Compatible MySQL error code: 1139

ERROR 1140 (42000) : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

  • OceanBase error code: 5221

  • Compatible MySQL error code: 1140

ERROR 1141 (HY000) : There is no such grant defined for user '%.*s' on host '%.*s'

  • OceanBase error code: 11008

  • Compatible MySQL error code: 1141

  • Cause: The grant is not defined for user '%.*s' on host '%.*s'.

  • Solution: Ensure that user '%.*s' on host '%.*s' has the correct grant and that the grant is correctly defined.

ERROR 1142 (42000) : %.*s command denied to user '%.*s'@'%.*s' for table '%.*s'

  • OceanBase error code: 5171

  • Compatible MySQL error code: 1142

ERROR 1144 (42000) : Illegal GRANT/REVOKE command; please consult the manual to see which privileges can be used

  • OceanBase error code: 5183

  • Compatible MySQL error code: 1144

ERROR 1146 (42S02) : Table \'%s.%s\' doesn\'t exist

  • OceanBase error code: 5019

  • Compatible MySQL error code: 1146

ERROR 1149 (42000) : You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use

  • OceanBase error code: 5006

  • Compatible MySQL error code: 1149

ERROR 1153 (08S01) : Got a packet bigger than \'max_allowed_packet\' bytes"

  • OceanBase error code: 4254

  • Compatible MySQL error code: 1153

ERROR 1166 (42000) : Incorrect column name '%.*s'

  • OceanBase error code: 5164

  • Compatible MySQL error code: 1166

ERROR 1167 (42000) : The used storage engine can't index column '%.*s'

  • OceanBase error code: 5216

  • Compatible MySQL error code: 1167

ERROR 1171 (42000) : Insert null into %.*s

  • OceanBase error code: 5030

  • Compatible MySQL error code: 1171

ERROR 1171 (42000) : All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead

  • OceanBase error code: 5256

  • Compatible MySQL error code: 1171

ERROR 1172 (42000) : Result consisted of more than one row

  • OceanBase error code: 5294

  • Compatible MySQL error code: 1172

ERROR 1173 (42000) : Primary key columns) not specified in the WHERE clause

  • OceanBase error code: 5047

  • Compatible MySQL error code: 1173

ERROR 1175 (HY000) : You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column

  • OceanBase error code: 5865

  • Compatible MySQL error code: 1175

ERROR 1176 (42000) : Key '%.*s' doesn't exist in table '%.*s'

  • OceanBase error code: 5289

  • Compatible MySQL error code: 1176

ERROR 1192 (HY000) : Can't execute the given command because you have active locked tables or an active transaction

  • OceanBase error code: 5236

  • Compatible MySQL error code: 1192

ERROR 1193 (HY000) : Unknown system variable '%.*s'

  • OceanBase error code: 5044

  • Compatible MySQL error code: 1193

ERROR 1203 (42000) : Too many sessions

  • OceanBase error code: 5059

  • Compatible MySQL error code: 1203

ERROR 1205 (HY000) : Lock wait timeout exceeded; try restarting transaction

  • OceanBase error code: 6003

  • Compatible MySQL error code: 1205

ERROR 1205 (HY000) : Lock wait timeout exceeded; try restarting transaction

  • OceanBase error code: 6006

  • Compatible MySQL error code: 1205

ERROR 1210 (HY000) : Incorrect arguments to %s

  • OceanBase error code: 4002

  • Compatible MySQL error code: 1210

ERROR 1210 (HY000) : Miss argument for %s

  • OceanBase error code: 4272

  • Compatible MySQL error code: 1210

ERROR 1210 (HY000) : Miss argument for %s

  • OceanBase error code: 4277

  • Compatible MySQL error code: 1210

ERROR 1213 (HY000) : Deadlock

  • OceanBase error code: 4101

  • Compatible MySQL error code: 1213

ERROR 1215 (HY000) : Cannot add foreign key constraint

  • OceanBase error code: 5317

  • Compatible MySQL error code: 1215

ERROR 1221 (HY000) : Incorrect usage of DB GRANT and GLOBAL PRIVILEGES

  • OceanBase error code: 5182

  • Compatible MySQL error code: 1221

ERROR 1221 (HY000) : Incorrect usage of UNION and INTO

  • OceanBase error code: 9641

  • Compatible MySQL error code: 1221

ERROR 1222 (21000) : The used SELECT statements have a different number of columns

  • OceanBase error code: 5007

  • Compatible MySQL error code: 1222

ERROR 1225 (HY000) : Option '%s' used twice in statement

  • OceanBase error code: 4299

  • Compatible MySQL error code: 1225

ERROR 1226 (42000) : User '%.*s' has exceeded the '%s' resource (current value: %lu)

  • OceanBase error code: 5967

  • Compatible MySQL error code: 1226

ERROR 1227 (42501) : Access denied; you need (at least one of) the %s privilege(s) for this operation

  • OceanBase error code: 5036

  • Compatible MySQL error code: 1227

ERROR 1228 (HY000) : Variable \'%.*s\' is a SESSION variable and can't be used with SET GLOBAL

  • OceanBase error code: 5100

  • Compatible MySQL error code: 1228

ERROR 1229 (HY000) : Variable \'%.*s\' is a GLOBAL variable and should be set with SET GLOBAL

  • OceanBase error code: 5101

  • Compatible MySQL error code: 1229

ERROR 1230 (42000) : Variable '%.*s' doesn't have a default value

  • OceanBase error code: 4256

  • Compatible MySQL error code: 1230

ERROR 1231 (42000) : Variable \'%.*s\' can't be set to the value of \'%.*s\'

  • OceanBase error code: 5145

  • Compatible MySQL error code: 1231

ERROR 1232 (42000) : Incorrect argument type to variable '%.*s'

  • OceanBase error code: 5180

  • Compatible MySQL error code: 1232

ERROR 1234 (42000) : Incorrect usage/placement of '%s'

  • OceanBase error code: 5213

  • Compatible MySQL error code: 1234

ERROR 1235 (0A000) : %s not supported

  • OceanBase error code: 4007

  • Compatible MySQL error code: 1235

ERROR 1235 (42000) : This version of MySQL doesn't yet support 'non-string DEFAULT value for a column in a JSON_TABLE expression'

  • OceanBase error code: 5517

  • Compatible MySQL error code: 1235

  • Cause: The current version does not support specifying a non-string default value for a column in a JSON_TABLE expression.

  • Solution: Upgrade to the latest version that supports this feature or modify the column's default value to a string type.

ERROR 1235 (42000) : This version doesn't yet support 'references in JSON Schema.

  • OceanBase error code: 6284

  • Compatible MySQL error code: 1235

  • Cause: Indicates that the current version does not support using references in JSON mode.

  • Solution: Modify the design of JSON mode to avoid using references.

ERROR 1235 (42000) : This version of OceanBase doesn't yet support 'multiple triggers with the same action time and event for one table'

  • OceanBase error code: 9581

  • Compatible MySQL error code: 1235

ERROR 1238 (HY000) : Variable '%.*s' is a %.*s variable

  • OceanBase error code: 5103

  • Compatible MySQL error code: 1238

ERROR 1239 (42000) : Incorrect foreign key definition: Key reference and table reference don't match

  • OceanBase error code: 5318

  • Compatible MySQL error code: 1239

ERROR 1241 (21000) : Operand should contain %ld column(s)

  • OceanBase error code: 5042

  • Compatible MySQL error code: 1241

ERROR 1243 (HY007) : statement not prepared, stmt_id=%u

  • OceanBase error code: 5043

  • Compatible MySQL error code: 1243

ERROR 1242 (21000) : Subquery returns more than 1 row

  • OceanBase error code: 5153

  • Compatible MySQL error code: 1242

ERROR 1243 (HY000) : Unknown prepared statement handle

  • OceanBase error code: 5560

  • Compatible MySQL error code: 1243

ERROR 1247 (42S22) : Reference '%.*s' not supported (reference to group function)

  • OceanBase error code: 5225

  • Compatible MySQL error code: 1247

ERROR 1250 (42000) : Table \'%.*s\' from one of the SELECTs cannot be used in global ORDER clause

  • OceanBase error code: 5238

  • Compatible MySQL error code: 1250

ERROR 1252 (7280) : All parts of a SPATIAL index must be NOT NULL.

  • OceanBase error code: 5238

  • Compatible MySQL error code: 1252

ERROR 1253 (42000) : COLLATION '%.*s' is not valid for CHARACTER SET '%.*s'

  • OceanBase error code: 5144

  • Compatible MySQL error code: 1253

ERROR 1259 (HY000) : ZLIB: Input data corrupted

  • OceanBase error code: 5124

  • Compatible MySQL error code: 1259

ERROR 1260 (42000) : Row %ld was cut by GROUP_CONCAT()

  • OceanBase error code: 5254

  • Compatible MySQL error code: 1260

ERROR 1261 (1000) : Row %ld doesn't contain data for all columns

  • OceanBase error code: 5611

  • Compatible MySQL error code: 1261

ERROR 1262 (1000) : Row %ld was truncated; it contained more data than there were input columns

  • OceanBase error code: 5612

  • Compatible MySQL error code: 1262

ERROR 1264 (22003) : Out of range value for column '%.*s' at row %ld

  • OceanBase error code: 4224

  • Compatible MySQL error code: 1264

ERROR 1264 (22003) : value larger than specified precision(%ld,%ld) allowed for this column

  • OceanBase error code: 5088

  • Compatible MySQL error code: 1264

ERROR 1264 (22003) : value(%s) larger than specified precision(%ld,%ld) allowed for this column

  • OceanBase error code: 5089

  • Compatible MySQL error code: 1264

ERROR 1264 (22003) : Result value was out of range when casting varchar to number

  • OceanBase error code: 5093

  • Compatible MySQL error code: 1264

ERROR 1264 (22003) : Out of range value for column '%.*s' at row %ld

  • OceanBase error code: 5229

  • Compatible MySQL error code: 1264

ERROR 1265 (01000) : Data truncated for column '%.*s' at row %ld

  • OceanBase error code: 4249

  • Compatible MySQL error code: 1265

ERROR 1265 (01000) : Timeout value truncated to 102 years

  • OceanBase error code: 4252

  • Compatible MySQL error code: 1265

ERROR 1267 (HY000) : Illegal mix of collations (%s,%s), (%s,%s)

  • OceanBase error code: 5177

  • Compatible MySQL error code: 1267

ERROR 1273 (HY000) : Unknown collation: '%.*s'

  • OceanBase error code: 5143

  • Compatible MySQL error code: 1273

ERROR 1280 (42000) : Incorrect index name '%.*s'

  • OceanBase error code: 5224

  • Compatible MySQL error code: 1280

ERROR 1283 (HY000) : Column '%.*s' cannot be part of FULLTEXT index

  • OceanBase error code: 5288

  • Compatible MySQL error code: 1283

ERROR 1283 (42000) : A FTS index may only contain a text type column.

  • OceanBase error code: 7289

  • Compatible MySQL error code: 1283

  • Cause: A full-text search (FTS) index can contain only columns of the TEXT type.

  • Solution: Ensure that the data type of the column for which you are creating the FTS index is TEXT, such as VARCHAR, TEXT, or CHAR.

ERROR 1286 (42000) : Unknown storage engine \'%.*s\'

  • OceanBase error code: 5259

  • Compatible MySQL error code: 1286

ERROR 1287 (HY000) : %s is deprecated and will be removed in a future release. Please use '%s' instead

  • OceanBase error code: 5516

  • Compatible MySQL error code: 1287

  • Cause: This syntax is deprecated and will be removed in a future version.

  • Solution: Use the SET variable=expression, ... or SELECT expression(s) INTO variables(s) syntax.

ERROR 1288 (HY000) : The target table %.*s of the %.*s is not updatable

  • OceanBase error code: 5228

  • Compatible MySQL error code: 1288

ERROR 1290 (HY000) : The MySQL server is running with the --read-only option so it cannot execute this statement

  • OceanBase error code: 5233

  • Compatible MySQL error code: 1290

ERROR 1291 (HY000) : Column '%.*s' has duplicated value '%.*s' in %s

  • OceanBase error code: 5334

  • Compatible MySQL error code: 1291

ERROR 1292 (22007) : %s=%d must between %d and %d

  • OceanBase error code: 4158

  • Compatible MySQL error code: 1292

ERROR 1292 (22007) : Incorrect value

  • OceanBase error code: 4190

  • Compatible MySQL error code: 1292

ERROR 1292 (01000) : Truncated incorrect DOUBLE value: '%.*s'

  • OceanBase error code: 4262

  • Compatible MySQL error code: 1292

ERROR 1292 (22007) : Incorrect datetime value: '%.*s' for column '%s'

  • OceanBase error code: 4219

  • Compatible MySQL error code: 1292

ERROR 1292 (22007) : Truncated incorrect %.*s value: '%.*s'

  • OceanBase error code: 5222

  • Compatible MySQL error code: 1292

ERROR 1294 (HY000) : Invalid ON UPDATE clause for \'%s\' column

  • OceanBase error code: 5172

  • Compatible MySQL error code: 1294

ERROR 1295 (HY000) : This command is not supported in the prepared statement protocol yet

  • OceanBase error code: 5568

  • Compatible MySQL error code: 1295

ERROR 1298 (HY000) : Unknown or incorrect time zone: \'%.*s\'

  • OceanBase error code: 5192

  • Compatible MySQL error code: 1298

ERROR 1300 (HY000) : Invalid %.*s character string: \'%.*s\'

  • OceanBase error code: 5250

  • Compatible MySQL error code: 1300

ERROR 1301 (HY000) : Result of %s() was larger than max_allowed_packet (%d) truncated

  • OceanBase error code: 5316

  • Compatible MySQL error code: 1301

ERROR 1302 (42000) : Conflicting declarations: '%s' and '%s'

  • OceanBase error code: 5858

  • Compatible MySQL error code: 1302

ERROR 1303 (2F003) : Cant create a routine from within another routine

  • OceanBase error code: 5582

  • Compatible MySQL error code: 1303

ERROR 1304 (42000) : %s %.*s already exists

  • OceanBase error code: 5541

  • Compatible MySQL error code: 1304

ERROR 1305 (42000) : %s %.*s does not exist

  • OceanBase error code: 5055

  • Compatible MySQL error code: 1305

ERROR 1305 (42000) : %s %.*s.%.*s does not exist

  • OceanBase error code: 5542

  • Compatible MySQL error code: 1305

ERROR 1305 (42000) : savepoint does not exist

  • OceanBase error code: 6242

  • Compatible MySQL error code: 1305

ERROR 1308 (42000) : no matching label: %.*s

  • OceanBase error code: 5546, 9505

  • Compatible MySQL error code: 1308

ERROR 1308 (42000) : %s with no matching label: %s

  • OceanBase error code: 5593

  • Compatible MySQL error code: 1308

ERROR 1309 (42000) : Redefining label '%.*s'

  • OceanBase error code: 9579

  • Compatible MySQL error code: 1309

ERROR 1313 (42000) : RETURN is only allowed in a FUNCTION

  • OceanBase error code: 5583

  • Compatible MySQL error code: 1313

ERROR 1314 (HY000) : '%.*s' is not allowed in stored procedure

  • OceanBase error code: 9580

  • Compatible MySQL error code: 1314

ERROR 1317 (70100) : Query execution was interrupted

  • OceanBase error code: 5065

  • Compatible MySQL error code: 1317

ERROR 1318 (42000) : Incorrect number of arguments for %s %s; expected %u, got %u

  • OceanBase error code: 5555

  • Compatible MySQL error code: 1318

ERROR 1319 (42000) : Undefined CONDITION: %.*s

  • OceanBase error code: 5545

  • Compatible MySQL error code: 1319

ERROR 1320 (42000) : No Return found in FUNCTION '%.*s'

  • OceanBase error code: 9575

  • Compatible MySQL error code: 1320

ERROR 1321 (2F005) : FUNCTION %s ended without RETURN

  • OceanBase error code: 5580

  • Compatible MySQL error code: 1321

ERROR 1323 (42000) : Cursor SELECT must not have INTO

  • OceanBase error code: 5584

  • Compatible MySQL error code: 1323

ERROR 1324 (42000) : Undefined CURSOR: %.*s

  • OceanBase error code: 5547

  • Compatible MySQL error code: 1324

ERROR 1325 (24000) : Cursor is already open

  • OceanBase error code: 5589

  • Compatible MySQL error code: 1325

ERROR 1326 (24000) : Cursor is not open

  • OceanBase error code: 5590

  • Compatible MySQL error code: 1326

ERROR 1327 (42000) : Undeclared variable: %.*s

  • OceanBase error code: 5543

  • Compatible MySQL error code: 1327

ERROR 1327 (42000) : Undeclared type: %.*s

  • OceanBase error code: 5544

  • Compatible MySQL error code: 1327

ERROR 1328 (HY000) : Incorrect number of FETCH variables

  • OceanBase error code: 5554

  • Compatible MySQL error code: 1328

ERROR 1329 (02000) : No data - zero rows fetched, selected, or processed

  • OceanBase error code: 4026

  • Compatible MySQL error code: 1329

ERROR 1330 (42000) : Duplicate parameter: %.*s

  • OceanBase error code: 5548

  • Compatible MySQL error code: 1330

ERROR 1330 (42000) : Duplicate type: %.*s

  • OceanBase error code: 5550

  • Compatible MySQL error code: 1330

ERROR 1330 (42000) : Duplicate label: %.*s

  • OceanBase error code: 5552

  • Compatible MySQL error code: 1330

ERROR 1331 (42000) : Duplicate variable: %.*s

  • OceanBase error code: 5549

  • Compatible MySQL error code: 1331

ERROR 1332 (42000) : Duplicate condition: %.*s

  • OceanBase error code: 5551

  • Compatible MySQL error code: 1332

ERROR 1333 (42000) : Duplicate cursor: %.*s

  • OceanBase error code: 5553

  • Compatible MySQL error code: 1333

ERROR 1336 (0A000) : %s is not allowed in stored function or trigger

  • OceanBase error code: 5569

  • Compatible MySQL error code: 1336

ERROR 1337 (42000) : Variable or condition declaration after cursor or handler declaration

  • OceanBase error code: 5586

  • Compatible MySQL error code: 1337

ERROR 1338 (42000) : Cursor declaration after handler declaration

  • OceanBase error code: 5587

  • Compatible MySQL error code: 1338

ERROR 1339 (20000) : Case not found for CASE statement

  • OceanBase error code: 5571

  • Compatible MySQL error code: 1339

ERROR 1347 (HY000) : \'%s.%s\' is not %s

  • OceanBase error code: 5214

  • Compatible MySQL error code: 1347

ERROR 1348 (HY000) : Column '%.*s' is not updatable

  • OceanBase error code: 5719

  • Compatible MySQL error code: 1348

ERROR 1349 (HY000) : View's SELECT contains a subquery in the FROM clause

  • OceanBase error code: 4238

  • Compatible MySQL error code: 1349

ERROR 1350 (HY000) : View's SELECT contains a 'INTO' clause.

  • OceanBase error code: 5503

  • Compatible MySQL error code: 1350

  • Cause: The SELECT statement of the view contains an 'INTO' clause.

  • Solution: Remove the 'INTO' clause from the SELECT statement of the view.

ERROR 1353 (HY000) : View's SELECT and view's field list have different column counts

  • OceanBase error code: 5740

  • Compatible MySQL error code: 1353

ERROR 1356 (42S22) : View \'%.*s.%.*s\' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

  • OceanBase error code: 5231

  • Compatible MySQL error code: 1356

ERROR 1360 (HY000) : Trigger does not exist

  • OceanBase error code: 5733

  • Compatible MySQL error code: 1360

ERROR 1362 (HY000) : Updating of %s row is not allowed in %s trigger

  • OceanBase error code: 9584

  • Compatible MySQL error code: 1362

ERROR 1363 (HY000) : There is no %s row in on %s trigger

  • OceanBase error code: 9640

  • Compatible MySQL error code: 1363

ERROR 1364 (HY000) : Field \'%s\' doesn't have a default value

  • OceanBase error code: 4227

  • Compatible MySQL error code: 1364

ERROR 1365 (22012) : Divided by zero

  • OceanBase error code: 4078

  • Compatible MySQL error code: 1365

ERROR 1366 (22007) : Incorrect datetime value: '%s' for column '%s'

  • OceanBase error code: 4219

  • Compatible MySQL error code: 1366

ERROR 1366 (HY000) : Incorrect integer value for column '%.*s' at row %ld

  • OceanBase error code: 4226

  • Compatible MySQL error code: 1366

ERROR 1366 (HY000) : Incorrect string value for column '%.*s' at row %ld

  • OceanBase error code: 4258

  • Compatible MySQL error code: 1366

ERROR 1367 (22007) : Illegal %s '%.*s' value found during parsing

  • OceanBase error code: 5332

  • Compatible MySQL error code: 1367

ERROR 1368 (HY000) : CHECK OPTION on non-updatable view '%.*s.%.*s'

  • OceanBase error code: 5972

  • Compatible MySQL error code: 1368

ERROR 1369 (HY000) : CHECK OPTION failed '%.*s.%.*s'

  • OceanBase error code: 5971

  • Compatible MySQL error code: 1369

ERROR 1370 (42000) : %.*s command denied to user '%.*s'@'%.*s' for routine '%.*s'

  • OceanBase error code: 5387

  • Compatible MySQL error code: 1370

  • Cause: The user is denied the permission to execute the routine command.

  • Solution: Check whether the user has the corresponding privilege and whether there are spelling errors in the stored procedure or function name.

ERROR 1382 (HY000) : The '%.*s' syntax is reserved for purposes internal to the OceanBase Server

  • OceanBase error code: 5405

  • Compatible MySQL error code: 1382

ERROR 1390 (54000) : Prepared statement contains too many placeholders

  • OceanBase error code: 5080

  • Compatible MySQL error code: 1390

ERROR 1391 (HY000) : Key part \'%.*s\' length cannot be 0

  • OceanBase error code: 5191

  • Compatible MySQL error code: 1391

ERROR 1393 (HY000) : Can not modify more than one base table through a join view '%.*s.%.*s'

  • OceanBase error code: 5718

  • Compatible MySQL error code: 1393

ERROR 1395 (HY000) : Can not delete from join view '%.*s.%.*s'

  • OceanBase error code: 5720

  • Compatible MySQL error code: 1395

ERROR 1396 (HY000) : Operation %.*s failed for %.*s

  • OceanBase error code: 5155

  • Compatible MySQL error code: 1396

ERROR 1397 (XAE04) : Unknown XID

  • OceanBase error code: 6245

  • Compatible MySQL error code: 1397

ERROR 1398 (XAE05) : XAER_INVAL: Invalid arguments (or unsupported command)

  • OceanBase error code: 6249

  • Compatible MySQL error code: 1398

ERROR 1399 (XAE07) : The command cannot be executed when global transaction is in the %s state

  • OceanBase error code: 6246

  • Compatible MySQL error code: 1399

ERROR 1399 (XAE07) : RMFAIL: The command cannot be executed when global transaction is in the %s state

  • OceanBase error code: 6258

  • Compatible MySQL error code: 1399

ERROR 1400 (XAE09) : Some work is done outside global transaction

  • OceanBase error code: 6248

  • Compatible MySQL error code: 1400

ERROR 1401 (XAE03) : XAER_RMERR: Fatal error occurred in the transaction branch - check your data for consistency

  • OceanBase error code: 6250

  • Compatible MySQL error code: 1401

ERROR 1402 (XA100) : XA_RBROLLBACK: Transaction branch was rolled back

  • OceanBase error code: 6252

  • Compatible MySQL error code: 1402

ERROR 1406 (22001) : Data too long for column '%.*s' at row %ld

  • OceanBase error code: 5167

  • Compatible MySQL error code: 1406

ERROR 1406 (22001) : Data too long for column

  • OceanBase error code: 5354

  • Compatible MySQL error code: 1406

ERROR 1407 (42000) : Bad SQLSTATE: \'%.*s\'

  • OceanBase error code: 5585

  • Compatible MySQL error code: 1407

ERROR 1410 (42000) : You are not allowed to create a user with GRANT

  • OceanBase error code: 5169

  • Compatible MySQL error code: 1410

ERROR 1411 (HY000) : Incorrect %.*s value: '%.*s' for function %.*s

  • OceanBase error code: 5936

  • Compatible MySQL error code: 1411

ERROR 1411 (HY000) : Incorrect string value for function %s

  • OceanBase error code: 11062

  • Compatible MySQL error code: 1411

  • Cause: The string value for function %s is incorrect.

  • Solution: Check the function to ensure its validity.

ERROR 1413 (42000) : Duplicate handler declared in the same block

  • OceanBase error code: 5581

  • Compatible MySQL error code: 1413

ERROR 1414 (42000) : OUT or INOUT argument %d for routine %.*s is not a variable

  • OceanBase error code: 5592

  • Compatible MySQL error code: 1414

ERROR 1415 (0A000) : Not allowed to return a result set from a %s

  • OceanBase error code: 5579

  • Compatible MySQL error code: 1415

ERROR 1416 (22003) : Cannot get geometry object from data you send to the GEOMETRY field.

  • OceanBase error code: 7276

  • Compatible MySQL error code: 1416

ERROR 1422 (HY000) : Explicit or implicit commit is not allowed in stored function or trigger

  • OceanBase error code: 5576

  • Compatible MySQL error code: 1422

ERROR 1422 (HY000) : '%.*s' is not allowed in stored function or trigger

  • OceanBase error code: 9576

  • Compatible MySQL error code: 1422

ERROR 1424 (HY000) : Recursive stored functions are not allowed

  • OceanBase error code: 5570

  • Compatible MySQL error code: 1424

ERROR 1425 (42000) : Too big scale %d specified for column '%s'. Maximum is %ld

  • OceanBase error code: 5202

  • Compatible MySQL error code: 1425

ERROR 1426 (42000) : Too big precision %d specified for column '%s'. Maximum is %ld

  • OceanBase error code: 5203

  • Compatible MySQL error code: 1426

ERROR 1427 (42000) : For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column '%s')

  • OceanBase error code: 5204

  • Compatible MySQL error code: 1427

ERROR 1435 (HY000) : Trigger in wrong schema

  • OceanBase error code: 9582

  • Compatible MySQL error code: 1435

ERROR 1439 (42000) : Display width out of range for column '%s' (max = %ld)

  • OceanBase error code: 5205

  • Compatible MySQL error code: 1439

ERROR 1439 (42000) : Display width out of range for column '%.*s' (max = %d)

  • OceanBase error code: 9578

  • Compatible MySQL error code: 1439

ERROR 1440 (XAE08) : The XID already exists

  • OceanBase error code: 6247

  • Compatible MySQL error code: 144

ERROR 1441 (22008) : Datetime overflow

  • OceanBase error code: 4261

  • Compatible MySQL error code: 1441

ERROR 1442 (HY000) : Can't update table \'%s\' in stored function/trigger because it is already used by statement which invoked this stored function/trigger

  • OceanBase error code: 5791

  • Compatible MySQL error code: 1442

ERROR 1444 (HY000) : The prepared statement contains a stored routine call that refers to that same statement. It's not allowed to execute a prepared statement in such a recursive manner

  • OceanBase error code: 11016

  • Compatible MySQL error code: 1444

  • Cause: The prepared statement contains a recursive call to itself.

  • Solution: Modify the logic of the stored procedure/function to avoid recursive calls to prepared statements.

ERROR 1445 (HY000) : Not allowed to set autocommit from a stored function or trigger

  • OceanBase error code: 5591

  • Compatible MySQL error code: 1445

ERROR 1449 (HY000) : User not exist

  • OceanBase error code: 5035

  • Compatible MySQL error code: 1449

ERROR 1451 (23000) : Cannot delete or update a parent row: a foreign key constraint fails

  • OceanBase error code: 5314

  • Compatible MySQL error code: 1451

ERROR 1451 (23000) : Cannot delete or update a parent row: a foreign key constraint fails

  • OceanBase error code: 5618

  • Compatible MySQL error code: 1451

ERROR 1452 (23000) : Cannot add or update a child row: a foreign key constraint fails

  • OceanBase error code: 5315

  • Compatible MySQL error code: 1452

ERROR 1456 (HY000) : Recursive limit %ld (as set by the max_sp_recursion_depth variable) was exceeded for routine

  • OceanBase error code: 5567

  • Compatible MySQL error code: 1456

ERROR 1458 (42000) : Incorrect routine name \'%.*s\'

  • OceanBase error code: 5588

  • Compatible MySQL error code: 1458

ERROR 1462 (42S02) : \'%.*s'.'%.*s\' contains view recursion

  • OceanBase error code: 5239

  • Compatible MySQL error code: 1462

ERROR 1466 (HY000) : Leading spaces are removed from name \'%.*s\'

  • OceanBase error code: 5247

  • Compatible MySQL error code: 1466

ERROR 1467 (HY000) : Failed to read auto increment value from storage engine

  • OceanBase error code: 5184

  • Compatible MySQL error code: 1467

ERROR 1470 (HY000) : String '%.*s' is too long for user name (should be no longer than 64)

  • OceanBase error code: 5181

  • Compatible MySQL error code: 1470

ERROR 1471 (HY000) : The target table %.*s of the INSERT is not insertable-into

  • OceanBase error code: 5717

  • Compatible MySQL error code: 1471

ERROR 1474 (HY000) : Name \'%.*s\' has become ''

  • OceanBase error code: 5246

  • Compatible MySQL error code: 1474

ERROR 1475 (42000) : Ambiguous column

  • OceanBase error code: 5015

  • Compatible MySQL error code: 1475

ERROR 1480 (HY000) : Only RANGE PARTITIONING can use VALUES LESS THAN in partition definition

  • OceanBase error code: 5878

  • Compatible MySQL error code: 1480

  • Cause: VALUES LESS THAN can only be used in partition definitions that employ RANGE PARTITIONING.

  • Solution: Use the correct syntax for partition definitions based on the table's partitioning scheme.

ERROR 1486 (HY000) : Constant or random or timezone-dependent expressions in sub)partitioning function are not allowed

  • OceanBase error code: 5230

  • Compatible MySQL error code: 1486

ERROR 1488 (HY000) : Field in list of fields for partition function not found in table

  • OceanBase error code: 5255

  • Compatible MySQL error code: 1488

ERROR 1491 (HY000) : The PARTITION function returns the wrong type

  • OceanBase error code: 5257

  • Compatible MySQL error code: 1491

ERROR 1493 (HY000) : VALUES LESS THAN value must be strictly increasing for each partition%.*s

  • OceanBase error code: 5281

  • Compatible MySQL error code: 1493

ERROR 1493 (HY000) : VALUES LESS THAN value must be strictly increasing for each partition

  • OceanBase error code: 5353

  • Compatible MySQL error code: 1493

ERROR 1495 (HY000) : Multiple definition of same constant in list partitioning

  • OceanBase error code: 5340

  • Compatible MySQL error code: 1495

ERROR 1499 (HY000) : Too many partitions (including subpartitions) were defined

  • OceanBase error code: 5188

  • Compatible MySQL error code: 1499

ERROR 1500 (HY000) : It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning

  • OceanBase error code: 4398
  • Compatible MySQL error code: 1500
  • Cause: When creating a partitioned table, incompatible partitioning methods were used. For example, RANGE/LIST partitioning and HASH/KEY partitioning were used together in subpartitions.
  • Solution:
    • Modify the partitioning method: If you need to use RANGE/LIST partitioning and HASH/KEY partitioning together in subpartitions, consider modifying the partitioning method to use a compatible one. Note that modifying the partitioning method or splitting a partitioned table may affect existing data and applications. Proceed with caution.
    • Split the partition: If you need to use incompatible partitioning methods, consider splitting the partitioned table into multiple tables, each using a different partitioning method.

ERROR 1503 (HY000) : A %s must include all columns in the table's partitioning function

  • OceanBase error code: 5261

  • Compatible MySQL error code: 1503

ERROR 1503 (HY000) : A PRIMARY KEY must include all columns in the table\'s partitioning function

  • OceanBase error code: 5283

  • Compatible MySQL error code: 1503

ERROR 1504 (HY000) : Number of partitions = 0 is not an allowed value

  • OceanBase error code: 5189

  • Compatible MySQL error code: 1504

ERROR 1505 (HY000) : Partition management on a not partitioned table is not possible

  • OceanBase error code: 5302

  • Compatible MySQL error code: 1505

ERROR 1507 (HY000) : error in list of partitions to DROP

  • OceanBase error code: 5303

  • Compatible MySQL error code: 1507

ERROR 1508 (HY000) : Cannot remove all partitions, use DROP TABLE instead

  • OceanBase error code: 5306

  • Compatible MySQL error code: 1508

ERROR 1512 (HY000) : %s PARTITION can only be used on RANGE/LIST partitions

  • OceanBase error code: 5305

  • Compatible MySQL error code: 1512

ERROR 1517 (HY000) : Duplicate partition name \'%.*s\'

  • OceanBase error code: 5280

  • Compatible MySQL error code: 1517

ERROR 1517 (HY000) : Duplicate partition name %.*s

  • OceanBase error code: 5493
  • Compatible MySQL error code: 1517
  • Cause: When modifying a table partition name, the new name duplicates an existing partition name in the table. (Since MySQL does not have a concept of subpartitions, this error code is shared by both partition and subpartition names.)
  • Solution: Rename the partition or delete the partition with the duplicate name.

ERROR 1517 (HY000) : Duplicate partition name %.*s

  • OceanBase error code: 5494
  • Compatible MySQL error code: 1517
  • Cause: The partition name is duplicated.
  • Solution: Rename the partition or delete the duplicate partition.

ERROR 1517 (HY000) : missing or invalid WAIT interval

  • OceanBase error code: 5495
  • Compatible MySQL error code: 1517
  • Cause: The wait time parameter specified in the MySQL WAIT command is invalid or missing.
  • Solution: Check the syntax of the WAIT command you are using and ensure the wait time parameter is correct.

ERROR 1520 (HY000) : Reorganize of range partitions cannot change total ranges except for last partition where it can extend the range

  • OceanBase error code: 5566

  • Compatible MySQL error code: 1520

ERROR 1524 (HY000) : Plugin '%.*s' is not loaded

  • OceanBase error code: 11003

  • Compatible MySQL error code: 1524

  • Cause:

    • The input plugin type is not supported.
    • The input plugin type is supported (currently, OceanBase AI Database only supports the mysql_native_password type), but the plugin was not correctly loaded by the program.
  • Solution:

    • Check whether the plugin type is supported.
    • Check whether the loading statement, configuration file, and version of the plugin are correct.
    • Check whether sufficient privileges are available to load and install the plugin.

ERROR 1525 (HY000) : Incorrect %s value: '%s'

  • OceanBase error code: 5241

  • Compatible MySQL error code: 1525

ERROR 1525 (HY000) : XML parsing failed

  • OceanBase error code: 9549

  • Compatible MySQL error code: 1525

  • Cause: The XML parser returned an error while attempting to parse the document.

  • Solution: Check whether the document to be parsed is valid.

ERROR 1526 (HY000) : Table has no partition for value

  • OceanBase error code: 5284

  • Compatible MySQL error code: 1526

ERROR 1537 (HY000) : Event '%.*s' already exists

  • OceanBase error code: 9768

  • Compatible MySQL error code: 1537

  • Cause: The name of the event being created conflicts with an existing event name.

  • Solution: Choose a different, unique name for the new event.

ERROR 1539 (HY000) : Unknown '%.*s' event

  • OceanBase error code: 9769

  • Compatible MySQL error code: 1539

  • Cause: The event that you are trying to access or operate on does not exist.

  • Solution: Verify that the event name is correct and that the target event exists.

ERROR 1540 (HY000) : Failed to alter event '%.*s'

  • OceanBase error code: 9770

  • Compatible MySQL error code: 1540

  • Cause: Failed to modify the event.

  • Solution: Ensure that the syntax of the ALTER EVENT statement is correct, including the attributes and values to be modified.

ERROR 1541 (HY000) : Failed to drop %.*s

  • OceanBase error code: 9771

  • Compatible MySQL error code: 1541

  • Cause: Failed to drop an event, table, or other database object.

  • Solution: Use the corresponding query statement to confirm the exact name and existence of the object.

ERROR 1542 (HY000) : INTERVAL is either not positive or too big

  • OceanBase error code: 9772

  • Compatible MySQL error code: 1542

  • Cause: The specified time interval (INTERVAL) when defining an event is not a positive number or exceeds the allowed maximum value.

  • Solution: Ensure the INTERVAL value is positive. If the interval value is too large, adjust it to a reasonable range based on your needs and system limitations.

ERROR 1543 (HY000) : ENDS is either invalid or before STARTS

  • OceanBase error code: 9773

  • Compatible MySQL error code: 1543

  • Cause: The event end time (ENDS) is either invalid or earlier than the start time (STARTS).

  • Solution: Confirm that the ENDS timestamp is correct and later than the STARTS time.

ERROR 1544 (HY000) : Event execution time is in the past. Event has been disabled

  • OceanBase error code: 9774

  • Compatible MySQL error code: 1544

  • Cause: The start time set when creating the event is earlier than the current time.

  • Solution: Update the event's start time to a future point in time to ensure it is valid.

ERROR 1549 (HY000) : Failed to delete the event from mysql.event

  • OceanBase error code: 9775

  • Compatible MySQL error code: 1549

  • Cause: Failed to delete an event from the mysql.event table.

  • Solution: Ensure the current user has the permission to delete events.

ERROR 1551 (HY000) : Same old and new event name

  • OceanBase error code: 9776

  • Compatible MySQL error code: 1551

  • Cause: The operation is invalid because the new name is the same as the old name when you try to rename an event.

  • Solution: Specify a new name that is different from the current event name in the ALTER EVENT statement.

ERROR 1552 (HY000) : Data for column '%.*s' too long

  • OceanBase error code: 9777

  • Compatible MySQL error code: 1552

  • Cause: The length of data inserted into a column exceeds the maximum length defined for that column.

  • Solution: Check and shorten the length of the inserted data to ensure it does not exceed the column's maximum length limit.

ERROR 1562 (HY000) : Cannot create temporary table with partitions

  • OceanBase error code: 5310

  • Compatible MySQL error code: 1562

ERROR 1563 (HY000) : Partition constant is out of partition function domain

  • OceanBase error code: 5286

  • Compatible MySQL error code: 1563

ERROR 1564 (HY000) : This partition function is not allowed

  • OceanBase error code: 5262

  • Compatible MySQL error code: 1564

ERROR 1566 (HY000) : Not allowed to use NULL value in VALUES LESS THAN

  • OceanBase error code: 5285

  • Compatible MySQL error code: 1566

ERROR 1567 (HY000) : Incorrect partition name '%.*s'

  • OceanBase error code: 11002

  • Compatible MySQL error code: 1567

  • Cause: The partition name is incorrect.

  • Solution: Please check whether the partition name is entered correctly.

ERROR 1568 (25001) : Transaction characteristics can't be changed while a transaction is in progress

  • OceanBase error code: 5219

  • Compatible MySQL error code: 1568

ERROR 1576 (HY000) : Recursion of EVENT DDL statements is forbidden when body is present

  • OceanBase error code: 9780

  • Compatible MySQL error code: 1576

  • Cause: A DDL operation attempts to directly or indirectly modify itself again. Recursive execution of an event's DDL statements is prohibited when the event definition contains a body.

  • Solution: Check the DDL statement to ensure it does not directly or indirectly reference the event being created or modified.

ERROR 1582 (42000) : Incorrect parameter count in the call to native function '%.*s'

  • OceanBase error code: 5054

  • Compatible MySQL error code: 1582

ERROR 1583 (42000) : Incorrect parameters in the call to native function '%.*s'

  • OceanBase error code: 5407

  • Compatible MySQL error code: 1583

ERROR 1588 (HY000) : Event execution time is in the past and ON COMPLETION NOT PRESERVE is set. The event was dropped immediately after creation.

  • OceanBase error code: 9778

  • Compatible MySQL error code: 1588

  • Cause: The event was automatically dropped immediately after creation because its execution time was in the past.

  • Solution: Set the event's start time to a future point to ensure it is executed in the future.

ERROR 1589 (HY000) : Event execution time is in the past. The event was not changed. Specify a time in the future.

  • OceanBase error code: 9779

  • Compatible MySQL error code: 1589

  • Cause: The execution time of the event being modified is in the past, so the modification did not take effect.

  • Solution: Ensure the modified event execution time is in the future so that the event can be scheduled properly.

ERROR 1613 (XA106) : XA_RBTIMEOUT: Transaction branch was rolled back: took too long

  • OceanBase error code: 6253

  • Compatible MySQL error code: 1613

ERROR 1621 (HY000) : variable is read only", "%.*s variable '%.*s' is read-only. Use SET %.*s to assign the value

  • OceanBase error code: 5102

  • Compatible MySQL error code: 1621

ERROR 1628 (HY000) : Comment for table is too long (max = %ld)

  • OceanBase error code: 4229

  • Compatible MySQL error code: 1628

ERROR 1629 (HY000) : Comment for field is too long (max = %ld)

  • OceanBase error code: 4230

  • Compatible MySQL error code: 1629

ERROR 1642 (01000) : Unhandled user-defined warning condition

  • OceanBase error code: 9701

  • Compatible MySQL error code: 1642

ERROR 1644 (HY000) : Unhandled user-defined exception condition

  • OceanBase error code: 5556

  • Compatible MySQL error code: 1644

ERROR 1645 (0K000) : RESIGNAL when handler not active

  • OceanBase error code: 9702

  • Compatible MySQL error code: 1645

ERROR 1646 (HY000) : SIGNAL/RESIGNAL can only use a CONDITION defined with SQLSTATE

  • OceanBase error code: 5557

  • Compatible MySQL error code: 1646

ERROR 1652 (HY000) : Duplicate partition field name '%.*s'

  • OceanBase error code: 5237

  • Compatible MySQL error code: 1652

ERROR 1653 (HY000) : Inconsistency in usage of column lists for partitioning

  • OceanBase error code: 5276

  • Compatible MySQL error code: 1653

ERROR 1654 (HY000) : Partition column values of incorrect type

  • OceanBase error code: 5275

  • Compatible MySQL error code: 1654

ERROR 1654 (HY000) : Partition column values of incorrect type

  • OceanBase error code: 5349

  • Compatible MySQL error code: 1654

ERROR 1654 (HY000) : Partition column values of incorrect type

  • OceanBase error code: 5355

  • Compatible MySQL error code: 1654

ERROR 1655 (HY000) : Too many fields in \'list of partition fields\'

  • OceanBase error code: 5287

  • Compatible MySQL error code: 1655

ERROR 1657 (HY000) : Cannot have more than one value for this type of RANGE partitioning

  • OceanBase error code: 5277

  • Compatible MySQL error code: 1657

ERROR 1659 (HY000) : Field \'%.*s\' is of a not allowed type for this type of partitioning

  • OceanBase error code: 5178

  • Compatible MySQL error code: 1659

ERROR 1688 (HY000) : Comment for index is too long (max = %ld)

  • OceanBase error code: 4231

  • Compatible MySQL error code: 1688

ERROR 1690 (22003) : %s value is out of range in '%s'

  • OceanBase error code: 4157

  • Compatible MySQL error code: 1690

ERROR 1697 (HY000) : VALUES value for partition \'%.*s\' must have type INT

  • OceanBase error code: 5274

  • Compatible MySQL error code: 1697

ERROR 1701 (42000) : Cannot truncate a table referenced in a foreign key constraint %.*s

  • OceanBase error code: 5594

  • Compatible MySQL error code: 1701

ERROR 1706 (HY000) : Primary key/index key/partition key update is not allowed since the table is updated both as '%.*s' and '%.*s'

  • OceanBase error code: 5344

  • Compatible MySQL error code: 1706

ERROR 1708 (HY000) : The value of \'%s\' should be no less than the value of \'%s\'

  • OceanBase error code: 5266

  • Compatible MySQL error code: 1708

ERROR 1731 (HY000) : Non matching attribute '%s' between partition and table

  • OceanBase error code: 4773

  • Compatible MySQL error code: 1731

  • Cause: Some attributes do not match between the partition and the table.

  • Solution: Check the attributes between the partition and the table to ensure they match.

ERROR 1732 (HY000) : Table to exchange with partition is partitioned: '%.*s'

  • OceanBase error code: 11017

  • Compatible MySQL error code: 1732

  • Cause: The table you are trying to exchange is a partitioned table.

  • Solution: Select a non-partitioned table for the exchange.

ERROR 1735 (HY000) : Unkown partition '%.*s' in table '%.*s'

  • OceanBase error code: 5146

  • Compatible MySQL error code: 1735

ERROR 1736 (HY000) : Tables have different definitions

  • OceanBase error code: 4772

  • Compatible MySQL error code: 1736

  • Cause: The definitions of the two tables are different.

  • Solution: Compare the schema definitions of the two tables to ensure they match, including table structure, field types, and the number of fields.

ERROR 1748 (HY000) : Found a row not matching the given partition set

  • OceanBase error code: 5147

  • Compatible MySQL error code: 1748

ERROR 1758 (35000) : Invalid condition number

  • OceanBase error code: 9696

  • Compatible MySQL error code: 1758

ERROR 1792 (25006) : Cannot execute statement in a READ ONLY transaction

  • OceanBase error code: 5220

  • Compatible MySQL error code: 1792

ERROR 1792 (25006) : Cannot execute statement in a READ ONLY transaction

  • OceanBase error code: 6226

  • Compatible MySQL error code: 1792

ERROR 1819 (HY000) : Your password does not satisfy the current policy requirements

  • OceanBase error code: 4365

  • Compatible MySQL error code: 1819

ERROR 1820 (HY000) : You must reset your password using ALTER USER statement before executing this statement

  • OceanBase error code: 4366

  • Compatible MySQL error code: 1820

ERROR 1827 (42000) : The password hash doesn't have the expected format. Check if the correct password algorithm is being used with the PASSWORD() function

  • OceanBase error code: 5227

  • Compatible MySQL error code: 1827

ERROR 1830 (HY000) : Column '%s' cannot be NOT NULL: needed in a foreign key constraint '%s' SET NULL

  • OceanBase error code: 5512

  • Compatible MySQL error code: 1830

  • Cause: A column cannot be set to NOT NULL because it needs to be set to SET NULL in a foreign key constraint.

  • Solution: Set the column to allow NULL, or modify the foreign key constraint to use another operation (such as SET DEFAULT).

ERROR 1830 (HY000) : Cannot define foreign key with ON DELETE SET NULL clause on a generated column

  • OceanBase error code: 5513

  • Compatible MySQL error code: 1830

  • Cause: A foreign key constraint with an ON DELETE SET NULL clause cannot be defined on a virtual column.

  • Solution: Do not define a foreign key constraint with an ON DELETE SET NULL clause on a virtual column.

ERROR 1831 (HY000) : Duplicate index '%s' defined on the table '%s.%s'

  • OceanBase error code: 9137

  • Compatible MySQL error code: 1831

  • Cause: An attempt was made to create an index that already exists.

  • Solution: Check whether the specified index exists. If so, delete or modify the existing index and then recreate the new one.

ERROR 1869 (HY000) : Auto-increment value in UPDATE conflicts with internally generated values

  • OceanBase error code: 5244

  • Compatible MySQL error code: 1869

ERROR 1882 (HY000) : The initialization vector supplied to aes_encrypt is too short. Must be at least 16 bytes long

  • OceanBase error code: 4336

  • Compatible MySQL error code: 1882

ERROR 3004 (0Z002) : GET STACKED DIAGNOSTICS when handler not active

  • OceanBase error code: 5402

  • Compatible MySQL error code: 3004

ERROR 3011 (HY000) : Referenced trigger '%s' for the given action time and event type does not exist

  • OceanBase error code: 9704

  • Compatible MySQL error code: 3011

  • Cause: The query execution time exceeded the maximum allowed by the system. This exceeds the threshold set by the max_execution_time parameter.

  • Solution: Adjust the max_execution_time parameter.

ERROR 3020 (2201E) : Invalid argument for logarithm

  • OceanBase error code: 5565

  • Compatible MySQL error code: 3020

ERROR 3024 (HY000) : maybe you can adjust the session variable max_execution_time or max_execution_time hint, and try again

  • OceanBase error code: 4412

  • Compatible MySQL error code: 3024

ERROR 3028 (HY000) : Expression #%d of ORDER BY contains aggregate function and applies to a UNION

  • OceanBase error code: 5263

  • Compatible MySQL error code: 3028

ERROR 3033 (HY000) : Binary geometry function %s given two geometries of different srids: %u and %u, which should have been identical

  • OceanBase error code: 7201

  • Compatible MySQL error code: 3033

ERROR 3034 (HY000) : Calling geometry function %s with unsupported types of arguments

  • OceanBase error code: 7202

  • Compatible MySQL error code: 3034

ERROR 3035 (HY000) : Unknown GIS error occurred in function %s

  • OceanBase error code: 7203

  • Compatible MySQL error code: 3035

ERROR 3036 (HY000) : Unknown exception caught in GIS function %s

  • OceanBase error code: 7204

  • Compatible MySQL error code: 3036

ERROR 3037 (22023) : Invalid GIS data provided to function %s

  • OceanBase error code: 7205

  • Compatible MySQL error code: 3037

ERROR 3038 (HY000) : The geometry has no data in function %s.

  • OceanBase error code: 7206

  • Compatible MySQL error code: 3038

ERROR 3039 (HY000) : Unable to calculate centroid because geometry is empty in function %s.

  • OceanBase error code: 7207

  • Compatible MySQL error code: 3039

ERROR 3040 (HY000) : Geometry overlay calculation error: geometry data is invalid in function %s.

  • OceanBase error code: 7208

  • Compatible MySQL error code: 3040

ERROR 3041 (HY000) : Geometry turn info calculation error: geometry data is invalid in function %s.

  • OceanBase error code: 7209

  • Compatible MySQL error code: 3041

ERROR 3042 (HY000) : Analysis procedures of intersection points interrupted unexpectedly in function %s.

  • OceanBase error code: 7210

  • Compatible MySQL error code: 3042

ERROR 3043 (HY000) : Unknown exception thrown in function %s.

  • OceanBase error code: 7211

  • Compatible MySQL error code: 3043

ERROR 3044 (HY000) : Memory allocation error: %-.256s in function %s.

  • OceanBase error code: 7265

  • Compatible MySQL error code: 3044

ERROR 3045 (HY000) : Domain error", "Domain error: %-.256s in function %s.

  • OceanBase error code: 7266

  • Compatible MySQL error code: 3045

ERROR 3046 (HY000) : Length error: %-.256s in function %s.

  • OceanBase error code: 7267

  • Compatible MySQL error code: 3046

ERROR 3047 (HY000) : Invalid argument error: %-.256s in function %s.

  • OceanBase error code: 7268

  • Compatible MySQL error code: 3047

ERROR 3048 (HY000) : Out of range error: %-.256s in function %s.

  • OceanBase error code: 7269

  • Compatible MySQL error code: 3048

ERROR 3049 (HY000) : Overflow error: %-.256s in function %s.

  • OceanBase error code: 7270

  • Compatible MySQL error code: 3049

ERROR 3530 (HY000) : role '%.*s' not granted or does not exist

  • OceanBase error code: 5377

  • Compatible MySQL error code: 3530

  • Cause: The role '%.*s' has not been granted or does not exist.

  • Solution: Ensure that the role '%.*s' has been correctly granted and exists in the system.

ERROR 3530 (HY000) : %.*s@%.*s is not granted to %.*s@%.*s

  • OceanBase error code: 5379

  • Compatible MySQL error code: 3530

  • Cause: %.*s@%.*s has not been granted to %.*s@%.*s.

  • Solution: Ensure that the authorization %.*s@%.*s has been correctly granted to %.*s@%.*s.

ERROR 3050 (HY000) : Range error: %-.256s in function %s.

  • OceanBase error code: 7271

  • Compatible MySQL error code: 3050

ERROR 3051 (HY000) : Underflow error: %-.256s in function %s.

  • OceanBase error code: 7272

  • Compatible MySQL error code: 3051

ERROR 3052 (HY000) : Logic error: %-.256s in function %s.

  • OceanBase error code: 7273

  • Compatible MySQL error code: 3052

ERROR 3053 (HY000) : Runtime error: %-.256s in function %s.

  • OceanBase error code: 7274

  • Compatible MySQL error code: 3053

ERROR 3054 (HY000) : Unknown exception: %-.384s in function %s.

  • OceanBase error code: 7275

  • Compatible MySQL error code: 3054

ERROR 3055 (HY000) : Geometry byte string must be little endian.

  • OceanBase error code: 7212

  • Compatible MySQL error code: 3055

ERROR 3060 (HY000) : Do not support online operation on table with GIS index

  • OceanBase error code: 7213

  • Compatible MySQL error code: 3060

ERROR 3061 (42000) : User variable name %.*s is illegal

  • OceanBase error code: 11013

  • Compatible MySQL error code: 3061

  • Cause: The user variable name is invalid. Its length cannot exceed 1,024 characters.

  • Solution: Change the user variable name to a valid one.

ERROR 3064 (HY000) : invalid type given for an argument

  • OceanBase error code: 5351

  • Compatible MySQL error code: 3064

ERROR 3105 (HY000) : The value specified for generated column '%.*s' in table '%.*s' is not allowed

  • OceanBase error code: 5290

  • Compatible MySQL error code: 3105

ERROR 3106 (HY000) : '%s' is not supported for generated columns

  • OceanBase error code: 5292

  • Compatible MySQL error code: 3106

ERROR 3108 (HY000) : Column '%.*s' has a generated column dependency

  • OceanBase error code: 5293

  • Compatible MySQL error code: 3108

ERROR 3118 (HY000) : User locked

  • OceanBase error code: 5039

  • Compatible MySQL error code: 3118

ERROR 3122 (HY000) : Inconsistent intersection points.

  • OceanBase error code: 7214

  • Compatible MySQL error code: 3122

ERROR 3134 (HY000) : Parameter %s exceeds the maximum number of points in a geometry (%lu) in function %s.

  • OceanBase error code: 7215

  • Compatible MySQL error code: 3134

ERROR 3140 (22032) : Invalid JSON text

  • OceanBase error code: 5411

  • Compatible MySQL error code: 3140

ERROR 3141 (22032) : Invalid JSON text in argument

  • OceanBase error code: 5412

  • Compatible MySQL error code: 3141

ERROR 3142 (42000) : The JSON binary value contains invalid data

  • OceanBase error code: 5413

  • Compatible MySQL error code: 3142

ERROR 3143 (42000) : Invalid JSON path expression

  • OceanBase error code: 5414

  • Compatible MySQL error code: 3143

ERROR 3144 (22032) : Cannot create a JSON value from a string

  • OceanBase error code: 5415

  • Compatible MySQL error code: 3144

ERROR 3145 (22032) : Invalid JSON character data provided to function

  • OceanBase error code: 5416

  • Compatible MySQL error code: 3145

ERROR 3146 (22032) : Invalid data type for JSON data in argument %u to function %s; a JSON string or JSON type is required

  • OceanBase error code: 5417

  • Compatible MySQL error code: 3146

ERROR 3147 (22032) : Cannot CAST value to JSON

  • OceanBase error code: 5418

  • Compatible MySQL error code: 3147

ERROR 3148 (42000) : A path expression must be encoded in the utf8 character set

  • OceanBase error code: 5419

  • Compatible MySQL error code: 3148

ERROR 3149 (42000) : In this situation, path expressions may not contain the * and ** tokens

  • OceanBase error code: 5420

  • Compatible MySQL error code: 3149

ERROR 3150 (22032) : The JSON value is too big to be stored in a JSON column

  • OceanBase error code: 5421

  • Compatible MySQL error code: 3150

ERROR 3151 (22032) : The JSON object contains a key name that is too long

  • OceanBase error code: 5422

  • Compatible MySQL error code: 3151

ERROR 1351 (HY000) : View's SELECT contains a variable or parameter

  • OceanBase error code: 9748
  • Compatible MySQL error code: 1351
  • Cause: The SELECT statement of the view contains variables or parameters.
  • Solution: Check the query statement to ensure it does not contain variables or parameters.

ERROR 3153 (42000) : The path expression is not allowed in this context

  • OceanBase error code: 5424

  • Compatible MySQL error code: 3153

ERROR 3154 (42000) : The oneOrAll argument may take these values: \'one\' or \'all\'

  • OceanBase error code: 5425

  • Compatible MySQL error code: 3154

ERROR 3155 (22003) : Out of range JSON value for CAST

  • OceanBase error code: 5426

  • Compatible MySQL error code: 3155

ERROR 3156 (22018) : Invalid JSON value for CAST

  • OceanBase error code: 5427

  • Compatible MySQL error code: 3156

ERROR 3157 (22032) : The JSON document exceeds the maximum depth

  • OceanBase error code: 5428

  • Compatible MySQL error code: 3157

ERROR 3158 (22032) : JSON documents may not contain NULL member names

  • OceanBase error code: 5429

  • Compatible MySQL error code: 3158

ERROR 3162 (HY000) : User %.*s does not exist

  • OceanBase error code: 11012

  • Compatible MySQL error code: 3162

  • Cause: User %.*s does not exist.

  • Solution: Ensure that the user %.*s to be operated on exists, or use another valid user to perform the operation.

ERROR 3163 (HY000) : Authorization ID '%.*s'@'%.*s' already exists

  • OceanBase error code: 11009

  • Compatible MySQL error code: 3163

  • Cause: Authorization ID '%.*s'@'%.*s' already exists.

  • Solution: Use a different authorization ID, or delete the existing authorization ID and try creating it again.

ERROR 3165 (42000) : A path expression is not a path to a cell in an array

  • OceanBase error code: 5431

  • Compatible MySQL error code: 3165

ERROR 3504 (HY000) : Too many enumeration valuesfor column %.*s

  • OceanBase error code: 5335

  • Compatible MySQL error code: 3504

ERROR 3505 (HY000) : Too long enumeration/setvalue for column %.*s

  • OceanBase error code: 5333

  • Compatible MySQL error code: 3505

ERROR 3516 (22S01) : %.64s value is a geometry of unexpected type %.64s in %.64s.

  • OceanBase error code: 7216

  • Compatible MySQL error code: 3516

ERROR 3516 (22S01) : Unknown WKB type(%d)! Full WKB type number was (%d).

  • OceanBase error code: 7288

  • Compatible MySQL error code: 3516

ERROR 3517 (SR002) : Can't parse the spatial reference system definition of SRID %u.

  • OceanBase error code: 7217

  • Compatible MySQL error code: 3517

ERROR 3518 (SR003) : The spatial reference system definition for SRID %u does not specify the mandatory %s (EPSG %u) projection parameter.

  • OceanBase error code: 7218

  • Compatible MySQL error code: 3518

ERROR 3519 (01000) : There's no spatial reference system with SRID %u.

  • OceanBase error code: 7219

  • Compatible MySQL error code: 3519

ERROR 3520 (22S00) : Function %s is only defined for Cartesian spatial reference systems, but one of its arguments is in SRID %u, which is not Cartesian.

  • OceanBase error code: 7220

  • Compatible MySQL error code: 3520

ERROR 3521 (SR001) : Function %s is only defined for Cartesian spatial reference systems, but one of its arguments is in SRID %u, which has not been defined.

  • OceanBase error code: 7221

  • Compatible MySQL error code: 3521

ERROR 3523 (HY000) : Unknown authorization ID %.*s@%.*s

  • OceanBase error code: 11007

  • Compatible MySQL error code: 3523

  • Cause: The authorization ID %.*s@%.*s is unknown.

  • Solution: Check whether the authorization ID %.*s@%.*s exists or is entered correctly.

ERROR 3548 (SR001) : There's no spatial reference system with SRID %u.

  • OceanBase error code: 7222

  • Compatible MySQL error code: 3548

ERROR 3548 (SR001) : Spatial reference system is empty

  • OceanBase error code: 7285

  • Compatible MySQL error code: 3548

ERROR 3558 (22023) : Invalid option key '%.192s' in function %.192s.

  • OceanBase error code: 7286

  • Compatible MySQL error code: 3558

ERROR 3559 (22023) : Invalid value '%.192s' for option '%.192s' in function '%.192s'.

  • OceanBase error code: 7287

  • Compatible MySQL error code: 3559

ERROR 3560 (22023) : The string '%.192s' is not a valid key %c value pair in function %.192s.

  • OceanBase error code: 7283

  • Compatible MySQL error code: 3560

ERROR 3565 (01000) : There's no spatial reference system with SRID %u. The axis order is unknown.

  • OceanBase error code: 7223

  • Compatible MySQL error code: 3565

ERROR 3573 (HY000) : Recursive Common Table Expression should contain a UNION ALL

  • OceanBase error code: 5742

  • Compatible MySQL error code: 3573

  • Cause: A recursive common table expression (CTE) must contain a UNION ALL operation.

  • Solution: Use a UNION ALL operation in the recursive CTE.

ERROR 3574 (HY000) : Recursive Common Table Expression should have one or more non-recursive query blocks followed by one or more recursive ones: %s

  • OceanBase error code: 5982

  • Compatible MySQL error code: 3574

ERROR 3575 (HY000) : ORDER BY / LIMIT / SELECT DISTINCT / HAVING / WINDOW FUNCTION / GROUP BY in recursive query block of Common Table Expression not supported

  • OceanBase error code: 5758

  • Compatible MySQL error code: 3575

  • Cause: ORDER BY, LIMIT, SELECT DISTINCT, HAVING, WINDOW FUNCTION, or GROUP BY is not supported in the common expression of a recursive query block.

  • Solution: Do not use ORDER BY, LIMIT, SELECT DISTINCT, HAVING, WINDOW FUNCTION, or GROUP BY in the common expression of a recursive query block.

ERROR 3576 (HY000) : In recursive query block of Recursive Common Table Expression, the recursive table must neither be in the right argument of a LEFT JOIN, nor be forced to be non-first with join order hints

  • OceanBase error code: 5759

  • Compatible MySQL error code: 3576

ERROR 3577 (HY000) : In recursive query block of Recursive Common Table Expression, the recursive table must be referenced only once, and not in any subquery

  • OceanBase error code: 5744

  • Compatible MySQL error code: 3577

ERROR 3581 (HY000) : A window which depends on another cannot define partitioning

  • OceanBase error code: 5438

  • Compatible MySQL error code: 3581

ERROR 3582 (HY000) : Window '%.*s' has a frame definition, so cannot be referenced by another window

  • OceanBase error code: 5439

  • Compatible MySQL error code: 3582

ERROR 3583 (HY000) : Window '%.*s' cannot inherit '%.*s' since both contain an ORDER BY clause

  • OceanBase error code: 5440

  • Compatible MySQL error code: 3583

ERROR 3586 (HY000) : Window '%.*s': frame start or end is negative or NULL or of non-integral type

  • OceanBase error code: 5507

  • Compatible MySQL error code: 3586

  • Cause: The start or end position of the window is negative, NULL, or of a non-integer type.

  • Solution: Correct the start or end position of the window to ensure it is non-negative, non-NULL, and of an integer type.

ERROR 3587 (HY000) : Window '%s' with RANGE N PRECEDING/FOLLOWING frame requires exactly one ORDER BY expression of numeric or temporal type

  • OceanBase error code: 5984

  • Compatible MySQL error code: 3587

ERROR 3588 (HY000) : Window '%.*s' with RANGE frame has ORDER BY expression of datetime type. Only INTERVAL bound value allowed.

  • OceanBase error code: 5508

  • Compatible MySQL error code: 3588

  • Cause: A window with a RANGE frame contains an ORDER BY expression based on a datetime type, and only INTERVAL boundary values are allowed.

  • Solution: Ensure that the ORDER BY expression in the window with a RANGE frame uses only INTERVAL boundary values, not datetime boundary values.

ERROR 3589 (HY000) : Window '%.*s' with RANGE frame has ORDER BY expression of numeric type. INTERVAL bound value not allowed.

  • OceanBase error code: 5509

  • Compatible MySQL error code: 3589

  • Cause: A window with a RANGE frame contains an ORDER BY expression of a numeric type, and INTERVAL boundary values are not allowed.

  • Solution: Do not use INTERVAL boundary values in a window where the ORDER BY expression is of a numeric type.

ERROR 3590 (HY000) : Window '%.*s' has a non-constant frame bound.

  • OceanBase error code: 5510

  • Compatible MySQL error code: 3590

  • Cause: The window has a non-constant frame boundary.

  • Solution: Ensure that the frame boundary of the window is a constant.

ERROR 3592 (HY000) : Window '%s': ORDER BY or PARTITION BY uses legacy position indication, which is not supported use expression

  • OceanBase error code: 5985

  • Compatible MySQL error code: 3592

ERROR 3596 (HY000) : Window '%s': INTERVAL can only be used with RANGE frames

  • OceanBase error code: 5983

  • Compatible MySQL error code: 3596

ERROR 3616 (22S02) : Longitude %f is out of range in function %.192s. It must be within (%f, %f].

  • OceanBase error code: 7263

  • Compatible MySQL error code: 3616

ERROR 3617 (22S03) : Latitude %f is out of range in function %.192s. It must be within [%f, %f].

  • OceanBase error code: 7264

  • Compatible MySQL error code: 3617

ERROR 3618 (22S00) : %.192s(%.80s) has not been implemented for geographic spatial reference systems.

  • OceanBase error code: 7224

  • Compatible MySQL error code: 3618

ERROR 3636 (HY000) : Recursive query aborted after %u iterations. Try increasing @@cte_max_recursion_depth to a larger value.

  • OceanBase error code: 5408

  • Compatible MySQL error code: 3636

ERROR 3643 (HY000) : The SRID of the geometry does not match the SRID of the column. The SRID of the geometry is %lu, but the SRID of the column is %lu. Consider changing the SRID of the geometry or the SRID property of the column.

  • OceanBase error code: 7225

  • Compatible MySQL error code: 3643

ERROR 3644 (HY000) : The SRID specification on the column '%.64s' cannot be changed because there is a spatial index on the column. Please remove the spatial index before altering the SRID specification.

  • OceanBase error code: 7226

  • Compatible MySQL error code: 3644

ERROR 3666 (42000) : Can't store an array or an object in the scalar %s column 'jpath'

  • OceanBase error code: 4298

  • Compatible MySQL error code: 3666

  • Cause: An array or object cannot be stored in a scalar column.

  • Solution: Convert the array or object to a scalar value, or change the column's data type to accommodate arrays or objects.

ERROR 3667 (42000) : Every table function must have an alias

  • OceanBase error code: 5515

  • Compatible MySQL error code: 3667

  • Cause: Each table function must have an alias.

  • Solution: Provide an alias for the table function.

ERROR 3674 (HY000) : The spatial index on column '%.64s' will not be used by the query optimizer since the column does not have an SRID attribute. Consider adding an SRID attribute to the column.

  • OceanBase error code: 7227

  • Compatible MySQL error code: 3674

ERROR 3682 (22S00) : Function %.192s is only defined for SRID 0 and SRID 4326.

  • OceanBase error code: 7228

  • Compatible MySQL error code: 3682

ERROR 3704 (22S00) : %.192s(%.80s) has not been implemented for Cartesian spatial reference systems.

  • OceanBase error code: 7229

  • Compatible MySQL error code: 3704

ERROR 3705 (22S00) : %.192s(%.80s) has not been implemented for projected spatial reference systems.

  • OceanBase error code: 7230

  • Compatible MySQL error code: 3705

ERROR 3706 (22023) : Invalid radius provided to function %s: Radius(%lf) must be greater than zero.

  • OceanBase error code: 7284

  • Compatible MySQL error code: 3706

ERROR 3708 (SR006) : Missing mandatory attribute %s.

  • OceanBase error code: 7231

  • Compatible MySQL error code: 3708

ERROR 3709 (SR006) : Multiple definitions of attribute %s.

  • OceanBase error code: 7232

  • Compatible MySQL error code: 3709

ERROR 3710 (SR006) : The spatial reference system name can't be an empty string or start or end with whitespace.

  • OceanBase error code: 7233

  • Compatible MySQL error code: 3710

ERROR 3711 (SR006) : The organization name can't be an empty string or start or end with whitespace.

  • OceanBase error code: 7234

  • Compatible MySQL error code: 3711

ERROR 3712 (SR004) : There is already a spatial reference system with SRID %u.

  • OceanBase error code: 7235

  • Compatible MySQL error code: 3712

ERROR 3713 (01S00) : There is already a spatial reference system with SRID %u.

  • OceanBase error code: 7236

  • Compatible MySQL error code: 3713

ERROR 3714 (SR000) : SRID 0 is not modifiable.

  • OceanBase error code: 7237

  • Compatible MySQL error code: 3714

ERROR 3715 (01S01) : The SRID range [%u, %u] has been reserved for system use. SRSs in this range may be added, modified or removed without warning during upgrade.

  • OceanBase error code: 7238

  • Compatible MySQL error code: 3715

ERROR 3716 (SR005) : Can't modify SRID %u. There is at least one column depending on it.

  • OceanBase error code: 7239

  • Compatible MySQL error code: 3716

ERROR 3717 (SR006) : Invalid character in attribute %s.

  • OceanBase error code: 7240

  • Compatible MySQL error code: 3717

ERROR 3718 (SR006) : Attribute %s is too long. The maximum length is %u characters.

  • OceanBase error code: 7241

  • Compatible MySQL error code: 3718

ERROR 3726 (22S00) : Function %s is only defined for geographic spatial reference systems, but one of its arguments is in SRID %u, which is not geographic.

  • OceanBase error code: 7242

  • Compatible MySQL error code: 3726

ERROR 3727 (22023) : Function %s encountered a polygon that was too large. Polygons must cover less than half the planet.

  • OceanBase error code: 7243

  • Compatible MySQL error code: 3727

ERROR 3728 (HY000) : Spatial indexes can't be primary or unique indexes.

  • OceanBase error code: 7244

  • Compatible MySQL error code: 3728

ERROR 3729 (HY000) : The index type %.20s is not supported for spatial indexes.

  • OceanBase error code: 7245

  • Compatible MySQL error code: 3729

ERROR 3729 (HY000) : The index type %s is not supported for spatial indexes.

  • OceanBase error code: 7281

  • Compatible MySQL error code: 3729

ERROR 3731 (22S02) : A parameter of function %.192s contains a geometry with longitude %f, which is out of range. It must be within (%f, %f].

  • OceanBase error code: 7246

  • Compatible MySQL error code: 3731

ERROR 3732 (22S03) : A parameter of function %.192s contains a geometry with latitude %f, which is out of range. It must be within [%f, %f].

  • OceanBase error code: 7247

  • Compatible MySQL error code: 3732

ERROR 3736 (SR002) : The spatial reference system definition for SRID %u specifies invalid geographic axes '%.20s' and '%.20s'. One axis must be NORTH or SOUTH and the other must be EAST or WEST.

  • OceanBase error code: 7248

  • Compatible MySQL error code: 3736

ERROR 3737 (SR002) : The length of the semi-major axis must be a positive number.

  • OceanBase error code: 7249

  • Compatible MySQL error code: 3737

ERROR 3738 (SR002) : The inverse flattening must be larger than 1.0, or 0.0 if the ellipsoid is a sphere.

  • OceanBase error code: 7250

  • Compatible MySQL error code: 3738

ERROR 3739 (SR002) : The angular unit conversion factor must be a positive number.

  • OceanBase error code: 7251

  • Compatible MySQL error code: 3739

ERROR 3740 (SR002) : The prime meridian must be within (-180, 180] degrees, specified in the SRS angular unit.

  • OceanBase error code: 7252

  • Compatible MySQL error code: 3740

ERROR 3741 (22S00) : Transformation from SRID %u is not supported.

  • OceanBase error code: 7253

  • Compatible MySQL error code: 3741

ERROR 3742 (22S00) : Transformation to SRID %u is not supported.

  • OceanBase error code: 7254

  • Compatible MySQL error code: 3742

ERROR 3743 (22S00) : Transformation from SRID %u is not supported. The spatial reference system has no TOWGS84 clause.

  • OceanBase error code: 7255

  • Compatible MySQL error code: 3743

ERROR 3744 (22S00) : Transformation to SRID %u is not supported. The spatial reference system has no TOWGS84 clause.

  • OceanBase error code: 7256

  • Compatible MySQL error code: 3744

ERROR 3753 (42000) : Cannot create a functional index on a function that returns a JSON or GEOMETRY value.

  • OceanBase error code: 7257

  • Compatible MySQL error code: 3753

ERROR 3754 (HY000) : Functional index '%.*s' cannot refer to an auto-increment column.

  • OceanBase error code: 5496
  • Compatible MySQL error code: 3754
  • Cause: An auto-increment column was used as part of a functional index during creation, which is not allowed.
  • Solution: Modify the functional index to remove the auto-increment column or use another column instead.

ERROR 3757 (HY000) : Cannot create a functional index on an expression that returns a BLOB or TEXT. Please consider using CAST.

  • OceanBase error code: 5498
  • Compatible MySQL error code: 3757
  • Cause: A functional index was created on an expression that returns a BLOB or TEXT type, which is not allowed.
  • Solution: Use the CAST function to convert the BLOB or TEXT expression to another type, and then create the functional index with the converted expression.

ERROR 3758 (HY000) : Expression of functional index contains a disallowed function.

  • OceanBase error code: 5905
  • Compatible MySQL error code: 3758
  • Cause: An unsupported function was used in the index function when creating a functional index. The index function uses SYSDATE or the user environment.
  • Solution: The index function must be a pure function (RNDS, RNPS, WNDS, or WNPS).

ERROR 3760 (HY000) : Spatial functional index is not supported.

  • OceanBase error code: 7258

  • Compatible MySQL error code: 3760

ERROR 3762 (HY000) : Functional index on a column is not supported. Consider using a regular index instead.

  • OceanBase error code: 5499
  • Compatible MySQL error code: 3762
  • Cause: The index function is a single column when creating a functional index.
  • Solution: Please use a regular index.

ERROR 3812 (HY000) : An expression of non-boolean type specified to a check constraint \'%.*s\'

  • OceanBase error code: 5987

  • Compatible MySQL error code: 3812

ERROR 3813 (HY000) : Column check constraint \'%.*s\' references other column

  • OceanBase error code: 5786

  • Compatible MySQL error code: 3813

ERROR 3814 (HY000) : An expression of a check constraint \'%.*s\' contains disallowed function: %.*s

  • OceanBase error code: 5991

  • Compatible MySQL error code: 3814

ERROR 3815 (HY000) : An expression of a check constraint \'%.*s\' contains disallowed function

  • OceanBase error code: 5992

  • Compatible MySQL error code: 3815

ERROR 3816 (HY000) : An expression of a check constraint \'%.*s\' cannot refer to a user or system variable

  • OceanBase error code: 5993

  • Compatible MySQL error code: 3816

ERROR 3818 (HY000) : Check constraint \'%.*s\' cannot refer to an auto-increment column

  • OceanBase error code: 5990

  • Compatible MySQL error code: 3818

ERROR 3819 (HY000) : check constraint violated

  • OceanBase error code: 5693

  • Compatible MySQL error code: 3819

ERROR 3820 (HY000) : Check constraint \'%.*s\' refers to non-existing column \'%.*s\'

  • OceanBase error code: 5994

  • Compatible MySQL error code: 3820

ERROR 3821 (HY000) : Check constraint \'%.*s\' is not found in the table

  • OceanBase error code: 5988

  • Compatible MySQL error code: 3821

ERROR 3822 (HY000) : Duplicate check constraint name \'%.*s\'

  • OceanBase error code: 5678

  • Compatible MySQL error code: 3822

ERROR 3837 (HY000) : Column '%.*s' has a functional index dependency and cannot be dropped or renamed.

  • OceanBase error code: 5497
  • Compatible MySQL error code: 3837
  • Cause: The column to be dropped has a functional index dependency and cannot be directly dropped or renamed.
  • Solution:
    • Drop the functional index: If the column to be dropped is part of a functional index, you can first drop the functional index and then drop the column.
    • Modify the functional index: If the column to be dropped is part of a functional index, you can modify the functional index to remove the column from it, and then drop the column.

ERROR 3853 (22032) : Invalid JSON type in argument, should be object.

  • OceanBase error code: 6285

  • Compatible MySQL error code: 3853

  • Cause: An invalid JSON type is used for an argument that should be an object type.

  • Solution: Ensure the parameter is a valid JSON object type or convert it to the correct JSON object type.

ERROR 3855 (HY000) : Column '%.*s' has a partitioning function dependency and cannot be dropped or renamed.

  • OceanBase error code: 5502
  • Compatible MySQL error code: 3855
  • Cause: The column cannot be dropped or renamed because it has a partitioning function dependency.

ERROR 3939 (HY000) : Table has multiple constraints with the name \'%.*s\'. Please use constraint specific \'%.*s\' clause

  • OceanBase error code: 5986

  • Compatible MySQL error code: 3939

ERROR 3940 (HY000) : Constraint \'%.*s\' does not exist

  • OceanBase error code: 5692

  • Compatible MySQL error code: 3940

ERROR 3941 (HY000) : Altering constraint enforcement is not supported for the constraint \'%.*s\'. Enforcement state alter is not supported for the PRIMARY, UNIQUE and FOREIGN KEY type constraints

  • OceanBase error code: 5989

  • Compatible MySQL error code: 3941

ERROR 3942 (HY000) : Each row of a VALUES clause must have at least one column, unless when used as source in an INSERT statement.

  • OceanBase error code: 11000

  • Compatible MySQL error code: 3942

  • Cause: Each row in a VALUES clause must have at least one column, unless it is used as a data source in an INSERT statement.

  • Solution: Ensure each row in the VALUES clause has at least one column.

ERROR 3943 (HY000) : A VALUES clause cannot use DEFAULT values, unless used as a source in an INSERT statement.

  • OceanBase error code: 11001

  • Compatible MySQL error code: 3943

  • Cause: Default values cannot be used in the VALUES clause, unless they are used as a data source in the INSERT statement.

  • Solution: Do not use default values in the VALUES clause, unless they are used as a data source in the INSERT statement.

ERROR 3959 (HY000) : Check constraint \'%.*s\' uses column \'%.*s\', hence column cannot be dropped or renamed

  • OceanBase error code: 5859

  • Compatible MySQL error code: 3959

ERROR 3966 (22035) : No value was found by '%.192s' on the specified path

  • OceanBase error code: 5432

  • Compatible MySQL error code: 3966

ERROR 3967 (22035) : More than one value was found by '%.192s' on the specified path

  • OceanBase error code: 5433

  • Compatible MySQL error code: 3967

Previous topic

Overview of error messages
Last

Next topic

4000 ~ 4499
Next
on this page
ERROR 1007 (HY000) : Can't create database '%s'; database exists
ERROR 1008 (HY000) : Can't drop database '%.*s'; database doesn't exist
ERROR 1017 (HY000) : File not exist
ERROR 1018 (HY000) : Directory not exist
ERROR 1022 (23000) : Can't write; duplicate key in table \'%.*s\'
ERROR 1025 (HY000) : ## ERROR on rename of \'%s.%s\' to \'%s.%s\'
ERROR 1040 (08004) : Too many connections
ERROR 1041 (53000) : Out of resource
ERROR 1044 (42000) : Access denied for user '%.*s'@'%.*s' to database '%.*s'
ERROR 1045 (42000) : Access denied for user '%.*s'@'%.*s' (using password: %s)
ERROR 1046 (3D000) : No database selected
ERROR 1047 (HY001) : Unknown packet
ERROR 1048 (23000) : Column '%.*s' cannot be null
ERROR 1049 (42000) : Unknown database '%.*s'
ERROR 1050 (42S01) : Table '%.*s' already exists
ERROR 1051 (42S02) : Unknown table '%.*s'
ERROR 1052 (23000) : Column '%.*s' in %.*s is ambiguous
ERROR 1054 (42S22) : Unknown column '%.*s' in '%.*s'
ERROR 1055 (42000) : \'%.*s\' is not in GROUP BY
ERROR 1056 (42000) : Can't group on '%.*s'
ERROR 1059 (42000) : Identifier name \'%.*s\' is too long
ERROR 1060 (42S21) : Duplicate column group name '%.*s'
ERROR 1061 (42000) : Duplicate key name \'%.*s\'
ERROR 1062 (23000) : Duplicate entry \'%s\' for key \'%.*s\'
ERROR 1063 (42000) : Incorrect column specifier for column '%.*s'
ERROR 1064 (0B000) : Failed to init SQL parser
ERROR 1064 (42000) : Parse error", "%s near \'%.*s\' at line %d
ERROR 1064 (42000) : Wrong number of partitions defined, mismatch with previous setting
ERROR 1065 (42000) : Query was empty
ERROR 1066 (42000) : Not unique table/alias: \'%.*s\'
ERROR 1067 (42000) : Invalid default value for \'%.*s\'
ERROR 1068 (42000) : Multiple primary key defined
ERROR 1069 (42000) : Too many keys specified; max %ld keys allowed
ERROR 1070 (42000) : Too many key parts specified; max %ld parts allowed
ERROR 1071 (42000) : Specified key was too long; max key length is %ld bytes
ERROR 1072 (42000) : Key column '%.*s' doesn't exist in table
ERROR 1074 (42000) : Column length too big for column '%s' (max = %d)
ERROR 1074 (42000) : Column length too big for column '%.*s' (max = %d); use BLOB or TEXT instead
ERROR 1075 (42000) : Incorrect table definition; there can be only one auto column
ERROR 1078 (01000) : (string):%s: Got signal %d. Aborting
ERROR 1082 (42S12) : Illegal index
ERROR 1082 (42000) : Index unavailable
ERROR 1083 (42000) : Field separator argument is not what is expected; check the manual
ERROR 1083 (HY000) : Non-ASCII separator arguments are not fully supported
ERROR 1083 (HY000) : First character of the FIELDS TERMINATED string is ambiguous; please use non-optional and non-empty FIELDS ENCLOSED BY
ERROR 1086 (58000) : File already exist
ERROR 1089 (HY000) : Incorrect prefix key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique prefix keys
ERROR 1090 (42000) : You can't delete all columns with ALTER TABLE; use DROP TABLE instead
ERROR 1091 (42000) : Can't DROP '%.*s'; check that column/key exists
ERROR 1093 (HY000) : You can\'t specify target table \'%s\' for update in FROM clause
ERROR 1094 (HY000) : Unknown thread id: %lu
ERROR 1095 (HY000) : You are not owner of thread %lu
ERROR 1096 (HY000) : No tables used
ERROR 1097 (HY000) : Too many strings for column %.*s and SET
ERROR 1101 (42000) : BLOB, TEXT, GEOMETRY or JSON column '%.*s' can't have a default value
ERROR 1102 (42000) : Incorrect database name '%.*s'
ERROR 1103 (42000) : Incorrect table name '%.*s'
ERROR 1105 (42000) : invalid xpath expression
ERROR 1105 (42000) : Given XPATH expression not supported
ERROR 1108 (HY000) : Incorrect parameters to procedure '%.*s'
ERROR 1109 (42S02) : Unknown table '%.*s' in %.*s
ERROR 1110 (42000) : Column \'%s\' specified twice
ERROR 1111 (HY000) : Invalid use of group function
ERROR 1113 (42000) : A table must have at least 1 column
ERROR 1115 (42000) : Unknown character set: '%.*s'
ERROR 1117 (42000) : Too many columns
ERROR 1118 (42000) : Row size too large
ERROR 1122 (HY000) : Can not load function %s
ERROR 1123 (HY000) : Can not initialize function '%.*s'
ERROR 1124 (HY000) : No paths allowed for shared library
ERROR 1125 (HY000) : Function %.*s already exists
ERROR 1126 (HY000) : Can not open shared library '%.*s'
ERROR 1127 (HY000) : Can't find symbol %.*s in library
ERROR 1028 (HY000) : Function %.*s is not defined
ERROR 1133 (42000) : Can not find any matching row in the user table'%.*s'
ERROR 1133 (42000) : Incorrect password
ERROR 1136 (21S01) : column count does not match value count at row '%d'
ERROR 1136 (21S01) : Column count doesn\'t match value count at row %ld
ERROR 1138 (22004) : Invalid use of NULL value
ERROR 1139 (42000) : Got error '%s' from regexp
ERROR 1140 (42000) : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
ERROR 1141 (HY000) : There is no such grant defined for user '%.*s' on host '%.*s'
ERROR 1142 (42000) : %.*s command denied to user '%.*s'@'%.*s' for table '%.*s'
ERROR 1144 (42000) : Illegal GRANT/REVOKE command; please consult the manual to see which privileges can be used
ERROR 1146 (42S02) : Table \'%s.%s\' doesn\'t exist
ERROR 1149 (42000) : You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use
ERROR 1153 (08S01) : Got a packet bigger than \'max_allowed_packet\' bytes"
ERROR 1166 (42000) : Incorrect column name '%.*s'
ERROR 1167 (42000) : The used storage engine can't index column '%.*s'
ERROR 1171 (42000) : Insert null into %.*s
ERROR 1171 (42000) : All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
ERROR 1172 (42000) : Result consisted of more than one row
ERROR 1173 (42000) : Primary key columns) not specified in the WHERE clause
ERROR 1175 (HY000) : You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
ERROR 1176 (42000) : Key '%.*s' doesn't exist in table '%.*s'
ERROR 1192 (HY000) : Can't execute the given command because you have active locked tables or an active transaction
ERROR 1193 (HY000) : Unknown system variable '%.*s'
ERROR 1203 (42000) : Too many sessions
ERROR 1205 (HY000) : Lock wait timeout exceeded; try restarting transaction
ERROR 1205 (HY000) : Lock wait timeout exceeded; try restarting transaction
ERROR 1210 (HY000) : Incorrect arguments to %s
ERROR 1210 (HY000) : Miss argument for %s
ERROR 1210 (HY000) : Miss argument for %s
ERROR 1213 (HY000) : Deadlock
ERROR 1215 (HY000) : Cannot add foreign key constraint
ERROR 1221 (HY000) : Incorrect usage of DB GRANT and GLOBAL PRIVILEGES
ERROR 1221 (HY000) : Incorrect usage of UNION and INTO
ERROR 1222 (21000) : The used SELECT statements have a different number of columns
ERROR 1225 (HY000) : Option '%s' used twice in statement
ERROR 1226 (42000) : User '%.*s' has exceeded the '%s' resource (current value: %lu)
ERROR 1227 (42501) : Access denied; you need (at least one of) the %s privilege(s) for this operation
ERROR 1228 (HY000) : Variable \'%.*s\' is a SESSION variable and can't be used with SET GLOBAL
ERROR 1229 (HY000) : Variable \'%.*s\' is a GLOBAL variable and should be set with SET GLOBAL
ERROR 1230 (42000) : Variable '%.*s' doesn't have a default value
ERROR 1231 (42000) : Variable \'%.*s\' can't be set to the value of \'%.*s\'
ERROR 1232 (42000) : Incorrect argument type to variable '%.*s'
ERROR 1234 (42000) : Incorrect usage/placement of '%s'
ERROR 1235 (0A000) : %s not supported
ERROR 1235 (42000) : This version of MySQL doesn't yet support 'non-string DEFAULT value for a column in a JSON_TABLE expression'
ERROR 1235 (42000) : This version doesn't yet support 'references in JSON Schema.
ERROR 1235 (42000) : This version of OceanBase doesn't yet support 'multiple triggers with the same action time and event for one table'
ERROR 1238 (HY000) : Variable '%.*s' is a %.*s variable
ERROR 1239 (42000) : Incorrect foreign key definition: Key reference and table reference don't match
ERROR 1241 (21000) : Operand should contain %ld column(s)
ERROR 1243 (HY007) : statement not prepared, stmt_id=%u
ERROR 1242 (21000) : Subquery returns more than 1 row
ERROR 1243 (HY000) : Unknown prepared statement handle
ERROR 1247 (42S22) : Reference '%.*s' not supported (reference to group function)
ERROR 1250 (42000) : Table \'%.*s\' from one of the SELECTs cannot be used in global ORDER clause
ERROR 1252 (7280) : All parts of a SPATIAL index must be NOT NULL.
ERROR 1253 (42000) : COLLATION '%.*s' is not valid for CHARACTER SET '%.*s'
ERROR 1259 (HY000) : ZLIB: Input data corrupted
ERROR 1260 (42000) : Row %ld was cut by GROUP_CONCAT()
ERROR 1261 (1000) : Row %ld doesn't contain data for all columns
ERROR 1262 (1000) : Row %ld was truncated; it contained more data than there were input columns
ERROR 1264 (22003) : Out of range value for column '%.*s' at row %ld
ERROR 1264 (22003) : value larger than specified precision(%ld,%ld) allowed for this column
ERROR 1264 (22003) : value(%s) larger than specified precision(%ld,%ld) allowed for this column
ERROR 1264 (22003) : Result value was out of range when casting varchar to number
ERROR 1264 (22003) : Out of range value for column '%.*s' at row %ld
ERROR 1265 (01000) : Data truncated for column '%.*s' at row %ld
ERROR 1265 (01000) : Timeout value truncated to 102 years
ERROR 1267 (HY000) : Illegal mix of collations (%s,%s), (%s,%s)
ERROR 1273 (HY000) : Unknown collation: '%.*s'
ERROR 1280 (42000) : Incorrect index name '%.*s'
ERROR 1283 (HY000) : Column '%.*s' cannot be part of FULLTEXT index
ERROR 1283 (42000) : A FTS index may only contain a text type column.
ERROR 1286 (42000) : Unknown storage engine \'%.*s\'
ERROR 1287 (HY000) : %s is deprecated and will be removed in a future release. Please use '%s' instead
ERROR 1288 (HY000) : The target table %.*s of the %.*s is not updatable
ERROR 1290 (HY000) : The MySQL server is running with the --read-only option so it cannot execute this statement
ERROR 1291 (HY000) : Column '%.*s' has duplicated value '%.*s' in %s
ERROR 1292 (22007) : %s=%d must between %d and %d
ERROR 1292 (22007) : Incorrect value
ERROR 1292 (01000) : Truncated incorrect DOUBLE value: '%.*s'
ERROR 1292 (22007) : Incorrect datetime value: '%.*s' for column '%s'
ERROR 1292 (22007) : Truncated incorrect %.*s value: '%.*s'
ERROR 1294 (HY000) : Invalid ON UPDATE clause for \'%s\' column
ERROR 1295 (HY000) : This command is not supported in the prepared statement protocol yet
ERROR 1298 (HY000) : Unknown or incorrect time zone: \'%.*s\'
ERROR 1300 (HY000) : Invalid %.*s character string: \'%.*s\'
ERROR 1301 (HY000) : Result of %s() was larger than max_allowed_packet (%d) truncated
ERROR 1302 (42000) : Conflicting declarations: '%s' and '%s'
ERROR 1303 (2F003) : Cant create a routine from within another routine
ERROR 1304 (42000) : %s %.*s already exists
ERROR 1305 (42000) : %s %.*s does not exist
ERROR 1305 (42000) : %s %.*s.%.*s does not exist
ERROR 1305 (42000) : savepoint does not exist
ERROR 1308 (42000) : no matching label: %.*s
ERROR 1308 (42000) : %s with no matching label: %s
ERROR 1309 (42000) : Redefining label '%.*s'
ERROR 1313 (42000) : RETURN is only allowed in a FUNCTION
ERROR 1314 (HY000) : '%.*s' is not allowed in stored procedure
ERROR 1317 (70100) : Query execution was interrupted
ERROR 1318 (42000) : Incorrect number of arguments for %s %s; expected %u, got %u
ERROR 1319 (42000) : Undefined CONDITION: %.*s
ERROR 1320 (42000) : No Return found in FUNCTION '%.*s'
ERROR 1321 (2F005) : FUNCTION %s ended without RETURN
ERROR 1323 (42000) : Cursor SELECT must not have INTO
ERROR 1324 (42000) : Undefined CURSOR: %.*s
ERROR 1325 (24000) : Cursor is already open
ERROR 1326 (24000) : Cursor is not open
ERROR 1327 (42000) : Undeclared variable: %.*s
ERROR 1327 (42000) : Undeclared type: %.*s
ERROR 1328 (HY000) : Incorrect number of FETCH variables
ERROR 1329 (02000) : No data - zero rows fetched, selected, or processed
ERROR 1330 (42000) : Duplicate parameter: %.*s
ERROR 1330 (42000) : Duplicate type: %.*s
ERROR 1330 (42000) : Duplicate label: %.*s
ERROR 1331 (42000) : Duplicate variable: %.*s
ERROR 1332 (42000) : Duplicate condition: %.*s
ERROR 1333 (42000) : Duplicate cursor: %.*s
ERROR 1336 (0A000) : %s is not allowed in stored function or trigger
ERROR 1337 (42000) : Variable or condition declaration after cursor or handler declaration
ERROR 1338 (42000) : Cursor declaration after handler declaration
ERROR 1339 (20000) : Case not found for CASE statement
ERROR 1347 (HY000) : \'%s.%s\' is not %s
ERROR 1348 (HY000) : Column '%.*s' is not updatable
ERROR 1349 (HY000) : View's SELECT contains a subquery in the FROM clause
ERROR 1350 (HY000) : View's SELECT contains a 'INTO' clause.
ERROR 1353 (HY000) : View's SELECT and view's field list have different column counts
ERROR 1356 (42S22) : View \'%.*s.%.*s\' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
ERROR 1360 (HY000) : Trigger does not exist
ERROR 1362 (HY000) : Updating of %s row is not allowed in %s trigger
ERROR 1363 (HY000) : There is no %s row in on %s trigger
ERROR 1364 (HY000) : Field \'%s\' doesn't have a default value
ERROR 1365 (22012) : Divided by zero
ERROR 1366 (22007) : Incorrect datetime value: '%s' for column '%s'
ERROR 1366 (HY000) : Incorrect integer value for column '%.*s' at row %ld
ERROR 1366 (HY000) : Incorrect string value for column '%.*s' at row %ld
ERROR 1367 (22007) : Illegal %s '%.*s' value found during parsing
ERROR 1368 (HY000) : CHECK OPTION on non-updatable view '%.*s.%.*s'
ERROR 1369 (HY000) : CHECK OPTION failed '%.*s.%.*s'
ERROR 1370 (42000) : %.*s command denied to user '%.*s'@'%.*s' for routine '%.*s'
ERROR 1382 (HY000) : The '%.*s' syntax is reserved for purposes internal to the OceanBase Server
ERROR 1390 (54000) : Prepared statement contains too many placeholders
ERROR 1391 (HY000) : Key part \'%.*s\' length cannot be 0
ERROR 1393 (HY000) : Can not modify more than one base table through a join view '%.*s.%.*s'
ERROR 1395 (HY000) : Can not delete from join view '%.*s.%.*s'
ERROR 1396 (HY000) : Operation %.*s failed for %.*s
ERROR 1397 (XAE04) : Unknown XID
ERROR 1398 (XAE05) : XAER_INVAL: Invalid arguments (or unsupported command)
ERROR 1399 (XAE07) : The command cannot be executed when global transaction is in the %s state
ERROR 1399 (XAE07) : RMFAIL: The command cannot be executed when global transaction is in the %s state
ERROR 1400 (XAE09) : Some work is done outside global transaction
ERROR 1401 (XAE03) : XAER_RMERR: Fatal error occurred in the transaction branch - check your data for consistency
ERROR 1402 (XA100) : XA_RBROLLBACK: Transaction branch was rolled back
ERROR 1406 (22001) : Data too long for column '%.*s' at row %ld
ERROR 1406 (22001) : Data too long for column
ERROR 1407 (42000) : Bad SQLSTATE: \'%.*s\'
ERROR 1410 (42000) : You are not allowed to create a user with GRANT
ERROR 1411 (HY000) : Incorrect %.*s value: '%.*s' for function %.*s
ERROR 1411 (HY000) : Incorrect string value for function %s
ERROR 1413 (42000) : Duplicate handler declared in the same block
ERROR 1414 (42000) : OUT or INOUT argument %d for routine %.*s is not a variable
ERROR 1415 (0A000) : Not allowed to return a result set from a %s
ERROR 1416 (22003) : Cannot get geometry object from data you send to the GEOMETRY field.
ERROR 1422 (HY000) : Explicit or implicit commit is not allowed in stored function or trigger
ERROR 1422 (HY000) : '%.*s' is not allowed in stored function or trigger
ERROR 1424 (HY000) : Recursive stored functions are not allowed
ERROR 1425 (42000) : Too big scale %d specified for column '%s'. Maximum is %ld
ERROR 1426 (42000) : Too big precision %d specified for column '%s'. Maximum is %ld
ERROR 1427 (42000) : For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column '%s')
ERROR 1435 (HY000) : Trigger in wrong schema
ERROR 1439 (42000) : Display width out of range for column '%s' (max = %ld)
ERROR 1439 (42000) : Display width out of range for column '%.*s' (max = %d)
ERROR 1440 (XAE08) : The XID already exists
ERROR 1441 (22008) : Datetime overflow
ERROR 1442 (HY000) : Can't update table \'%s\' in stored function/trigger because it is already used by statement which invoked this stored function/trigger
ERROR 1444 (HY000) : The prepared statement contains a stored routine call that refers to that same statement. It's not allowed to execute a prepared statement in such a recursive manner
ERROR 1445 (HY000) : Not allowed to set autocommit from a stored function or trigger
ERROR 1449 (HY000) : User not exist
ERROR 1451 (23000) : Cannot delete or update a parent row: a foreign key constraint fails
ERROR 1451 (23000) : Cannot delete or update a parent row: a foreign key constraint fails
ERROR 1452 (23000) : Cannot add or update a child row: a foreign key constraint fails
ERROR 1456 (HY000) : Recursive limit %ld (as set by the max_sp_recursion_depth variable) was exceeded for routine
ERROR 1458 (42000) : Incorrect routine name \'%.*s\'
ERROR 1462 (42S02) : \'%.*s'.'%.*s\' contains view recursion
ERROR 1466 (HY000) : Leading spaces are removed from name \'%.*s\'
ERROR 1467 (HY000) : Failed to read auto increment value from storage engine
ERROR 1470 (HY000) : String '%.*s' is too long for user name (should be no longer than 64)
ERROR 1471 (HY000) : The target table %.*s of the INSERT is not insertable-into
ERROR 1474 (HY000) : Name \'%.*s\' has become ''
ERROR 1475 (42000) : Ambiguous column
ERROR 1480 (HY000) : Only RANGE PARTITIONING can use VALUES LESS THAN in partition definition
ERROR 1486 (HY000) : Constant or random or timezone-dependent expressions in sub)partitioning function are not allowed
ERROR 1488 (HY000) : Field in list of fields for partition function not found in table
ERROR 1491 (HY000) : The PARTITION function returns the wrong type
ERROR 1493 (HY000) : VALUES LESS THAN value must be strictly increasing for each partition%.*s
ERROR 1493 (HY000) : VALUES LESS THAN value must be strictly increasing for each partition
ERROR 1495 (HY000) : Multiple definition of same constant in list partitioning
ERROR 1499 (HY000) : Too many partitions (including subpartitions) were defined
ERROR 1500 (HY000) : It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning
ERROR 1503 (HY000) : A %s must include all columns in the table's partitioning function
ERROR 1503 (HY000) : A PRIMARY KEY must include all columns in the table\'s partitioning function
ERROR 1504 (HY000) : Number of partitions = 0 is not an allowed value
ERROR 1505 (HY000) : Partition management on a not partitioned table is not possible
ERROR 1507 (HY000) : error in list of partitions to DROP
ERROR 1508 (HY000) : Cannot remove all partitions, use DROP TABLE instead
ERROR 1512 (HY000) : %s PARTITION can only be used on RANGE/LIST partitions
ERROR 1517 (HY000) : Duplicate partition name \'%.*s\'
ERROR 1517 (HY000) : Duplicate partition name %.*s
ERROR 1517 (HY000) : Duplicate partition name %.*s
ERROR 1517 (HY000) : missing or invalid WAIT interval
ERROR 1520 (HY000) : Reorganize of range partitions cannot change total ranges except for last partition where it can extend the range
ERROR 1524 (HY000) : Plugin '%.*s' is not loaded
ERROR 1525 (HY000) : Incorrect %s value: '%s'
ERROR 1525 (HY000) : XML parsing failed
ERROR 1526 (HY000) : Table has no partition for value
ERROR 1537 (HY000) : Event '%.*s' already exists
ERROR 1539 (HY000) : Unknown '%.*s' event
ERROR 1540 (HY000) : Failed to alter event '%.*s'
ERROR 1541 (HY000) : Failed to drop %.*s
ERROR 1542 (HY000) : INTERVAL is either not positive or too big
ERROR 1543 (HY000) : ENDS is either invalid or before STARTS
ERROR 1544 (HY000) : Event execution time is in the past. Event has been disabled
ERROR 1549 (HY000) : Failed to delete the event from mysql.event
ERROR 1551 (HY000) : Same old and new event name
ERROR 1552 (HY000) : Data for column '%.*s' too long
ERROR 1562 (HY000) : Cannot create temporary table with partitions
ERROR 1563 (HY000) : Partition constant is out of partition function domain
ERROR 1564 (HY000) : This partition function is not allowed
ERROR 1566 (HY000) : Not allowed to use NULL value in VALUES LESS THAN
ERROR 1567 (HY000) : Incorrect partition name '%.*s'
ERROR 1568 (25001) : Transaction characteristics can't be changed while a transaction is in progress
ERROR 1576 (HY000) : Recursion of EVENT DDL statements is forbidden when body is present
ERROR 1582 (42000) : Incorrect parameter count in the call to native function '%.*s'
ERROR 1583 (42000) : Incorrect parameters in the call to native function '%.*s'
ERROR 1588 (HY000) : Event execution time is in the past and ON COMPLETION NOT PRESERVE is set. The event was dropped immediately after creation.
ERROR 1589 (HY000) : Event execution time is in the past. The event was not changed. Specify a time in the future.
ERROR 1613 (XA106) : XA_RBTIMEOUT: Transaction branch was rolled back: took too long
ERROR 1621 (HY000) : variable is read only", "%.*s variable '%.*s' is read-only. Use SET %.*s to assign the value
ERROR 1628 (HY000) : Comment for table is too long (max = %ld)
ERROR 1629 (HY000) : Comment for field is too long (max = %ld)
ERROR 1642 (01000) : Unhandled user-defined warning condition
ERROR 1644 (HY000) : Unhandled user-defined exception condition
ERROR 1645 (0K000) : RESIGNAL when handler not active
ERROR 1646 (HY000) : SIGNAL/RESIGNAL can only use a CONDITION defined with SQLSTATE
ERROR 1652 (HY000) : Duplicate partition field name '%.*s'
ERROR 1653 (HY000) : Inconsistency in usage of column lists for partitioning
ERROR 1654 (HY000) : Partition column values of incorrect type
ERROR 1654 (HY000) : Partition column values of incorrect type
ERROR 1654 (HY000) : Partition column values of incorrect type
ERROR 1655 (HY000) : Too many fields in \'list of partition fields\'
ERROR 1657 (HY000) : Cannot have more than one value for this type of RANGE partitioning
ERROR 1659 (HY000) : Field \'%.*s\' is of a not allowed type for this type of partitioning
ERROR 1688 (HY000) : Comment for index is too long (max = %ld)
ERROR 1690 (22003) : %s value is out of range in '%s'
ERROR 1697 (HY000) : VALUES value for partition \'%.*s\' must have type INT
ERROR 1701 (42000) : Cannot truncate a table referenced in a foreign key constraint %.*s
ERROR 1706 (HY000) : Primary key/index key/partition key update is not allowed since the table is updated both as '%.*s' and '%.*s'
ERROR 1708 (HY000) : The value of \'%s\' should be no less than the value of \'%s\'
ERROR 1731 (HY000) : Non matching attribute '%s' between partition and table
ERROR 1732 (HY000) : Table to exchange with partition is partitioned: '%.*s'
ERROR 1735 (HY000) : Unkown partition '%.*s' in table '%.*s'
ERROR 1736 (HY000) : Tables have different definitions
ERROR 1748 (HY000) : Found a row not matching the given partition set
ERROR 1758 (35000) : Invalid condition number
ERROR 1792 (25006) : Cannot execute statement in a READ ONLY transaction
ERROR 1792 (25006) : Cannot execute statement in a READ ONLY transaction
ERROR 1819 (HY000) : Your password does not satisfy the current policy requirements
ERROR 1820 (HY000) : You must reset your password using ALTER USER statement before executing this statement
ERROR 1827 (42000) : The password hash doesn't have the expected format. Check if the correct password algorithm is being used with the PASSWORD() function
ERROR 1830 (HY000) : Column '%s' cannot be NOT NULL: needed in a foreign key constraint '%s' SET NULL
ERROR 1830 (HY000) : Cannot define foreign key with ON DELETE SET NULL clause on a generated column
ERROR 1831 (HY000) : Duplicate index '%s' defined on the table '%s.%s'
ERROR 1869 (HY000) : Auto-increment value in UPDATE conflicts with internally generated values
ERROR 1882 (HY000) : The initialization vector supplied to aes_encrypt is too short. Must be at least 16 bytes long
ERROR 3004 (0Z002) : GET STACKED DIAGNOSTICS when handler not active
ERROR 3011 (HY000) : Referenced trigger '%s' for the given action time and event type does not exist
ERROR 3020 (2201E) : Invalid argument for logarithm
ERROR 3024 (HY000) : maybe you can adjust the session variable max_execution_time or max_execution_time hint, and try again
ERROR 3028 (HY000) : Expression #%d of ORDER BY contains aggregate function and applies to a UNION
ERROR 3033 (HY000) : Binary geometry function %s given two geometries of different srids: %u and %u, which should have been identical
ERROR 3034 (HY000) : Calling geometry function %s with unsupported types of arguments
ERROR 3035 (HY000) : Unknown GIS error occurred in function %s
ERROR 3036 (HY000) : Unknown exception caught in GIS function %s
ERROR 3037 (22023) : Invalid GIS data provided to function %s
ERROR 3038 (HY000) : The geometry has no data in function %s.
ERROR 3039 (HY000) : Unable to calculate centroid because geometry is empty in function %s.
ERROR 3040 (HY000) : Geometry overlay calculation error: geometry data is invalid in function %s.
ERROR 3041 (HY000) : Geometry turn info calculation error: geometry data is invalid in function %s.
ERROR 3042 (HY000) : Analysis procedures of intersection points interrupted unexpectedly in function %s.
ERROR 3043 (HY000) : Unknown exception thrown in function %s.
ERROR 3044 (HY000) : Memory allocation error: %-.256s in function %s.
ERROR 3045 (HY000) : Domain error", "Domain error: %-.256s in function %s.
ERROR 3046 (HY000) : Length error: %-.256s in function %s.
ERROR 3047 (HY000) : Invalid argument error: %-.256s in function %s.
ERROR 3048 (HY000) : Out of range error: %-.256s in function %s.
ERROR 3049 (HY000) : Overflow error: %-.256s in function %s.
ERROR 3530 (HY000) : role '%.*s' not granted or does not exist
ERROR 3530 (HY000) : %.*s@%.*s is not granted to %.*s@%.*s
ERROR 3050 (HY000) : Range error: %-.256s in function %s.
ERROR 3051 (HY000) : Underflow error: %-.256s in function %s.
ERROR 3052 (HY000) : Logic error: %-.256s in function %s.
ERROR 3053 (HY000) : Runtime error: %-.256s in function %s.
ERROR 3054 (HY000) : Unknown exception: %-.384s in function %s.
ERROR 3055 (HY000) : Geometry byte string must be little endian.
ERROR 3060 (HY000) : Do not support online operation on table with GIS index
ERROR 3061 (42000) : User variable name %.*s is illegal
ERROR 3064 (HY000) : invalid type given for an argument
ERROR 3105 (HY000) : The value specified for generated column '%.*s' in table '%.*s' is not allowed
ERROR 3106 (HY000) : '%s' is not supported for generated columns
ERROR 3108 (HY000) : Column '%.*s' has a generated column dependency
ERROR 3118 (HY000) : User locked
ERROR 3122 (HY000) : Inconsistent intersection points.
ERROR 3134 (HY000) : Parameter %s exceeds the maximum number of points in a geometry (%lu) in function %s.
ERROR 3140 (22032) : Invalid JSON text
ERROR 3141 (22032) : Invalid JSON text in argument
ERROR 3142 (42000) : The JSON binary value contains invalid data
ERROR 3143 (42000) : Invalid JSON path expression
ERROR 3144 (22032) : Cannot create a JSON value from a string
ERROR 3145 (22032) : Invalid JSON character data provided to function
ERROR 3146 (22032) : Invalid data type for JSON data in argument %u to function %s; a JSON string or JSON type is required
ERROR 3147 (22032) : Cannot CAST value to JSON
ERROR 3148 (42000) : A path expression must be encoded in the utf8 character set
ERROR 3149 (42000) : In this situation, path expressions may not contain the * and ** tokens
ERROR 3150 (22032) : The JSON value is too big to be stored in a JSON column
ERROR 3151 (22032) : The JSON object contains a key name that is too long
ERROR 1351 (HY000) : View's SELECT contains a variable or parameter
ERROR 3153 (42000) : The path expression is not allowed in this context
ERROR 3154 (42000) : The oneOrAll argument may take these values: \'one\' or \'all\'
ERROR 3155 (22003) : Out of range JSON value for CAST
ERROR 3156 (22018) : Invalid JSON value for CAST
ERROR 3157 (22032) : The JSON document exceeds the maximum depth
ERROR 3158 (22032) : JSON documents may not contain NULL member names
ERROR 3162 (HY000) : User %.*s does not exist
ERROR 3163 (HY000) : Authorization ID '%.*s'@'%.*s' already exists
ERROR 3165 (42000) : A path expression is not a path to a cell in an array
ERROR 3504 (HY000) : Too many enumeration valuesfor column %.*s
ERROR 3505 (HY000) : Too long enumeration/setvalue for column %.*s
ERROR 3516 (22S01) : %.64s value is a geometry of unexpected type %.64s in %.64s.
ERROR 3516 (22S01) : Unknown WKB type(%d)! Full WKB type number was (%d).
ERROR 3517 (SR002) : Can't parse the spatial reference system definition of SRID %u.
ERROR 3518 (SR003) : The spatial reference system definition for SRID %u does not specify the mandatory %s (EPSG %u) projection parameter.
ERROR 3519 (01000) : There's no spatial reference system with SRID %u.
ERROR 3520 (22S00) : Function %s is only defined for Cartesian spatial reference systems, but one of its arguments is in SRID %u, which is not Cartesian.
ERROR 3521 (SR001) : Function %s is only defined for Cartesian spatial reference systems, but one of its arguments is in SRID %u, which has not been defined.
ERROR 3523 (HY000) : Unknown authorization ID %.*s@%.*s
ERROR 3548 (SR001) : There's no spatial reference system with SRID %u.
ERROR 3548 (SR001) : Spatial reference system is empty
ERROR 3558 (22023) : Invalid option key '%.192s' in function %.192s.
ERROR 3559 (22023) : Invalid value '%.192s' for option '%.192s' in function '%.192s'.
ERROR 3560 (22023) : The string '%.192s' is not a valid key %c value pair in function %.192s.
ERROR 3565 (01000) : There's no spatial reference system with SRID %u. The axis order is unknown.
ERROR 3573 (HY000) : Recursive Common Table Expression should contain a UNION ALL
ERROR 3574 (HY000) : Recursive Common Table Expression should have one or more non-recursive query blocks followed by one or more recursive ones: %s
ERROR 3575 (HY000) : ORDER BY / LIMIT / SELECT DISTINCT / HAVING / WINDOW FUNCTION / GROUP BY in recursive query block of Common Table Expression not supported
ERROR 3576 (HY000) : In recursive query block of Recursive Common Table Expression, the recursive table must neither be in the right argument of a LEFT JOIN, nor be forced to be non-first with join order hints
ERROR 3577 (HY000) : In recursive query block of Recursive Common Table Expression, the recursive table must be referenced only once, and not in any subquery
ERROR 3581 (HY000) : A window which depends on another cannot define partitioning
ERROR 3582 (HY000) : Window '%.*s' has a frame definition, so cannot be referenced by another window
ERROR 3583 (HY000) : Window '%.*s' cannot inherit '%.*s' since both contain an ORDER BY clause
ERROR 3586 (HY000) : Window '%.*s': frame start or end is negative or NULL or of non-integral type
ERROR 3587 (HY000) : Window '%s' with RANGE N PRECEDING/FOLLOWING frame requires exactly one ORDER BY expression of numeric or temporal type
ERROR 3588 (HY000) : Window '%.*s' with RANGE frame has ORDER BY expression of datetime type. Only INTERVAL bound value allowed.
ERROR 3589 (HY000) : Window '%.*s' with RANGE frame has ORDER BY expression of numeric type. INTERVAL bound value not allowed.
ERROR 3590 (HY000) : Window '%.*s' has a non-constant frame bound.
ERROR 3592 (HY000) : Window '%s': ORDER BY or PARTITION BY uses legacy position indication, which is not supported use expression
ERROR 3596 (HY000) : Window '%s': INTERVAL can only be used with RANGE frames
ERROR 3616 (22S02) : Longitude %f is out of range in function %.192s. It must be within (%f, %f].
ERROR 3617 (22S03) : Latitude %f is out of range in function %.192s. It must be within [%f, %f].
ERROR 3618 (22S00) : %.192s(%.80s) has not been implemented for geographic spatial reference systems.
ERROR 3636 (HY000) : Recursive query aborted after %u iterations. Try increasing @@cte_max_recursion_depth to a larger value.
ERROR 3643 (HY000) : The SRID of the geometry does not match the SRID of the column. The SRID of the geometry is %lu, but the SRID of the column is %lu. Consider changing the SRID of the geometry or the SRID property of the column.
ERROR 3644 (HY000) : The SRID specification on the column '%.64s' cannot be changed because there is a spatial index on the column. Please remove the spatial index before altering the SRID specification.
ERROR 3666 (42000) : Can't store an array or an object in the scalar %s column 'jpath'
ERROR 3667 (42000) : Every table function must have an alias
ERROR 3674 (HY000) : The spatial index on column '%.64s' will not be used by the query optimizer since the column does not have an SRID attribute. Consider adding an SRID attribute to the column.
ERROR 3682 (22S00) : Function %.192s is only defined for SRID 0 and SRID 4326.
ERROR 3704 (22S00) : %.192s(%.80s) has not been implemented for Cartesian spatial reference systems.
ERROR 3705 (22S00) : %.192s(%.80s) has not been implemented for projected spatial reference systems.
ERROR 3706 (22023) : Invalid radius provided to function %s: Radius(%lf) must be greater than zero.
ERROR 3708 (SR006) : Missing mandatory attribute %s.
ERROR 3709 (SR006) : Multiple definitions of attribute %s.
ERROR 3710 (SR006) : The spatial reference system name can't be an empty string or start or end with whitespace.
ERROR 3711 (SR006) : The organization name can't be an empty string or start or end with whitespace.
ERROR 3712 (SR004) : There is already a spatial reference system with SRID %u.
ERROR 3713 (01S00) : There is already a spatial reference system with SRID %u.
ERROR 3714 (SR000) : SRID 0 is not modifiable.
ERROR 3715 (01S01) : The SRID range [%u, %u] has been reserved for system use. SRSs in this range may be added, modified or removed without warning during upgrade.
ERROR 3716 (SR005) : Can't modify SRID %u. There is at least one column depending on it.
ERROR 3717 (SR006) : Invalid character in attribute %s.
ERROR 3718 (SR006) : Attribute %s is too long. The maximum length is %u characters.
ERROR 3726 (22S00) : Function %s is only defined for geographic spatial reference systems, but one of its arguments is in SRID %u, which is not geographic.
ERROR 3727 (22023) : Function %s encountered a polygon that was too large. Polygons must cover less than half the planet.
ERROR 3728 (HY000) : Spatial indexes can't be primary or unique indexes.
ERROR 3729 (HY000) : The index type %.20s is not supported for spatial indexes.
ERROR 3729 (HY000) : The index type %s is not supported for spatial indexes.
ERROR 3731 (22S02) : A parameter of function %.192s contains a geometry with longitude %f, which is out of range. It must be within (%f, %f].
ERROR 3732 (22S03) : A parameter of function %.192s contains a geometry with latitude %f, which is out of range. It must be within [%f, %f].
ERROR 3736 (SR002) : The spatial reference system definition for SRID %u specifies invalid geographic axes '%.20s' and '%.20s'. One axis must be NORTH or SOUTH and the other must be EAST or WEST.
ERROR 3737 (SR002) : The length of the semi-major axis must be a positive number.
ERROR 3738 (SR002) : The inverse flattening must be larger than 1.0, or 0.0 if the ellipsoid is a sphere.
ERROR 3739 (SR002) : The angular unit conversion factor must be a positive number.
ERROR 3740 (SR002) : The prime meridian must be within (-180, 180] degrees, specified in the SRS angular unit.
ERROR 3741 (22S00) : Transformation from SRID %u is not supported.
ERROR 3742 (22S00) : Transformation to SRID %u is not supported.
ERROR 3743 (22S00) : Transformation from SRID %u is not supported. The spatial reference system has no TOWGS84 clause.
ERROR 3744 (22S00) : Transformation to SRID %u is not supported. The spatial reference system has no TOWGS84 clause.
ERROR 3753 (42000) : Cannot create a functional index on a function that returns a JSON or GEOMETRY value.
ERROR 3754 (HY000) : Functional index '%.*s' cannot refer to an auto-increment column.
ERROR 3757 (HY000) : Cannot create a functional index on an expression that returns a BLOB or TEXT. Please consider using CAST.
ERROR 3758 (HY000) : Expression of functional index contains a disallowed function.
ERROR 3760 (HY000) : Spatial functional index is not supported.
ERROR 3762 (HY000) : Functional index on a column is not supported. Consider using a regular index instead.
ERROR 3812 (HY000) : An expression of non-boolean type specified to a check constraint \'%.*s\'
ERROR 3813 (HY000) : Column check constraint \'%.*s\' references other column
ERROR 3814 (HY000) : An expression of a check constraint \'%.*s\' contains disallowed function: %.*s
ERROR 3815 (HY000) : An expression of a check constraint \'%.*s\' contains disallowed function
ERROR 3816 (HY000) : An expression of a check constraint \'%.*s\' cannot refer to a user or system variable
ERROR 3818 (HY000) : Check constraint \'%.*s\' cannot refer to an auto-increment column
ERROR 3819 (HY000) : check constraint violated
ERROR 3820 (HY000) : Check constraint \'%.*s\' refers to non-existing column \'%.*s\'
ERROR 3821 (HY000) : Check constraint \'%.*s\' is not found in the table
ERROR 3822 (HY000) : Duplicate check constraint name \'%.*s\'
ERROR 3837 (HY000) : Column '%.*s' has a functional index dependency and cannot be dropped or renamed.
ERROR 3853 (22032) : Invalid JSON type in argument, should be object.
ERROR 3855 (HY000) : Column '%.*s' has a partitioning function dependency and cannot be dropped or renamed.
ERROR 3939 (HY000) : Table has multiple constraints with the name \'%.*s\'. Please use constraint specific \'%.*s\' clause
ERROR 3940 (HY000) : Constraint \'%.*s\' does not exist
ERROR 3941 (HY000) : Altering constraint enforcement is not supported for the constraint \'%.*s\'. Enforcement state alter is not supported for the PRIMARY, UNIQUE and FOREIGN KEY type constraints
ERROR 3942 (HY000) : Each row of a VALUES clause must have at least one column, unless when used as source in an INSERT statement.
ERROR 3943 (HY000) : A VALUES clause cannot use DEFAULT values, unless used as a source in an INSERT statement.
ERROR 3959 (HY000) : Check constraint \'%.*s\' uses column \'%.*s\', hence column cannot be dropped or renamed
ERROR 3966 (22035) : No value was found by '%.192s' on the specified path
ERROR 3967 (22035) : More than one value was found by '%.192s' on the specified path