GaussDB100 T 是否支持闪回事务查询功能。

GaussDB 是否支持闪回事务查询功能。

环境：redhat7.5+gaussdb100

1.创建表：

SQL> conn wsx/password@127.0.0.1:1888

connected.

SQL> create table wsx.t1 as select * from dual;

Succeed.

2.模拟delete操作：

SQL> delete from wsx.t1;

1 rows affected.

SQL>
SQL>
SQL> commit;

Succeed.

SQL> select * from t1;

DUMMY
-----

0 rows fetched.


SQL> select sysdate from dual;

SYSDATE
----------------------
2020-02-18 17:05:56

1 rows fetched.

3.查看回收站是否有记录。

SQL> col org_name format a10;

SQL>
SQL> col partition_name format a10;

SQL>
SQL>
SQL> conn / as sysdba

connected.

SQL>
SQL> select name,user#,org_name,partition_name,operation#,flags from sys_recyclebin;

NAME                           USER#        ORG_NAME   PARTITION_ OPERATION#   FLAGS
------------------------------ ------------ ---------- ---------- ------------ ------------

0 rows fetched.

4.闪回查询

SQL> SELECT * FROM wsx.t1
    AS OF TIMESTAMP TO_DATE ('2020/02/18 17:04:00', 'yyyy/mm/dd hh24:mi:ss');

DUMMY
-----
X

1 rows fetched.

5.恢复表wsx.t1在2020.02.18 17:04:00误删除的记录：

SQL> conn wsx/password@127.0.0.1:1888

connected.

SQL>
SQL>
SQL> insert into wsx.t1
(SELECT * FROM wsx.t1
    AS OF TIMESTAMP TO_DATE ('2020/02/18 17:04:00', 'yyyy/mm/dd hh24:mi:ss'));

1 rows affected.

SQL>
SQL> commit;

Succeed.

SQL>
SQL>
SQL> select * from wsx.t1;

DUMMY
-----
X

1 rows fetched.

----可以看到，表wsx.t1已经有记录了

总的来说，gaussdb100 T 是可以支持闪回事务查询。