Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

flashback does not properly handle dropped tables #40318

Closed
Tracked by #40026
Defined2014 opened this issue Jan 4, 2023 · 1 comment · Fixed by #40460
Closed
Tracked by #40026

flashback does not properly handle dropped tables #40318

Defined2014 opened this issue Jan 4, 2023 · 1 comment · Fixed by #40460
Assignees
Labels
feature/developing the related feature is in development severity/major sig/sql-infra SIG: SQL Infra type/bug The issue is confirmed as a bug.

Comments

@Defined2014
Copy link
Contributor

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

use test;
create table t(a int);
select now();
insert into t values (1);
drop table t;
flashback cluster to timestamp 'xxx'; // flashback to timestamp before insert
select * from t;

2. What did you expect to see? (Required)

mysql> select * from t;
Empty set (0.01 sec)

3. What did you see instead (Required)

mysql> select * from t;
+------+
| a    |
+------+
|    1 |
+------+
1 row in set (0.01 sec)

4. What is your TiDB version? (Required)

6ae151a

@Defined2014 Defined2014 added type/bug The issue is confirmed as a bug. severity/major labels Jan 4, 2023
@Defined2014 Defined2014 self-assigned this Jan 4, 2023
@ti-chi-bot ti-chi-bot added may-affects-4.0 This bug maybe affects 4.0.x versions. may-affects-5.0 This bug maybe affects 5.0.x versions. may-affects-5.1 This bug maybe affects 5.1.x versions. may-affects-5.2 This bug maybe affects 5.2.x versions. may-affects-5.3 This bug maybe affects 5.3.x versions. may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-6.0 may-affects-6.1 may-affects-6.2 may-affects-6.3 may-affects-6.4 labels Jan 4, 2023
@Defined2014 Defined2014 removed may-affects-4.0 This bug maybe affects 4.0.x versions. may-affects-5.1 This bug maybe affects 5.1.x versions. may-affects-5.2 This bug maybe affects 5.2.x versions. may-affects-5.3 This bug maybe affects 5.3.x versions. may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-5.0 This bug maybe affects 5.0.x versions. may-affects-6.0 may-affects-6.1 may-affects-6.2 may-affects-6.3 may-affects-6.4 labels Jan 4, 2023
@Defined2014
Copy link
Contributor Author

Defined2014 commented Jan 4, 2023

Also find a bug with flashback dropped schema. I need to rethink the flashback key ranges.

@ChenPeng2013 ChenPeng2013 added the sig/sql-infra SIG: SQL Infra label Jan 5, 2023
@bb7133 bb7133 added the feature/developing the related feature is in development label Jan 5, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature/developing the related feature is in development severity/major sig/sql-infra SIG: SQL Infra type/bug The issue is confirmed as a bug.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants