OceanBase logo

OceanBase

A unified distributed database ready for your transactional, analytical, and AI workloads.

DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All
BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Resources

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All
PRODUCTS

OceanBase Cloud

OceanBase Database

Tools

Connectors and Middleware

QUICK START

OceanBase Cloud

OceanBase Database

BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Company

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Contact Us

International - English
中国站 - 简体中文
日本 - 日本語
Sign In
Start on Cloud

A unified distributed database ready for your transactional, analytical, and AI workloads.

DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All
BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All
PRODUCTS
OceanBase CloudOceanBase Database
ToolsConnectors and Middleware
QUICK START
OceanBase CloudOceanBase Database
BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Contact Us

Start on Cloud
编组
All Products
    • Databases
    • iconOceanBase Database
    • iconOceanBase Cloud
    • iconOceanBase Tugraph
    • iconInteractive Tutorials
    • iconOceanBase Best Practices
    • Tools
    • iconOceanBase Cloud Platform
    • iconOceanBase Migration Service
    • iconOceanBase Developer Center
    • iconOceanBase Migration Assessment
    • iconOceanBase Admin Tool
    • iconOceanBase Loader and Dumper
    • iconOceanBase Deployer
    • iconKubernetes operator for OceanBase
    • iconOceanBase Diagnostic Tool
    • iconOceanBase Binlog Service
    • Connectors and Middleware
    • iconOceanBase Database Proxy
    • iconEmbedded SQL in C for OceanBase
    • iconOceanBase Call Interface
    • iconOceanBase Connector/C
    • iconOceanBase Connector/J
    • iconOceanBase Connector/ODBC
    • iconOceanBase Connector/NET
icon

OceanBase Database

