【 使用环境 】测试环境
【 OB or 其他组件 】
【 使用版本 】OceanBase_CE 4.0.0.0 (r100000272022110114-6af7f9ae79cd0ecbafd4b1b88e2886ccdba0c3be) (Built Nov 1 2022 14:57:18)
【问题描述】清晰明确描述问题
【复现路径】问题出现前后相关操作
【问题现象及影响】
【附件】
# 确认启用recyclebin
obclient [test]> show global variables like 'recyclebin';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| recyclebin | ON |
+---------------+-------+
1 row in set (0.002 sec)
obclient [test]> show variables like 'recyclebin';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| recyclebin | ON |
+---------------+-------+
1 row in set (0.001 sec)
obclient [test]> show tables;
+----------------+
| Tables_in_test |
+----------------+
| t3 |
+----------------+
1 row in set (0.004 sec)
# 删表
obclient [test]> drop table t3;
Query OK, 0 rows affected (0.370 sec)
# 这种方式看不到
obclient [test]> show recyclebin;
Empty set (0.006 sec)
# 这种方式可以看到并能闪回
obclient [test]> show tables from __recyclebin;
+--------------------------------+
| Tables_in___recyclebin |
+--------------------------------+
| __recycle_$_1_1667443847749680 |
| __recycle_$_1_1667447965140784 |
+--------------------------------+
obclient [test]> flashback table __recycle_$_1_1667447965140784 to before drop rename to t3;
Query OK, 0 rows affected (0.045 sec)
obclient [test]> show tables ;
+----------------+
| Tables_in_test |
+----------------+
| t3 |
+----------------+