matrixone
matrixone copied to clipboard
matrixorigin
[Bug]: dump用户，创建DB `123`后，执行SQL报错
Is there an existing issue for the same bug?
- [X] I have checked the existing issues.
Branch Name
1.2-dev
Commit ID
7ec65cffb
Other Environment Information
- Hardware parameters:
- OS type:
- Others:
aliyun dev环境
Actual Behavior
使用dump用户，执行如下操作：
create database `123`;
use `123`;
create table `123123``` (
id INT PRIMARY KEY AUTO_INCREMENT,
A INT,
B FLOAT,
C FLOAT,
D VARCHAR(10)
);
INSERT INTO `123123``` (A, B, C, D) VALUES
(51, 0.866176, -2.612549, 'cherry'),
(92, 0.601115, 0.950370, 'apple'),
(14, 0.708073, 0.816445, 'cherry'),
(71, 0.020584, -1.523876, 'apple'),
(60, 0.969910, -0.428046, 'cherry'),
(20, 0.832443, -0.742407, 'cherry'),
(82, 0.212339, -0.703344, 'apple'),
(86, 0.181825, -2.139621, 'apple'),
(74, 0.183405, -0.629475, 'cherry'),
(74, 0.304242, 0.597720, 'banana');
SELECT SUM(size) AS size FROM (SELECT mo_table_size(reldatabase, relname) AS size FROM mo_catalog.mo_tables WHERE relkind IN('r', 'e', 'cluster', 'v') AND reldatabase = '123') AS t;
报错：
[42000][1064] SQL parser error: table "123" does not exist
Expected Behavior
首先这里是有123这个库的，其次没有这个库的话，我理解也应该报错DB ”123“ does not exist
Steps to Reproduce
如上
Additional information
No response