SQL - V3.2.4Enterprise Edition

  • Documentation Revision History
  • Document Overview
  • Get Started
    • What is OceanBase Database
      • Overview
      • Concepts
      • Compatibility with Oracle
        • Overview
        • SQL data types
        • Built-in functions
        • System views
      • Compatibility with MySQL
      • Management tools
      • Version rules
      • Limitations
    • Deploy OceanBase Database
      • Deployment introduction
      • Deployment process
      • Preparations
        • Prepare servers
        • Server configurations
        • Prepare installation packages
      • HA solution for OceanBase clusters
      • Deploy through the GUI
        • Configure the deployment environment
          • Deploy OAT
          • Verify deployment
          • Configure the clock source
          • Upload installation packages
          • Add a server
          • Initialize a server
        • Deploy OCP
          • Overview
          • Add an OCP configuration file
          • Deploy OCP
          • Verify deployment
        • Deploy the OceanBase cluster
          • (Optional) Configure DNS
          • Add an OBServer to the OCP resource pool
          • Create an OceanBase cluster
        • Deploy ODP
          • Overview
          • Deploy ODP
        • Create an OceanBase tenant
          • View resources available for a business tenant
          • Create a tenant
          • Verify deployment
        • Deploy OMS
          • Overview
          • Add an OMS configuration file
          • Deploy OMS
          • Verify deployment
        • Deploy ODC
          • Overview
          • Add an ODC configuration file
          • Deploy ODC
          • Verify deployment
      • Deploy through the CLI
        • Configure the deployment environment
          • Install oat-cli
          • Use oat-cli to configure the deployment environment
          • Configure the clock source
          • Upload installation packages
          • Configure host information
          • Check the environment before deployment
        • Deploy OCP
          • Overview
          • Generate a configuration file
          • Start deployment
          • Verify deployment
        • Deploy the OceanBase cluster
          • Deploy a single-replica OceanBase cluster
          • Deploy a three-replica OceanBase cluster
        • Deploy ODP
          • Deploy ODP by using the CLI
        • Create an OceanBase tenant
          • View resources available for a business tenant
          • Create a tenant
          • Verify deployment
        • Deploy OMS
          • Overview
          • Modify the configuration file
          • Start deployment
          • Verify deployment
        • Deploy ODC
          • Overview
          • Modify the configuration file
          • Start deployment
          • Verify deployment
    • Data migration
      • Overview
      • Migrate data by using OMS
        • Migrate data by using OMS
        • Migrate data from a MySQL database to a MySQL tenant of OceanBase Database by using OMS
        • Migrate data from a MySQL tenant of OceanBase Database to a MySQL database by using OMS
        • Migrate data from an Oracle database to a MySQL tenant of OceanBase Database by using OMS
        • Migrate data from an Oracle database to an Oracle tenant of OceanBase Database by using OMS
        • Migrate data from an Oracle tenant of OceanBase Database to an Oracle database by using OMS
        • Migrate data from a DB2 LUW database to a MySQL tenant of OceanBase Database by using OMS
        • Migrate data from a DB2 LUW database to an Oracle tenant of OceanBase Database by using OMS
        • Migrate data from a MySQL tenant of OceanBase Database to a DB2 LUW database by using OMS
        • Migrate data from an Oracle tenant of OceanBase Database to a DB2 LUW database by using OMS
        • Migrate data from a TiDB database to a MySQL tenant of OceanBase Database by using OMS
        • Migrate data between MySQL tenants of OceanBase Database by using OMS
        • Use OMS to migrate data between Oracle tenants of OceanBase Database
      • Migrate data by using OBLOADER & OBDUMPER
        • Import data by using OBLOADER
        • Export data by using OBDUMPER
      • Migrate data by using SQL scripts
      • Migrate data by using mysqldump
      • Migrate data by using DataX
      • Migrate data by using the OUTFILE statement
    • Database connections and routing
      • Overview
      • Manage ODP
        • ODP management overview
        • Manage ODP clusters
          • Create an ODP cluster
          • Manage ODP cluster parameters
          • Delete an ODP cluster
          • Upgrade all ODPs in an ODP cluster
          • Restart all ODPs in an ODP cluster
          • Manage OceanBase clusters connected to an ODP cluster
          • Monitor ODP cluster performance
        • Manage ODP
          • Add an ODP
          • Start an ODP
          • Refresh ODP configurations
          • Stop an ODP
          • Restart an ODP
          • Delete an ODP
          • Upgrade an ODP
        • ODP startup parameters
      • Database connections
        • Connect to OceanBase Database from OBClient
        • Connect to OceanBase Database from a MySQL client
        • Connect to OceanBase Database through ODC
      • Physical connections
      • Logical connections
        • Query all sessions
        • Query the details of a session
        • Query the metrics of a session
        • Query session variables
        • Terminate a session
      • Driver management
        • Overview
        • OB-ODBC
        • OBCI
        • OceanBase Connector/C
        • OceanBase Connector/J
      • Routing management
        • Table-based routing of ODP
        • SQL parser
        • LDC-based routing
        • ODP routing strategies
          • Read/Write splitting
          • Follower-first read
          • Blocklist mechanism
    • Cluster and multi-tenant management
      • Manage clusters
        • Create a cluster
        • Manage clusters
        • Manage cluster parameters
          • Overview
          • Query cluster-level parameters
          • Modify cluster-level parameters
        • Manage zones in a cluster
          • Overview of zone management
          • Add or delete a zone
          • Add or delete an encrypted zone
          • Start or stop a zone
          • Modify the configurations of a zone
          • Restart a zone
          • Isolate a failed zone
        • Manage OBServer nodes
          • Add an OBServer node
          • View OBServer node status
          • Stop or start an OBServer node
          • Restart an OBServer node
          • Isolate a failed OBServer node
          • Delete an OBServer node
          • Replace an OBServer node
        • View cluster information
        • Overview of cluster tenant management
        • Monitor cluster performance
        • Cluster performance report
        • View resource information of a cluster
      • Configuration management
        • Overview of configuration management
        • Set parameters
        • Set variables
        • Configure general parameters
        • Examples of parameter configuration in a production environment
        • Recommended minimum resource configuration
      • Resource management
        • Overview
        • Create a resource unit
        • Manage resource units
          • View configurations of a resource unit
          • Modify configurations of a resource unit
          • Drop a resource unit
        • Create a resource pool
        • Manage resource pools
          • Allocate a resource pool to a tenant
          • Modify a resource pool
          • Merge resource pools
          • Split a resource pool
          • Remove a resource pool from a tenant
          • Delete a resource pool
        • Query resource allocation
      • Tenant management
        • Overview of tenant management
        • Create a tenant
        • Copy a tenant
        • Manage tenants
          • Query tenant information
          • Modify a tenant
          • Rename a tenant
          • Drop a tenant
        • Manage users and privileges
          • Users and privileges
            • Overview
            • sys tenant
            • Oracle tenants
            • MySQL tenants
          • Oracle mode
            • Create a user
            • Set password complexity
            • Logon failure handling policies
            • View user privileges
            • Modify user privileges
            • Change the password of a user
            • Lock or unlock a user
            • Drop a user
            • Manage roles
              • Overview
              • Create a role
              • Assign a role to another role
              • Assign a role to a user
              • Specify valid or invalid roles for a user
              • View roles
              • Modify a role
              • Revoke a role
              • Drop a role
          • MySQL mode
            • Create a user
            • Set password complexity
            • Handle logon failures
            • View user privileges
            • Modify user privileges
            • Change the password of a user
            • Lock and unlock a user
            • Drop a user
        • Set and view the tenant allowlist
        • View the topology of a tenant
        • View the resource configurations of a tenant
        • Modify the resource configurations of a tenant
        • View the performance metrics of a tenant
        • View tenant sessions
        • Terminate a tenant session
        • Manage tenant parameters
          • Overview
          • Query tenant-level parameters
          • Modify tenant-level parameters
        • Manage tenant variables
      • Manage data storage
        • Minor compaction management
          • Overview
          • Automatically trigger a minor compaction
          • Manually initiate a minor compaction
          • View minor compaction information
          • Modify minor compaction settings
        • Major compaction management
          • Overview
          • Automatically trigger a major compaction
          • Configure scheduled major compactions
          • Manually initiate a major compaction
          • Manually control a major compaction
          • View major compaction information
            • View the major compaction process
            • View disk usage during a major compaction
          • Major compaction timeouts and errors
          • Modify major compaction settings
        • Data compression
          • Overview
          • Data encoding and compression
      • Manage memory
        • Overview
        • Memory structure
        • Set the maximum memory for an OceanBase database
        • Manage internal system memory
        • Manage internal tenant memory
        • Manage the memory of the plan cache
        • Query memory usage information
        • FAQ
      • Manage processes
        • Overview
        • Multi-tenant threads of OceanBase Database
        • FAQ about multi-tenant threads
        • Background threads of OceanBase Database
      • Manage logs
        • Log overview
        • Log generation levels
          • Log generation levels
          • Set a log generation level
        • Log file size and quantity management
          • Use the log file splitting feature
          • Control the number of log files
        • Query logs
          • Query the log of an SQL request
          • Query the log of a previous SQL request by using the SQL Trace feature
    • Database object management
      • Oracle mode
        • Manage tables
          • Overview
          • Create a table
          • Define column constraints
          • Query table definition
          • Modify a table
          • Empty a table
          • Drop a table
        • Manage table groups
          • Overview
          • Statements for table group management
        • Manage indexes
          • Overview
          • Create indexes
          • Query indexes
          • Drop an index
        • Manage views
        • Manage sequences
        • Manage synonyms
        • Manage triggers
          • Overview
          • Create a DML trigger
          • Create an INSTEAD OF trigger
          • Modify and drop a trigger
          • Disable or enable a trigger
          • Query trigger information
        • Manage directory objects
        • Manage DBLinks
      • MySQL mode
        • Manage databases
          • Create a database
          • View databases
          • Modify a database
          • Drop a database
        • Manage tables
          • Overview
          • Create a table
          • Define an auto-increment column
          • Define column constraints
          • Query table definition
          • Modify a table
          • Empty a table
          • Drop a table
        • Manage table groups
          • Overview
          • Statements for table group management
        • Manage indexes
          • Overview
          • Create indexes
          • Query indexes
          • Drop an index
        • Manage views
        • Manage sequences
        • Manage triggers
          • Overview
          • Create a DML trigger
          • Query trigger information
          • Drop a trigger
    • Distributed storage management
      • Overview of data distribution
      • Manage partitions
        • Oracle mode
          • Overview of partitions
          • Create a partitioned table
          • Manage a partitioned table
          • Create a subpartitioned table
          • Manage a subpartitioned table
          • Partition pruning
          • Query data in specified partitions
          • Create an index for a partitioned table
            • Overview of indexes
            • Local indexes
            • Global indexes
          • Create a partitioned table group
          • Add a partitioned table to a table group
          • Manage a partitioned table group
          • Create a subpartitioned table group
          • Add a subpartitioned table to a table group
          • Manage a subpartitioned table group
        • MySQL mode
          • Overview of partitions
          • Create a partitioned table
          • Manage a partitioned table
          • Create a subpartitioned table
          • Manage a subpartitioned table
          • Partition pruning
          • Query data in specified partitions
          • Create an index for a partitioned table
            • Overview of indexes
            • Local indexes
            • Global indexes
          • Create a partitioned table group
          • Add a partitioned table to a table group
          • Manage a partitioned table group
          • Create a subpartitioned table group
          • Add a subpartitioned table to a table group
          • Manage a subpartitioned table group
      • Manage replicas
        • Overview
        • Create a replica
        • Edit a tenant replica in a zone
        • Delete a tenant replica from a zone
      • Manage locality
        • Overview
        • Modify table locality
        • Modify tenant locality
      • Load balancing
        • Overview of load balancing
        • Manage automatic load balancing
        • Manually manage load balancing
          • Manually migrate and switch partition replicas
          • Set load balancing by using table groups
          • Set load balancing by primary zone
    • Performance tuning
      • Overview
      • Performance tools
        • System tools
          • General tool Top
          • CPU tools
          • Memory tools
          • Disk I/O tools
          • Network tools
        • Internal tables
          • gv$sysstat
          • gv$sql_audit
          • __all_virtual_trans_stat
        • Logs
          • slow trans
          • tenant dump
          • Slow queries
        • OCP
          • Monitoring and alerts
          • SQL diagnostics
          • Performance report
          • ASH report
          • Transaction diagnostics
          • Deadlock detection
      • System tuning
        • OS parameter tuning
        • Database parameter tuning
          • CPU parameters
          • I/O parameters
          • Memory-related parameters
          • Network transmission parameters
        • ODP parameter tuning
          • CPU parameters
          • Network transmission parameters
          • Route parameters on nodes
      • Business model tuning
        • Load balancing
        • SQL diagnostics
        • Distributed transactions
      • SQL tuning guide
        • Execution process of SQL queries
        • SQL execution plan
          • Introduction to SQL execution plans
          • Execution plan operators
            • TABLE SCAN
            • TABLE LOOKUP
            • JOIN
            • COUNT
            • GROUP BY
            • WINDOW FUNCTION
            • SUBPLAN FILTER
            • DISTINCT
            • SEQUENCE
            • MATERIAL
            • SORT
            • LIMIT
            • FOR UPDATE
            • SELECT INTO
            • SUBPLAN SCAN
            • UNION
            • INTERSECT
            • EXCEPT/MINUS
            • INSERT
            • DELETE
            • UPDATE
            • MERGE
            • EXCHANGE
            • GI
          • Plan cache
          • Fast parameterization
          • Real-time execution plan display
        • Distributed execution plan
          • Perform distributed execution and parallel queries
          • Generate a distributed plan
          • Schedule distributed execution plans
          • Manage distributed execution plans
          • Execute parallel queries
          • Perform parameter tuning for a parallel query
          • Parallel DML
        • SQL tuning
          • Overview
          • General procedure of SQL tuning
          • Monitor the SQL execution performance
            • gv$sql_audit
            • SQL Trace
            • Plan cache views
            • Examples of SQL performance analysis
              • Use SQL Audit to analyze wait events in a query
              • 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 specified 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
              • Histograms
              • Manual statistics collection
              • Automatic statistics collection
            • Statistics management
              • Overview
              • Deletion
              • Setting
              • Import and export
              • Locking and unlocking
              • History management
              • Statistics preference management
            • Examples
          • Query rewrite
            • Overview
            • Rule-based query rewrite
            • Cost-based query rewrite
          • Query optimization
            • Access path
              • Overview
              • Rule-based path selection
              • Cost-based path selection
            • Join algorithms
              • Overview
              • Join algorithms
              • Join order
          • Manage execution plans
            • Optimizer hints
            • Plan binding
            • SQL plan management
        • Glossary
        • General issues in SQL tuning
      • Performance diagnostics
        • Monitor and diagnose the cluster performance
        • Tenant performance diagnostics
        • Monitor ODP performance
        • Monitor host performance
      • Case analysis
      • Performance test (MySQL mode)
        • Sysbench OLTP
        • BenchMarkSQL
        • TPC-H
      • Performance test (Oracle mode)
        • BenchMarkSQL
        • TPC-H
    • Data high availability
      • Flashback
        • Objects supported by the recycle bin
        • Recycle bin for databases, tables, and indexes
        • Recycle bin for tenants
        • Flash back objects from the recycle bin
        • Restore point
        • Use a flashback query to query data of multiple versions
      • Manage physical backup and restore
        • Introduction to physical backup and restore
        • Deploy NFS
        • Data backup for a cluster
          • Perform a backup by using commands
            • Preparations for backup
            • Initiate a log backup
            • Initiate a data backup
          • Perform a backup for a cluster in OCP
          • Backup of a specified path for a tenant
          • Enable backup for clusters based on log splitting
          • Check the backup progress
          • Stop a backup
          • Automatically clear backup data for clusters
          • Manually clear backup data for clusters
          • Stop backup data clearing for clusters
        • Back up data backups
          • Overview
          • Perform a secondary backup for a cluster by using commands
            • Preparations for secondary backup
            • Initiate a secondary log backup
            • Initiate a secondary data backup
          • Perform a secondary backup for clusters in OCP
          • Perform a secondary backup for tenants
          • View the progress of secondary data backup tasks
          • Stop a secondary backup
          • Automatically clear secondary backup data for clusters
          • Manually clear secondary backup data
          • Stop clearing secondary backup data
        • Update access_id and access_key for OSS in the backup destination during backup
        • Verify data
          • Overview
          • Verify backup data in a cluster
          • Verify backup data in a specified path in a cluster
          • Verify backup data in a specified path across clusters
          • View data verification results
        • Restore data
          • Preparations for restore
          • Perform full restore
          • Restore a specified table
          • Restore secondary backup data
          • View the restore progress and results
          • Cancel restore
        • Routine maintenance
          • Query backup parameters
          • Force stop all backup-related tasks
          • Set backup_zone
      • Primary/Standby cluster management
        • Overview
        • Considerations and limitations
        • Deploy the primary and standby clusters
          • Configuration requirements
          • Deploy a primary cluster
          • Check the configurations of the primary cluster
          • Deploy standby clusters in OCP
        • Tenant management
        • Log transfer service
          • Overview
          • Set the log transfer parameter for a standby cluster
          • Configure log compression
        • Protection mode
          • Overview
          • Protection modes and protection levels
          • Switch to another protection mode
        • Role switching
          • Preparations for a switchover
          • Perform a switchover in a command-line tool
          • Perform a switchover in OCP
          • Perform a failover in a command-line tool
            • Preparations for a failover
            • Perform a lossless failover
            • Connect the original primary cluster after a lossless failover
            • Connect other standby clusters after a lossless failover
            • Perform a lossy failover
            • Restore other clusters after a lossy failover
            • Correct the data after a failover
          • Perform a failover in OCP
        • Standby cluster read service
        • Delete a standby cluster
        • Standby cluster disconnection
          • Preparations for disconnection
          • Disconnect a standby cluster
        • Troubleshooting
          • Failover errors
          • Switchover errors
          • Protection mode switching errors
          • Tenant creation for a standby cluster got stuck
          • Data synchronization enablement errors
          • Standby cluster disconnection errors
    • Database security
      • Data storage encryption
        • Overview
        • MySQL mode
          • Enable storage encryption for a new table
          • Enable storage encryption for an existing table
          • Decrypt a table
        • Oracle mode
          • Enable storage encryption for a new table
          • Enable storage encryption for an existing table
          • Decrypt a table
      • Data transmission encryption
        • Overview
        • Transmission encryption of OBServer nodes
        • Transmission encryption of ODPs
      • RPC connection authentication
      • Set row-level access control
      • Audit databases
        • Overview
        • Enable audit
        • Audit user logon operations
        • Audit user operations
        • Audit specified database objects
    • O&M management
      • O&M overview
        • Overview
        • Monitoring
          • View status monitoring information
          • View performance monitoring information
          • Perform SQL diagnostics
        • Alerts
          • Alert configuration
          • Manage alert subscriptions
          • Perform alert management
          • Manage alert items
      • Database upgrade
        • Overview
        • Perform an upgrade
        • Perform a major compaction
        • Check upgrade results
      • Scale-in and scale-out
        • Overview
        • Cluster-level scale-in and scale-out
          • Scale-out
            • Add zones to a cluster
            • Add OBServer nodes to zones
          • Scale-in
            • Delete zones from a cluster
            • Delete OBServer nodes from zones
        • Scale-in and scale-out of tenant resources
          • Modify unit_config
          • Modify UNIT_NUM
      • Resource isolation
        • cgroup-based resource isolation
          • Enable cgroups-based CPU isolation between tenant worker threads
          • Clear cgroup configurations
      • Routine inspections
        • Overview
        • Check the cluster status
        • Check cluster parameters
        • Check the host status
        • Check tenant resource usage
        • Check cluster resource usage
        • Check the OBServer node status
        • Check the NTP offset
        • Check data backup
        • Check the ODP connection status
      • Troubleshooting
        • Overview
        • Issue analysis
          • View alerts
          • View logs
          • View error codes
          • Query views
        • Troubleshoot OBServer node restart failures
        • Troubleshoot unexpected exit of an observer process
        • Troubleshoot bootstrap failures
        • Troubleshoot database connection issues
        • Troubleshoot clock synchronization issues
        • Troubleshoot the absence of a leader
        • Troubleshoot replica migration issues
        • Troubleshoot exhausted tenant MemStore memory
        • Tenant memory overrun
        • Troubleshoot major compaction exceptions
        • Overloaded OBServer nodes
        • Troubleshoot row lock contention
        • Troubleshoot transaction errors
      • Emergency response
        • Overview
        • Analysis, diagnosis, and decision-making process
        • Common emergency response
          • Exceptions caused by hardware
            • Node failures
            • Network jitter
            • ODP faults
            • Other exceptions related to hardware and network
          • Exceptions caused by capacity changes
            • Exceptions of SQL queries
            • High disk I/O on an OBServer node
            • Overloaded NIC on an OBServer node
            • Full occupation of tenant memory
            • Full usage of ODP threads
            • Full usage of OBServer clog disk
            • Full usage of the OBServer data disk
            • Accumulated request queue of a tenant
          • Other cluster exceptions
            • Blocked tenant minor compaction
            • Blocked cluster major compaction
            • sys tenant or RootService exceptions
            • Insufficiency or leakage of system memory
            • Slow query of the queuing table
    • System references
      • System parameters
        • Overview
        • Summary of system parameters
        • Cluster-level parameters
          • all_cluster_list
          • auto_broadcast_location_cache_rate_limit
          • auto_delete_expired_backup
          • auto_leader_switch_interval
          • auto_refresh_location_cache_rate_limit
          • autoinc_cache_refresh_interval
          • backup_backup_archive_log_batch_count
          • backup_backup_archivelog_retry_interval
          • backup_backup_dest
          • backup_backupset_batch_count
          • backup_backup_dest_option
          • backup_backupset_retry_interval
          • backup_concurrency
          • backup_dest
          • backup_dest_option
          • backup_log_archive_option
          • backup_net_limit
          • backup_recovery_window
          • backup_region
          • backup_zone
          • balance_blacklist_failure_threshold
          • balance_blacklist_retry_interval
          • balancer_emergency_percentage
          • balancer_idle_time
          • balancer_log_interval
          • balancer_task_timeout
          • balancer_timeout_check_interval
          • balancer_tolerance_percentage
          • bf_cache_miss_count_threshold
          • bf_cache_priority
          • builtin_db_data_verify_cycle
          • cache_wash_threshold
          • clog_cache_priority
          • clog_disk_usage_limit_percentage
          • clog_disk_utilization_threshold
          • clog_expire_days
          • clog_sync_time_warn_threshold
          • clog_transport_compress_all
          • clog_transport_compress_func
          • cluster
          • cluster_id
          • config_additional_dir
          • cpu_count
          • cpu_quota_concurrency
          • cpu_reserved
          • data_copy_concurrency
          • data_dir
          • data_disk_usage_limit_percentage
          • data_storage_error_tolerance_time
          • data_storage_warning_tolerance_time
          • datafile_disk_percentage
          • datafile_size
          • dead_socket_detection_timeout
          • debug_sync_timeout
          • default_compress
          • default_compress_func
          • default_row_format
          • default_transport_compress_func
          • devname
          • disk_io_thread_count
          • dtl_buffer_size
          • election_blacklist_interval
          • election_cpu_quota
          • enable_async_syslog
          • enable_auto_leader_switch
          • enable_auto_refresh_location_cache
          • enable_ddl
          • enable_election_group
          • enable_global_freeze_trigger
          • enable_log_archive
          • enable_major_freeze
          • enable_manual_merge
          • enable_merge_by_turn
          • enable_ob_ratelimit
          • enable_one_phase_commit
          • enable_perf_event
          • enable_pg
          • enable_rebalance
          • enable_record_trace_id
          • enable_record_trace_log
          • enable_rereplication
          • enable_rich_error_msg
          • enable_rootservice_standalone
          • enable_separate_sys_clog
          • enable_smooth_leader_switch
          • enable_sql_audit
          • enable_sql_operator_dump
          • enable_sys_unit_standalone
          • enable_syslog_recycle
          • enable_syslog_wf
          • enable_tcp_keepalive
          • enable_unit_balance_resource_weight
          • enable_upgrade_mode
          • fast_recovery_concurrency
          • flush_log_at_trx_commit
          • force_refresh_location_cache_interval
          • force_refresh_location_cache_threshold
          • freeze_trigger_percentage
          • fuse_row_cache_priority
          • gc_wait_archive
          • get_leader_candidate_rpc_timeout
          • global_index_build_single_replica_timeout
          • global_major_freeze_residual_memory
          • global_write_halt_residual_memory
          • high_priority_net_thread_count
          • ignore_replay_checksum_error
          • ignore_replica_checksum_error
          • ilog_index_expire_time
          • index_cache_priority
          • index_clog_cache_priority
          • index_info_block_cache_priority
          • internal_sql_execute_timeout
          • large_query_threshold
          • large_query_worker_percentage
          • leak_mod_to_check
          • lease_time
          • location_cache_cpu_quota
          • location_cache_expire_time
          • location_cache_priority
          • location_cache_refresh_min_interval
          • location_cache_refresh_rpc_timeout
          • location_cache_refresh_sql_timeout
          • location_fetch_concurrency
          • location_refresh_thread_count
          • log_archive_batch_buffer_limit
          • log_archive_checkpoint_interval
          • log_archive_concurrency
          • log_restore_concurrency
          • major_compact_trigger
          • major_freeze_duty_time
          • max_kept_major_version_number
          • max_px_worker_count
          • max_string_print_length
          • max_syslog_file_count
          • memory_chunk_cache_size
          • memory_limit
          • memory_limit_percentage
          • memory_reserved
          • memstore_limit_percentage
          • merge_stat_sampling_ratio
          • merge_thread_count
          • merger_check_interval
          • merger_completion_percentage
          • merger_switch_leader_duration_time
          • merger_warm_up_duration_time
          • micro_block_merge_verify_level
          • migrate_concurrency
          • migration_disable_time
          • min_observer_version
          • minor_compact_trigger
          • minor_deferred_gc_time
          • minor_freeze_times
          • minor_merge_concurrency
          • minor_warm_up_duration_time
          • multiblock_read_gap_size
          • multiblock_read_size
          • mysql_port
          • net_thread_count
          • ob_event_history_recycle_interval
          • ob_ratelimit_stat_period
          • obconfig_url
          • ofs_list
          • partition_table_check_interval
          • partition_table_scan_batch_count
          • plan_cache_evict_interval
          • plan_cache_high_watermark
          • plan_cache_low_watermark
          • px_task_size
          • px_workers_per_cpu_quota
          • rebuild_replica_data_lag_threshold
          • recyclebin_object_expire_time
          • replica_safe_remove_time
          • resource_hard_limit
          • resource_soft_limit
          • restore_concurrency
          • rootservice_async_task_queue_size
          • rootservice_async_task_thread_count
          • rootservice_list
          • rootservice_memory_limit
          • rootservice_ready_check_interval
          • row_compaction_update_limit
          • row_purge_thread_count
          • rpc_port
          • 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_data_copy_in_concurrency
          • server_data_copy_out_concurrency
          • server_permanent_offline_time
          • server_temporary_offline_time
          • sql_audit_memory_limit
          • sql_audit_queue_size
          • ssl_client_authentication
          • ssl_external_kms_info
          • stack_size
          • switchover_process_thread_count
          • sys_bkgd_io_high_percentage
          • sys_bkgd_io_low_percentage
          • sys_bkgd_migration_change_member_list_timeout
          • sys_bkgd_migration_retry_num
          • sys_bkgd_net_percentage
          • sys_cpu_limit_trigger
          • syslog_io_bandwidth_limit
          • syslog_level
          • system_cpu_quota
          • system_memory
          • system_trace_level
          • tableapi_transport_compress_func
          • tablet_size
          • tcp_keepcnt
          • tcp_keepidle
          • tcp_keepintvl
          • tenant_cpu_variation_per_server
          • tenant_groups
          • tenant_task_queue_size
          • token_reserved_percentage
          • trace_log_sampling_interval
          • trace_log_slow_query_watermark
          • trx_2pc_retry_interval
          • trx_force_kill_threshold
          • trx_try_wait_lock_timeout
          • unit_balance_resource_weight
          • use_large_pages
          • user_block_cache_priority
          • user_iort_up_percentage
          • user_row_cache_priority
          • user_tab_col_stat_cache_priority
          • virtual_table_location_cache_expire_time
          • wait_leader_batch_count
          • weak_read_version_refresh_interval
          • workers_per_cpu_quota
          • zone
          • zone_merge_concurrency
          • zone_merge_order
          • zone_merge_timeout
          • ob_esi_rpc_port
          • enable_ob_esi_process
          • ob_esi_session_timeout
          • ob_esi_io_concurrency
          • ob_esi_memory_limit
          • ob_esi_syslog_level
          • ob_esi_max_syslog_file_count
          • sql_login_thread_count
          • diag_syslog_per_error_limit
          • enable_cgroup
          • rpc_client_authentication_method
          • rpc_server_authentication_method
          • max_trx_part_size
        • Tenant-level parameters
          • audit_sys_operations
          • audit_trail
          • clog_max_unconfirmed_log_count
          • clog_persistence_compress_func
          • connection_control_failed_connections_threshold
          • connection_control_min_connection_delay
          • connection_control_max_connection_delay
          • default_progressive_merge_num
          • enable_clog_persistence_compress
          • enable_early_lock_release
          • enable_monotonic_weak_read
          • external_kms_info
          • enable_sql_extension
          • job_queue_processes
          • max_stale_time_for_weak_consistency
          • ob_enable_batched_multi_statement
          • ob_proxy_readonly_transaction_routing_policy
          • ob_ssl_invited_common_names
          • open_cursors
          • plsql_ccflags
          • plsql_code_type
          • plsql_debug
          • plsql_optimize_level
          • plsql_v2_compatibility
          • plsql_warnings
          • sql_work_area
          • tde_method
          • writing_throttling_maximum_duration
          • writing_throttling_trigger_percentage
          • workarea_size_policy
          • ob_query_switch_leader_retry_timeout
      • System variables (MySQL mode)
        • Overview
        • System variable summary
        • auto_increment_cache_size
        • auto_increment_increment
        • auto_increment_offset
        • autocommit
        • binlog_row_image
        • block_encryption_mode
        • character_set_client
        • character_set_connection
        • character_set_database
        • character_set_filesystem
        • character_set_results
        • character_set_server
        • character_set_system
        • collation_connection
        • collation_database
        • collation_server
        • connect_timeout
        • datadir
        • debug_sync
        • default_password_lifetime
        • div_precision_increment
        • error_on_overlap_time
        • explicit_defaults_for_timestamp
        • foreign_key_checks
        • group_concat_max_len
        • identity
        • init_connect
        • interactive_timeout
        • is_result_accurate
        • last_insert_id
        • license
        • lower_case_table_names
        • max_allowed_packet
        • max_sp_recursion_depth
        • max_user_connections
        • net_buffer_length
        • net_read_timeout
        • net_write_timeout
        • nls_calendar
        • nls_characterset
        • nls_comp
        • nls_currency
        • nls_date_format
        • nls_date_language
        • nls_dual_currency
        • nls_iso_currency
        • nls_language
        • nls_length_semantics
        • nls_nchar_characterset
        • nls_nchar_conv_excp
        • nls_numeric_characters
        • nls_sort
        • nls_territory
        • nls_timestamp_format
        • nls_timestamp_tz_format
        • ob_bnl_join_cache_size
        • ob_capability_flag
        • ob_compatibility_mode
        • ob_create_table_strict_mode
        • ob_default_replica_num
        • ob_early_lock_release
        • ob_enable_aggregation_pushdown
        • ob_enable_blk_nestedloop_join
        • ob_enable_hash_group_by
        • ob_enable_index_direct_select
        • ob_enable_jit
        • ob_enable_plan_cache
        • ob_enable_sql_audit
        • ob_enable_trace_log
        • ob_enable_transformation
        • ob_enable_transmission_checksum
        • ob_enable_truncate_flashback
        • ob_global_debug_sync
        • ob_last_schema_version
        • ob_log_level
        • ob_max_parallel_degree
        • ob_org_cluster_id
        • ob_pl_block_timeout
        • ob_plan_cache_evict_high_percentage
        • ob_plan_cache_evict_low_percentage
        • ob_plan_cache_percentage
        • ob_proxy_global_variables_version
        • ob_proxy_partition_hit
        • ob_proxy_set_trx_executed
        • ob_query_timeout
        • ob_read_consistency
        • ob_reserved_meta_memory_percentage
        • ob_route_policy
        • ob_safe_weak_read_snapshot
        • ob_sql_audit_percentage
        • ob_sql_work_area_percentage
        • ob_stmt_parallel_degree
        • ob_tcp_invited_nodes
        • ob_temp_tablespace_size_percentage
        • ob_timestamp_service
        • ob_trace_info
        • ob_trx_idle_timeout
        • ob_trx_lock_timeout
        • ob_trx_timeout
        • optimizer_capture_sql_plan_baselines
        • optimizer_use_sql_plan_baselines
        • parallel_max_servers
        • parallel_servers_target
        • performance_schema
        • plugin_dir
        • query_cache_size
        • query_cache_type
        • read_only
        • recyclebin
        • resource_manager_plan
        • secure_file_priv
        • 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_warnings
        • system_time_zone
        • time_zone
        • timestamp
        • tracefile_identifier
        • transaction_isolation
        • transaction_read_only
        • tx_isolation
        • tx_read_only
        • undo_retention
        • version
        • version_comment
        • wait_timeout
        • 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
        • server_uuid
        • binlog_format
        • binlog_checksum
        • binlog_rows_query_log_events
        • log_bin
        • server_id
        • default_storage_engine
        • max_connections
        • event_scheduler
        • cte_max_recursion_depth
        • regexp_stack_limit
        • regexp_time_limit
      • System variables (Oracle mode)
        • Overview
        • System variable summary
        • auto_increment_cache_size
        • auto_increment_increment
        • auto_increment_offset
        • autocommit
        • binlog_row_image
        • block_encryption_mode
        • character_set_client
        • character_set_connection
        • character_set_database
        • character_set_filesystem
        • character_set_results
        • character_set_server
        • character_set_system
        • collation_connection
        • collation_database
        • collation_server
        • connect_timeout
        • datadir
        • debug_sync
        • default_password_lifetime
        • div_precision_increment
        • error_on_overlap_time
        • explicit_defaults_for_timestamp
        • foreign_key_checks
        • group_concat_max_len
        • identity
        • init_connect
        • interactive_timeout
        • is_result_accurate
        • last_insert_id
        • license
        • lower_case_table_names
        • max_allowed_packet
        • max_sp_recursion_depth
        • max_user_connections
        • net_buffer_length
        • net_read_timeout
        • net_write_timeout
        • nls_calendar
        • nls_characterset
        • nls_comp
        • nls_currency
        • nls_date_format
        • nls_date_language
        • nls_dual_currency
        • nls_iso_currency
        • nls_language
        • nls_length_semantics
        • nls_nchar_characterset
        • nls_nchar_conv_excp
        • nls_numeric_characters
        • nls_sort
        • nls_territory
        • nls_timestamp_format
        • nls_timestamp_tz_format
        • ob_bnl_join_cache_size
        • ob_capability_flag
        • ob_compatibility_mode
        • ob_create_table_strict_mode
        • ob_default_replica_num
        • ob_early_lock_release
        • ob_enable_aggregation_pushdown
        • ob_enable_blk_nestedloop_join
        • ob_enable_hash_group_by
        • ob_enable_index_direct_select
        • ob_enable_jit
        • ob_enable_plan_cache
        • ob_enable_sql_audit
        • ob_enable_trace_log
        • ob_enable_transformation
        • ob_enable_transmission_checksum
        • ob_enable_truncate_flashback
        • ob_global_debug_sync
        • ob_last_schema_version
        • ob_log_level
        • ob_max_parallel_degree
        • ob_org_cluster_id
        • ob_pl_block_timeout
        • ob_plan_cache_evict_high_percentage
        • ob_plan_cache_evict_low_percentage
        • ob_plan_cache_percentage
        • ob_proxy_global_variables_version
        • ob_proxy_partition_hit
        • ob_proxy_set_trx_executed
        • ob_query_timeout
        • ob_read_consistency
        • ob_reserved_meta_memory_percentage
        • ob_route_policy
        • ob_safe_weak_read_snapshot
        • ob_sql_audit_percentage
        • ob_sql_work_area_percentage
        • ob_stmt_parallel_degree
        • ob_tcp_invited_nodes
        • ob_temp_tablespace_size_percentage
        • ob_timestamp_service
        • ob_trace_info
        • ob_trx_idle_timeout
        • ob_trx_lock_timeout
        • ob_trx_timeout
        • optimizer_capture_sql_plan_baselines
        • optimizer_use_sql_plan_baselines
        • parallel_max_servers
        • parallel_servers_target
        • performance_schema
        • plugin_dir
        • query_cache_size
        • query_cache_type
        • read_only
        • recyclebin
        • resource_manager_plan
        • secure_file_priv
        • sql_auto_is_null
        • sql_quote_show_create
        • sql_select_limit
        • sql_throttle_current_priority
        • sql_throttle_network
        • sql_throttle_priority
        • sql_throttle_rt
        • sql_warnings
        • system_time_zone
        • sql_safe_updates
        • time_zone
        • timestamp
        • tracefile_identifier
        • transaction_isolation
        • transaction_read_only
        • tx_isolation
        • tx_read_only
        • undo_retention
        • version
        • version_comment
        • wait_timeout
        • 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
        • event_scheduler
      • System views (MySQL mode)
        • Overview
        • Dictionary views
          • Overview
          • mysql.help_topic
          • mysql.help_category
          • mysql.help_keyword
          • mysql.help_relation
          • mysql.db
          • mysql.proc
          • mysql.time_zone
          • mysql.time_zone_name
          • mysql.time_zone_transition
          • mysql.time_zone_transition_type
          • mysql.user
          • information_schema.CHARACTER_SETS
          • information_schema.CHECK_CONSTRAINTS
          • information_schema.COLLATIONS
          • information_schema.COLLATION_CHARACTER_SET_APPLICABILITY
          • information_schema.COLUMNS
          • information_schema.DBA_OUTLINES
          • information_schema.ENGINES
          • information_schema.GLOBAL_STATUS
          • information_schema.GLOBAL_VARIABLES
          • information_schema.KEY_COLUMN_USAGE
          • information_schema.PARAMETERS
          • information_schema.PARTITIONS
          • information_schema.PROCESSLIST
          • information_schema.REFERENTIAL_CONSTRAINTS
          • information_schema.ROUTINES
          • information_schema.SCHEMATA
          • information_schema.SCHEMA_PRIVILEGES
          • information_schema.SESSION_STATUS
          • information_schema.SESSION_VARIABLES
          • information_schema.STATISTICS
          • information_schema.TABLES
          • information_schema.TABLE_CONSTRAINTS
          • information_schema.TABLE_PRIVILEGES
          • information_schema.USER_PRIVILEGES
          • information_schema.USER_RECYCLEBIN
          • information_schema.VIEWS
          • information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS
          • oceanbase.CDB_OB_BACKUP_ARCHIVELOG_SUMMARY
          • oceanbase.CDB_OB_BACKUP_JOB_DETAILS
          • oceanbase.CDB_OB_BACKUP_SET_DETAILS
          • oceanbase.CDB_OB_BACKUP_PROGRESS
          • oceanbase.CDB_OB_BACKUP_SET_EXPIRED
          • oceanbase.CDB_OB_BACKUP_ARCHIVELOG_PROGRESS
          • oceanbase.CDB_OB_BACKUP_CLEAN_HISTORY
          • oceanbase.CDB_OB_BACKUP_TASK_CLEAN_HISTORY
          • oceanbase.CDB_OB_RESTORE_PROGRESS
          • oceanbase.CDB_OB_RESTORE_HISTORY
          • oceanbase.CDB_CKPT_HISTORY
          • oceanbase.CDB_OB_BACKUP_VALIDATION_JOB
          • oceanbase.CDB_OB_BACKUP_VALIDATION_JOB_HISTORY
          • oceanbase.CDB_OB_TENANT_BACKUP_VALIDATION_TASK
          • oceanbase.CDB_OB_BACKUP_VALIDATION_TASK_HISTORY
          • oceanbase.CDB_OB_BACKUP_BACKUP_ARCHIVELOG_SUMMARY
          • oceanbase.CDB_OB_BACKUP_BACKUPSET_TASK_HISTORY
          • oceanbase.CDB_OB_BACKUP_BACKUPSET_TASK
          • oceanbase.CDB_OB_BACKUP_BACKUPSET_JOB_HISTORY
          • oceanbase.CDB_OB_BACKUP_BACKUPSET_JOB
          • oceanbase.CDB_OB_BACKUP_SET_OBSOLETE
          • oceanbase.CDB_OB_BACKUP_ARCHIVELOG
          • oceanbase.CDB_OB_BACKUP_BACKUP_ARCHIVELOG
          • oceanbase.CDB_OB_BACKUP_BACKUPPIECE_JOB
          • oceanbase.CDB_OB_BACKUP_BACKUPPIECE_JOB_HISTORY
          • oceanbase.CDB_OB_BACKUP_BACKUPPIECE_TASK
          • oceanbase.CDB_OB_BACKUP_BACKUPPIECE_TASK_HISTORY
          • oceanbase.CDB_OB_BACKUP_PIECE_FILES
          • oceanbase.CDB_OB_BACKUP_SET_FILES
          • information_schema.ST_GEOMETRY_COLUMNS
          • information_schema.ST_SPATIAL_REFERENCE_SYSTEMS
          • oceanbase.DBA_RSRC_PLANS
          • oceanbase.DBA_RSRC_PLAN_DIRECTIVES
          • oceanbase.DBA_RSRC_GROUP_MAPPINGS
          • oceanbase.DBA_RSRC_CONSUMER_GROUPS
        • Performance views
          • Overview
          • gv$plan_cache_stat
          • gv$plan_cache_plan_stat
          • gv$session_event
          • gv$session_wait
          • gv$session_wait_history
          • gv$system_event
          • gv$sesstat
          • gv$sysstat
          • gv$sql_audit
          • gv$latch
          • gv$memory
          • gv$memstore
          • gv$memstore_info
          • gv$plan_cache_plan_explain
          • gv$obrpc_outgoing
          • gv$obrpc_incoming
          • gv$sql
          • gv$sql_plan_monitor
          • gv$outline
          • gv$concurrent_limit_sql
          • gv$sql_plan_statistics
          • gv$server_memstore
          • gv$unit_load_balance_event_history
          • gv$tenant
          • gv$database
          • gv$table
          • gv$unit
          • gv$partition
          • gv$lock_wait_stat
          • gv$session_longops
          • gv$tenant_memstore_allocator_info
          • gv$minor_merge_info
          • gv$tenant_px_worker_stat
          • gv$partition_audit
          • gv$ps_stat
          • gv$ps_item_info
          • gv$sql_workarea
          • gv$sql_workarea_histogram
          • gv$ob_sql_workarea_memory_info
          • gv$server_schema_info
          • gv$merge_info
          • gv$lock
          • gv$sstable
          • gv$ob_trans_table_status
          • gv$tenant_memory_info
          • v$statname
          • v$event_name
          • v$session_event
          • v$session_wait
          • v$session_wait_history
          • v$sesstat
          • v$sysstat
          • v$system_event
          • v$memory
          • v$memstore
          • v$memstore_info
          • v$plan_cache_stat
          • v$plan_cache_plan_stat
          • v$plan_cache_plan_explain
          • v$sql_audit
          • v$obrpc_outgoing
          • v$obrpc_incoming
          • v$sql
          • v$sql_plan_monitor
          • v$sql_plan_statistics
          • v$unit
          • v$partition
          • v$lock_wait_stat
          • v$session_longops
          • v$latch
          • v$tenant_memstore_allocator_info
          • v$tenant_px_worker_stat
          • v$partition_audit
          • v$ob_cluster
          • v$ob_standby_status
          • v$ob_cluster_stats
          • v$ob_cluster_event_history
          • v$ps_stat
          • v$ps_item_info
          • v$sql_workarea
          • v$sql_workarea_active
          • v$sql_workarea_histogram
          • v$ob_sql_workarea_memory_info
          • v$ob_timestamp_service
          • v$server_schema_info
          • v$merge_info
          • v$lock
          • v$sql_monitor_statname
          • v$restore_point
          • v$ob_cluster_failover_info
          • v$encrypted_tables
          • v$encrypted_tablespaces
          • v$sstable
          • v$ob_trans_table_status
          • v$ob_all_clusters
          • v$tenant_memory_info
          • GV$OB_DTL_INTERM_RESULT_MONITOR
          • V$OB_DTL_INTERM_RESULT_MONITOR
          • V$RSRC_PLAN
      • System views (Oracle mode)
        • Overview
        • Dictionary views
          • Overview
          • ALL_ALL_TABLES
          • ALL_ARGUMENTS
          • ALL_COL_COMMENTS
          • ALL_COLL_TYPES
          • ALL_COL_PRIVS
          • ALL_CONSTRAINTS
          • ALL_CONS_COLUMNS
          • ALL_DEF_AUDIT_OPTS
          • ALL_DEPENDENCIES
          • ALL_DIRECTORIES
          • ALL_ERRORS
          • ALL_INDEXES
          • ALL_IND_COLUMNS
          • ALL_IND_EXPRESSIONS
          • ALL_IND_PARTITIONS
          • ALL_IND_SUBPARTITIONS
          • ALL_METHOD_PARAMS
          • ALL_OBJECTS
          • ALL_PART_COL_STATISTICS
          • ALL_PART_HISTOGRAMS
          • ALL_PART_INDEXES
          • ALL_PART_KEY_COLUMNS
          • ALL_PART_TABLES
          • ALL_PROCEDURES
          • ALL_PROFILES
          • ALL_SCHEDULER_JOB_ARGS
          • ALL_SCHEDULER_PROGRAM_ARGS
          • ALL_SEQUENCES
          • ALL_SOURCE
          • ALL_SUBPART_COL_STATISTICS
          • ALL_SUBPART_HISTOGRAMS
          • ALL_SUBPARTITION_TEMPLATES
          • ALL_SUBPART_KEY_COLUMNS
          • ALL_SYNONYMS
          • ALL_TABLES
          • ALL_TAB_COL_STATISTICS
          • ALL_TAB_COLS
          • ALL_TAB_COLUMNS
          • ALL_TAB_COMMENTS
          • ALL_TAB_HISTOGRAMS
          • ALL_TAB_PARTITIONS
          • ALL_TAB_PRIVS
          • ALL_TAB_STATISTICS
          • ALL_TAB_STATS_HISTORY
          • ALL_TAB_SUBPARTITIONS
          • ALL_TRIGGERS
          • ALL_TYPES
          • ALL_TYPE_ATTRS
          • ALL_TYPE_METHODS
          • ALL_USERS
          • ALL_VIEWS
          • AUDIT_ACTIONS
          • DBA_ALL_TABLES
          • DBA_ARGUMENTS
          • DBA_AUDIT_EXISTS
          • DBA_AUDIT_OBJECT
          • DBA_AUDIT_SESSION
          • DBA_AUDIT_STATEMENT
          • DBA_AUDIT_TRAIL
          • DBA_COLL_TYPES
          • DBA_COL_COMMENTS
          • DBA_COL_PRIVS
          • DBA_CONSTRAINTS
          • DBA_CONS_COLUMNS
          • DBA_ERRORS
          • DBA_INDEXES
          • DBA_IND_COLUMNS
          • DBA_IND_EXPRESSIONS
          • DBA_IND_PARTITIONS
          • DBA_IND_SUBPARTITIONS
          • DBA_METHOD_PARAMS
          • DBA_OBJECTS
          • DBA_OBJ_AUDIT_OPTS
          • DBA_PART_INDEXES
          • DBA_PART_KEY_COLUMNS
          • DBA_PART_TABLES
          • DBA_PROCEDURES
          • DBA_PROFILES
          • DBA_ROLES
          • DBA_ROLE_PRIVS
          • DBA_SCHEDULER_JOB_ARGS
          • DBA_SCHEDULER_JOBS
          • DBA_SCHEDULER_PROGRAM
          • DBA_SCHEDULER_PROGRAM_ARGS
          • DBA_SEGMENTS
          • DBA_SEQUENCES
          • DBA_SOURCE
          • DBA_STMT_AUDIT_OPTS
          • DBA_SUBPARTITION_TEMPLATES
          • DBA_SUBPART_KEY_COLUMNS
          • DBA_SYNONYMS
          • DBA_SYS_PRIVS
          • DBA_TABLES
          • DBA_TABLESPACES
          • DBA_TAB_COLS
          • DBA_TAB_COLUMNS
          • DBA_TAB_COMMENTS
          • DBA_TAB_PARTITIONS
          • DBA_TAB_PRIVS
          • DBA_TAB_STATS_HISTORY
          • DBA_TAB_SUBPARTITIONS
          • DBA_TRIGGERS
          • DBA_TYPES
          • DBA_TYPE_ATTRS
          • DBA_TYPE_METHODS
          • DBA_USERS
          • DBA_VIEWS
          • DBA_JOBS_RUNNING
          • DBA_JOBS
          • DBA_RECYCLEBIN
          • DBA_DEPENDENCIES
          • DBA_RSRC_CONSUMER_GROUPS
          • DBA_RSRC_GROUP_MAPPINGS
          • DBA_RSRC_PLANS
          • DBA_RSRC_PLAN_DIRECTIVES
          • DBA_DIRECTORIES
          • DBA_PART_COL_STATISTICS
          • DBA_PART_HISTOGRAMS
          • DBA_SUBPART_COL_STATISTICS
          • DBA_SUBPART_HISTOGRAMS
          • DBA_TAB_COL_STATISTICS
          • DBA_TAB_HISTOGRAMS
          • DBA_TAB_STATISTICS
          • DICT
          • DICTIONARY
          • NLS_DATABASE_PARAMETERS
          • NLS_INSTANCE_PARAMETERS
          • NLS_SESSION_PARAMETERS
          • ROLE_ROLE_PRIVS
          • ROLE_SYS_PRIVS
          • ROLE_TAB_PRIVS
          • STMT_AUDIT_OPTION_MAP
          • TENANT_VIRTUAL_GLOBAL_VARIABLE
          • TENANT_VIRTUAL_SESSION_VARIABLE
          • USER_ALL_TABLES
          • USER_ARGUMENTS
          • USER_AUDIT_OBJECT
          • USER_AUDIT_SESSION
          • USER_AUDIT_STATEMENT
          • USER_AUDIT_TRAIL
          • USER_COLL_TYPES
          • USER_COL_COMMENTS
          • USER_COL_PRIVS
          • USER_CONSTRAINTS
          • USER_CONS_COLUMNS
          • USER_ERRORS
          • USER_INDEXES
          • USER_IND_COLUMNS
          • USER_IND_EXPRESSIONS
          • USER_IND_PARTITIONS
          • USER_IND_SUBPARTITIONS
          • USER_OBJECTS
          • USER_PART_INDEXES
          • USER_PART_KEY_COLUMNS
          • USER_PART_TABLES
          • USER_PROCEDURES
          • USER_PROFILES
          • USER_ROLE_PRIVS
          • USER_SEGMENTS
          • USER_SEQUENCES
          • USER_SOURCE
          • USER_SUBPARTITION_TEMPLATES
          • USER_SUBPART_KEY_COLUMNS
          • USER_SYNONYMS
          • USER_SYS_PRIVS
          • USER_TAB_STATS_HISTORY
          • USER_TAB_SUBPARTITIONS
          • USER_TRIGGERS
          • USER_TABLES
          • USER_TABLESPACES
          • USER_TAB_COLS
          • USER_TAB_COLUMNS
          • USER_TAB_COMMENTS
          • USER_TAB_PARTITIONS
          • USER_TAB_PRIVS
          • USER_TYPES
          • USER_TYPE_ATTRS
          • USER_TYPE_METHODS
          • USER_JOBS
          • USER_VIEWS
          • USER_RECYCLEBIN
          • USER_DEPENDENCIES
          • USER_PART_COL_STATISTICS
          • USER_PART_HISTOGRAMS
          • USER_SUBPART_COL_STATISTICS
          • USER_SUBPART_HISTOGRAMS
          • USER_TAB_COL_STATISTICS
          • USER_TAB_HISTOGRAMS
          • USER_TAB_STATISTICS
          • DBA_CONTEXT
        • Performance views
          • Overview
          • GV$CONCURRENT_LIMIT_SQL
          • GV$DBLINK
          • GV$GLOBAL_TRANSACTION
          • GV$INSTANCE
          • GV$LOCK
          • GV$MEMORY
          • GV$MEMSTORE
          • GV$MEMSTORE_INFO
          • GV$OB_SQL_WORKAREA_MEMORY_INFO
          • GV$OPEN_CURSOR
          • GV$OUTLINE
          • GV$PLAN_CACHE_PLAN_EXPLAIN
          • GV$PLAN_CACHE_PLAN_STAT
          • GV$PLAN_CACHE_STAT
          • GV$PS_ITEM_INFO
          • GV$PS_STAT
          • GV$SERVER_MEMSTORE
          • GV$SESSION_WAIT
          • GV$SESSION_WAIT_HISTORY
          • GV$SESSTAT
          • GV$SQL_AUDIT
          • GV$SQL_WORKAREA
          • GV$SQL_WORKAREA_ACTIVE
          • GV$SQL_WORKAREA_HISTOGRAM
          • GV$SYSSTAT
          • GV$SYSTEM_EVENT
          • GV$SSTABLE
          • GV$TENANT_MEMORY_INFO
          • V$DBLINK
          • V$ENCRYPTED_TABLES
          • V$ENCRYPTED_TABLESPACES
          • V$GLOBAL_TRANSACTION
          • V$INSTANCE
          • V$LOCK
          • V$MEMORY
          • V$MEMSTORE
          • V$MEMSTORE_INFO
          • V$NLS_PARAMETERS
          • V$OB_SQL_WORKAREA_MEMORY_INFO
          • V$OPEN_CURSOR
          • V$PLAN_CACHE_PLAN_EXPLAIN
          • V$PLAN_CACHE_PLAN_STAT
          • V$PLAN_CACHE_STAT
          • V$PS_ITEM_INFO
          • V$PS_STAT
          • V$RESTORE_POINT
          • V$RSRC_PLAN
          • V$SESSION_WAIT
          • V$SESSION_WAIT_HISTORY
          • V$SESSTAT
          • V$SQL_AUDIT
          • V$SQL_MONITOR_STATNAME
          • V$SQL_WORKAREA
          • V$SQL_WORKAREA_ACTIVE
          • V$SQL_WORKAREA_HISTOGRAM
          • V$SSTABLE
          • V$SYSSTAT
          • V$SYSTEM_EVENT
          • V$TIMEZONE_NAMES
          • V$TENANT_MEMORY_INFO
          • V$VERSION
          • GV$OB_DTL_INTERM_RESULT_MONITOR
          • V$OB_DTL_INTERM_RESULT_MONITOR
          • V$GLOBALCONTEXT
      • Error codes (MySQL mode)
        • Overview
        • 0001 to 3999
        • 4000 to 4499
        • 4500 to 4999
        • 5000 to 5999
        • 6000 to 6999
        • 7000 to 7999
        • 8000 to 8999
        • 9000 to 9499
        • 9500 to 9999
        • 22998, 30926, 38104, and 38105
      • Error codes (Oracle mode)
        • Overview
        • ORA-00000 to ORA-00999
        • ORA-01000 to ORA-01499
        • ORA-01500 to ORA-01999
        • ORA-02000 to ORA-04999
        • ORA-05000 to ORA-10000
        • ORA-10000 to ORA-19999
        • ORA-20000 to ORA-29999
        • ORA-30000 to ORA-49999
        • ORA-50000 to ORA-99999
        • PLS-00000 to PLS-00999
      • Reserved keywords (MySQL mode)
      • Reserved keywords (Oracle mode)
  • Develop
    • Developer guide (MySQL mode)
      • Connect to OceanBase Database
        • Overview
        • Connect to an OceanBase Database tenant by using a MySQL client
        • Connect to an OceanBase Database tenant by using OBClient
        • Connect to OceanBase Database by using ODC
      • Application development
        • Java
          • Java APIs
          • Connect Java applications to OceanBase Database
        • Python applications
        • Connect C applications to OceanBase Database
      • Create and manage database objects
        • About DDL statements
        • View the currently connected database
        • Change the password of a user
        • Data type
          • Common data types
          • Unsupported data types
        • Create database objects by using ODC
          • Create a table in ODC
          • Create a view in ODC
          • Create a function in ODC
          • Create a stored procedure in ODC
        • Create and manage tables
          • About tables
          • Create a table
          • About auto-increment columns
          • About types of column constraints
          • About table structure modification
          • About table clearing
          • About table dropping
          • Flash back a dropped table
          • About table privileges
        • Create and manage partition tables
          • About partitioned tables
          • Create a partitioned table
          • Manage a partitioned table
          • Create a subpartitioned table
          • Manage a subpartitioned table
          • Partition routing
          • Indexes on partitioned tables
          • Suggestions on using partitioned tables
        • Create and manage indexes
          • Overview
          • Create an index
          • Drop an index
        • Create and manage table groups
          • Overview
          • Create table groups
            • Create a non-partitioned table group
            • Create a subpartitioned table group
          • Specify a table group when creating a table
          • View information about a table group
          • Add a table to a table group
          • Drop a table group
        • Create and manage views
          • About views
          • Create a view
          • Modify a view
          • Drop a view
        • Create and manage sequences
          • About sequences
          • Create a sequence
          • Modify a sequence
          • Drop a sequence
        • Create and manage triggers
          • About triggers
          • Create a trigger
          • Drop a trigger
      • Query
        • Overview of queries
        • Run queries in ODC
        • Single-table queries
        • WHERE queries
        • ORDER BY queries
        • GROUP BY queries
        • Use the LIMIT clause in queries
        • Multi-table join queries
          • Multi-table join queries
          • INNER JOIN queries
          • OUTER JOIN queries
          • Subqueries
        • Use operators and functions in a query
          • Use arithmetic operators in queries
          • Use numerical functions in queries
          • Use string concatenation functions in queries
          • Use string functions in queries
          • Use date and 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
          • Use the SELECT FOR UPDATE statement to lock query results
        • Execution plan
          • View an execution plan
          • Understand an execution plan
        • Use SQL hints in queries
        • Variables of query timeout
      • DML statements and transactions
        • DML statements
          • About DML statements
          • About the INSERT statement
          • UPDATE statements
          • About the DELETE statement
          • About the REPLACE INTO statement
        • Transactions
          • About transaction control statements
          • Start a transaction
          • Transaction savepoints
          • Commit a transaction
          • Roll back a transaction
          • About transaction timeout
    • Developer guide (Oracle mode)
      • Connect to OceanBase Database
        • Overview
        • Connect to an OceanBase Database tenant by using OBClient
        • Connect to OceanBase Database by using ODC
      • Application development
        • Java
          • OceanBase Connector/J
          • Java APIs
          • Connect Java applications to OceanBase Database
        • Python
          • OceanBase Connector/J in Python
          • Python APIs
          • Connect Python applications to OceanBase Database
        • C
          • OBCI
          • OBCI APIs
          • Connect C applications to OceanBase Database
      • Create and manage database objects
        • DDL statements
        • View the currently connected database
        • Change the password of a user
        • Create database objects by Using ODC
          • Create tables, views, functions, and stored procedures in ODC
          • Create a trigger in ODC
          • Create a sequence in ODC
          • Create a program package in ODC
          • Create a synonym in ODC
          • Create a type in ODC
        • Data type
          • Data types
          • Unsupported data types
        • Create and manage tables
          • Overview
          • Create a table
          • Define an auto-increment column by using the SEQUENCE keyword
          • Types of column constraints
          • Modify the structure of a table
          • Clear a table
          • Drop a table
          • Flash back a dropped table
          • Table privileges
        • Create and manage partition tables
          • Overview
          • Create a partitioned table
          • Manage a partitioned table
          • Create a subpartitioned table
          • Manage a subpartitioned table
          • Partition routing
          • Indexing on partitioned tables
          • Recommendations for using partitioned tables
        • Create and manage indexes
          • Drop an index
          • Overview
          • Create an index
        • Create and manage table groups
          • Overview
          • Create table groups
            • Create a non-partitioned table group
            • Create a subpartitioned table group
          • Specify a table group when creating a table
          • View information about a table group
          • Add a table to a table group
          • Drop a table group
        • Create and manage views
          • About views
          • Create a view
          • Modify a view
          • Drop a view
        • Create and manage sequences
          • Overview
          • Create a sequence
          • Modify a sequence
          • Drop a sequence
        • Create and manage synonyms
          • Overview
          • Create a synonym
          • Drop a synonym
        • Create and manage triggers
          • Overview
          • Create a trigger
          • Modify a trigger
          • Drop a trigger
          • Enable or disable a trigger
      • Query
        • About queries
        • Run queries in ODC
        • Single-table queries
        • Conditional queries
        • ORDER BY queries
        • GROUP BY queries
        • Use Row_Limiting_Clause in queries
        • Multi-table join queries
          • Multi-table join queries
          • INNER JOIN queries
          • OUTER JOIN queries
          • Subqueries
        • Use operators and functions in a query
          • Use arithmetic operators in queries
          • Use numerical functions in queries
          • Use string connectors in queries
          • Use string functions in queries
          • Use datetime functions in queries
          • Use type conversion functions in queries
          • Use aggregate functions in queries
          • Use NULL-related functions in queries
          • Use CASE functions in queries
          • Use the SELECT FOR UPDATE statement to lock query results
        • Execution plan
          • View execution plans of queries
          • Understand execution plans
        • Use SQL hints in queries
        • About query timeout variables
      • DML statements and transactions
        • DML statements
          • About DML statements
          • About the INSERT statement
          • About the UPDATE statement
          • About the MERGE statement
          • About the DELETE statement
        • Transactions
          • About transaction control statements
          • Start a transaction
          • Transaction savepoints
          • Commit a transaction
          • Roll back a transaction
          • About transaction timeout
    • Data migration
      • About data migration and synchronization
      • Migrate data by using OMS
      • Export and import data by using ODC
        • Overview
        • Export and import file formats
        • Batch export and import
        • Single table export and import
      • Migrate data by using SQL scripts
        • Common SQL scripts for data migration
        • Export data by using OUTFILE statements
        • Export data by using the LOAD DATA statement
      • Migrate data by using mysqldump
      • Migrate data by using OBLOADER & OBDUMPER
        • Import data by using OBLOADER
        • Export data by using OBDUMPER
      • Migrate data by using DataX
        • DataX
        • Examples of using DataX in OceanBase Database
    • Design conventions and constraints
      • Object naming conventions
        • Overview
        • Tenant naming conventions
        • User naming conventions
        • Table naming conventions
        • Field naming conventions
        • Other naming conventions
      • Object structure conventions
        • Field design
        • Table structure design
        • Partitioned table design
        • Index design
        • Other structural designs
      • Character set specifications
      • Database connection specifications
      • Best practices for database design
        • Configuration example (database connection pool)
          • Overview of database connection pool configuration
          • Example of configuring a Tomcat connection pool
          • Example of configuring a C3P0 connection pool
          • Example of configuring a Proxool connection pool
          • Example of configuring a HiKariCP connection pool
          • Example of configuring a DBCP connection pool
          • CommonPool configuration example
          • Example of configuring a JDBC connection pool
        • Development framework connection example
          • SpringBoot connection example
          • SpringBatch connection example
          • SpringJDBC connection example
          • SpringJPA connection example
          • Hibernate connection example
          • MyBatis connection example
        • Use of table comments
        • ORM conventions
        • Exception handling
    • SQL syntax
      • System tenant
        • Overview
        • ALTER SYSTEM
          • BACKUP
          • BALANCE TASK
          • BOOTSTRAP
          • CANCEL MIGRATE UNIT
          • CHANGE TENANT
          • CLUSTER
          • CONVERT
          • DELETE BACKUPSET
          • DELETE OBSOLETE BACKUP
          • FAILOVER
          • FLUSH PLAN CACHE
          • JOB
          • MERGE
          • MIGRATE UNIT
          • PARAMETER
          • REFRESH
          • REPLICA
          • RESTORE
          • ROOTSERVICE
          • SERVER
          • SET STANDBY CLUSTER
          • SWITCHOVER
          • THROTTLE
          • UPGRADE
          • VALIDATE
          • ZONE
        • ALTER RESOURCE POOL
        • 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
      • User tenants (MySQL mode)
        • Elements
          • Data type
            • Overview
            • Numeric data types
              • Overview
              • Integer data types
              • Fixed-point data types
              • Floating-point data types
              • Bit value data type
            • Date and time data types
              • Overview
              • DATE, DATETIME, and TIMESTAMP types
              • TIME type
              • YEAR type
            • Character data types
              • Overview
              • CHAR and VARCHAR
              • BINARY and VARBINARY
            • BLOB and TEXT data types
              • Overview
              • BLOB types
              • TEXT types
            • ENUM data type
            • SET data type
            • JSON data types
              • Overview
              • Create a JSON value
              • Query and modify JSON values
              • Convert a JSON data type
            • Spatial data types
              • Overview
              • SRS
              • Create a spatial column
              • Create a spatial index
              • Spatial data formats
          • Expressions
            • Overview
            • Expression syntax
            • Convert data types in expression evaluation
          • Character sets and collations
            • Overview
            • Character sets
            • Collations
            • Database-level character sets and collations
            • Table-level character sets and collations
            • Column-level character sets and collations
            • Character sets and collations for character expressions
            • Character sets and collations for client connection
          • Literals
            • Overview
            • Strings
            • Numbers
            • Datetime values
            • Bit values
            • Boolean values
            • NULLs
          • Schema object names
          • User-defined variables
          • Comments
        • Operators
          • Overview
          • Operator precedence
          • Arithmetic operators
          • Bitwise operators
          • Comparison operators
          • Logical operators
          • Assignment operators
          • Date and time operators
          • Concatenation operators
          • BINARY operator
          • CASE conditional operator
        • Sequence pseudocolumns
        • Functions
          • Overview
          • Single-row functions
            • Date and time 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
              • DAY
            • String functions
              • ASCII
              • BIN
              • BIT_LENGTH
              • CHAR
              • CHAR_LENGTH
              • CONCAT
              • CONCAT_WS
              • EXPORT_SET
              • ELT
              • FIELD
              • FIND_IN_SET
              • FORMAT
              • HEX
              • INSERT
              • INSTR
              • INT2IP
              • IP2INT
              • LCASE
              • LEFT
              • LENGTH
              • LOCATE
              • LOWER
              • LPAD
              • LTRIM
              • MAKE_SET
              • MID
              • OCT
              • ORD
              • POSITION
              • QUOTE
              • REGEXP
              • REGEXP_INSTR
              • REGEXP_LIKE
              • REGEXP_REPLACE
              • REGEXP_SUBSTR
              • REPEAT
              • REPLACE
              • REVERSE
              • RIGHT
              • RLIKE
              • RPAD
              • RTRIM
              • SPACE
              • STRCMP
              • SUBSTR
              • SUBSTRING
              • SUBSTRING_INDEX
              • TRIM
              • UCASE
              • UNHEX
              • UPPER
              • WEIGHT_STRING
              • TO_BASE64
              • FROM_BASE64
            • Conversion functions
              • CAST
              • CONVERT
            • Mathematical functions
              • ABS
              • ACOS
              • ASIN
              • ATAN
              • ATAN2
              • BIT_COUNT
              • CEIL
              • CEILING
              • CONV
              • COS
              • COT
              • CRC32
              • DEGREES
              • EXP
              • FLOOR
              • LN
              • LOG
              • LOG10
              • LOG2
              • MOD
              • NEG
              • PI
              • POW
              • POWER
              • RADIANS
              • RAND
              • ROUND
              • SIGN
              • SIN
              • SQRT
              • TAN
              • TRUNCATE
            • Comparison functions
              • GREATEST
              • INTERVAL
              • ISNULL
              • LEAST
            • Process control functions
              • IF
              • IFNULL
              • NULLIF
              • ORA_DECODE
          • Aggregate functions
            • APPROX_COUNT_DISTINCT
            • AVG
            • BIT_AND
            • BIT_OR
            • BIT_XOR
            • COUNT
            • GROUP_CONCAT
            • GROUPING
            • MAX
            • MIN
            • STD
            • STDDEV
            • STDDEV_POP
            • STDDEV_SAMP
            • SUM
            • VAR_POP
            • VAR_SAMP
            • VARIANCE
          • Analytic functions
            • APPROX_COUNT_DISTINCT
            • AVG
            • COUNT
            • CUME_DIST
            • DENSE_RANK
            • FIRST_VALUE
            • LAG
            • LAST_VALUE
            • LEAD
            • MAX
            • MIN
            • NTH_VALUE
            • NTILE
            • PERCENT_RANK
            • RANK
            • ROW_NUMBER
            • STD
            • STDDEV
            • STDDEV_POP
            • STDDEV_SAMP
            • SUM
            • VAR_POP
            • VAR_SAMP
            • VARIANCE
          • Encryption functions
            • AES_DECRYPT
            • AES_ENCRYPT
            • MD5
          • Information functions
            • BENCHMARK
            • CHARSET
            • COERCIBILITY
            • COLLATION
            • CONNECTION_ID
            • CURRENT_USER
            • DATABASE
            • FOUND_ROWS
            • LAST_INSERT_ID
            • SCHEMA
            • ROW_COUNT
            • SESSION_USER
            • SYSTEM_USER
            • USER
            • VERSION
            • OB_VERSION
          • JSON functions
            • Functions that create JSON values
              • JSON_ARRAY
              • JSON_OBJECT
              • JSON_QUOTE
            • Functions that search JSON values
              • JSON_CONTAINS
              • JSON_CONTAINS_PATH
              • JSON_EXTRACT
              • JSON_KEYS
              • JSON_OVERLAPS
              • JSON_SEARCH
              • JSON_VALUE
              • MEMBER OF
            • Functions that modify JSON values
              • JSON_ARRAY_APPEND
              • JSON_ARRAY_INSERT
              • JSON_INSERT
              • JSON_MERGE
              • JSON_MERGE_PATCH
              • JSON_MERGE_PRESERVE
              • JSON_REMOVE
              • JSON_REPLACE
              • JSON_SET
              • JSON_UNQUOTE
            • Functions that return JSON text attributes
              • JSON_DEPTH
              • JSON_LENGTH
              • JSON_TYPE
              • JSON_VALID
            • JSON utility functions
              • JSON_PRETTY
              • JSON_STORAGE_SIZE
            • JSON aggregate functions
              • JSON_ARRAYAGG
              • JSON_OBJECTAGG
          • Other functions
            • ANY_VALUE
            • COALESCE
            • DEFAULT
            • INET_ATON
            • INET_NTOA
            • INET6_ATON
            • INET6_NTOA
            • IS_IPV4
            • IS_IPV4_COMPAT
            • IS_IPV4_MAPPED
            • IS_IPV6
            • NVL
            • SLEEP
            • UUID
            • UUID_SHORT
            • VALUES
          • Spatial functions
            • Create a geometric function
            • Spatial operation functions
            • Spatial relation functions
            • Geometry property functions
            • Geometric format conversion functions
        • Queries and subqueries
          • Overview
          • Subqueries
          • JOIN
        • SQL statements
          • General syntax
          • CTE
          • ALTER DATABASE
          • ALTER OUTLINE
          • ALTER SEQUENCE
          • ALTER TABLE
          • ALTER TABLEGROUP
          • ALTER USER
          • ALTER VIEW
          • ANALYZE
          • CREATE DATABASE
          • CREATE INDEX
          • CREATE OUTLINE
          • CREATE RESTORE POINT
          • CREATE SEQUENCE
          • CREATE TABLE
          • CREATE TABLEGROUP
          • CREATE USER
          • CREATE VIEW
          • DEALLOCATE PREPARE
          • DELETE
          • DESCRIBE
          • DROP DATABASE
          • DROP INDEX
          • DROP OUTLINE
          • DROP RESTORE POINT
          • DROP TABLE
          • DROP TABLEGROUP
          • DROP SEQUENCE
          • DROP USER
          • DROP VIEW
          • EXECUTE
          • EXPLAIN
          • FLASHBACK
          • GRANT
          • HELP
          • INSERT
          • KILL
          • LOAD DATA
          • OPTIMIZE
          • PREPARE
          • PURGE
          • PURGE RECYCLEBIN
          • RENAME TABLE
          • RENAME USER
          • REPLACE
          • REVOKE
          • SAVEPOINT
          • SCHEMA
          • SELECT
            • SELECT
            • JOIN clause
            • OVER clause
            • UNION clause
          • SELECT INTO
          • SET
          • SET CHARSET
          • SET NAMES
          • SET PASSWORD
          • SET TRANSACTION
          • SHOW
          • TRANSACTION
          • TRUNCATE TABLE
          • UPDATE
          • USE
      • User tenants (Oracles mode)
        • SQL overview
        • Pseudocolumns
          • Overview
          • Hierarchical query pseudocolumns
          • Sequence pseudocolumns
          • ORA_ROWSCN pseudocolumn
          • ROWNUM pseudocolumn
          • ROWID pseudocolumn
        • Elements
          • Built-in data types
            • Overview of built-in data types
            • Character data types
              • Overview of character data types
              • CHAR data type
              • NCHAR data type
              • NVARCHAR2 data type
              • VARCHAR2 data type
              • VARCHAR data type
            • Numeric data types
              • Overview
              • NUMBER data type
              • FLOAT data type
              • Floating-point numbers
              • Precedence of numeric data types
            • Date, time, and interval data types
              • Overview of datetime and interval data types
              • DATE data type
              • TIMESTAMP data type
              • TIMESTAMP WITH TIME ZONE date type
              • TIMESTAMP WITH LOCAL TIME ZONE data type
              • INTERVAL YEAR TO MONTH data type
              • INTERVAL DAY TO SECOND data type
              • Calculation of dates, timestamps, and intervals
            • RAW data type
            • Large object data types
              • Overview
              • BLOB data type
              • CLOB data type
            • Rowid data types
            • User-defined data types
          • Comparison rules of data types
            • Overview
            • Numeric value comparison rules
            • Date value comparison rules
            • Character value comparison rules
            • Data type precedence
            • Data type conversion rules
            • Security considerations for data conversion
          • Literals
            • Overview
            • Text literals
            • Numeric literals
            • Datetime literals
              • Date literals
              • Timestamp literals
            • Interval literals
          • Format models
            • Overview
            • Number format models
            • Datetime format models
            • RR datetime format element
            • String-to-date conversion rules
          • Null values
            • Overview of nulls
            • Nulls in SQL functions
            • Nulls in comparison conditions
            • Nulls in conditional expressions
          • Comments
            • Overview
            • Comments within SQL statements
            • Comments on schema and nonschema objects
            • Hint
              • Overview of hints
              • Lists of hints
                • Hints related to access path
                • Hints related to join orders
                • Hints related to joins
                • Hints related to parallel execution
                • Hints related to query strategy
                • Hints related to query conversion
                • Other hints
          • Database objects
            • Schema objects
            • Non-schema objects
          • Database naming conventions
            • Overview
            • Database object names and qualifiers
            • Suggestions on schema object names
          • Methods of referencing database objects
            • Overview
            • Reference schema objects
            • Reference objects in a remote database
              • Create database links
              • Reference database links
            • Reference partition tables and indexes
            • Reference an attribute or method of an object type
        • Operators
          • Overview of operators
          • Operator precedence
          • Arithmetic operators
          • Concatenation operator
          • Hierarchical query operators
          • Set operators
          • COLLATE operator
        • Functions
          • Function overview
          • Single-row functions
            • Numeric functions
              • ABS
              • ACOS
              • ASIN
              • ATAN
              • ATAN2
              • BITAND
              • CEIL
              • COS
              • COSH
              • EXP
              • FLOOR
              • LN
              • LOG
              • MOD
              • NANVL
              • POWER
              • REMAINDER
              • ROUND
              • SIGN
              • SIN
              • SINH
              • SQRT
              • TAN
              • TANH
              • TRUNC
              • WIDTH_BUCKET
            • String functions that return strings
              • CHR
              • CONCAT
              • INITCAP
              • LOWER
              • LPAD
              • LTRIM
              • NLS_LOWER
              • NLS_UPPER
              • REGEXP_REPLACE
              • REGEXP_SUBSTR
              • REPLACE
              • RPAD
              • RTRIM
              • SUBSTR
              • TRANSLATE
              • TRANSLATE ... USING
              • TRIM
              • UPPER
            • String functions that return numbers
              • ASCII
              • INSTR
              • LENGTH
              • REGEXP_COUNT
              • REGEXP_INSTR
            • Datetime functions
              • ADD_MONTHS
              • CURRENT_DATE
              • CURRENT_TIMESTAMP
              • DBTIMEZONE
              • EXTRACT (datetime)
              • FROM_TZ
              • LAST_DAY
              • LOCALTIMESTAMP
              • MONTHS_BETWEEN
              • NEXT_DAY
              • NUMTODSINTERVAL
              • NUMTOYMINTERVAL
              • ROUND (date)
              • SESSIONTIMEZONE
              • SYS_EXTRACT_UTC
              • SYSDATE
              • SYSTIMESTAMP
              • TO_CHAR (datetime)
              • TO_DSINTERVAL
              • TO_TIMESTAMP
              • TO_TIMESTAMP_TZ
              • TO_YMINTERVAL
              • TRUNC (date)
              • TZ_OFFSET
            • General comparison functions
              • GREATEST
              • LEAST
            • Conversion functions
              • ASCIISTR
              • CAST
              • CHARTOROWID
              • CONVERT
              • HEXTORAW
              • NUMTODSINTERVAL
              • NUMTOYMINTERVAL
              • RAWTOHEX
              • ROWIDTOCHAR
              • ROWIDTONCHAR
              • TO_BINARY_DOUBLE
              • TO_BINARY_FLOAT
              • TO_BLOB
              • TO_CHAR (character)
              • TO_CHAR (datetime)
              • TO_CHAR (number)
              • TO_CLOB
              • TO_DATE
              • TO_DSINTERVAL
              • TO_MULTI_BYTE
              • TO_NUMBER
              • TO_NCHAR (character)
              • TO_NCHAR (datetime)
              • TO_NCHAR (number)
              • TO_SINGLE_BYTE
              • TO_TIMESTAMP
              • TO_TIMESTAMP_TZ
              • TO_YMINTERVAL
              • UNISTR
            • Encoding and decoding functions
              • DECODE
              • DUMP
              • ORA_HASH
              • VSIZE
            • Null value-related functions
              • COALESCE
              • LNNVL
              • NANVL
              • NULLIF
              • NVL
              • NVL2
            • Environment and identifier functions
              • SYS_CONTEXT
              • SYS_GUID
              • UID
              • USER
              • USERENV
              • OB_VERSION
            • Hierarchical functions
              • SYS_CONNECT_BY_PATH
            • XML functions
              • XMLAGG
              • XMLATTRIBUTES
              • XMLELEMENT
              • XMLPARSE
          • Aggregate functions
            • APPROX_COUNT_DISTINCT
            • AVG
            • CORR
            • COUNT
            • COVAR_POP
            • COVAR_SAMP
            • CUME_DIST
            • DENSE_RANK
            • GROUPING
            • KEEP
            • LISTAGG
            • MAX
            • MEDIAN
            • MIN
            • PERCENT_RANK
            • PERCENTILE_CONT
            • PERCENTILE_DISC
            • RANK
            • REGR_ (Linear Regression) Functions
            • ROLLUP
            • STDDEV
            • STDDEV_POP
            • STDDEV_SAMP
            • SUM
            • VAR_POP
            • VAR_SAMP
            • VARIANCE
            • WMSYS.WM_CONCAT/WM_CONCAT
          • Analytic functions
            • Analytic functions
            • AVG
            • CORR
            • COUNT
            • COVAR_POP
            • COVAR_SAMP
            • CUME_DIST
            • DENSE_RANK
            • FIRST_VALUE
            • KEEP
            • LAG
            • LAST_VALUE
            • LEAD
            • LISTAGG
            • MAX
            • MEDIAN
            • MIN
            • NTILE
            • NTH_VALUE
            • PERCENT_RANK
            • PERCENTILE_CONT
            • PERCENTILE_DISC
            • RANK
            • RATIO_TO_REPORT
            • REGR_ (Linear Regression) Functions
            • ROW_NUMBER
            • STDDEV
            • STDDEV_POP
            • STDDEV_SAMP
            • SUM
            • VAR_POP
            • VAR_SAMP
            • VARIANCE
            • WMSYS.WM_CONCAT/WM_CONCAT
        • Expressions
          • Overview
          • Simple expressions
          • Compound expressions
          • Case expressions
          • Column expressions
          • CURSOR expressions
          • Datetime expressions
          • Function expressions
          • Interval expressions
          • Scalar subquery expressions
          • Type constructor expressions
          • Expression list
        • Conditions
          • Overview of SQL conditions
          • Condition precedence
          • Comparison conditions
          • Floating-point conditions
          • Logical conditions
          • Pattern-matching conditions
          • Null conditions
          • Compound conditions
          • BETWEEN condition
          • EXISTS condition
          • IN condition
        • Queries and subqueries
          • Overview of queries and subqueries
          • Simple query
          • Hierarchical query
          • Compound queries
          • Join queries
          • Subquery
          • DUAL table query
        • SQL statements
          • DDL
            • ALTER INDEX
            • ALTER KEYSTORE
            • ALTER OUTLINE
            • ALTER PROFILE
            • ALTER ROLE
            • ALTER SEQUENCE
            • ALTER SESSION
            • ALTER SYSTEM FLUSH PLAN CACHE
            • ALTER SYSTEM PARAMETER
            • ALTER TABLE
            • ALTER TABLEGROUP
            • ALTER USER
            • CREATE DIRECTORY
            • CREATE DATABASE LINK
            • CREATE INDEX
            • CREATE KEYSTORE
            • CREATE OUTLINE
            • CREATE PROFILE
            • CREATE RESTORE POINT
            • CREATE ROLE
            • CREATE SEQUENCE
            • CREATE SYNONYM
            • CREATE TABLE
            • CREATE TABLEGROUP
            • CREATE TABLESPACE
            • CREATE USER
            • CREATE VIEW
            • DROP DIRECTORY
            • DROP DATABASE LINK
            • DROP INDEX
            • DROP OUTLINE
            • DROP PROFILE
            • DROP RESTORE POINT
            • DROP ROLE
            • DROP SEQUENCE
            • DROP SYNONYM
            • DROP TABLE
            • DROP TABLEGROUP
            • DROP TABLESPACE
            • DROP USER
            • DROP VIEW
            • RENAME
            • TRUNCATE TABLE
          • DML
            • DELETE
            • INSERT
            • MERGE
            • PURGE
            • SELECT
              • SIMPLE SELECT
              • Set-based SELECT
              • WITH clause
            • UPDATE
          • DCL
            • ANALYZE
            • AUDIT
            • COMMENT
            • COMMIT
            • EXPLAIN
            • FLASHBACK TABLE BEFORE DROP
            • GRANT
            • KILL
            • REVOKE
            • ROLLBACK
            • SAVEPOINT
            • SET NAMES
            • SET PASSWORD
            • SET ROLE
            • SET VARIABLE
            • SHOW
            • SHRINK
            • TRANSACTION
    • PL reference
      • What is PL?
        • Overview
        • Main features of PL
        • PL architecture
      • PL reference (MySQL mode)
        • Syntax of PL stored programs
        • Stored programs
          • Overview
          • Variables in stored programs
          • Stored procedures
          • Stored functions
          • Triggers
          • Access control and account management
          • Limitations on stored programs
        • Cursors
          • Overview
          • Cursor execution process
          • Limitations on server cursors
        • Conditional control statements
          • CASE
          • IF
          • ITERATE
          • LEAVE
          • LOOP
          • REPEAT
          • RETURN
          • WHILE
        • Data manipulation statements
          • CALL
          • DO
        • Data definition statements
          • CREATE FUNCTION
          • CREATE PROCEDURE
          • CREATE TRIGGER
          • DROP FUNCTION
          • DROP PROCEDURE
          • DROP TRIGGER
        • Database management statements
          • SHOW CREATE FUNCTION
          • SHOW CREATE PROCEDURE
          • SHOW CREATE TRIGGER
          • SHOW FUNCTION STATUS
          • SHOW PROCEDURE STATUS
          • SHOW TRIGGERS
        • Dictionary view
          • INFORMATION_SCHEMA PARAMETERS
          • INFORMATION_SCHEMA ROUTINES
          • INFORMATION_SCHEMA TRIGGERS
        • Exception handling
          • Overview
          • DECLARE ... CONDITION
          • DECLARE ... HANDLER
          • GET DIAGNOSTICS
          • RESIGNAL
          • SIGNAL
          • Effective scope of an exception handler
          • Diagnostics area
          • Exception handling and OUT/INOUT parameters
          • Limitations on exception handling
        • PL packages
          • DBMS_RESOURCE_MANAGER
            • Overview
            • CREATE_CONSUMER_GROUP
            • CREATE_PLAN
            • CREATE_PLAN_DIRECTIVE
            • DELETE_CONSUMER_GROUP
            • DELETE_PLAN
            • DELETE_PLAN_DIRECTIVE
            • SET_CONSUMER_GROUP_MAPPING
            • UPDATE_PLAN_DIRECTIVE
          • DBMS_STATS
            • Overview
            • DELETE_COLUMN_STATS
            • DELETE_TABLE_STATS
            • EXPORT_COLUMN_STATS
            • EXPORT_TABLE_STATS
            • FLUSH_DATABASE_MONITORING_INFO
            • GATHER_TABLE_STATS
            • IMPORT_COLUMN_STATS
            • IMPORT_TABLE_STATS
            • LOCK_PARTITION_STATS
            • LOCK_SCHEMA_STATS
            • LOCK_TABLE_STATS
            • SET_COLUMN_STATS
            • SET_TABLE_STATS
            • UNLOCK_PARTITION_STATS
            • UNLOCK_SCHEMA_STATS
            • UNLOCK_TABLE_STATS
        • Reserved and non-reserved PL keywords
      • PL reference (Oracle mode)
        • Language basics
          • Character sets
          • Lexical units
          • Declaration
          • Reference identifiers
          • Scope and visibility of identifiers
          • Assign values
          • Expressions
          • PL blocks
          • Subprograms
          • Error-reporting functions
        • Data types
          • Overview
          • SQL data types
          • LOB data types
          • BOOLEAN type
          • User-defined subtypes
          • PLS_INTEGER and BINARY_INTEGER
          • Arrays
        • Flow control
          • Overview
          • Conditional control
          • Loop control
          • Sequential control
        • Collections and records
          • Overview
          • Collections
          • Associative arrays
          • Varrays
          • Nested tables
          • Collection constructor function
          • Collection methods
            • Overview of collection methods
            • DELETE method
            • TRIM method
            • EXTEND method
            • EXISTS method
            • FIRST and LAST methods
            • COUNT method
            • LIMIT method
            • PRIOR and NEXT methods
          • Records
          • Insert records into a table and update a table by using records
          • Create and call a subprogram with record type parameters
        • Static SQL
          • Overview
          • Cursors
            • Overview
            • Cursor attributes
            • Implicit cursors
            • Explicit cursors
            • Cursor variables
            • Traverse cursor data by using the FOR loop
            • Modify and drop a cursor
          • Transaction processing and control
          • Autonomous transactions
            • Overview
            • Control autonomous transactions
            • Autonomous triggers
        • Dynamic SQL
          • Overview
          • Execute dynamic SQL statements
          • DBMS_SQL system package
        • Stored procedures and functions
          • Overview
          • Create a stored procedure
          • Create a function
          • Manage stored procedures and functions
          • Privilege control
          • User-defined aggregate functions
            • Overview
            • Interface for user-defined aggregate functions
            • Create user-defined aggregate functions
            • Use user-defined aggregate functions
        • Triggers
          • Overview
          • Create a DML trigger
          • Modify and drop a trigger
          • Disable or enable a trigger
          • Query trigger information
          • INSTEAD OF DML trigger
        • Packages
          • Overview
          • Create a program package
          • Overloaded programs in a package
          • Manage program packages
          • Definition of the PL environment by the STANDARD package
        • Exception handling
          • Overview
          • Compile-Time alerts
          • Exception types
          • Exception handling processes
        • DDL operations on stored PL units
          • Overview
          • ALTER FUNCTION
          • ALTER PACKAGE
          • ALTER PROCEDURE
          • ALTER TRIGGER
          • ALTER TYPE
          • CREATE FUNCTION
          • CREATE PACKAGE
          • CREATE PACKAGE BODY
          • CREATE PROCEDURE
          • CREATE TRIGGER
          • CREATE TYPE
          • CREATE TYPE BODY
          • DROP FUNCTION
          • DROP PACKAGE
          • DROP PROCEDURE
          • DROP TRIGGER
          • DROP TYPE
          • DROP TYPE BODY
        • PL packages
          • Overview
          • DBMS_APPLICATION_INFO
            • Overview
            • READ_CLIENT_INFO
            • READ_MODULE
            • SET_ACTION
            • SET_CLIENT_INFO
            • SET_MODULE
          • DBMS_CRYPTO
            • Overview
            • ENCRYPT
            • DECRYPT
            • HASH
          • DBMS_DEBUG
            • Overview
            • ATTACH_SESSION
            • CONTINUE
            • DEBUG_ON
            • DEBUG_OFF
            • DETACH_SESSION
            • DELETE_BREAKPOINT
            • DISABLE_BREAKPOINT
            • ENABLE_BREAKPOINT
            • GET_VALUE
            • GET_VALUES
            • GET_RUNTIME_INFO
            • GET_TIMEOUT_BEHAVIOUR
            • INITIALIZE
            • PROBE_VERSION
            • PRINT_BACKTRACE
            • SET_TIMEOUT
            • SET_TIMEOUT_BEHAVIOUR
            • SET_BREAKPOINT
            • SHOW_BREAKPOINTS
          • DBMS_DESCRIBE
            • Overview
            • DESCRIBE_PROCEDURE
          • DBMS_JOB
            • Overview
            • BROKEN
            • CHANGE
            • ZONE
            • INTERVAL
            • NEXT_DATE
            • REMOVE
            • RUN
            • SUBMIT
            • USER_EXPORT
            • WHAT
          • DBMS_LOB
            • Overview
            • APPEND
            • CLOSE
            • COMPARE
            • COPY
            • CREATETEMPORARY
            • ERASE
            • FREETEMPORARY
            • GETLENGTH
            • ISOPEN
            • INSTR
            • OPEN
            • READ
            • SUBSTR
            • TRIM
            • WRITE
            • WRITEAPPEND
          • DBMS_LOCK
            • Overview
            • SLEEP
          • DBMS_METADATA
            • Overview
            • GET_DDL
          • DBMS_OUTPUT
            • Overview
            • DISABLE
            • ENABLE
            • GET_LINE
            • GET_LINES
            • NEW_LINE
            • PUT
            • PUT_LINE
          • DBMS_PLAN_CACHE
            • Overview
            • PURGE
          • DBMS_RANDOM
            • Overview
            • INITIALIZE
            • NORMAL
            • RANDOM
            • SEED
            • STRING
            • TERMINATE
            • VALUE
          • DBMS_RESOURCE_MANAGER
            • Overview
            • CREATE_CONSUMER_GROUP
            • CREATE_PLAN
            • CREATE_PLAN_DIRECTIVE
            • DELETE_CONSUMER_GROUP
            • DELETE_PLAN
            • DELETE_PLAN_DIRECTIVE
            • SET_CONSUMER_GROUP_MAPPING
            • UPDATE_PLAN_DIRECTIVE
          • DBMS_SCHEDULER
            • Overview
            • CREATE_JOB
            • CREATE_PROGRAM
            • DEFINE_PROGRAM_ARGUMENT
            • DISABLE
            • DROP_JOB
            • DROP_PROGRAM
            • ENABLE
            • GENERATE_JOB_NAME
            • RUN_JOB
            • SET_ATTRIBUTE
            • SET_JOB_ARGUMENT_VALUE
          • DBMS_SESSION
            • Overview
            • CLEAR_ALL_CONTEXT
            • CLEAR_CONTEXT
            • CLEAR_IDENTIFIER
            • SET_CONTEXT
            • SET_IDENTIFIER
          • DBMS_SQL
            • Overview
            • BIND_VARIABLE
            • CLOSE_CURSOR
            • COLUMN_VALUE
            • DEFINE_COLUMN
            • DEFINE_ARRAY
            • DESCRIBE_COLUMNS
            • EXECUTE
            • EXECUTE_AND_FETCH
            • FETCH_ROWS
            • IS_OPEN
            • OPEN_CURSOR
            • PARSE
          • DBMS_STATS
            • Overview
            • DELETE_COLUMN_STATS
            • DELETE_TABLE_STATS
            • EXPORT_COLUMN_STATS
            • EXPORT_TABLE_STATS
            • FLUSH_DATABASE_MONITORING_INFO
            • GATHER_TABLE_STATS
            • IMPORT_COLUMN_STATS
            • IMPORT_TABLE_STATS
            • LOCK_PARTITION_STATS
            • LOCK_SCHEMA_STATS
            • LOCK_TABLE_STATS
            • SET_COLUMN_STATS
            • SET_TABLE_STATS
            • UNLOCK_PARTITION_STATS
            • UNLOCK_SCHEMA_STATS
            • UNLOCK_TABLE_STATS
          • DBMS_UTILITY
            • Overview
            • ACTIVE_INSTANCES
            • COMMA_TO_TABLE
            • CURRENT_INSTANCE
            • DB_VERSION
            • FORMAT_CALL_STACK
            • FORMAT_ERROR_BACKTRACE
            • FORMAT_ERROR_STACK
            • GET_ENDIANNESS
            • GET_HASH_VALUE
            • GET_PARAMETER_VALUE
            • GET_SQL_HASH
            • GET_TIME
            • IS_BIT_SET
            • IS_CLUSTER_DATABASE
            • NAME_RESOLVE
            • NAME_TOKENIZE
            • OLD_CURRENT_SCHEMA
            • OLD_CURRENT_USER
            • PORT_STRING
            • TABLE_TO_COMMA
          • DBMS_XA
            • Overview
            • DBMS_XA constants
            • DBMS_XA_XID object type
            • DIST_TXN_SYNC
            • XA_COMMIT
            • XA_END
            • XA_FORGET
            • XA_GETLASTOER
            • XA_PREPARE
            • XA_RECOVER
            • XA_ROLLBACK
            • XA_SETTIMEOUT
            • XA_START
          • ODCICONST
            • Overview
            • ODCIArgDesc.ArgType
            • ODCIEnv.CallProperty
            • ODCIEnv.Envflags
            • ODCIIndexAlter
            • ODCIIndexAlter parameter alter_option
            • ODCIIndexInfo.IndexInfoFlags
            • ODCIIndexInfo.IndexParaDegree
            • ODCIPredInfo.Flags
            • ODCIQueryInfo.Flags
            • ODCIStatsOptions.Flags
            • ODCIStatsOptions.Options
            • Return Status
            • ScnFlg
          • UTL_FILE
            • Overview
            • FCLOSE
            • FFLUSH
            • FOPEN
            • FGETPOS
            • FREMOVE
            • FRENAME
            • FSEEK
            • NEW_LINE
            • GET_LINE
            • PUT
            • PUT_LINE
          • UTL_ENCODE
            • Overview
            • BASE64_DECODE
            • BASE64_ENCODE
          • UTL_I18N
            • Overview
            • RAW_TO_CHAR
            • STRING_TO_RAW
          • UTL_RAW
            • Overview
            • BIT_AND
            • BIT_COMPLEMENT
            • BIT_OR
            • BIT_XOR
            • CAST_FROM_BINARY_DOUBLE
            • CAST_FROM_BINARY_FLOAT
            • CAST_FROM_BINARY_INTEGER
            • CAST_FROM_NUMBER
            • CAST_TO_BINARY_DOUBLE
            • CAST_TO_BINARY_FLOAT
            • CAST_TO_BINARY_INTEGER
            • CAST_TO_NUMBER
            • CAST_TO_NVARCHAR2
            • CAST_TO_RAW
            • CAST_TO_VARCHAR2
            • COMPARE
            • CONCAT
            • COPIES
            • LENGTH
            • REVERSE
            • SUBSTR
        • PL label security package
          • Overview of label security PL packages
          • SA_SYSDBA policy management package
            • Overview
            • SA_SYSDBA.ALTER_POLICY
            • SA_SYSDBA.CREATE_POLICY
            • SA_SYSDBA.DROP_POLICY
          • SA_COMPONENTS label component package
            • Overview
            • SA_COMPONENTS.ALTER_LEVEL
            • SA_COMPONENTS.CREATE_LEVEL
            • SA_COMPONENTS.DROP_LEVEL
          • SA_LABEL_ADMIN label management package
            • Overview
            • SA_LABEL_ADMIN.ALTER_LABEL
            • SA_LABEL_ADMIN.CREATE_LABEL
            • SA_LABEL_ADMIN.DROP_LABEL
          • SA_POLICY_ADMIN policy management package
            • Overview
            • SA_POLICY_ADMIN.APPLY_TABLE_POLICY
            • SA_POLICY_ADMIN.DISABLE_TABLE_POLICY
            • SA_POLICY_ADMIN.ENABLE_TABLE_POLICY
            • SA_POLICY_ADMIN.REMOVE_TABLE_POLICY
          • SA_USER_ADMIN user label management package
            • Overview
            • SA_USER_ADMIN.SET_LEVELS
          • SA_SESSION session management package
            • Overview
            • SA_SESSION.LABEL
            • SA_SESSION.RESTORE_DEFAULT_LABELS
            • SA_SESSION.ROW_LABEL
            • SA_SESSION.SET_LABEL
            • SA_SESSION.SET_ROW_LABEL
        • Reserved PL keywords
    • SQL practices and recommendations
      • Limits on writing SQL statements
      • SQL writing conventions
        • SELECT statements
        • DML statements
        • Multi-table join statements
        • Table scan
        • Transactions
        • Cache
        • Hint
        • Others
      • SQL statement examples
        • Implicit data type conversion
        • JOIN tables
        • Weak consistency read
        • Pagination queries
    • Common errors and solutions
      • MySQL
        • About error codes
        • Database connection error
        • Timeout errors
          • Idle session timeout
          • Transaction timeout errors
        • User errors
          • Locked user
          • Incorrect user password
        • Table errors
          • Table already exists
          • Table does not exist
          • Invalid use of NULL value
        • Constraint errors
          • Unique key conflict
          • Foreign key conflicts
        • SQL errors
          • Data inconsistency
      • Oracle
        • Overview
        • Database connection error
        • Timeout errors
          • Idle session timeout
          • Transaction timeout errors
        • User errors
          • Locked user
          • Incorrect user password
        • Object errors
          • Object already exists
          • Object does not exist
        • Constraint errors
          • Unique key conflict
          • Foreign key conflicts
        • SQL errors
          • Data type inconsistency
  • Architecture
    • Architecture of OceanBase Database
    • Development of OceanBase Database
    • Multi-tenant architecture
      • Overview
      • Compatibility modes
      • System tenants
      • User tenants
      • Tenant and resource management
        • Manage tenant resources
        • Multi-tenant resource isolation
        • Balance resource units
    • Database objects
      • Oracle mode
        • Introduction to database objects
          • Overview
          • Database object types
          • Database object storage
          • Dependencies between database objects
        • Tables
          • Overview
          • Data types
            • Overview
            • Character data types
            • Numeric data types
            • Date and time data types
            • ROWID data types
            • LOB data types
            • Format models
              • Overview
              • Number format models
              • Datetime format models
          • Integrity constraints
          • Table storage
          • Table compression
          • Partitioned tables
          • Table groups
          • Tables with and without a primary key
          • Temporary tables
        • Indexes
          • Overview of indexes
          • Local and global indexes
          • Unique and non-unique indexes
          • Index usage
          • Index storage
        • Partitions
          • Overview
          • Partition key
          • Partition types
          • Partitioned indexes
        • Views
          • Overview
          • Data manipulation in views
          • Data access from views
          • Updatable views
        • Other objects
          • Sequences
          • Synonyms
        • System views
          • Dictionary views
          • Dynamic performance views
        • Data integrity
          • Overview
          • Types of integrity constraints
            • Overview
            • NOT NULL constraints
            • UNIQUE KEY constraints
            • PRIMARY KEY constraints
            • Foreign key constraints
            • CHECK constraints
          • Use of integrity constraints
      • MySQL mode
        • Introduction to database objects
          • Overview
          • Database object types
          • Database object storage
          • Dependencies between database objects
        • Tables
          • Overview
          • Data types
            • Overview
            • Numeric data types
            • Date and time data types
            • Character data types
            • LOB data types
          • Integrity constraints
          • Table storage
          • Table compression
          • Partitioned tables
          • Table groups
          • Tables with and without a primary key
        • Indexes
          • Overview
          • Local and global indexes
          • Unique and non-unique indexes
          • Index usage
          • Index storage
        • Partitions
          • Overview
          • Partition key
          • Partitioning strategies
          • Partitioned indexes
        • Views
          • Overview
          • Data manipulation in views
          • Data access from views
          • Updatable views
        • System views
          • Dictionary views
          • Performance views
        • Data integrity
          • Overview
          • Types of integrity constraints
            • Overview
            • NOT NULL integrity constraints
            • UNIQUE KEY constraints
            • PRIMARY KEY constraints
            • Foreign key constraints
          • Use of integrity constraints
    • Distributed database objects
      • Overview
      • Cluster architecture
      • Data partitions and replicas
        • Overview
        • Partition replica types
          • Overview
          • Full-featured replicas
          • Log-only replicas
          • Encrypted voting replicas
          • Read-only replicas
        • Multi-replica consensus protocols
        • Data balancing
          • Partition replica balancing
            • Automatic load balancing
            • Table groups
          • Leader balancing
            • Automatic load balancing
            • Primary zone
      • Dynamic scaling
        • Cluster scaling
        • Tenant resource scaling
          • Overview
          • Horizontal scaling of tenant resources
          • Vertical scaling of tenant resources
          • Cross-zone management of tenant resources
    • Data link
      • Overview
      • ODP
        • Overview
        • SQL statement routing
        • Connection management
        • Configuration management
        • Logs and monitoring
      • Database drivers
        • Overview
        • OBCI
        • OceanBase Connector/J
        • OceanBase Connector/C
    • User interfaces and query languages
      • SQL
        • SQL introduction
          • SQL overview
          • SQL data access
          • SQL standards
        • SQL statement
          • Overview
          • DDL
          • DML
          • DCL
        • Execution process of SQL queries
        • SQL execution plan
        • Distributed execution plan
          • Distributed execution and parallel query
          • Generate distributed execution plans
          • Run and disable a parallel query
          • Manage distributed execution plans
          • Parameter tuning for a parallel query
      • PL
        • PL concepts
          • Oracle mode
            • Subprograms
            • Stored procedures
            • Functions
            • Triggers
            • Packages
          • MySQL mode
            • Subprograms
            • Stored procedure
            • Functions
            • Triggers
        • PL subprogram execution mechanism
      • Client programming languages
    • Transaction management
      • Transactions
        • Overview of transactions
        • Transaction structure
        • Statement-level atomicity
        • GTS
        • Transaction control
          • Overview
          • Active transactions
          • Savepoints
          • Transaction control statements
            • MySQL transaction control
            • Oracle transaction control
        • Redo logs
        • Local transactions
        • Distributed transactions
          • Overview
          • Two-phase commit
        • XA transactions
      • Transaction concurrency and consistency
        • Overview
        • Multi-version read consistency
        • Concurrency control
          • Overview
          • Lock mechanism
        • Transaction isolation levels
          • Overview
          • Oracle mode
          • MySQL mode
        • Weak consistency read
    • Storage architecture
      • Overview
      • Data storage
        • Overview
        • MemTables
        • SSTables
        • Compression and encoding
      • Minor compaction and major compaction
        • Overview
        • Minor compactions
        • Major compactions
      • Multi-level caching
      • Query processing
      • Data integrity
        • Detect silent data corruption
    • Data reliability and HA
      • HA architecture
        • Overview
        • ODP HA
        • Leader election in distributed systems
        • Multi-replica log synchronization
        • Paxos protocol
        • Automatic handling of node faults
        • GTS HA
      • Deployment solutions for disaster recovery
      • Primary/standby cluster
        • Overview
        • Typical scenarios
        • Protection modes
        • Log transfer service
        • Role switching
        • Read service of standby clusters
        • Benefits
      • Data protection
        • Overview
        • Flashback queries
        • Restore points
        • Recycle bin
      • Backup and restore
        • Overview
        • Backup metadata for restoration
        • Backup architecture
        • Restoration architecture
    • Database security
      • Overview
      • Identity authentication
      • Access control
      • Data transmission encryption
      • Data storage encryption
      • Monitoring and alerts
      • Security audit
    • OBServer architecture
      • Structure of the OBServer installation directory
      • Configuration files
      • OBServer thread model
        • Threads
        • Worker threads
        • Background threads
      • Logs
      • Memory management
        • Overview
        • Memory-related parameters
        • Memory-related internal tables
        • Memory usage logs
        • Diagnose memory errors
    • Appendix: Basic concepts of OceanBase Database
  • Releases
    • V3.2
      • OceanBase Database Enterprise Edition V3.2.4
      • OceanBase Database Enterprise Edition V3.2.3
      • OceanBase Database Enterprise Edition V3.2.2
      • OceanBase Database Enterprise Edition V3.2.1
      • OceanBase Database Enterprise Edition V3.2.0
    • V3.1
      • OceanBase Database Enterprise Edition V3.1.2
      • OceanBase Database Enterprise Edition V3.1.1
    • V2.2
      • OceanBase Database Enterprise Edition V2.2.77

