matrixorigin / matrixone

Hyperconverged cloud-edge native database
https://docs.matrixorigin.cn/en
Apache License 2.0
1.77k stars 275 forks source link

[Bug]: create db and table ,insert data, create snapshot, drop db, select * from table{snapshot = ''} report 'ERROR 1046 (HY000): not connect to a database'. #15962

Closed Ariznawlll closed 5 months ago

Ariznawlll commented 5 months ago

Is there an existing issue for the same bug?

Branch Name

main

Commit ID

44a4d5e

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

image

Expected Behavior

db和表还在

Steps to Reproduce

drop database if exists test03;
create database test03;
use test03;

create table t1(col1 int);
insert into t1 values(1),(2),(3);
select count(*) from t1;

drop snapshot if exists sp01;
create snapshot sp01 for account sys;

drop database test03;
select * from t1{snapshot = 'sp01'};    -->此处报错

Additional information

No response

YANGGMM commented 5 months ago

这不是一个bug

Ariznawlll commented 5 months ago

查询的时候需要带上db_name

image