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' ERR...
[root@10-186-58-75 ~]# mysql -h10.186.58.75 -P8001 -uroot -proot -f < 1.sql ERROR 1046 (3D000) at line 1: No database selected ERROR 1049 (42000) at line 4: Unknown database 'renzy' [root@10-186-58-75 ~]# echo $? 0 临时修复 进入OMS 容器,按 OMS 容器初始化脚本提示(下...
(3D000): No database selected MySQL [(none)]> use testdb Database changed MySQL [testdb]> CREATE TABLE t1 (id int,name varchar(20)); Query OK, 0 rows affected (0.058 sec) MySQL [testdb]> insert into t1(id,name) values(88,"cjtom"); Query OK, 1 row affected (0.014 sec) ...
1 row in set (0.00 sec) obclient> SHOW RECYCLEBIN; Empty set (0.01 sec) obclient> CREATE TABLE test1 AS SELECT * FROM t1; ERROR 1046 (3D000): No database selected obclient> USE test; Database changed obclient> CREATE TABLE test1 AS SELECT * FROM t1; Query OK, 1 row affected (...
Fixed the issue where the NULLABLE and IS_VISIBLE fields in the information_schema.STATISTICS view were incompatible with OceanBase Database V4.0.0. Fixed the issue where no error was reported or the error was not reported in the same form as MySQL when the REGEXP function contains both binar...
```shell SQL> select * from t1; no rows selected ``` 执行如下存储过程。 ```shell SQL> declare fee1 date; fee2 number(14, 2); begin select min(c1) into fee1 from t1; insert into t2 values(fee1 - to_date('2020-01-01', 'yyyy-mm-dd')); commit; end; / PL/SQL procedure ...
In MySQL mode of OceanBase Database, no SQL statement for rollback can be generated for an UPDATE or DELETE operation performed on a table without a primary key or unique key. No SQL statement for rollback can be generated for a change operation performed on a table with LOB fields. ...
data, resulting in suboptimal performance. OceanBase Database V4.3.1 adds partitioning capabilities to external tables, supporting partitioning methods similar to list partitioning on regular tables. This update offers two partitioning approaches—automatic and manual. When the automatic option is selected,...
If you have selectedFull MigrationandIncremental Synchronizationwhen you created the data migration project, the data transmission service requires that the local incremental logs of the source database be retained for at least 7 days. If the data transmission service cannot obtai...
OceanBase is an enterprise distributed relational database with high availability, high performance, horizontal scalability, and compatibility with SQL standards. - Release v4.2.1_CE_BP9 · oceanbase/oceanbase