Download PDF

Documentation Revision History Document Overview Overview Concepts Compatibility with MySQL Management tools Version rules Limitations Deployment introduction Deployment process HA solution for OceanBase clusters Overview Migrate data by using SQL scripts Migrate data by using mysqldump Migrate data by using DataX Migrate data by using the OUTFILE statement OverviewPhysical connections Overview of data distribution Overview Case analysis RPC connection authentication Set row-level access control Reserved keywords (MySQL mode) Reserved keywords (Oracle mode) About data migration and synchronization Migrate data by using OMS Migrate data by using mysqldump Character set specifications Database connection specifications Limits on writing SQL statementsArchitecture of OceanBase Database Development of OceanBase Database Overview Compatibility modes System tenants User tenants Overview Cluster architecture Overview Client programming languages Overview Multi-level caching Query processing Deployment solutions for disaster recovery Overview Identity authenticationAccess control Data transmission encryption Data storage encryption Monitoring and alerts Security audit Structure of the OBServer installation directoryConfiguration files Logs Appendix: Basic concepts of OceanBase Database OceanBase Database Enterprise Edition V3.2.4 OceanBase Database Enterprise Edition V3.2.3 OceanBase Database Enterprise Edition V3.2.2 OceanBase Database Enterprise Edition V3.2.1 OceanBase Database Enterprise Edition V3.2.0 OceanBase Database Enterprise Edition V3.1.2 OceanBase Database Enterprise Edition V3.1.1 OceanBase Database Enterprise Edition V2.2.77
OceanBase logo

