oceanbase-ce-3.1.0 无法闪回删除表

[蓝蓝的天]

【产品名称】oceanbase-ce-3.1.0

【产品版本】3.1.0

【问题描述】

MySQL [tpccdb]> show recyclebin\G

*************************** 1. row ***************************

OBJECT_NAME: __recycle_$_1_1623308900314704

ORIGINAL_NAME: t_drop

TYPE: TABLE

CREATETIME: 2021-06-10 15:08:20.316332

MySQL [tpccdb]> flashback table __recycle_$_1_1623308900314704 to before drop rename to t_drop;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ‘flashback table __recycle_$_1_1623308900314704 to before drop rename to t_drop’ at line 1

[蓝蓝的天]

请大侠帮忙看看，谢谢。

tpcc的权限：

MySQL [tpccdb]> show grants for tpcc;

+----------------------------------------------+

| Grants for tpcc@%              |

+----------------------------------------------+

| GRANT ALL PRIVILEGES ON *.* TO 'tpcc'    |

| GRANT SELECT ON `oceanbase`.* TO 'tpcc'   |

| GRANT ALL PRIVILEGES ON `tpccdb`.* TO 'tpcc' |

+----------------------------------------------+

3 rows in set (0.004 sec)

[三木大大]

flashback 功能在社区版本暂不支持，商业版支持

[意游]

社区3.1.3版已解决了这个问题。