The Unified Distributed Database for the AI Era.

Follow Us
Products
OceanBase CloudOceanBase EnterpriseOceanBase Community EditionOceanBase seekdb
Resources
DocsBlogLive DemosTraining & Certification
Company
About OceanBaseTrust CenterLegalPartnerContact Us
Follow Us

© OceanBase 2026. All rights reserved

Cloud Service AgreementPrivacy PolicySecurity
Contact Us
Document Feedback
  1. Documentation Center
  2. OceanBase Database
  3. SQL
  4. V3.2.4
iconOceanBase Database
SQL - V 3.2.4Enterprise Edition
SQL
KV
  • V 4.4.2
  • V 4.3.5
  • V 4.3.3
  • V 4.3.1
  • V 4.3.0
  • V 4.2.5
  • V 4.2.2
  • V 4.2.1
  • V 4.2.0
  • V 4.1.0
  • V 4.0.0
  • V 3.1.4 and earlier

0001 to 3999

Last Updated:2023-10-24 09:23:03  Updated
share
What is 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 1059 (42000): Identifier name '%.*s' is too long
ERROR 1060 (42S21): Duplicate column 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 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 1109 (42S02): Unknown table '%.*s' in %.*s
ERROR 1110 (42000): Column \'%s\' specified twice
ERROR 1111 (HY000): Invalid use of group function
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 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 'empty (sub)expression' 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 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 1221 (HY000): Incorrect usage of srid.
ERROR 1221 (HY000): Incorrect usage of spatial/fulltext/hash index and explicit index order.
ERROR 1222 (21000): The used SELECT statements have a different number of columns
ERROR 1225 (HY000): Option '%s' used twice in statement
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 (0A000): %s not supported
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 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
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 1286 (42000): Unknown storage engine \'%.*s\'
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): FUNCTION %.*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 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 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 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 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 (42000): Divided by zero
ERROR 1366 (22007): Incorrect datetime value: '%s' for column '%s'
ERROR 1366 (HY000): Incorrect integer value: '%.*s'
ERROR 1366 (HY000): Incorrect string value for column '%.*s' at row %ld
ERROR 1367 (22007): Illegal %s '%.*s' value found during parsing
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 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 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 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 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 1445 (HY000): Not allowed to set autocommit from a stored function or trigger
ERROR 1449 (01007): 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 16)
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 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 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 %s
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 1520 (HY000): Reorganize of range partitions cannot change total ranges except for last partition where it can extend the range
ERROR 1525 (HY000): Incorrect %s value: '%s'
ERROR 1526 (HY000): Table has no partition for value
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 1568 (25001): Transaction characteristics can't be changed while a transaction is in progress
ERROR 1582 (42000): Incorrect parameter count in the call to native function '%.*s'
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 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 1687 (42000): A SPATIAL index may only contain a geometrical type column.
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 1735 (HY000): Unkown partition '%.*s' in table '%.*s'
ERROR 1748 (HY000): Found a row not matching the given partition set
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 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 3020 (2201E): Invalid argument for logarithm
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 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 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 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 3165 (42000): A path expression is not a path to a cell in an array
ERROR 3504 (HY000): Too many enumeration values for 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 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 3574 (HY000): Recursive Common Table Expression should have one or more non-recursive query blocks followed by one or more recursive ones: %s
ERROR 3587 (HY000): Window '%s' with RANGE N PRECEDING/FOLLOWING frame requires exactly one ORDER BY expression of numeric or temporal type
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 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 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 3760 (HY000): Spatial functional index is not supported.
ERROR 3812 (HY000): An expression of non-boolean type specified to a check constraint \'%.*s\'
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 3820 (HY000): Check constraint \'%.*s\' refers to non-existing column \'%.*s\'
ERROR 3821 (HY000): Check constraint \'%.*s\' is not found in the table
ERROR 3882 (SU001): The geometry passed to function %s is in SRID 0, which doesn't specify a length unit. Can't convert to '%s'.
ERROR 3902 (SU001): There's no unit of measure named '%s'.
ERROR 3939 (HY000): Table has multiple constraints with the name \'%.*s\'. Please use constraint specific \'%.*s\' clause
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 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

folded

share

These error codes are compatible with specific MySQL error codes.

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

  • Error code in OceanBase Database: 5158

  • MySQL error code: 1007

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

  • Error code in OceanBase Database: 5166

  • MySQL error code: 1008

ERROR 1017 (HY000): File not exist

  • Error code in OceanBase Database: 4027

  • MySQL error code: 1017

ERROR 1018 (HY000): Directory not exist

  • Error code in OceanBase Database: 4066

  • MySQL error code: 1018

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

  • Error code in OceanBase Database: 5595

  • MySQL error code: 1022

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

  • Error code in OceanBase Database: 5215

  • MySQL error code: 1025

ERROR 1040 (08004): Too many connections

  • Error code in OceanBase Database: 5271

  • MySQL error code: 1040

ERROR 1041 (53000): Out of resource

  • Error code in OceanBase Database: 4153

  • MySQL error code: 1041

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

  • Error code in OceanBase Database: 5170

  • MySQL error code: 1044

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

  • Error code in OceanBase Database: 4043

  • MySQL error code: 1045

ERROR 1046 (3D000): No database selected

  • Error code in OceanBase Database: 5134

  • MySQL error code: 1046

ERROR 1047 (HY001): Unknown packet

  • Error code in OceanBase Database: 4118

  • MySQL error code: 1047

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

  • Error code in OceanBase Database: 4235

  • MySQL error code: 1048

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

  • Error code in OceanBase Database: 5154

  • MySQL error code: 1049

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

  • Error code in OceanBase Database: 5020

  • MySQL error code: 1050

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

  • Error code in OceanBase Database: 5201

  • MySQL error code: 1051

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

  • Error code in OceanBase Database: 5207

  • MySQL error code: 1052

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

  • Error code in OceanBase Database: 5217

  • MySQL error code: 1054

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

  • Error code in OceanBase Database: 5218

  • MySQL error code: 1055

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

  • Error code in OceanBase Database: 5206

  • MySQL error code: 1056

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

  • Error code in OceanBase Database: 5179

  • MySQL error code: 1059

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

  • Error code in OceanBase Database: 9526

  • MySQL error code: 1059

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

  • Error code in OceanBase Database: 5008

  • MySQL error code: 1060

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

  • Error code in OceanBase Database: 5025

  • MySQL error code: 1061

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

  • Error code in OceanBase Database: 5024

  • MySQL error code: 1062

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

  • Error code in OceanBase Database: 5165

  • MySQL error code: 1063

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

  • Error code in OceanBase Database: 5000

  • MySQL error code: 1064

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

  • Error code in OceanBase Database: 5001

  • MySQL error code: 1064

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

  • Error code in OceanBase Database: 5282

  • MySQL error code: 1064

ERROR 1065 (42000): Query was empty

  • Error code in OceanBase Database: 5253

  • MySQL error code: 1065

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

  • Error code in OceanBase Database: 5208

  • MySQL error code: 1066

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

  • Error code in OceanBase Database: 5173

  • MySQL error code: 1067

ERROR 1068 (42000): Multiple primary key defined

  • Error code in OceanBase Database: 5210

  • MySQL error code: 1068

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

  • Error code in OceanBase Database: 5194

  • MySQL error code: 1069

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

  • Error code in OceanBase Database: 5195

  • MySQL error code: 1070

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

  • Error code in OceanBase Database: 5196

  • MySQL error code: 1071

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

  • Error code in OceanBase Database: 5211

  • MySQL error code: 1072

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

  • Error code in OceanBase Database: 5198

  • MySQL error code: 1074

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

  • Error code in OceanBase Database: 5193

  • MySQL error code: 1075

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

  • Error code in OceanBase Database: 4662

  • MySQL error code: 1078

ERROR 1082 (42S12): Illegal index

  • Error code in OceanBase Database: 5028

  • MySQL error code: 1082

ERROR 1082 (42000): Index unavailable

  • Error code in OceanBase Database: 5073

  • MySQL error code: 1082

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

  • Error code in OceanBase Database: 5295

  • MySQL error code: 1083

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

  • Error code in OceanBase Database: 5609

  • 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

  • Error code in OceanBase Database: 5610

  • MySQL error code: 1083

ERROR 1086 (58000): File already exist

  • Error code in OceanBase Database: 4117

  • 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

  • Error code in OceanBase Database: 5190

  • MySQL error code: 1089

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

  • Error code in OceanBase Database: 5187

  • MySQL error code: 1090

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

  • Error code in OceanBase Database: 5209

  • MySQL error code: 1091

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

  • Error code in OceanBase Database: 5174

  • MySQL error code: 1093

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

  • Error code in OceanBase Database: 4174

  • MySQL error code: 1094

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

  • Error code in OceanBase Database: 5251

  • MySQL error code: 1095

ERROR 1096 (HY000): No tables used

  • Error code in OceanBase Database: 5185

  • MySQL error code: 1096

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

  • Error code in OceanBase Database: 5336

  • MySQL error code: 1097

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

  • Error code in OceanBase Database: 5430

  • MySQL error code: 1101

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

  • Error code in OceanBase Database: 5162

  • MySQL error code: 1102

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

  • Error code in OceanBase Database: 5163

  • MySQL error code: 1103

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

  • Error code in OceanBase Database: 5200

  • MySQL error code: 1109

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

  • Error code in OceanBase Database: 4228

  • MySQL error code: 1110

ERROR 1111 (HY000): Invalid use of group function

  • Error code in OceanBase Database: 5176

  • MySQL error code: 1111

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

  • Error code in OceanBase Database: 5142

  • MySQL error code: 1115

ERROR 1117 (42000): Too many columns

  • Error code in OceanBase Database: 5197

  • MySQL error code: 1117

ERROR 1118 (42000): Row size too large

  • Error code in OceanBase Database: 5199

  • MySQL error code: 1118

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

  • Error code in OceanBase Database: 4291

  • MySQL error code: 1122

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

  • Error code in OceanBase Database: 4292

  • MySQL error code: 1123

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

  • Error code in OceanBase Database: 4293

  • MySQL error code: 1124

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

  • Error code in OceanBase Database: 4294

  • MySQL error code: 1125

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

  • Error code in OceanBase Database: 4295

  • MySQL error code: 1126

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

  • Error code in OceanBase Database: 4296

  • MySQL error code: 1127

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

  • Error code in OceanBase Database: 4042

  • MySQL error code: 1133

ERROR 1133 (42000): Incorrect password

  • Error code in OceanBase Database: 5038

  • MySQL error code: 1133

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

  • Error code in OceanBase Database: 5168

  • MySQL error code: 1136

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

  • Error code in OceanBase Database: 5175

  • MySQL error code: 1136

ERROR 1138 (22004): Invalid use of NULL value

  • Error code in OceanBase Database: 5596

  • MySQL error code: 1138

ERROR 1139 (42000): Got error 'empty (sub)expression' from regexp

  • Error code in OceanBase Database: 5115

  • 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

  • Error code in OceanBase Database: 5221

  • MySQL error code: 1140

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

  • Error code in OceanBase Database: 5171

  • MySQL error code: 1142

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

  • Error code in OceanBase Database: 5183

  • MySQL error code: 1144

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

  • Error code in OceanBase Database: 5019

  • 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

  • Error code in OceanBase Database: 5006

  • MySQL error code: 1149

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

  • Error code in OceanBase Database: 4254

  • MySQL error code: 1153

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

  • Error code in OceanBase Database: 5164

  • MySQL error code: 1166

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

  • Error code in OceanBase Database: 5216

  • MySQL error code: 1167

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

  • Error code in OceanBase Database: 5030

  • 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

  • Error code in OceanBase Database: 5256

  • MySQL error code: 1171

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

  • Error code in OceanBase Database: 5294

  • MySQL error code: 1172

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

  • Error code in OceanBase Database: 5047

  • 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

  • Error code in OceanBase Database: 5865

  • MySQL error code: 1175

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

  • Error code in OceanBase Database: 5289

  • MySQL error code: 1176

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

  • Error code in OceanBase Database: 5236

  • MySQL error code: 1192

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

  • Error code in OceanBase Database: 5044

  • MySQL error code: 1193

ERROR 1203 (42000): Too many sessions

  • Error code in OceanBase Database: 5059

  • MySQL error code: 1203

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

  • Error code in OceanBase Database: 6003

  • MySQL error code: 1205

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

  • Error code in OceanBase Database: 6006

  • MySQL error code: 1205

ERROR 1210 (HY000): Incorrect arguments to %s

  • Error code in OceanBase Database: 4002

  • MySQL error code: 1210

ERROR 1210 (HY000): Miss argument for %s

  • Error code in OceanBase Database: 4272

  • MySQL error code: 1210

ERROR 1210 (HY000): Miss argument for %s

  • Error code in OceanBase Database: 4277

  • MySQL error code: 1210

ERROR 1213 (HY000): Deadlock

  • Error code in OceanBase Database: 4101

  • MySQL error code: 1213

ERROR 1215 (HY000): Cannot add foreign key constraint

  • Error code in OceanBase Database: 5317

  • MySQL error code: 1215

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

  • Error code in OceanBase Database: 5182

  • MySQL error code: 1221

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

  • Error code in OceanBase Database: 9641

  • MySQL error code: 1221

ERROR 1221 (HY000): Incorrect usage of srid.

  • Error code in OceanBase Database: 7277

  • MySQL error code: 1221

ERROR 1221 (HY000): Incorrect usage of spatial/fulltext/hash index and explicit index order.

  • Error code in OceanBase Database: 7278

  • MySQL error code: 1221

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

  • Error code in OceanBase Database: 5007

  • MySQL error code: 1222

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

  • Error code in OceanBase Database: 4299

  • MySQL error code: 1225

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

  • Error code in OceanBase Database: 5036

  • MySQL error code: 1227

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

  • Error code in OceanBase Database: 5100

  • MySQL error code: 1228

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

  • Error code in OceanBase Database: 5101

  • MySQL error code: 1229

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

  • Error code in OceanBase Database: 4256

  • MySQL error code: 1230

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

  • Error code in OceanBase Database: 5145

  • MySQL error code: 1231

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

  • Error code in OceanBase Database: 5180

  • MySQL error code: 1232

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

  • Error code in OceanBase Database: 5213

  • MySQL error code: 1234

ERROR 1235 (0A000): %s not supported

  • Error code in OceanBase Database: 4007

  • MySQL error code: 1235

ERROR 1235 (0A000): %s not supported

  • Error code in OceanBase Database: 4259

  • MySQL error code: 1235

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

  • Error code in OceanBase Database: 9581

  • MySQL error code: 1235

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

  • Error code in OceanBase Database: 5103

  • MySQL error code: 1238

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

  • Error code in OceanBase Database: 5318

  • MySQL error code: 1239

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

  • Error code in OceanBase Database: 5042

  • MySQL error code: 1241

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

  • Error code in OceanBase Database: 5043

  • MySQL error code: 1243

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

  • Error code in OceanBase Database: 5153

  • MySQL error code: 1242

ERROR 1243 (HY000): Unknown prepared statement handle

  • Error code in OceanBase Database: 5560

  • MySQL error code: 1243

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

  • Error code in OceanBase Database: 5225

  • MySQL error code: 1247

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

  • Error code in OceanBase Database: 5238

  • MySQL error code: 1250

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

  • Error code in OceanBase Database: 5238

  • MySQL error code: 1252

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

  • Error code in OceanBase Database: 5144

  • MySQL error code: 1253

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

  • Error code in OceanBase Database: 5254

  • MySQL error code: 1260

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

  • Error code in OceanBase Database: 5611

  • MySQL error code: 1261

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

  • Error code in OceanBase Database: 5612

  • MySQL error code: 1262

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

  • Error code in OceanBase Database: 4224

  • MySQL error code: 1264

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

  • Error code in OceanBase Database: 5088

  • MySQL error code: 1264

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

  • Error code in OceanBase Database: 5089

  • MySQL error code: 1264

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

  • Error code in OceanBase Database: 5093

  • MySQL error code: 1264

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

  • Error code in OceanBase Database: 5229

  • MySQL error code: 1264

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

  • Error code in OceanBase Database: 4249

  • MySQL error code: 1265

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

  • Error code in OceanBase Database: 4252

  • MySQL error code: 1265

ERROR 1267 (HY000): Illegal mix of collations

  • Error code in OceanBase Database: 5177

  • MySQL error code: 1267

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

  • Error code in OceanBase Database: 5143

  • MySQL error code: 1273

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

  • Error code in OceanBase Database: 5224

  • MySQL error code: 1280

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

  • Error code in OceanBase Database: 5288

  • MySQL error code: 1283

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

  • Error code in OceanBase Database: 5259

  • MySQL error code: 1286

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

  • Error code in OceanBase Database: 5228

  • MySQL error code: 1288

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

  • Error code in OceanBase Database: 5233

  • MySQL error code: 1290

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

  • Error code in OceanBase Database: 5334

  • MySQL error code: 1291

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

  • Error code in OceanBase Database: 4158

  • MySQL error code: 1292

ERROR 1292 (22007): Incorrect value

  • Error code in OceanBase Database: 4190

  • MySQL error code: 1292

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

  • Error code in OceanBase Database: 4262

  • MySQL error code: 1292

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

  • Error code in OceanBase Database: 4219

  • MySQL error code: 1292

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

  • Error code in OceanBase Database: 5222

  • MySQL error code: 1292

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

  • Error code in OceanBase Database: 5172

  • MySQL error code: 1294

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

  • Error code in OceanBase Database: 5568

  • MySQL error code: 1295

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

  • Error code in OceanBase Database: 5192

  • MySQL error code: 1298

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

  • Error code in OceanBase Database: 5250

  • MySQL error code: 1300

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

  • Error code in OceanBase Database: 5316

  • MySQL error code: 1301

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

  • Error code in OceanBase Database: 5858

  • MySQL error code: 1302

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

  • Error code in OceanBase Database: 5582

  • MySQL error code: 1303

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

  • Error code in OceanBase Database: 5541

  • MySQL error code: 1304

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

  • Error code in OceanBase Database: 5055

  • MySQL error code: 1305

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

  • Error code in OceanBase Database: 5542

  • MySQL error code: 1305

ERROR 1305 (42000): savepoint does not exist

  • Error code in OceanBase Database: 6242

  • MySQL error code: 1305

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

  • Error code in OceanBase Database: 5546 and 9505

  • MySQL error code: 1308

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

  • Error code in OceanBase Database: 5593

  • MySQL error code: 1308

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

  • Error code in OceanBase Database: 5583

  • MySQL error code: 1313

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

  • Error code in OceanBase Database: 9580

  • MySQL error code: 1314

ERROR 1317 (70100): Query execution was interrupted

  • Error code in OceanBase Database: 5065

  • MySQL error code: 1317

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

  • Error code in OceanBase Database: 5555

  • MySQL error code: 1318

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

  • Error code in OceanBase Database: 5545

  • MySQL error code: 1319

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

  • Error code in OceanBase Database: 5580

  • MySQL error code: 1321

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

  • Error code in OceanBase Database: 5584

  • MySQL error code: 1323

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

  • Error code in OceanBase Database: 5547

  • MySQL error code: 1324

ERROR 1325 (24000): Cursor is already open

  • Error code in OceanBase Database: 5589

  • MySQL error code: 1325

ERROR 1326 (24000): Cursor is not open

  • Error code in OceanBase Database: 5590

  • MySQL error code: 1326

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

  • Error code in OceanBase Database: 5543

  • MySQL error code: 1327

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

  • Error code in OceanBase Database: 5544

  • MySQL error code: 1327

ERROR 1328 (HY000): Incorrect number of FETCH variables

  • Error code in OceanBase Database: 5554

  • MySQL error code: 1328

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

  • Error code in OceanBase Database: 5548

  • MySQL error code: 1330

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

  • Error code in OceanBase Database: 5550

  • MySQL error code: 1330

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

  • Error code in OceanBase Database: 5552

  • MySQL error code: 1330

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

  • Error code in OceanBase Database: 5549

  • MySQL error code: 1331

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

  • Error code in OceanBase Database: 5551

  • MySQL error code: 1332

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

  • Error code in OceanBase Database: 5553

  • MySQL error code: 1333

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

  • Error code in OceanBase Database: 5569

  • MySQL error code: 1336

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

  • Error code in OceanBase Database: 5586

  • MySQL error code: 1337

ERROR 1338 (42000): Cursor declaration after handler declaration

  • Error code in OceanBase Database: 5587

  • MySQL error code: 1338

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

  • Error code in OceanBase Database: 5571

  • MySQL error code: 1339

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

  • Error code in OceanBase Database: 5214

  • MySQL error code: 1347

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

  • Error code in OceanBase Database: 5719

  • MySQL error code: 1348

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

  • Error code in OceanBase Database: 4238

  • MySQL error code: 1349

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

  • Error code in OceanBase Database: 5242

  • 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

  • Error code in OceanBase Database: 5231

  • MySQL error code: 1356

ERROR 1360 (HY000): Trigger does not exist

  • Error code in OceanBase Database: 5733

  • MySQL error code: 1360

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

  • Error code in OceanBase Database: 9584

  • MySQL error code: 1362

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

  • Error code in OceanBase Database: 9640

  • MySQL error code: 1363

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

  • Error code in OceanBase Database: 4227

  • MySQL error code: 1364

ERROR 1365 (42000): Divided by zero

  • Error code in OceanBase Database: 4078

  • MySQL error code: 1365

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

  • Error code in OceanBase Database: 4219

  • MySQL error code: 1366

ERROR 1366 (HY000): Incorrect integer value: '%.*s'

  • Error code in OceanBase Database: 4226

  • MySQL error code: 1366

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

  • Error code in OceanBase Database: 4258

  • MySQL error code: 1366

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

  • Error code in OceanBase Database: 5332

  • MySQL error code: 1367

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

  • Error code in OceanBase Database: 5080

  • MySQL error code: 1390

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

  • Error code in OceanBase Database: 5191

  • MySQL error code: 1391

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

  • Error code in OceanBase Database: 5718

  • MySQL error code: 1393

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

  • Error code in OceanBase Database: 5720

  • MySQL error code: 1395

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

  • Error code in OceanBase Database: 5155

  • MySQL error code: 1396

ERROR 1397 (XAE04): Unknown XID

  • Error code in OceanBase Database: 6245

  • MySQL error code: 1397

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

  • Error code in OceanBase Database: 6249

  • MySQL error code: 1398

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

  • Error code in OceanBase Database: 6246

  • MySQL error code: 1399

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

  • Error code in OceanBase Database: 6258

  • MySQL error code: 1399

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

  • Error code in OceanBase Database: 6248

  • MySQL error code: 1400

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

  • Error code in OceanBase Database: 6250

  • MySQL error code: 1401

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

  • Error code in OceanBase Database: 6252

  • MySQL error code: 1402

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

  • Error code in OceanBase Database: 5167

  • MySQL error code: 1406

ERROR 1406 (22001): Data too long for column

  • Error code in OceanBase Database: 5354

  • MySQL error code: 1406

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

  • Error code in OceanBase Database: 5585

  • MySQL error code: 1407

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

  • Error code in OceanBase Database: 5169

  • MySQL error code: 1410

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

  • Error code in OceanBase Database: 5936

  • MySQL error code: 1411

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

  • Error code in OceanBase Database: 5581

  • MySQL error code: 1413

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

  • Error code in OceanBase Database: 5592

  • MySQL error code: 1414

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

  • Error code in OceanBase Database: 5579

  • MySQL error code: 1415

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

  • Error code in OceanBase Database: 5579

  • MySQL error code: 1415

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

  • Error code in OceanBase Database: 7276

  • MySQL error code: 1416

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

  • Error code in OceanBase Database: 5576

  • MySQL error code: 1422

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

  • Error code in OceanBase Database: 5570

  • MySQL error code: 1424

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

  • Error code in OceanBase Database: 5202

  • MySQL error code: 1425

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

  • Error code in OceanBase Database: 5203

  • MySQL error code: 1426

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

  • Error code in OceanBase Database: 5204

  • MySQL error code: 1427

ERROR 1435 (HY000): Trigger in wrong schema

  • Error code in OceanBase Database: 9582

  • MySQL error code: 1435

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

  • Error code in OceanBase Database: 5205

  • MySQL error code: 1439

ERROR 1440 (XAE08): The XID already exists

  • Error code in OceanBase Database: 6247

  • MySQL error code: 1440

ERROR 1441 (22008): Datetime overflow

  • Error code in OceanBase Database: 4261

  • 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

  • Error code in OceanBase Database: 5791

  • MySQL error code: 1442

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

  • Error code in OceanBase Database: 5591

  • MySQL error code: 1445

ERROR 1449 (01007): User not exist

  • Error code in OceanBase Database: 5035

  • MySQL error code: 1449

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

  • Error code in OceanBase Database: 5314

  • MySQL error code: 1451

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

  • Error code in OceanBase Database: 5618

  • MySQL error code: 1451

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

  • Error code in OceanBase Database: 5315

  • MySQL error code: 1452

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

  • Error code in OceanBase Database: 5567

  • MySQL error code: 1456

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

  • Error code in OceanBase Database: 5588

  • MySQL error code: 1458

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

  • Error code in OceanBase Database: 5239

  • MySQL error code: 1462

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

  • Error code in OceanBase Database: 5247

  • MySQL error code: 1466

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

  • Error code in OceanBase Database: 5184

  • MySQL error code: 1467

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

  • Error code in OceanBase Database: 5181

  • MySQL error code: 1470

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

  • Error code in OceanBase Database: 5717

  • MySQL error code: 1471

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

  • Error code in OceanBase Database: 5246

  • MySQL error code: 1474

ERROR 1475 (42000): Ambiguous column

  • Error code in OceanBase Database: 5015

  • MySQL error code: 1475

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

  • Error code in OceanBase Database: 5230

  • MySQL error code: 1486

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

  • Error code in OceanBase Database: 5255

  • MySQL error code: 1488

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

  • Error code in OceanBase Database: 5257

  • MySQL error code: 1491

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

  • Error code in OceanBase Database: 5281

  • MySQL error code: 1493

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

  • Error code in OceanBase Database: 5353

  • MySQL error code: 1493

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

  • Error code in OceanBase Database: 5340

  • MySQL error code: 1495

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

  • Error code in OceanBase Database: 5188

  • MySQL error code: 1499

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

  • Error code in OceanBase Database: 5261

  • MySQL error code: 1503

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

  • Error code in OceanBase Database: 5283

  • MySQL error code: 1503

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

  • Error code in OceanBase Database: 5189

  • MySQL error code: 1504

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

  • Error code in OceanBase Database: 5302

  • MySQL error code: 1505

ERROR 1507 (HY000): Error in list of partitions to %s

  • Error code in OceanBase Database: 5303

  • MySQL error code: 1507

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

  • Error code in OceanBase Database: 5306

  • MySQL error code: 1508

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

  • Error code in OceanBase Database: 5305

  • MySQL error code: 1512

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

  • Error code in OceanBase Database: 5280

  • MySQL error code: 1517

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

  • Error code in OceanBase Database: 5566

  • MySQL error code: 1520

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

  • Error code in OceanBase Database: 5241

  • MySQL error code: 1525

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

  • Error code in OceanBase Database: 5284

  • MySQL error code: 1526

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

  • Error code in OceanBase Database: 5310

  • MySQL error code: 1562

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

  • Error code in OceanBase Database: 5286

  • MySQL error code: 1563

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

  • Error code in OceanBase Database: 5262

  • MySQL error code: 1564

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

  • Error code in OceanBase Database: 5285

  • MySQL error code: 1566

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

  • Error code in OceanBase Database: 5219

  • MySQL error code: 1568

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

  • Error code in OceanBase Database: 5054

  • MySQL error code: 1582

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

  • Error code in OceanBase Database: 6253

  • MySQL error code: 1613

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

  • Error code in OceanBase Database: 5102

  • MySQL error code: 1621

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

  • Error code in OceanBase Database: 4229

  • MySQL error code: 1628

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

  • Error code in OceanBase Database: 4230

  • MySQL error code: 1629

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

  • Error code in OceanBase Database: 9701

  • MySQL error code: 1642

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

  • Error code in OceanBase Database: 5556

  • MySQL error code: 1644

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

  • Error code in OceanBase Database: 5557

  • MySQL error code: 1646

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

  • Error code in OceanBase Database: 5237

  • MySQL error code: 1652

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

  • Error code in OceanBase Database: 5276

  • MySQL error code: 1653

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

  • Error code in OceanBase Database: 5275

  • MySQL error code: 1654

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

  • Error code in OceanBase Database: 5349

  • MySQL error code: 1654

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

  • Error code in OceanBase Database: 5355

  • MySQL error code: 1654

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

  • Error code in OceanBase Database: 5287

  • MySQL error code: 1655

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

  • Error code in OceanBase Database: 5277

  • MySQL error code: 1657

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

  • Error code in OceanBase Database: 5178

  • MySQL error code: 1659

ERROR 1687 (42000): A SPATIAL index may only contain a geometrical type column.

  • Error code in OceanBase Database: 7279

  • MySQL error code: 1687

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

  • Error code in OceanBase Database: 4231

  • MySQL error code: 1688

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

  • Error code in OceanBase Database: 4157

  • MySQL error code: 1690

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

  • Error code in OceanBase Database: 5274

  • MySQL error code: 1697

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

  • Error code in OceanBase Database: 5594

  • 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'

  • Error code in OceanBase Database: 5344

  • MySQL error code: 1706

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

  • Error code in OceanBase Database: 5266

  • MySQL error code: 1708

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

  • Error code in OceanBase Database: 5146

  • MySQL error code: 1735

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

  • Error code in OceanBase Database: 5147

  • MySQL error code: 1748

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

  • Error code in OceanBase Database: 5220

  • MySQL error code: 1792

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

  • Error code in OceanBase Database: 6226

  • MySQL error code: 1792

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

  • Error code in OceanBase Database: 4365

  • MySQL error code: 1819

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

  • Error code in OceanBase Database: 4366

  • 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

  • Error code in OceanBase Database: 5227

  • MySQL error code: 1827

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

  • Error code in OceanBase Database: 5244

  • MySQL error code: 1869

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

  • Error code in OceanBase Database: 4336

  • MySQL error code: 1882

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

  • Error code in OceanBase Database: 5402

  • MySQL error code: 3004

ERROR 3020 (2201E): Invalid argument for logarithm

  • Error code in OceanBase Database: 5565

  • MySQL error code: 3020

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

  • Error code in OceanBase Database: 5263

  • 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

  • Error code in OceanBase Database: 7201

  • MySQL error code: 3033

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

  • Error code in OceanBase Database: 7202

  • MySQL error code: 3034

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

  • Error code in OceanBase Database: 7203

  • MySQL error code: 3035

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

  • Error code in OceanBase Database: 7204

  • MySQL error code: 3036

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

  • Error code in OceanBase Database: 7205

  • MySQL error code: 3037

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

  • Error code in OceanBase Database: 7206

  • MySQL error code: 3038

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

  • Error code in OceanBase Database: 7207

  • MySQL error code: 3039

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

  • Error code in OceanBase Database: 7208

  • MySQL error code: 3040

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

  • Error code in OceanBase Database: 7209

  • MySQL error code: 3041

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

  • Error code in OceanBase Database: 7210

  • MySQL error code: 3042

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

  • Error code in OceanBase Database: 7211

  • MySQL error code: 3043

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

  • Error code in OceanBase Database: 7265

  • MySQL error code: 3044

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

  • Error code in OceanBase Database: 7266

  • MySQL error code: 3045

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

  • Error code in OceanBase Database: 7267

  • MySQL error code: 3046

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

  • Error code in OceanBase Database: 7268

  • MySQL error code: 3047

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

  • Error code in OceanBase Database: 7269

  • MySQL error code: 3048

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

  • Error code in OceanBase Database: 7270

  • MySQL error code: 3049

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

  • Error code in OceanBase Database: 7271

  • MySQL error code: 3050

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

  • Error code in OceanBase Database: 7272

  • MySQL error code: 3051

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

  • Error code in OceanBase Database: 7273

  • MySQL error code: 3052

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

  • Error code in OceanBase Database: 7274

  • MySQL error code: 3053

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

  • Error code in OceanBase Database: 7275

  • MySQL error code: 3054

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

  • Error code in OceanBase Database: 7212

  • MySQL error code: 3055

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

  • Error code in OceanBase Database: 7213

  • MySQL error code: 3060

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

  • Error code in OceanBase Database: 5351

  • MySQL error code: 3064

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

  • Error code in OceanBase Database: 5290

  • MySQL error code: 3105

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

  • Error code in OceanBase Database: 5292

  • MySQL error code: 3106

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

  • Error code in OceanBase Database: 5293

  • MySQL error code: 3108

ERROR 3118 (HY000): User locked

  • Error code in OceanBase Database: 5039

  • MySQL error code: 3118

ERROR 3122 (HY000): Inconsistent intersection points.

  • Error code in OceanBase Database: 7214

  • MySQL error code: 3122

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

  • Error code in OceanBase Database: 7215

  • MySQL error code: 3134

ERROR 3140 (22032): Invalid JSON text

  • Error code in OceanBase Database: 5411

  • MySQL error code: 3140

ERROR 3141 (22032): Invalid JSON text in argument

  • Error code in OceanBase Database: 5412

  • MySQL error code: 3141

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

  • Error code in OceanBase Database: 5413

  • MySQL error code: 3142

ERROR 3143 (42000): Invalid JSON path expression

  • Error code in OceanBase Database: 5414

  • MySQL error code: 3143

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

  • Error code in OceanBase Database: 5415

  • MySQL error code: 3144

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

  • Error code in OceanBase Database: 5416

  • 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

  • Error code in OceanBase Database: 5417

  • MySQL error code: 3146

ERROR 3147 (22032): Cannot CAST value to JSON

  • Error code in OceanBase Database: 5418

  • MySQL error code: 3147

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

  • Error code in OceanBase Database: 5419

  • MySQL error code: 3148

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

  • Error code in OceanBase Database: 5420

  • MySQL error code: 3149

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

  • Error code in OceanBase Database: 5421

  • MySQL error code: 3150

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

  • Error code in OceanBase Database: 5422

  • MySQL error code: 3151

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

  • Error code in OceanBase Database: 5424

  • MySQL error code: 3153

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

  • Error code in OceanBase Database: 5425

  • MySQL error code: 3154

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

  • Error code in OceanBase Database: 5426

  • MySQL error code: 3155

ERROR 3156 (22018): Invalid JSON value for CAST

  • Error code in OceanBase Database: 5427

  • MySQL error code: 3156

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

  • Error code in OceanBase Database: 5428

  • MySQL error code: 3157

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

  • Error code in OceanBase Database: 5429

  • MySQL error code: 3158

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

  • Error code in OceanBase Database: 5431

  • MySQL error code: 3165

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

  • Error code in OceanBase Database: 5335

  • MySQL error code: 3504

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

  • Error code in OceanBase Database: 5333

  • MySQL error code: 3505

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

  • Error code in OceanBase Database: 7216

  • MySQL error code: 3516

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

  • Error code in OceanBase Database: 7288

  • MySQL error code: 3516

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

  • Error code in OceanBase Database: 7217

  • 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.

  • Error code in OceanBase Database: 7218

  • MySQL error code: 3518

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

  • Error code in OceanBase Database: 7219

  • 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.

  • Error code in OceanBase Database: 7220

  • 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.

  • Error code in OceanBase Database: 7221

  • MySQL error code: 3521

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

  • Error code in OceanBase Database: 7222

  • MySQL error code: 3548

ERROR 3548 (SR001): Spatial reference system is empty

  • Error code in OceanBase Database: 7285

  • MySQL error code: 3548

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

  • Error code in OceanBase Database: 7286

  • MySQL error code: 3558

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

  • Error code in OceanBase Database: 7287

  • MySQL error code: 3559

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

  • Error code in OceanBase Database: 7283

  • MySQL error code: 3560

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

  • Error code in OceanBase Database: 7223

  • MySQL error code: 3565

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 code in OceanBase Database: 5982

  • MySQL error code: 3574

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

  • Error code in OceanBase Database: 5984

  • MySQL error code: 3587

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

  • Error code in OceanBase Database: 5985

  • MySQL error code: 3592

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

  • Error code in OceanBase Database: 5983

  • MySQL error code: 3596

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

  • Error code in OceanBase Database: 7263

  • MySQL error code: 3616

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

  • Error code in OceanBase Database: 7264

  • MySQL error code: 3617

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

  • Error code in OceanBase Database: 7224

  • MySQL error code: 3618

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 code in OceanBase Database: 7225

  • 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.

  • Error code in OceanBase Database: 7226

  • MySQL error code: 3644

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 code in OceanBase Database: 7227

  • MySQL error code: 3674

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

  • Error code in OceanBase Database: 7228

  • MySQL error code: 3682

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

  • Error code in OceanBase Database: 7229

  • MySQL error code: 3704

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

  • Error code in OceanBase Database: 7230

  • MySQL error code: 3705

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

  • Error code in OceanBase Database: 7284

  • MySQL error code: 3706

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

  • Error code in OceanBase Database: 7231

  • MySQL error code: 3708

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

  • Error code in OceanBase Database: 7232

  • MySQL error code: 3709

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

  • Error code in OceanBase Database: 7233

  • MySQL error code: 3710

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

  • Error code in OceanBase Database: 7234

  • MySQL error code: 3711

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

  • Error code in OceanBase Database: 7235

  • MySQL error code: 3712

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

  • Error code in OceanBase Database: 7236

  • MySQL error code: 3713

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

  • Error code in OceanBase Database: 7237

  • 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.

  • Error code in OceanBase Database: 7238

  • MySQL error code: 3715

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

  • Error code in OceanBase Database: 7239

  • MySQL error code: 3716

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

  • Error code in OceanBase Database: 7240

  • MySQL error code: 3717

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

  • Error code in OceanBase Database: 7241

  • 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.

  • Error code in OceanBase Database: 7242

  • MySQL error code: 3726

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

  • Error code in OceanBase Database: 7243

  • MySQL error code: 3727

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

  • Error code in OceanBase Database: 7244

  • MySQL error code: 3728

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

  • Error code in OceanBase Database: 7245

  • MySQL error code: 3729

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

  • Error code in OceanBase Database: 7281

  • 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].

  • Error code in OceanBase Database: 7246

  • 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].

  • Error code in OceanBase Database: 7247

  • 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.

  • Error code in OceanBase Database: 7248

  • MySQL error code: 3736

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

  • Error code in OceanBase Database: 7249

  • 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.

  • Error code in OceanBase Database: 7250

  • MySQL error code: 3738

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

  • Error code in OceanBase Database: 7251

  • MySQL error code: 3739

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

  • Error code in OceanBase Database: 7252

  • MySQL error code: 3740

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

  • Error code in OceanBase Database: 7253

  • MySQL error code: 3741

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

  • Error code in OceanBase Database: 7254

  • MySQL error code: 3742

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

  • Error code in OceanBase Database: 7255

  • MySQL error code: 3743

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

  • Error code in OceanBase Database: 7256

  • MySQL error code: 3744

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

  • Error code in OceanBase Database: 7257

  • MySQL error code: 3753

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

  • Error code in OceanBase Database: 7258

  • MySQL error code: 3760

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

  • Error code in OceanBase Database: 5987

  • MySQL error code: 3812

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

  • Error code in OceanBase Database: 5991

  • MySQL error code: 3814

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

  • Error code in OceanBase Database: 5992

  • MySQL error code: 3815

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

  • Error code in OceanBase Database: 5993

  • MySQL error code: 3816

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

  • Error code in OceanBase Database: 5990

  • MySQL error code: 3818

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

  • Error code in OceanBase Database: 5994

  • MySQL error code: 3820

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

  • Error code in OceanBase Database: 5988

  • MySQL error code: 3821

ERROR 3882 (SU001): The geometry passed to function %s is in SRID 0, which doesn't specify a length unit. Can't convert to '%s'.

  • Error code in OceanBase Database: 7259

  • MySQL error code: 3882

ERROR 3902 (SU001): There's no unit of measure named '%s'.

  • Error code in OceanBase Database: 7282

  • MySQL error code: 3902

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

  • Error code in OceanBase Database: 5986

  • MySQL error code: 3939

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 code in OceanBase Database: 5989

  • MySQL error code: 3941

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

  • Error code in OceanBase Database: 5859

  • MySQL error code: 3959

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

  • Error code in OceanBase Database: 5432

  • MySQL error code: 3966

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

  • Error code in OceanBase Database: 5433

  • MySQL error code: 3967

Previous topic

Overview
Last

Next topic

4000 to 4499
Next
What is 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 1059 (42000): Identifier name '%.*s' is too long
ERROR 1060 (42S21): Duplicate column 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 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 1109 (42S02): Unknown table '%.*s' in %.*s
ERROR 1110 (42000): Column \'%s\' specified twice
ERROR 1111 (HY000): Invalid use of group function
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 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 'empty (sub)expression' 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 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 1221 (HY000): Incorrect usage of srid.
ERROR 1221 (HY000): Incorrect usage of spatial/fulltext/hash index and explicit index order.
ERROR 1222 (21000): The used SELECT statements have a different number of columns
ERROR 1225 (HY000): Option '%s' used twice in statement
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 (0A000): %s not supported
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 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
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 1286 (42000): Unknown storage engine \'%.*s\'
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): FUNCTION %.*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 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 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 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 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 (42000): Divided by zero
ERROR 1366 (22007): Incorrect datetime value: '%s' for column '%s'
ERROR 1366 (HY000): Incorrect integer value: '%.*s'
ERROR 1366 (HY000): Incorrect string value for column '%.*s' at row %ld
ERROR 1367 (22007): Illegal %s '%.*s' value found during parsing
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 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 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 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 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 1445 (HY000): Not allowed to set autocommit from a stored function or trigger
ERROR 1449 (01007): 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 16)
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 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 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 %s
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 1520 (HY000): Reorganize of range partitions cannot change total ranges except for last partition where it can extend the range
ERROR 1525 (HY000): Incorrect %s value: '%s'
ERROR 1526 (HY000): Table has no partition for value
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 1568 (25001): Transaction characteristics can't be changed while a transaction is in progress
ERROR 1582 (42000): Incorrect parameter count in the call to native function '%.*s'
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 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 1687 (42000): A SPATIAL index may only contain a geometrical type column.
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 1735 (HY000): Unkown partition '%.*s' in table '%.*s'
ERROR 1748 (HY000): Found a row not matching the given partition set
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 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 3020 (2201E): Invalid argument for logarithm
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 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 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 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 3165 (42000): A path expression is not a path to a cell in an array
ERROR 3504 (HY000): Too many enumeration values for 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 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 3574 (HY000): Recursive Common Table Expression should have one or more non-recursive query blocks followed by one or more recursive ones: %s
ERROR 3587 (HY000): Window '%s' with RANGE N PRECEDING/FOLLOWING frame requires exactly one ORDER BY expression of numeric or temporal type
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 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 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 3760 (HY000): Spatial functional index is not supported.
ERROR 3812 (HY000): An expression of non-boolean type specified to a check constraint \'%.*s\'
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 3820 (HY000): Check constraint \'%.*s\' refers to non-existing column \'%.*s\'
ERROR 3821 (HY000): Check constraint \'%.*s\' is not found in the table
ERROR 3882 (SU001): The geometry passed to function %s is in SRID 0, which doesn't specify a length unit. Can't convert to '%s'.
ERROR 3902 (SU001): There's no unit of measure named '%s'.
ERROR 3939 (HY000): Table has multiple constraints with the name \'%.*s\'. Please use constraint specific \'%.*s\' clause
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 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